[geeklog-users] SQL error on index.php

[Dirk Haun]

>I just finished installing Geelklog 1.3.9 on my machine.
>It is OS 10.3 with PHP 4.3.6 and MySQL 4.0.2
[...]
>Sat Jul 24 10:18:58 2004 - 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$
>CT DISTINCT count(*) AS dups, type, question, gl_stories.title, 
>gl_stories.sid, qid, max(gl_comments.date) as lastdate FROM gl_comments 
>LEFT JOIN gl_stories ON (($

This looks like the same issue that has already been discussed in several
forum threads, e.g. this one:
http://www.geeklog.net/forum/viewtopic.php?forum=1&showtopic=33026

The workaround is to set

$_CONF['hidenewcomments'] = 1;

in config.php. To actually resolve the problem, you'll have to upgrade MySQL.

bye, Dirk


-- 
http://www.haun-online.de/
http://www.macosx-faq.de/