[geeklog-users] SQL error on index.php

[Everett Littles]

Dirk,

Thanks for the workaround. It worked great.  I kept searching the 
forums and obviously missed this thread.

Thanks again.


On Jul 24, 2004, at 11:04 AM, Dirk Haun wrote:

>> 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/
>
> _______________________________________________
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-users
>