Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-06-01 18:39:13

blueprint
Member
From: Netherlands
Registered: 2006-03-05
Posts: 43
Website

Is STATUS a reserved word in version 4.0.6

About a month ago I posted my problem with upgrading to 4.0.6. This problem was never solved (see posting). Basically the problem was that individual articles didn’t show up. The rest of the page was rendered correct.

This weekend I found some time to look further into the issue. I started with a new 406 install, and added all the tables manually from 405. The prefs table turned out to be the problem, and focussing further I found that there is an issue with custom fields.

In 405 I had a custom field named STATUS; and in 406 this was the source of the problem; renaming it to a complete other word didn’t cause any problem. Renaming one of the other custom fields to STATUS gave the same problem.

Anyone known with this issue??

Offline

#2 2008-06-01 18:57:06

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

Re: Is STATUS a reserved word in version 4.0.6

Yep, here is a similar problem caused by a custom field named ‘title’. So try to avoid all names used by TXP itself.

Offline

#3 2008-06-01 19:02:20

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,823
Website GitHub

Re: Is STATUS a reserved word in version 4.0.6

There’s a list of names to avoid on this page but ‘status’ is missing at the moment. Anyone with a wiki account care to add it?

Edit: Els beat me to it while I was finding the right page in Textbook :-)

Last edited by Bloke (2008-06-01 19:03:23)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#4 2008-06-01 19:09:22

blueprint
Member
From: Netherlands
Registered: 2006-03-05
Posts: 43
Website

Re: Is STATUS a reserved word in version 4.0.6

Thanx for the reply; a list that is certainly usefull is the attributes cross reference list; STATUS is on that list. But I am quite sure there are other words too.

Anyway, the good news is that my issue is solved. But it might be worth some entry in a WIKI or troubleshooting list.

Offline

#5 2008-06-01 19:10:05

jm
Plugin Author
From: Missoula, MT
Registered: 2005-11-27
Posts: 1,746
Website

Re: Is STATUS a reserved word in version 4.0.6

Anyone with a wiki account care to add it?

Done :).

Offline

#6 2008-06-01 19:11:23

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

Re: Is STATUS a reserved word in version 4.0.6

Hmm… looks to me as if all column names in the textpattern table are forbidden. Am I right?

Offline

#7 2008-06-01 19:20:37

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Is STATUS a reserved word in version 4.0.6

No, but you’re close. Some columns have been renamed. You can find the exact list in /textpattern/publish.php (in the populateArticleData function)

Offline

#8 2008-06-01 20:50:52

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

Re: Is STATUS a reserved word in version 4.0.6

Aha, thanks for explaining.

jm, care to add ‘modified’ and ‘override_form’ to the wiki list as well? ;)

Offline

Board footer

Powered by FluxBB