Welcome to Geeklog Tuesday, February 18 2020 @ 07:18 pm EST

Geeklog Forums

Comment (?) error after 1.6.0sr1 upgrade


Status: offline

Jokke_K

Forum User
Newbie
Registered: 24/02/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: 12/01/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):
PHP Formatted Code
    function DisplayElements($item = 'title')
    {
        global $_CONF;

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

See if that helps.

bye, Dirk
 Quote

Status: offline

Jokke_K

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

Problem solved.
 Quote

All times are EST. The time is now 07:18 pm.

  • 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