Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 03:04 am EST
Geeklog Forums
1064: You have an error in your SQL syntax
Status: offline
barrywong
Forum User
Regular Poster
Registered: 04/12/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:
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:
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:
Text Formatted Code
Fri 12 Sep 2008 18:05:22 SGT - error in get_userdataFri 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:
7
10
Quote
All times are EST. The time is now 03:04 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