Medieval2Knight Posted December 27, 2018 Share Posted December 27, 2018 I was following the instructions of a previous thread on how to reset my admin username (somehow it was deleted when I changed my database password), but instead of it actually helping me, it caused this error: 1054 - Unknown column 's.customers_group_id' in 'where clause' select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id = '0' order by s.specials_date_added desc limit 10[TEP STOP] To get you to exactly what happen, I will explained it step by step: I was trying to update the look of my site, so I was uploading a new theme. It required me to manually install the oscommerce files. It then asked me to log into my database. I could not remember initially on how to access the password for it. So I changed it in my control panel; not thinking on how it was going to affect the site. After I noticed that the site was down (error messages), I went back and corrected the password (database) back to its original password. It worked....... kind of...... It would allowed you to see the site as a customer, but you could not log into the admin side at all. There was an error. So I looked on the theads here, and came across one that stated I needed to log into my database, then pull up the administrators section. Click on the users, then delete. I did that. It completely deleted the entire administrators section in my database. Now I get the above error message when you visit the site as a customer or admin trying to log in. www.TheKeychainFactory.com Is there ANYTHING I can do to rectify this situation or do I have to start all over? Thanks!!! Link to comment Share on other sites More sharing options...
ArtcoInc Posted December 27, 2018 Share Posted December 27, 2018 @Medieval2Knight 1) Do you have a complete backup of your site (both the files and the database) from before you started messing with things? 2) What version of osCommerce is your site? 3) Which "new theme" were you trying to install? M Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.