westmidsguy Posted December 17, 2009 Share Posted December 17, 2009 1054 - Unknown column 'guest_account' in 'field list' select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, guest_account from customers where customers_email_address = '[email protected]' and guest_account='0' [TEP STOP] i got this message when i went to checkout... furthermore its not displaying a screen to checkout via guest account on the login.php page how can i fix this? Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 this is nt good news :( Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 seems like a problem with login.php // PWA BOF // using guest_account with customers_email_address $check_customer_query = tep_db_query( "select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, guest_account from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address). "' and guest_account='0'"); // PWA EOF but thats what i have entered Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 i even checked my tables in php admin and guest_account is in customers table... Link to comment Share on other sites More sharing options...
MrPhil Posted December 17, 2009 Share Posted December 17, 2009 You added some code ("PWA"?) that makes use of a "guest_account" field in the "customers" table, but it appears that somewhere along the line you didn't run the SQL to actually add that field to the existing table. Or you did, but misspelled the name. Go into phpMyAdmin and look at the "structure" of the customers table. Is there a "guest_account" in there? Is it spelled (and capitalized) exactly that way? If it is misspelled, you can ALTER the table to change the field name to the correct one. If it isn't there at all, go back to the installation instructions and see what step you overlooked. If all this checks out, and you do have guest_account in customers, are you sure you put it in the right table? If you have multiple databases, could you have updated the wrong one? If the field shows up in phpMyAdmin, there's no reason that it shouldn't immediately be seen by osC, unless it's in the wrong database. Could your hosting service have done a database restore from backup (wiping out your changed tables) without telling you? Go in and look at it again, to make sure that didn't happen. Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 yes all the parameters are correct it has guest_account and it is set to 0 too im freaking out! :( Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 holy smokes yeh u were right i had two instances of oscommerce thanku brother but now i cannot even see page on login.php which asks a customer to purchase without a account? Link to comment Share on other sites More sharing options...
westmidsguy Posted December 17, 2009 Author Share Posted December 17, 2009 holy macaroni LOL yeh it all works i guess i havent tested it yet though it asks me if i want to checkout without purchasing thanku! ur a life saver u have been repped Link to comment Share on other sites More sharing options...
MrPhil Posted December 17, 2009 Share Posted December 17, 2009 Holy macaroni? I don't think I've heard that one before... holy smokes, holy sh*t, holy mackerel, holy water, holy mac and cheese... Anyway, glad you got it straightened out, and thanks for the +1. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.