The secure CMS.

Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 07:40 pm EST

Geeklog Forums

Comment submission issue

 New Topic  Post Reply
 03/19/12 06:23am (Read 1,847 times)  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
On one of my geeklog 1.8.1 site when users submit comments the page display the message "An SQL error has occurred."

Log file is
Text Formatted Code
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 ')' at line 1. SQL in question: REPLACE INTO gl_commentnotifications (uid,deletehash,mid) VALUES (39,'50dee73dc953c0283b320bc0e57b0c4f',)


I can't reproduce it on demo site. What can I do to avoid this error

From lib-comment.php near line 1217
Text Formatted Code

//null goes into cid, comment not published yet, set moderation queue id
DB_save($_TABLES['commentnotifications'], 'uid,deletehash,mid',"$uid,'$deletehash',$cid");
 

$cid seems to be null in this case.

Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote
 03/19/12 07:52pm  
Status: offline

Roccivic

Forum User
Moderator
Registered: 05/19/10
Posts: 136
Something to do with this bug?
 Quote
 03/20/12 05:06am  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Certainly. I solved my issue by adding $cid = 0

Text Formatted Code

// save user notification information
    if (isset($_POST['notify']) && ($ret == -1 || $ret == 0) ) {
        $deletehash = md5($title . $cid . $comment . rand());
        if ($ret == -1) {
            //null goes into cid, comment not published yet, set moderation queue id
            $cid = 0; // comment went into the submission queue
            DB_save($_TABLES['commentnotifications'], 'uid,deletehash,mid',"$uid,'$deletehash',$cid");
        } else {
            DB_save($_TABLES['commentnotifications'], 'cid,uid,deletehash',"$cid,$uid,'$deletehash'");
        }
    }


Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote
 New Topic  Post Reply
All times are EST. The time is now 07:40 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