Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • Forum edit problems

    Posted by SirVer

    Hi,

    i'm running a tiki-ligth 1.8.4 at widelands.sf.net. Always when i try to edit my forum posts, the following message shows up in my browser:

    Warning: mysql error: You have an error in your SQL syntax near ' `threadId` LIMIT 0,20' at line 10 in query:
    select a.`threadId`,a.`object`,a.`objectType`,a.`parentId`, a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`, a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`, a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating`, IFNULL(max(b.`commentDate`), a.`commentDate`) as `lastPost`, count(b.`threadId`) as `replies` from `tiki_comments` a left join `tiki_comments` b on b.`parentId`=a.`threadId` where a.`object`=? and a.`type` = ? and a.`objectType` = 'forum' and a.`parentId` = ? group by a.`threadId`,a.`object`,a.`objectType`,a.`parentId`,a.`userName`,a.`commentDate`,a.`hits`,a.`type`,a.`points`,a.`votes`,a.`average`,a.`title`,a.`data`,a.`hash`,a.`user_ip`,a.`summary`,a.`smiley`,a.`message_id`,a.`in_reply_to`,a.`comment_rating` order by , `threadId`
    in /var/local/home/groups/w/wi/widelands/htdocs/wiki/tikilight_1.8.4/lib/tikidblib.php on line 133

    Fatal error: Call to a member function on a non-object in /var/local/home/groups/w/wi/widelands/htdocs/wiki/tikilight_1.8.4/lib/tikidblib.php on line 151

    Is this a know issue, what can i do to fix it?

    : Edit :
    I think this is mysql version related. when i run this on my box with mysql 4.0.22 no problems occure. The sf.net server delivers:
    mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

    If my suggestion is right, i need a workaround, but since i'm a full PHP noob, i need some advice.
    : Edit :

    Cheers,
    Holger

    Reads: 1549
    Posted by sylvie greverend

    It is a tikilight problem.
    Damian, do you have a forum for tikilight outside tw.org ? Otherwise a new forum on tw.org will be great.



    Posted by sylvie greverend

    Just an idea..... not sure at all
    The syntax error is around the place that has the sort information" order by , `threadId`" .
    It can be a problem with mysql ... It can be a problem with the value of the sort info set in the database.
    Check your url around the parameter topics_sort_mode, can be lastPost_desc. or add comments_sort_mode=commentDate_desc
    never knows ...


    Posted by SirVer

    Hi,

    this is no tiki light problem. Same problem occures under full tiki version,
    when it is a SQL version problem, how can i fix it?

    Holger