Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2006-08-30 11:10:16
- filip baraka
- Member
- Registered: 2006-06-05
- Posts: 24
Publish Article doesn't work
txp: 4.0.3 stable dl version
hosting: howe at textdrive
sibenikregion.com status:live
Article doesn’t get published; when i wan’t to add new article nothing happens, page is submiting but after reload i’m getting the same old “publish” btn;( on textdrive forums i got reply that it can be connected with auto-increment of id’s but i’m sure that that option was selected during export of db (site is up and running for few days now)
Help please
Offline
Re: Publish Article doesn't work
Your problems are likely due to a bug/error that occurred when you moved your site (i.e., exported & imported your mysql-tables). There is more information and instructions of how to fix it here:
http://forum.textpattern.com/viewtopic.php?id=17614
If possible, I recommend a fresh export/import (while checking that auto_increment is not missing this time). Otherwise you have to fix it manually.
(Given that this problems seems to crop up a lot, maybe someone wants to write a plugin that fixes this error…)
Offline
#3 2006-08-30 11:48:07
- filip baraka
- Member
- Registered: 2006-06-05
- Posts: 24
Re: Publish Article doesn't work
tnx sencer, im going to post update on this, right now i will have a nice lunch;)
Offline
Re: Publish Article doesn't work
sencer, how would you fix this manually then? would that mean fixing mysql table entries via phpMyAdmin for instance?
A hole turned upside down is a dome, when there’s also gravity.
Offline
Re: Publish Article doesn't work
There is 9 instances of auto_increment in textpattern/setup/txpsql.php. Those would have to be recreated as described in the topic that I linked to.
textpattern.ID
txp_category.id
txp_discuss.discuss_id
txp_file.id
txp_image.id
txp_lang.id
txp_link.id
txp_log.id
txp_users.user_id
Last edited by Sencer (2006-08-30 14:24:51)
Offline
#6 2006-08-30 20:05:18
- filip baraka
- Member
- Registered: 2006-06-05
- Posts: 24
Re: Publish Article doesn't work
Update
I reimported whole db, mostly because I added dozen articles at localhost
i’m now sure that ai option was on and again same thing, so my guess that this bug is persistent in this version of mysql (MySQL – 4.1.20)
So i manualy updated id fields as sencer pointed out (but i skipped the 2.step —> assigning the value above last id) and all works fine, well, for now:)
Tnx for help
Sencer: that plugin idea is not bad:)
Offline
Pages: 1