| ettinet |
First Post Posted on: 03-02-08 03:38 AM |
| urgent help !!! |
|
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 |
Reply #: 1 Posted on: 03-02-08 03:44 AM |
| Re: urgent help !!! |
|
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 |
Reply #: 2 Posted on: 03-02-08 04:10 AM |
| Re: urgent help !!! |
|
| Please download again the file Upgrade.cgi and run it and it will fix these issues. |
Mewsoft Support
www.mewsoft.com
|
|
|
|
|
|
| totalbids |
Reply #: 3 Posted on: 03-03-08 07:49 PM |
| Re: urgent help !!! |
|
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 |
Reply #: 4 Posted on: 03-03-08 08:59 PM |
| Re: urgent help !!! |
|
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. |
|
|
|
|
|
|