Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2006-07-08 08:58:03

Saigo
Member
Registered: 2005-01-02
Posts: 60
Website

I have a rather strange problem with images and their IDs.

After running the plugin fpx_image_import (this is not about the plugin), I accidentally made multiple copies of the same batch of images (about 20 images in all) that it increments the ID repeatedly, from ID 910 to 990.

So I accessed phpMyAdmin and remove all said IDs, removed all images with the filenames from 910.jpg to 990.jpg (as well as their thumbnails), then ran the plugin again to automatically import the images and thumbnail them accordingly. For some reason (again, I doubt this has to do with the plugin, but Textpattern itself), the IDs that were given to this batch of images were from 990+ till 1000+, not from 910.

The IDs I removed earlier were under the txp_image table in phpMyAdmin. Is there another table I should go to to remove the additional IDs I incurred earlier?

Offline

#2 2006-07-08 10:17:33

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: I have a rather strange problem with images and their IDs.

Go to the txp_image table in phpMyAdmin, go to ‘Operations’, at the bottom of the screen you’ll see under ‘Table options’ a number before ‘auto_increment’. This is the next ID that will be used when a new image is uploaded. You can change this, but first you’ll have to go through the process of removing the newly uploaded images again.

Offline

#3 2006-07-08 15:49:29

Saigo
Member
Registered: 2005-01-02
Posts: 60
Website

Re: I have a rather strange problem with images and their IDs.

Thanks! That worked perfectly fine. :D

Offline

Board footer

Powered by FluxBB