| poldy |
First Post Posted on: 08-02-09 09:12 AM |
| Data Base Problems |
|
| I only checkes 2 items:\
New user registration and posting an item.\
I get the following SQL Errors:\
This for posting an item:\
\
SQL Error: Incorrect decimal value: '' for column 'Buy_Price' at row 1\
Query:\
INSERT INTO Items (ID, Cat_ID, CatA_ID, User_ID, Bids, Current_Bid, Sponser, Price, Title, Description, Image, Quantity, Sold, Start_Bid, Increment, Reserve, Buy_Price, Duration, Start_Time, End_Time, Resubmit, Resubmited, Private, PaymentMethods, PaymentDetails, ShipTo, ShipToDetails, ShipTime, ShipPayment, ShipPaymentDetails, Bold, Colored, Featured, Featured1, Gift_Icon, Media, Media_Show, Item_Language, Gallery, Gallery_Img, Banner, Homepage, Status, Reason, Currency, SubTitle, Type, ShipAddress, ShipZip, ShipInsurance, Insurance, ReturnPeriod, ReturnMethod, ReturnDetails, ShipService1, ShipCost1, ShipCostNext1, ShipService2, ShipCost2, ShipCostNext2, ShipService3, ShipCost3, ShipCostNext3, ShipDetails, PackageWeight, PackageWeight1, PackageType, PackageW, PackageH, PackageL, PackageUnit, SalesTax, ShipTax, Ad1, Ad2, Ad3, Ad4, Ad5, Ad6, Ad7, Ad8, Ad9, Ad10, Ad11, Ad12, Ad13, Ad14, Ad15, Ad16, Ad17, Ad18, Ad19, Ad20, Ads1, Ads2, Ads3, Ads4, Ads5, Ads6, Ads7, Ads8, Ads9, Ads10, Ads11, Ads12, Ads13, Ads14, Ads15, Ads16, Ads17, Ads18, Ads19, Ads20) VALUES ('1138201351', '35', '7', 'poldy', '0', '10', '0', '0', 'test', 'test', '', '1', '0', '10', '2.00', '12', '', '7', '1138208551', '1138813351', '0', '0', '0', '', '', '', '', '1', '1', '', '0', '', '0', '0', '', '', '0', 'Hebrew', '0', '', '', '', '1', '0', 'ILS', '', '1', '11', '11', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')\
Line 49, File Q:/pumbit.com/www3/cgi-bin/auction/SQLlib.pm.\
\
\
And this for new User:\
\
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 ('qwq','qqqqq','qqq@qqq.com','weww','ewwqe','','','wewqewq','wqewqew','','44223','Israel','3432432423','','','','','1138208145','1138208145','1','','','','','34324324','Friend','','','','','','','','','','','','','','','','','','','','8E5SC43V')\
Line 572, File Q:/pumbit.com/www3/cgi-bin/auction/SQLlib.pm.\
\
\
We are running MYSql 5\
\
Please try to help as quickly as possible. This is a production site.\
Thank you |
|
|
|
|
|
 |
| poldy |
Reply #: 1 Posted on: 08-02-09 09:43 AM |
| Re: Data Base Problems |
|
| I found the fix. Sorry.\
Do you have list of changes for sqllib. we have some changes in the file and i would like to keep them.\
\
thanks |
|
|
|
|
|
|