Posted on: 07/11/04 03:46am
By: Anonymous (amigo)
Hi, I just updated version 1.3.8 sr4 to 1.3.9 sr1. I intalled the filed in their respective plase and edit the lib-common.php file. But when I went to refresh the page it gave me a sql error.
This is what the error log has.
Sun Jul 11 03:13:39 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 near 'WHERE is_enabled = 1' at line 1. SQL in question: SELECT fid,type,topic,limits,update_info FROM WHERE is_enabled = 1
Any idea how this can be fix?
error in your SQL syntax
Posted on: 07/11/04 04:08am
By: Dirk
Make sure you've replaced the lib-database.php as well: /path/to/geeklog/system/lib-database.php
bye, Dirk
error in your SQL syntax
Posted on: 07/11/04 11:30pm
By: Anonymous (amigo)
That file was not in the update package. Anyway I did as you told me, and not only that file but replace all the system files with the ones from version 1.3.9 sr 1. Now this is what I get in error.log
Sun Jul 11 23:21:18 2004 - 1146: Table 'hcast.gl_syndication' doesn't exist. SQL in question: SELECT fid,type,topic,limits,update_info FROM gl_syndication WHERE is_enabled = 1
error in your SQL syntax
Posted on: 07/12/04 01:56am
By: Dirk
[QUOTE BY= amigo] That file was not in the update package.[/QUOTE]
Which tarball did you use to upgrade? When you're coming from 1.3.8, you'll have to use the full 1.3.9sr1 tarball (not the 1.3.9sr1 upgrade, which is only for 1.3.9 installs). And don't forget to run the install script in upgrade mode afterwards.
That will probably solve all your problems ...
bye, Dirk