Welcome to Geeklog Monday, December 16 2019 @ 12:09 am EST

Geeklog Forums

SQL error: unknown column 'c.lft'


Status: offline

tlingit54

Forum User
Newbie
Registered: 04/01/05
Posts: 8
I recently upgraded Geeklog 1.3.9rc1 to 1.3.11.
When I got to the installation, and upgraded my SQL database, there were no installation errors.
But then I got a missing field right off the bat ('expire') which I copied from my wife's fresh 1.3.11 installation.
Now I'm getting the error below:

PHP Formatted Code

1054: Unknown column 'c.lft' in 'order clause'. SQL in question: SELECT c.*, u.username, u.fullname, u.photo, 0 as pindent, unix_timestamp(c.date) AS nice_date FROM gl_comments as c, gl_users as u WHERE c.sid = '20050103051841446' AND c.uid = u.uid ORDER BY c.lft ASC LIMIT 0, 100

 


Are there new fields in the 1.3.11 database that didn't get inserted somehow?

Thanks. I love Geeklog, btw---and have tried a number of them, in search of one that is usable for my wife's photolog.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
The 'lft' field was introduced in 1.3.10.

When you upgraded, are you sure you selected 1.3.9 as the previous version?

bye, Dirk
 Quote

Status: offline

tlingit54

Forum User
Newbie
Registered: 04/01/05
Posts: 8
That may have been my error; I remembered reading that v.1.3.9r1 was actually 1.3.10, so I selected 1.3.10 as the previous version.
However, I manually entered the missing fields into the tables and seems to be working fine now.
Luckily, I have another installation to compare to.
Thanks.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
Quote by tlingit54: I remembered reading that v.1.3.9r1 was actually 1.3.10, so I selected 1.3.10 as the previous version.

I don't know where you read that, but it is complete and utter nonsense.

Quote by tlingit54: However, I manually entered the missing fields into the tables and seems to be working fine now.

This is not a good idea. There were quite a few database changes between 1.3.9 and 1.3.10 and some of them require delicate updates of the existing data.

I'd strongly suggest you re-install your backup of the old database and do a proper update using the install script.

bye, Dirk
 Quote

All times are EST. The time is now 12:09 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content