Welcome Visitor, Please Login or Register Now |
|
Friday, April 26, 2024 08:38 AM |
|
ibscottish |
Registered Member |
Posts: 4 |
Joined: 02-22-05 10:34 AM |
|
|
|
|
|
|
|
|
|
SQL Error |
Edit Delete Quote |
First Post Posted on: 08-30-08 04:46 AM |
|
|
|
Help >>> PLEASE ?????!!\
\
I am unable to register to my site \
\
Error Creating Pending Users Table: 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 'User1 VARCHAR(100), User2 VARCHAR(100), User3 VAR.\
Error Creating Pending Users Index: Table 'xxxxxx_auc00.Pending_Users' doesn't exist.\
\
and >>\
\
SQL Error: Table 'amtgfrbd_auc00.Pending_Users' doesn't exist\
Query: \
SELECT User_ID FROM Pending_Users ORDER BY Start_Date DESC, User_ID ASC\
Line 751, File /home/xxxxxx/public_html/cgi-bin/auction/sqldriver.pm.\
\
at Pending Admin console.\
\
please help !!!???\
\
I have reset sql db's 2 times and no changes |
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-26-24 08:38 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
ibscottish |
Registered Member |
Posts: 4 |
Joined: 02-22-05 10:34 AM |
|
|
|
|
|
|
|
|
|
Re: SQL Error |
Edit Delete Quote |
Reply #: 2 Posted on: 08-31-08 04:14 AM |
|
|
|
Thank you Mewsoft !\
\
- I tried that and I am getting the same results |
|
|
|
|
|
ibscottish |
Registered Member |
Posts: 4 |
Joined: 02-22-05 10:34 AM |
|
|
|
|
|
|
|
|
|
CAN'T REGISTER & IT IS DRIVING ME NUTZ !! |
Edit Delete Quote |
Reply #: 3 Posted on: 08-31-08 05:46 AM |
|
|
|
Please send more options about my dillema ..\
\
I am trying to register to my auction site but keep getting the previous mentioned errors.\
\
I have tried the suggestion from mewsoft >3x.\
\
>>(Create the SQL tables from admin -> setup wizard ->Create SQL Tables.\
\
Of course you need to set the SQL atabase info in your admin->configuration. )\
\
still no luck..\
\
please help. |
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-26-24 08:38 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
|
ibscottish |
Registered Member |
Posts: 4 |
Joined: 02-22-05 10:34 AM |
|
|
|
|
|
|
|
|
|
no change |
Edit Delete Quote |
Reply #: 5 Posted on: 09-02-08 04:14 AM |
|
|
|
thank you mewsoft - I have deleted all tables and recreated and I am getting the same results.\
as follows...............\
\
1. SQL Error \
SQL Error: Table 'username_auc00.Pending_Users' doesn't exist\
Query: \
SELECT * FROM Pending_Users WHERE User_ID=''\
Line 558, File /home/username/public_html/cgi-bin/auction/signup.pm.\
\
And,\
\
2. Error Creating Pending Users Table: 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 'User1 VARCHAR(100), User2 VARCHAR(100), User3 VAR.\
Error Creating Pending Users Index: Table 'username_auc00.Pending_Users' doesn't exist.\
\
\
And,\
\
3. SQL Error \
SQL Error: Table 'username_auc00.Pending_Users' doesn't exist\
Query: \
SELECT User_ID FROM Pending_Users ORDER BY Start_Date DESC, User_ID ASC\
Line 751, File /home/username/public_html/cgi-bin/auction/sqldriver.pm. \
\
------------------\
\
What can cause errors in sql syntax and how do I check that ??.\
\
Thank you |
|
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-26-24 08:38 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
Re: SQL Error |
Edit Delete Quote |
Reply #: 6 Posted on: 09-02-08 02:31 PM |
|
|
|
|
|
|
|
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.1802 Seconds |
|