Welcome Visitor, Please Login or Register Now Thursday, April 18, 2024 04:55 AM 
Forums Index > Mewsoft Products > Auctionawy > Problems inseting Seller items
New Topic   New Reply
Search for:
Author Message
acampana acampana's personal page
Registered Member
Posts: 8 Display member's posts
Joined: 01-08-06 06:09 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Problems inseting Seller items Edit Delete Reply with quote Quote
First Post Posted on: 07-21-09 05:49 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 04:55 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems inseting Seller items Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 07-21-09 07:23 AM next post previous post
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 john_sam's personal page
Registered Member
Posts: 24 Display member's posts
Joined: 11-18-06 01:48 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Incorrect decimal value Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 05-25-10 08:04 PM next post previous post
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 john_sam's personal page
Registered Member
Posts: 24 Display member's posts
Joined: 11-18-06 01:48 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Incorrect decimal value Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 05-25-10 08:09 PM next post previous post
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 john_sam's personal page
Registered Member
Posts: 24 Display member's posts
Joined: 11-18-06 01:48 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Incorrect decimal value Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 05-25-10 08:10 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 04:55 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems inseting Seller items Edit Delete Reply with quote Quote
Reply #: 5 Posted on: 05-27-10 02:30 AM next post previous post
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 john_sam's personal page
Registered Member
Posts: 24 Display member's posts
Joined: 11-18-06 01:48 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Update Edit Delete Reply with quote Quote
Reply #: 6 Posted on: 05-30-10 07:59 AM next post previous post
Update?? We just purchased the program on 11/16/06 - The script is the latest.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 04:55 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems inseting Seller items Edit Delete Reply with quote Quote
Reply #: 7 Posted on: 05-30-10 08:12 AM next post previous post
If you have the latest version then you do not need to update anything.

Mewsoft Support
www.mewsoft.com
john_sam john_sam's personal page
Registered Member
Posts: 24 Display member's posts
Joined: 11-18-06 01:48 AM
Member Offline
View Member's Profile Send private message
 
Back to top
SQL 5 Edit Delete Reply with quote Quote
Reply #: 8 Posted on: 06-01-10 12:38 PM next post previous post
Then why is it not working with MySql 5?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 04:55 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems inseting Seller items Edit Delete Reply with quote Quote
Reply #: 9 Posted on: 06-02-10 02:39 PM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-18-24 04:55 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Problems inseting Seller items Edit Delete Reply with quote Quote
Reply #: 10 Posted on: 06-03-10 12:03 AM last post previous post

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
Page 1 of 1
Go to page:

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

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.3148 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation