My box (Windows 2003 Server, IIS 6) had PHP 4.4.0 (i believe) installed on it and everything was working fine with geeklog 1.4.1. I then installed PHP 5.2 and I now get this error going to the home page:
An SQL error has occurred. Please see error.log for details.
And the error log contains:
01/16/07 13:40:53 - 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 near '
' at line 1. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
Now I realize that the sql statement is missing data in the () but I don't know why?
When I did this install on my test server everything went fine (it was a fresh php install not an install over php 4). PHPMyAdmin does work fine on the new install.
One of the Geeklog Core Developers.