Welcome to Geeklog, Anonymous Monday, November 11 2024 @ 12:05 pm EST
Geeklog Forums
Upgrade issue
Henke
Anonymous
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
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
7
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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 ...
bye, Dirk
P.S. And a friendly reminder to have a backup handy when you're trying out beta software ...
9
9
Quote
Henke
Anonymous
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....
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....
8
9
Quote
Henke
Anonymous
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.
I checked as good I can, can't find any error. The
$_LI_CONF['newlinksinterval'] = 1209600; // = 14 days
is there.
7
7
Quote
All times are EST. The time is now 12:05 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content