Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 07:47 am EDT

Geeklog Forums

Comment (?) error after 1.6.0sr1 upgrade


Status: offline

Jokke_K

Forum User
Newbie
Registered: 02/24/04
Posts: 9
Hello,

I'm getting following error message in error.log:

Sat Aug 1 14:04:28 2009 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET commentcode = '1' WHERE sid = '20070108213841653'' at line 1. SQL in question: UPDATE SET commentcode = '1' WHERE sid = '20070108213841653'

when accessing articles.

Ideas? I forget to update some file?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, I guess that's a missing global declaration in the story class. Try this:

Open system/classes/story.class.php and find the function DisplayElements (line 1459):
Text Formatted Code
    function DisplayElements($item = 'title')
    {
        global $_CONF;

Change that global declaration like so:
Text Formatted Code
    function DisplayElements($item = 'title')
    {
        global $_CONF, $_TABLES;

See if that helps.

bye, Dirk
 Quote

Status: offline

Jokke_K

Forum User
Newbie
Registered: 02/24/04
Posts: 9
Thanks,

Problem solved.
 Quote

All times are EDT. The time is now 07:47 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