Welcome Visitor, Please Login or Register Now |
|
Thursday, April 18, 2024 04:55 AM |
|
acampana |
Registered Member |
Posts: 8 |
Joined: 01-08-06 06:09 AM |
|
|
|
|
|
|
|
|
|
Problems inseting Seller items |
Edit Delete Quote |
First Post Posted on: 07-21-09 05:49 AM |
|
|
|
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 |
Administrator Team Member |
Posts: 5381 |
Joined: 04-18-24 04:55 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
john_sam |
Registered Member |
Posts: 24 |
Joined: 11-18-06 01:48 AM |
|
|
|
|
|
|
|
|
|
Incorrect decimal value |
Edit Delete Quote |
Reply #: 2 Posted on: 05-25-10 08:04 PM |
|
|
|
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 |
Registered Member |
Posts: 24 |
Joined: 11-18-06 01:48 AM |
|
|
|
|
|
|
|
|
|
Incorrect decimal value |
Edit Delete Quote |
Reply #: 3 Posted on: 05-25-10 08:09 PM |
|
|
|
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 |
Registered Member |
Posts: 24 |
Joined: 11-18-06 01:48 AM |
|
|
|
|
|
|
|
|
|
Incorrect decimal value |
Edit Delete Quote |
Reply #: 4 Posted on: 05-25-10 08:10 PM |
|
|
|
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 |
Administrator Team Member |
Posts: 5381 |
Joined: 04-18-24 04:55 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
john_sam |
Registered Member |
Posts: 24 |
Joined: 11-18-06 01:48 AM |
|
|
|
|
|
|
|
|
|
Update |
Edit Delete Quote |
Reply #: 6 Posted on: 05-30-10 07:59 AM |
|
|
|
Update?? We just purchased the program on 11/16/06 - The script is the latest. |
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-18-24 04:55 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
john_sam |
Registered Member |
Posts: 24 |
Joined: 11-18-06 01:48 AM |
|
|
|
|
|
|
|
|
|
SQL 5 |
Edit Delete Quote |
Reply #: 8 Posted on: 06-01-10 12:38 PM |
|
|
|
Then why is it not working with MySql 5? |
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-18-24 04:55 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
mewsoft |
Administrator Team Member |
Posts: 5381 |
Joined: 04-18-24 04:55 AM |
Location: knxoville, TN, USA |
|
|
|
|
|
|
|
|
|
|
|
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.3148 Seconds |
|