Textpattern CMS

#1 2015-10-21 21:51:22

leegold

Member

Registered: 2011-04-11

Posts: 12

[Solved] New Install errors

General error Textpattern Error: Unknown column ‘load_order’ in ‘order clause’ on line 95

Tag error: <txp:article limit=“5” /> -> Textpattern Error: Unknown column ‘Expires’ in ‘where clause’ while parsing form None on page default

Tag error: <txp:article limit=“5” /> -> Textpattern Error: Unknown column ‘Expires’ in ‘field list’ while parsing form None on page default

I get this on the opening page. What is the problem?

Thanks

Last edited by leegold (2015-10-22 02:53:03)

#2 2015-10-21 22:17:45

Bloke

Developer

From: Leeds, UK

Registered: 2006-01-29

Posts: 11,271

Website GitHub

Re: [Solved] New Install errors

leegold wrote #296097:

General error Textpattern Error: Unknown column ‘load_order’ in ‘order clause’ on line 95

Sounds like the upgrade scripts (which run when you first log into the admin panel) haven’t done their job properly. Try this to resolve things:

1. Fully log out of the admin side if you are logged in.
2. Remove the txp_login cookie.
3. Visit your admin panel and do a hard refresh (CTRL-R normally does the trick).
4. Log in.

The upgrade scripts should run and complete. You may see some warnings depending on which bits of the process completed last time it ran, but it should get to the end and show you the languages panel where you can update your language strings.

If that doesn’t solve things you can trick Txp into thinking it’s just been installed. So, after logging out of the admin side, run this SQL from your client of choice (e.g. phpMyAdmin):

UPDATE `txp_prefs` SET val="1.0rc4" WHERE name='version'

Then delete any txp_login cookie and try logging in. Again, you’ll see (more) warnings and you may need to log out and in once more to complete the process (the documented ‘load_order’ column issue), but that should kick the installer into high gear.

This unfortunately happens occasionally. Bottom line is that the upgrade scripts need hardening to catch any errors, ensure you’re logged out, and so forth. It’s on the list. It’s just a big list.

---

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

#3 2015-10-21 22:39:41

leegold

Member

Registered: 2011-04-11

Posts: 12

Re: [Solved] New Install errors

I completely wiped textpattern and am going to reinstall.

also textpattern couldn’t access mysql – gave it a user w/global everything enabled. Not sure what’s going on – will try again.

#4 2015-10-21 23:01:43

leegold

Member

Registered: 2011-04-11

Posts: 12

Re: [Solved] New Install errors

reinstalled afresh – all’s well.

So far everything works now.

Thanks