Textpattern CMS

#1 2009-11-05 01:33:53

jmachacek

New Member

Registered: 2009-03-19

Posts: 7

Textpattern article problem after restoring database

Hello,

We recently had a problem with our ‘textpattern’ database table becoming corrupted. I restored the database from a backup and our site is back, except now when I add an article the ID field is set to “0” (we have close to 100 articles in our system, but the numbering isn’t totally continuous. A couple of the articles have been deleted at some point, so our articles start at ID 2, and go up through 96). This causes Textpattern to dump a bunch of error messages when I even try to edit the article through the Admin interface; I have to go into phpMyAdmin and manually modify the article’s ID field to an appropriate value (e.g. 97).

How can I get TextPattern to start incrementing at the correct ID index again?

Thanks,
Jason

Last edited by jmachacek (2009-11-05 01:49:48)

#2 2009-11-05 02:19:51

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,306

Re: Textpattern article problem after restoring database

Backup any possible changes you made in the meantime, then try the following:

In PHPmyAdmin select the database TXP saves to, click the SQL tab, enter ALTER TABLE `textpattern` AUTO_INCREMENT = 100;, press OK. The next post will have an ID of 100 (any gaps in numeration aren’t essential).

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2009-11-24 20:48:01

jmachacek

New Member

Registered: 2009-03-19

Posts: 7

Re: Textpattern article problem after restoring database

Thanks for your help!