[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

>