Welcome Visitor, Please Login or Register Now Wednesday, April 24, 2024 12:45 PM 
Forums Index > Mewsoft Products > Auctionawy > urgent help !!!
New Topic   New Reply
Search for:
Author Message
ettinet ettinet's personal page
Registered Member
Posts: Display member's posts
Joined: 04-24-24 12:45 PM
Member Offline
View Member's Profile PM
 
Back to top
urgent help !!! Edit Delete Reply with quote Quote
First Post Posted on: 03-02-08 03:38 AM next post first post

SQL Error: Unknown column 'User1' in 'field list'
Query:
INSERT INTO Users (User_ID, Password, Email, FName, LName, Company, Job_Title, Street, City, State, Zip, Country, Phone, Mobile, Fax, Website, Payment_Method, CC_Number, CC_Name, CC_Type, CC_Month, CC_Year, Street1, City1, State1, Zip1, Country1, Start_Date, Last_Updated, Status, User_Icon, Total_Paid, Current_Balance, Last_Paid_Date, User1, User2, User3, User4, User5, User6, User7, User8, User9, User10) VALUES ('nana','nana','aelm@walla.com','òéãï','ìåé','','','ãåáðåá 3','øòäðäëâ','øòäð','44444','Israel','454515415','','','','','','','','0','0','','','','','','1091152821','1091152821','1','','0.00000','0.00000','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
Line 507, File /home/aelm/public_html/cgi-bin/auction/sqldriver.pm.



what is mean what is the problem what i need to fix????
Gup Gup's personal page
Registered Member
Posts: 25 Display member's posts
Joined: 04-24-24 12:45 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Re: urgent help !!! Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 03-02-08 03:44 AM next post previous post
I am getting the same. This started after my upgrade to the new version.

PLEASE HELP...

Gup

Tim Bass Austin, Texas www.sportsbid.net
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-24-24 12:45 PM
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: urgent help !!! Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 03-02-08 04:10 AM next post previous post
Please download again the file Upgrade.cgi and run it and it will fix these issues.

Mewsoft Support
www.mewsoft.com
totalbids totalbids's personal page
Registered Member
Posts: 64 Display member's posts
Joined: 04-24-24 12:45 PM
Location: Southend
Member Offline
View Member's Profile Visit member's website http://www.totalbids.co.uk Send private message YIM Messenger: toptech1911 MSN Messenger: jason_yorke@hotmail.com
 
Back to top
Re: urgent help !!! Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 03-03-08 07:49 PM next post previous post
I am also getting this error and i have run the upgrade.cgi file

This happens on registration process.

SQL Error
SQL Error: Unknown column 'User1' in 'field list'
Query:
INSERT INTO Users (User_ID, Password, Email, FName, LName, Company, Job_Title, Street, City, State, Zip, Country, Phone, Mobile, Fax, Website, Payment_Method, CC_Number, CC_Name, CC_Type, CC_Month, CC_Year, Street1, City1, State1, Zip1, Country1, Start_Date, Last_Updated, Status, User_Icon, Total_Paid, Current_Balance, Last_Paid_Date, User1, User2, User3, User4, User5, User6, User7, User8, User9, User10) VALUES ('testing','clyde1002','support@totalbids.co.uk','Jason','Yorke','','','19 Windermere Road','Southend On Sea','Essex','SS1 2RF','United Kingdom','01702 316137','','','','','','','','','','','','','','','1093542773','1093542773','0','','','','','','','','','','','','','','')
Line 507, File /home/totalbid/public_html/cgi-bin/auction/sqldriver.pm.
totalbids totalbids's personal page
Registered Member
Posts: 64 Display member's posts
Joined: 04-24-24 12:45 PM
Location: Southend
Member Offline
View Member's Profile Visit member's website http://www.totalbids.co.uk Send private message YIM Messenger: toptech1911 MSN Messenger: jason_yorke@hotmail.com
 
Back to top
Re: urgent help !!! Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 03-03-08 08:59 PM last post previous post

ok..i have siorted this now.

It wouuld appear that users and pending users database tables never had user 1, user2 etc fields.

I backed up my user data into a sql file and dropped the table and then created it again. Then i run a command in php my admin and insertyed the data in again. I had to do the same for pending users. Then i ran the Update.cgi file and now everything works as should be.

I am not saying that anyone should do this but this is how i got my one working.

Cheers everyone

Jason



You do not need to do all this mess, if you just read the update instructions post, all you need is to upload the fil Upgrade.cgi, call it from your browser one time, it will do the pending users and users and users info updates. Yes the fileds User1 to User10 added to the users tables.
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.1226 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation