#1956 Forums: TikiComments entry causes MySQL error

Rob Kelley

I discovered a nasty bug In loading one of our forum pages:

Warning: mysql error: 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 9 in query:

insert into
`tiki_comments`(`objectType`, `object`,
`commentDate`, `userName`, `title`, `data`, `votes`,
`points`, `hash`, `parentId`, `average`, `hits`,
`type`, `summary`, `smiley`, `user_ip`,
`message_id`, `in_reply_to`)
values ( ?, ?, ?, ?, ?, ?,
0, 0, ?, ?, 0, 0, ?, ?,
?, ?, ?, ?)

in /var/www/www.nycwireless.net/lib/tikidblib.php on
line 134

Notice: Undefined variable: smarty in
/var/www/www.nycwireless.net/lib/tikidblib.php on line 152
An error occured in a database query!

I can't tell if this is an offset error, a smarty
template error, an unescaped character, or what?

Any help?

You can open the attached text file for the full SQL
insert statement


  • Rob Kelley

    Rob Kelley - 2005-05-01
    • priority: 5 --> 7
  • Webcreature

    Webcreature - 2005-05-24

    Logged In: YES

    Possibly the error has a starting point in memory
    requirements of Smarty. I had several (not traceable) errors
    _with_ (e.g. Fatal error: Allowed memory size of blabla
    exhausted in blabla) and _without_ error reporting. In last
    case the call of the concerning script (e.g. tiki-index.php) with
    the effect, as if the file does not exist.

    Everything solved by increasing "memory_limit" in PHP.INI
    from =8M to =12M.

  • Oliver Hertel

    Oliver Hertel - 2006-09-20
    • status: open --> closed-works-for-me
  • Oliver Hertel

    Oliver Hertel - 2006-09-20

    Logged In: YES

    no bug but problem in system configuration


Log in to post a comment.