Image list registration problem

[Lucifer]

ex)

#35 image registration error

#35 Erase and again registration


Problem

#35 is not and is registered by #36

Is no there method to register by #35?

:-(

[Dennis]

Ok, I took a long look in my crystal boll for this.

The id number is of the type autoincrement, what this means is that whenever a record is added this number is upped by one.

Problem here is that when you delete a row (in this case an image) this number is removed from the database, but (here it comes) cannot be used again, so the next number will be the deleted one + 1.

The only way to keep your id's is not to delete the record, but modify it. Since you deleted it there is no way you can add a #35 again (except if you can handle SQL).

If you can: goto PHPMyAdmin, look for the pixelpost database and open the (pixelpost_prefix)pixelpost table (where pixelpost_prefix is the prefix from pixelpost.php file).

WARNING: be carefull what you do with PHPMyAdmin. You can seriously mess up your database.

Change the ID of #36 to #35 and then execute this SQL statement:

ALTER TABLE (pixelpost_prefix)pixelpost AUTO_INCREMENT = 36


For documentation references: the number (in this case 36) is the number the next row will take.

WARNING: be carefull what you do with PHPMyAdmin. You can seriously mess up your database.

[Lucifer]

Was solved..

Thank reply. ;-)