Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2010-09-13 11:25:07
- Cyprian
- New Member
- Registered: 2010-09-13
- Posts: 5
Error during installation
I just started my textpattern experience.
And I started it with error. Damn.
Do you have any idea, how to solve this?
Unknown column ‘load_order’ in ‘order clause’ select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order in /textpattern/lib/txplib_db.php on line 85
Offline
#2 2010-09-13 11:48:56
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: Error during installation
Have you found this one?
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: Error during installation
Cyprian wrote:
Unknown column ‘load_order’…
Hi and welcome to TXP. Sorry about the hiccup. Does any of this help at all?
EDIT: dammit, too late :-)
Last edited by Bloke (2010-09-13 11:49:41)
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 2010-09-13 12:36:48
- Cyprian
- New Member
- Registered: 2010-09-13
- Posts: 5
Re: Error during installation
OK,
Thank guys. It helped somehow.
Here is how to solved this problem in 100%.
In TP databe find txp_prefs and than “version” and you can see there “1.0rc4”
Now you have to login to admin panel or your TP. It will probably not work, but when you refresh your database, in version you will see proper version of your TP. For me it became “4.2.0”
Now, modify “version“in database to “4.0.6”
If you change “1.0rc4” to “4.2.0”, without loggin in to admin panel, it will not work.
So you have to try to login to admin panel first.
Last edited by Cyprian (2010-09-13 12:38:06)
Offline
Re: Error during installation
Cyprian wrote:
If you change “1.0rc4” to “4.2.0”, without loggin in to admin panel, it will not work.
Hmmm, I can sort of understand why this happens. When you install TXP, it sets the system to a known initial state (1.0rc4). When you log in for the first time it then runs through all the update scripts and makes database changes to bring everything up to the latest version.
My guess is that at some point, either something went stray or your chosen MySQL user didn’t have quite enough privileges to perform one of the tasks. The weird thing is that if it was a permissions thing, I can’t see why it would manage to perform other ‘alter’ tasks (like adding Expires to the textpattern table) but not be able to add load_order to the txp_plugin table.
We do see this behaviour every so often and I’d love to find out under what circumstances / server configurations it fails so we can address it. Would be good to collate relevant server info from people who have failed installations and see if any patterns emerge.
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
Pages: 1