The secure CMS.

Welcome to Geeklog, Anonymous Wednesday, October 09 2024 @ 12:50 am EDT

Geeklog Forums

SQL Error - Unknown column 'c.lft'

 New Topic  Post Reply
 05/18/04 05:07pm (Read 1,413 times)  
Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
When I click on a story title from the story list in Story Admin page, I get an SQL error, with the following message in the error.log.

Text Formatted Code
Tue May 18 17:00:54 2004 - 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 = '20040512135909340' AND c.uid = u.uid ORDER BY c.lft ASC LIMIT 0, 100

 


BTW, this is after updating the site with new CVS files up to May 17, 2004.

Sam
 Quote
 05/18/04 05:56pm  
Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
Figured out!
 Quote
 02/08/05 01:27pm  
Status: offline

greenhil

Forum User
Chatty
Registered: 07/20/04
Posts: 51
hi, i really need to know what your solution was..!

please post asap...thanks in advance!

Jonathan
 Quote
 02/08/05 03:50pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The 'lft' field was added to the gl_comments table in Geeklog 1.3.10. You've probably done something wrong when upgrading from an older version. Re-install your backup and try again.

bye, Dirk
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 12:50 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