Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2010-11-30 20:07:40
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: ok to upgrade from 4.0.6 to 4.3.0?
There are two more preferences settings that you can check, “Allow PHP in pages?’ and ‘Allow PHP in articles?’ (Advanced Preferences)
Don’t the errors disappear if you log out and then in again?
Offline
#14 2010-11-30 20:13:31
- angelika
- Member
- Registered: 2010-11-30
- Posts: 13
Re: ok to upgrade from 4.0.6 to 4.3.0?
“Allow PHP in pages?’ and ‘Allow PHP in articles?’ are both set to yes. It that how it should be?
Offline
#15 2010-11-30 20:14:05
- angelika
- Member
- Registered: 2010-11-30
- Posts: 13
Re: ok to upgrade from 4.0.6 to 4.3.0?
Ok, I’ll try the reinstall.
Offline
#16 2010-11-30 20:17:11
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: ok to upgrade from 4.0.6 to 4.3.0?
angelika wrote:
“Allow PHP in pages?’ and ‘Allow PHP in articles?’ are both set to yes. It that how it should be?
If you have <txp:php> tags in your page or in an article, yes. ‘Allow raw PHP’ is always best set to ‘no’, you don’t need it when using the <txp:php> tags.
Ok, I’ll try the reinstall.
Good luck :) Are you following these instructions?
Offline
#17 2010-11-30 20:22:39
- angelika
- Member
- Registered: 2010-11-30
- Posts: 13
Re: ok to upgrade from 4.0.6 to 4.3.0?
Yes, I’m following the instructions. A question about the txp_prefs table. Which columns is it supposed to have? The error message keeps asking for the column user_name and there isn’t one. Is there supposed to be?
/A
Offline
Re: ok to upgrade from 4.0.6 to 4.3.0?
angelika wrote:
I’m so very grateful for all your help!
No problem – although we haven’t helped fix it quite yet :)
The config.php file seems fine to me.
That’s good.
The mode is set to Test. I think I’ll leave it like that for the time being, I don’t want to miss any messages.
Good idea – and you may find debugging may be useful at this point
The only setting that is of when it comes to php is “Allow raw PHP?”.
Sounds like something is missing
In that area you should have:
- Use plugins? No Yes
- Use admin-side plugins? No Yes
- Allow PHP in pages? No Yes
- Allow PHP in articles? No Yes
- Allow raw php? No Yes
If the plugin preference there is set to “no” you’d also get the tag missing warning.
The first two php setting deal with the txp:php tag (like the error).
I’m not sure why they’d be missing but the raw php setting would show up.
I can find the plugin in the txp_plugin table, but under the Plugin tab there are only error messages and a field for uploading new plugins. Error messages: ……..Also, the error messages seem to be true, there really is no column named user_name in the txp_prefs. Should there be? Is there som db script that has not been run?
Hmm – with that many unknown columns . . . I’ve not run into that particular situation. I’m sorry I can’t help more. Hopefully some of the other folks can jump in shortly. It does sound like part of the issue could require some work w/ the database.
Do you have a back up of the database prior to upgrading?
Last edited by maverick (2010-11-30 20:29:19)
Offline
Re: ok to upgrade from 4.0.6 to 4.3.0?
angelika wrote:
“Allow PHP in pages?’ and ‘Allow PHP in articles?’ are both set to yes. It that how it should be?
Els beat me to the post. Sorry for the duplicate answer :)
Offline
#20 2010-11-30 20:40:30
- angelika
- Member
- Registered: 2010-11-30
- Posts: 13
Re: ok to upgrade from 4.0.6 to 4.3.0?
You know, i think at least one of my problems is that the db has not been updated at all. If I look in _to_4.0.7.php for example, I find this:
$txpplugin = getThings(‘describe `’.PFX.‘txp_plugin`’); if (!in_array(‘load_order’, $txpplugin)) { safe_alter(‘txp_plugin’, “ADD load_order TINYINT UNSIGNED NOT NULL DEFAULT 5”); }
There is no column load_order in the table txp_plugin, so the update has not been made. It there a way to trigger this?
Offline
Re: ok to upgrade from 4.0.6 to 4.3.0?
angelika wrote:
There is no column load_order in the table txp_plugin, so the update has not been made. It there a way to trigger this?
This happens from time to time and we’ve never tracked down the actual reason (DB privs for UPDATEs or something?). Regardless, logout of TXP, go into phpMyAdmin, find the txp_prefs table and set version to an older version, like 4.0.6, then log into the TXP admin side again. That should trigger the update mechanism from that version forward.
Last edited by Bloke (2010-11-30 20:45:24)
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
Online
#22 2010-11-30 21:06:37
- angelika
- Member
- Registered: 2010-11-30
- Posts: 13
Re: ok to upgrade from 4.0.6 to 4.3.0?
Yes! It effing works! I’m so happy I think I’m gonna dance!
The version trick in the db did he trick.
Thank you all for your patience and help!
/Angelika
Offline