| acampana |
First Post Posted on: 07-21-09 05:49 AM |
| Problems inseting Seller items |
|
| When I try to insert a seller item I keep getting the following error:-\
\
SQL Error \
SQL Error: Incorrect decimal value: '' for column 'Reserve' 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 ('1137109316', '3', '1', 'acampana3', '0', '11000', '0', '0', 'Thisi s a tyes', 'sfdf sdfsdf\n\nf\nfs\ndfs\nf\n\nfsdfsdfdf', '', '11', '0', '11000', '100.00', '', '11111', '7', '1137148916', '1137753716', '0', '0', '0', '', '', '', '', '1', '1', '', '0', '', '0', '0', '', '', '0', 'English', '0', '', '', 'http://', '1', '0', 'USD', '', '1', 'asdasasdasas', '2312', '1', '', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')\
Line 49, File C:/Program Files/Apache Group/Apache2/cgi-bin/auction/SQLlib.pm.\
\
\
\
I try adding all required fields but it keeps giving me errors like the one above or invalid Insurance, ShipCost1 etc. |
|
|
|
|
|
 |
| mewsoft |
Reply #: 1 Posted on: 07-21-09 07:23 AM |
| Re: Problems inseting Seller items |
|
| Seems you are using MySQL server 5.xx, anyway, download the latest Auctinawy.zip version from our site "My Account" and update only the module SQLlib.pm to fix this. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| john_sam |
Reply #: 2 Posted on: 05-25-10 08:04 PM |
| Incorrect decimal value |
|
| I'm getting the same error. I'm running MySql 5 and just downloaded the software. My update button only gives "Page Cannot Be Found" error when pressed.\
\
The SQLlib.pm file is dated 9/28/06\
\
HELP!! |
|
|
|
|
|
| john_sam |
Reply #: 3 Posted on: 05-25-10 08:09 PM |
| Incorrect decimal value |
|
| I'm getting the same error. I'm running MySql 5 and just downloaded the software. My update button only gives "Page Cannot Be Found" error when pressed.\
\
The SQLlib.pm file is dated 9/28/06\
\
HELP!! |
|
|
|
|
|
| john_sam |
Reply #: 4 Posted on: 05-25-10 08:10 PM |
| Incorrect decimal value |
|
| I'm getting the same error. I'm running MySql 5 and just downloaded the software. My update button only gives "Page Cannot Be Found" error when pressed.\
\
The SQLlib.pm file is dated 9/28/06\
\
HELP!! |
|
|
|
|
|
| mewsoft |
Reply #: 5 Posted on: 05-27-10 02:30 AM |
| Re: Problems inseting Seller items |
|
| To update go to our website, click on My Account, using your license number download the latest zip file then unzip and update the files using any FTP program. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| john_sam |
Reply #: 6 Posted on: 05-30-10 07:59 AM |
| Update |
|
| Update?? We just purchased the program on 11/16/06 - The script is the latest. |
|
|
|
|
|
| mewsoft |
Reply #: 7 Posted on: 05-30-10 08:12 AM |
| Re: Problems inseting Seller items |
|
| If you have the latest version then you do not need to update anything. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| john_sam |
Reply #: 8 Posted on: 06-01-10 12:38 PM |
| SQL 5 |
|
| Then why is it not working with MySql 5? |
|
|
|
|
|
| mewsoft |
Reply #: 9 Posted on: 06-02-10 02:39 PM |
| Re: Problems inseting Seller items |
|
| I have no way to access your local server and see exactly what's your problem. You need to be online so we can help. The software works up to the latest mysql server version. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
| mewsoft |
Reply #: 10 Posted on: 06-03-10 12:03 AM |
| Re: Problems inseting Seller items |
|
Download the latest zip file now, update the file SQLlib.pm only, it will zero all empty items before saving them. Also whattype of language you are using, you may using a language with decimal separator not understood with by your MySQL server and its settings. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|