4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: Sakuriana on May 05, 2003, 09:27:39 AM

Title: Editing Category IDs
Post by: Sakuriana 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.

Title: Editing Category IDs
Post by: V@no on May 05, 2003, 10:49:51 AM

only do it manualy, messing with the database.

Title: Editing Category IDs
Post by: V@no 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? :?

Title: Re: Editing Category IDs
Post by: geohei 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,