Textpattern CMS support forum

You are not logged in. Register | Login | Help

#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

#2 2006-08-30 11:43:55

Sencer
Developer emeritus
From: cgn, de
Registered: 2004-03-23
Posts: 1,803
Website

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

#4 2006-08-30 13:40:43

jayrope
Plugin Author
From: Berlin
Registered: 2006-07-06
Posts: 647
Website

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

#5 2006-08-30 14:19:59

Sencer
Developer emeritus
From: cgn, de
Registered: 2004-03-23
Posts: 1,803
Website

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

Board footer

Powered by FluxBB