acampana |
First Post Posted on: 07-17-09 07:20 AM |
MySQL error when registering a new user |
|
Hi\
In my auction site I went to register a new user amd when I select the Create Account button I got the following error :-\
\
\
\
SQL Error \
SQL Error: Incorrect decimal value: '' for column 'Total_Paid' at row 1\
Query: \
INSERT INTO Pending_Users (User_ID, Password, Email, FName, LName, Company, Job_Title, Street, City, \
State, Zip, Country, Phone, Mobile, Fax, Website, Payment_Method, Start_Date, Last_Updated, Status, User_Icon, \
Total_Paid, Current_Balance, Last_Paid_Date, User1, User2, User3, User4, User5, User6, User7, User8, User9, \
User10, User11, User12, User13, User14, User15, User16, User17, User18, User19, User20, Promotional_Code, \
Confirmation_Code) VALUES \
('acampana','test123','acampana@optusnet.com.au','Adrian','Campanaro','Oracle','QA',\
'1 test st','testcity','vic','3300','Australia','555 5555','0400 222 3333','555 6666',\
'http://localhost/mysite','','1136808560','1136808560','1','','','','','','','','','','','','','','','','','','','','','','','','','','ZP13D25N')\
Line 553, File C:/Program Files/Apache Group/Apache2/cgi-bin/auction/SQLlib.pm.\
\
\
Help would be appreciated.\
Thanks |
|
|
|
|
|
|
nibb |
Reply #: 1 Posted on: 07-17-09 03:47 PM |
Re: MySQL error when registering a new user |
|
I think you are using SQL server not MYSQL. The scripts require MYSQL, are you on a Windows server? |
|
|
|
|
|
acampana |
Reply #: 2 Posted on: 07-17-09 05:03 PM |
Re: MySQL error when registering a new user |
|
|
|
mikeinman |
Reply #: 3 Posted on: 07-18-09 04:14 PM |
Same problem |
|
I am having the same problem. i have tried a reinstall of the site and a reinstall of mysql and its still not working. so far everything els seems to be working fine. |
|
|
|
|
|
mewsoft |
Reply #: 4 Posted on: 07-20-09 04:28 AM |
Re: MySQL error when registering a new user |
|
That was old bug I think you just need to update the cgi files *.pm specialy the SQLlib.pm only. |
Mewsoft Support www.mewsoft.com
|
|
|
|
|
|