Welcome Visitor, Please Login or Register Now |
|
Friday, March 29, 2024 02:47 PM |
|
poldy |
Registered Member |
Posts: 90 |
Joined: 03-29-24 02:47 PM |
|
|
|
|
|
|
|
|
|
Data Base Problems |
Edit Delete Quote |
First Post Posted on: 08-02-09 09:12 AM |
|
|
|
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 |
Registered Member |
Posts: 90 |
Joined: 03-29-24 02:47 PM |
|
|
|
|
|
|
|
|
|
Re: Data Base Problems |
Edit Delete Quote |
Reply #: 1 Posted on: 08-02-09 09:43 AM |
|
|
|
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 |
|
|
|
|
|
|
|
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.0629 Seconds |
|