Welcome Visitor, Please Login or Register Now Friday, March 29, 2024 07:57 AM 
Forums Index > Mewsoft Products > Auctionawy > MySQL error when registering a new user
New Topic   New Reply
Search for:
Author Message
acampana acampana's personal page
Registered Member
Posts: 8 Display member's posts
Joined: 01-08-06 06:09 AM
Member Offline
View Member's Profile Send private message
 
Back to top
MySQL error when registering a new user Edit Delete Reply with quote Quote
First Post Posted on: 07-17-09 07:20 AM next post first post
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 nibb's personal page
Registered Member
Posts: Display member's posts
Joined: 03-29-24 07:57 AM
Member Offline
View Member's Profile PM
 
Back to top
Re: MySQL error when registering a new user Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 07-17-09 03:47 PM next post previous post
I think you are using SQL server not MYSQL. The scripts require MYSQL, are you on a Windows server?
acampana acampana's personal page
Registered Member
Posts: 8 Display member's posts
Joined: 01-08-06 06:09 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: MySQL error when registering a new user Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 07-17-09 05:03 PM next post previous post
I am using MySQL.
mikeinman mikeinman's personal page
Registered Member
Posts: 7 Display member's posts
Joined: 01-10-06 09:51 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Same problem Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 07-18-09 04:14 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-29-24 07:57 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: MySQL error when registering a new user Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 07-20-09 04:28 AM last post previous post
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

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print