Welcome to Geeklog, Anonymous Monday, April 15 2024 @ 08:31 am EDT

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

 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 ...
 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....
 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.

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Henke: Can the links plugin be disabled?

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

bye, Dirk
 Quote

All times are EDT. The time is now 08:31 am.

  • 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