Welcome Visitor, Please Login or Register Now Friday, March 29, 2024 02:47 PM 
Forums Index > Mewsoft Products > Auctionawy > Data Base Problems
New Topic   New Reply
Search for:
Author Message
poldy poldy's personal page
Registered Member
Posts: 90 Display member's posts
Joined: 03-29-24 02:47 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Data Base Problems Edit Delete Reply with quote Quote
First Post Posted on: 08-02-09 09:12 AM next post first post
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 poldy's personal page
Registered Member
Posts: 90 Display member's posts
Joined: 03-29-24 02:47 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: Data Base Problems Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 08-02-09 09:43 AM last post previous post
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
Page 1 of 1
Go to page:

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