Welcome Visitor, Please Login or Register Now |
|
Friday, March 29, 2024 07:57 AM |
|
acampana |
Registered Member |
Posts: 8 |
Joined: 01-08-06 06:09 AM |
|
|
|
|
|
|
|
|
|
MySQL error when registering a new user |
Edit Delete Quote |
First Post Posted on: 07-17-09 07:20 AM |
|
|
|
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 |
Registered Member |
Posts: |
Joined: 03-29-24 07:57 AM |
|
|
|
|
PM |
|
|
|
|
Re: MySQL error when registering a new user |
Edit Delete Quote |
Reply #: 1 Posted on: 07-17-09 03:47 PM |
|
|
|
I think you are using SQL server not MYSQL. The scripts require MYSQL, are you on a Windows server? |
|
|
|
|
|
acampana |
Registered Member |
Posts: 8 |
Joined: 01-08-06 06:09 AM |
|
|
|
|
|
|
|
|
|
Re: MySQL error when registering a new user |
Edit Delete Quote |
Reply #: 2 Posted on: 07-17-09 05:03 PM |
|
|
|
|
|
mikeinman |
Registered Member |
Posts: 7 |
Joined: 01-10-06 09:51 PM |
|
|
|
|
|
|
|
|
|
Same problem |
Edit Delete Quote |
Reply #: 3 Posted on: 07-18-09 04:14 PM |
|
|
|
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 |
Administrator Team Member |
Posts: 5381 |
Joined: 03-29-24 07:57 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
|
|
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.1234 Seconds |
|