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

Geeklog Forums

1064: You have an error in your SQL syntax


Status: offline

barrywong

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.

Note:
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

:banghead:
 Quote

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