Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 09:46 am EST
Geeklog Forums
SQL error: unknown column 'c.lft'
Status: offline
tlingit54
Forum User
Newbie
Registered: 01/04/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:
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.
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:
Text 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.
11
8
Quote
Status: offline
tlingit54
Forum User
Newbie
Registered: 01/04/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.
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.
11
11
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/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
16
13
Quote
All times are EST. The time is now 09:46 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