| ibscottish |
First Post Posted on: 08-30-08 04:46 AM |
| SQL Error |
|
| 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 |
Reply #: 1 Posted on: 08-30-08 09:24 AM |
| Re: SQL Error |
|
| 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. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| ibscottish |
Reply #: 2 Posted on: 08-31-08 04:14 AM |
| Re: SQL Error |
|
Thank you Mewsoft !\
\
- I tried that and I am getting the same results  |
|
|
|
|
|
| ibscottish |
Reply #: 3 Posted on: 08-31-08 05:46 AM |
| CAN'T REGISTER & IT IS DRIVING ME NUTZ !! |
|
| 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 |
Reply #: 4 Posted on: 08-31-08 07:46 AM |
| Re: SQL Error |
|
| What is you domain?. Delete all your sql tables, then recreate them again, if you get any errors, post them here. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
| ibscottish |
Reply #: 5 Posted on: 09-02-08 04:14 AM |
| no change |
|
| 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 |
Reply #: 6 Posted on: 09-02-08 02:31 PM |
| Re: SQL Error |
|
|
|
|
|