« previous next »
Pages: [1]

Author Topic: Editing Category IDs  (Read 5217 times)

0 Members and 1 Guest are viewing this topic.

Offline Sakuriana

  • Pre-Newbie
  • Posts: 1
    • View Profile
    • http://sakuriana.com/
Editing Category IDs
« on: May 05, 2003, 09:27:39 AM »
Is there some way the IDs for the categories can be changed? I know it's not a big problem but it really annoys me that categories that the IDs of categories I have deleted are just vacant and new categories just get built on over them.
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Editing Category IDs
« Reply #1 on: May 05, 2003, 10:49:51 AM »
only do it manualy, messing with the database.
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Editing Category IDs
« Reply #2 on: May 05, 2003, 02:46:32 PM »
Quote from: Cr@zy Sash
well i wouldn't do that because that can make troubles in your db because the id's are automatic generated...

yep, and all your images will be messed up too.

P.S. who cares about IDs? :?
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline geohei

  • Jr. Member
  • **
  • Posts: 85
    • View Profile
Re: Editing Category IDs
« Reply #3 on: May 20, 2007, 09:16:53 PM »
Hi.

Changing the "Auto Increment" value in the Operations part of phpMyAdmin would possibly do it. However I don't know it existing values for that field are not overwritten (= messing up the database!)?

E.g. 1, 2, 4, 5.
3 is missing. Set "Auto Increment" to 3 and create a new record. If the "Auto Increment" value then jumps to 4 or 6 ... don't know ...

... later ...

Changing the value makes MySQL put it back to the maximum (=6 in the example above). This method doesn't allow changing the cat_id manually.

Bye,
Logged
Pages: [1]
« previous next »