Welcome to Geeklog, Anonymous Thursday, October 10 2024 @ 11:32 pm EDT
Geeklog Forums
SQL error-- please help!
db
Anonymous
My site reads:
An SQL error has occured. Please see error.log for details.
The error log tells me:
Tue Jan 4 16:27:41 2005 - 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 'WHERE sp_id = 'caedynraine'' at line 1. SQL in question: SELECT sp_title FROM WHERE sp_id = 'caedynraine'
Then repeats it about 34 times.
What do I need to do? I know a good amount about MySQL and have been tinkering with it, but have no idea what will help. Thanks so much!
An SQL error has occured. Please see error.log for details.
The error log tells me:
Tue Jan 4 16:27:41 2005 - 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 'WHERE sp_id = 'caedynraine'' at line 1. SQL in question: SELECT sp_title FROM WHERE sp_id = 'caedynraine'
Then repeats it about 34 times.
What do I need to do? I know a good amount about MySQL and have been tinkering with it, but have no idea what will help. Thanks so much!
8
8
Quote
Status: Banned
machinari
Forum User
Full Member
Registered: 03/22/04
Posts: 1512
according to the error, you are missing a table name that should be present between "FROM" and "WHERE."
you'll have to search for that query in your staticpages php files and find out why the table variable is not being passed. or something like that.
I am assuming that the 'sp' equal staticpages plugin
you'll have to search for that query in your staticpages php files and find out why the table variable is not being passed. or something like that.
I am assuming that the 'sp' equal staticpages plugin
8
10
Quote
All times are EDT. The time is now 11:32 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