Welcome to Geeklog Saturday, September 19 2020 @ 12:46 pm EDT

Geeklog Forums

1064: You have an error in your SQL syntax

Status: offline


Forum User
Regular Poster
Registered: 12/04/02
Posts: 95
I am not sure if this should be raised as a Plugin problem or a Geeklog Database problem. I decided to enter the query here as I think this is a Geeklog problem for those of us who plan to upgrade their OS or database.

I have MediaGallery plugin installed on my Geeklog. It was running well before I upgraded my server's OS from Centos (RHE) 4.6 to 5.2. After the OS upgrade, I notice problems with uploading pics to my MediaGallery via Web Publishing Wizard.

The error message with Web Publishing Wizard is:

Web Service Error
The wizard could not connect to the Internet, or the Web service returned a wizard page that is not valid. To try again, click Back. To close this wizard, click Cancel.

Checking my error.log, I see:
PHP Formatted Code
Fri 12 Sep 2008 18:05:22 SGT - error in get_userdata
Fri 12 Sep 2008 18:05:22 SGT - 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: DELETE FROM spsp_sessions WHERE uid =

I suspect that the upgrade process have modified my existing setting or my database. Can you tell me what could possible be wrong and how to fix this problem.

Centos 5.2 (from Centos 4.6)
MYSQL: 5.0.45
PHP: 5.1.6

I am planning to upgrade Geeklog and plugins after the OS upgrade.

I am now running:
Media Gallery Installed Version: 1.2.5
Geeklog Version: 1.4.0sr2


All times are EDT. The time is now 12:46 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