Geeklog Forums

Hello,
I upgraded to 1.4.1 the other day and by doing that I crashed the installation. Since then I get the error stated below in the logfile.
As far as I can tell the installation was successfull and the check whent fine.

Anyone know of a method to get the site online again?

Mon 23 Oct 2006 12:12:23 CEST - 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 '))) AND (perm_anon >= 2) ORDER BY date DESC LIMIT 15' at line 1. SQL in question: SELECT lid,title FROM gl_links WHERE (date >= (date_sub(NOW(), INTERVAL SECOND))) AND (perm_anon >= 2) ORDER BY date DESC LIMIT 15

Check the config.php file of the links plugin. Make sure it's not corrupted, doesn't have syntax errors, and contains a $_LI_CONF['newlinksinterval'] setting.

bye, Dirk

P.S. And a friendly reminder to have a backup handy when you're trying out beta software ...

Thanx Dirk I'll look into it and see if I can find any of them.

I didn't use the 1.4.1 but Geeklog_1.4.0sr5-1.

Ofcourse a backup is handy but I'm not able to do one....

Can the links plugin be disabled?

I checked as good I can, can't find any error. The
$_LI_CONF['newlinksinterval'] = 1209600; // = 14 days
is there.

In the gl_plugins table, find the "links" entry and set the field pi_enabled to 0.

bye, Dirk