Forums Index > Mewsoft Products > Auctionawy > help with this pls
jimpedigo First Post Posted on: 07-14-09 07:08 PM
help with this pls

i set the files to read/execute\ and still get this\ SQL Error: Incorrect decimal value: '' for column 'Total_Paid' at row 1\ Query: \ INSERT INTO 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) VALUES ('jinp','pedi','blacksheepcapt@yahoo.com','','','','','','','','','','','','','','','1132143531','1132143531','1','','','','','','','','','','','','','','','','','','','','','','','','')\ Line 505, File C:/Program Files/Apache Group/Apache2/cgi-bin/auction/SQLlib.pm.\ \ http://mybidliveonline.com is the sight thanks
mewsoft Reply #: 1 Posted on: 07-14-09 11:11 PM
Re: help with this pls

If you transfered all the files under /cgi-bin/auction in ASCII mode, then your installation is fine, if this is the case email me your FTP info to check.

Mewsoft Support
www.mewsoft.com

mewsoft Reply #: 2 Posted on: 07-15-09 03:48 PM
Re: help with this pls

You turned on the forum plugin in admin->configuration before installing the forum, also you need to download the latest cgi files from our site, your auction is working now.

Mewsoft Support
www.mewsoft.com

jimpedigo Reply #: 3 Posted on: 07-15-09 07:45 PM
it a new prob

thanks for fixing the one here is the new one and again thanks\ \ SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Reads='1',Poll='1',ViewIP='1',MSNM=''' at line 1\ Query: \ INSERT INTO Forum_Users_Info SET Language='English',AttachSign='1',LastVist='1136666547',Browse='1',Sticky='1',NotifyPM='1',DateFormat=NULL,WebURL='',Announce='1',User_ID='edkeen',AllowPM='1',Custom1='',Custom2='',Location='',Custom3='',Custom4='',Custom5='',Custom6='',Custom7='',Custom8='',Level='0',Custom9='',Occupation='',Deletes='1',Attach='1',Vote='1',Rank='0',Reply='1',View='1',WebTitle='',ViewOnline='1',ViewEmail='1',AIM='',Interests='',Custom10='',Posts='0',YIM='',Edit='1',EmailTime='0',Post='1',Timezone='-5',ICQ='',Avatar='',Sig='',Reads='1',Poll='1',ViewIP='1',MSNM=''\ Line 658, File C:/Program Files/Apache Group/Apache2/cgi-bin/auction/SQLlib.pm.
mewsoft Reply #: 4 Posted on: 07-17-09 03:06 AM
Re: help with this pls

Yes you need to update to the latest cgi file (*.pm) only from our site, in the latest releases for the forum we posted an update to avoid MySQL server 5.x reserved keywords "Reads".

Mewsoft Support
www.mewsoft.com