Forums Index > Mewsoft Products > Classifiedawy > Urgent: SQL Error: Out of range value adjusted for column 'CC_Month' at row 1
manishjain99 First Post Posted on: 07-26-11 06:48 AM
Urgent: SQL Error: Out of range value adjusted for column 'CC_Month' at row 1

Hi,\ \ I just bought the product yesterday so I have the latest download. Everything went just went fine. After clicking submit on registration page (after providing all the info) I get the followin error. Is there is the bug in the software. Need help fast. I have a demo for the site.\ \ SQL Error \ SQL Error: Out of range value adjusted for column 'CC_Month' 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, CC_Number, CC_Name, CC_Type, CC_Month, CC_Year, CC_CVV, CC_IssueNum, CC_Bank, CC_Phone, CC_Street, CC_City, CC_State, CC_Zip, CC_Country, Start_Date, Last_Updated, Status, User_Icon, Total_Paid, Current_Balance, Last_Paid_Date, Promotional_Code, Confirmation_Code, User1, User2, User3, User4, User5, User6, User7, User8, User9, User10, User11, User12, User13, User14, User15, User16, User17, User18, User19, User20) VALUES ('manish','manish','manishjain99@gmail.com','Manish','Jain','hello inc','Software Engineer','39380 civic center drive','fremont','ca','94538','US: California','510-7391654','','','','','','','','','','','','','','','','','','','1131651109','1131651109','1','','','','','','4TE1MYYW','','','','','','','','','','','','','','','','','','','','')\ Line 535, File C:/Apache/Apache2/cgi-bin/SQLlib.pm.
mewsoft Reply #: 1 Posted on: 07-26-11 05:38 PM
Re: Urgent: SQL Error: Out of range value adjusted for column 'CC_Month' at row 1

First, no bugs, second what is the url to your classified.cgi so we can check, you may be modified the selection ranges to be out of range for the cc month field or your sql tables not correctly created.

Mewsoft Support
www.mewsoft.com