Posted on: 01/10/05 11:26am
By: tlingit54
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.
SQL error: unknown column 'c.lft'
Posted on: 01/10/05 02:03pm
By: Dirk
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
SQL error: unknown column 'c.lft'
Posted on: 01/10/05 09:52pm
By: tlingit54
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.
SQL error: unknown column 'c.lft'
Posted on: 01/11/05 01:56am
By: Dirk
[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.[/QUOTE]
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.[/QUOTE]
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