4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: V@no on October 16, 2002, 05:36:25 AM

Title: How can I change volume of 'next autoindex' in MySQL for 4images_images tab
Post by: V@no on October 16, 2002, 05:36:25 AM

I add and delete many pictures, and now I have 1000+ all together, but image_id increasing from 2000+ already. is there a way to change that number from MySQL command?
I'm using phpMyAdmin to work with MySQL, but there is no way I can fix it if I dont know the command or whatever.
can someone help me?

P.S. I fully understand that this can make a mess.

Title: How can I change volume of 'next autoindex' in MySQL for 4im
Post by: Jan on October 16, 2002, 08:30:49 AM

No, the only way to reset the auto increament index is to empty the whole table with

Code: [Select]

DELETE FROM [table]

Jan

Title: How can I change volume of 'next autoindex' in MySQL for 4im
Post by: V@no on October 17, 2002, 01:41:52 AM

omg, sounds not too good...
but thx, Jan.
btw, if so, how many photos I can add? is there a limit like to 65535? hope not, couse I'm getting close to this number! just 63535 more photos and I'm done! hehe

Title: How can I change volume of 'next autoindex' in MySQL for 4im
Post by: Jan on October 17, 2002, 08:20:04 AM

The limit is 8388607. Hope this is enough ;)

Jan