v3locity Posted May 19, 2008 Share Posted May 19, 2008 I did a database backup and restore. I just wanted to remove the countries i wasn't using. Now I have an error: 1146 - Table 'weekendwarriorsportz.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] I'm confused as to how to fix this. I contacted the hosting company since i don't have the rights to upload the sql file for the database. The database name is weekendwarriorsportz. When I log in to phpmyadmin the database is a much smaller file than the one i backed up. The db that i see under phpmyadmin has 4 tables under it. Newsletters, orders_total, products_description, and products_notifications Where did I go wrong? How do I fix it? Link to comment Share on other sites More sharing options...
spooks Posted May 19, 2008 Share Posted May 19, 2008 The error may be in the name you used for your backup sql, when it recreats the dbase it uses the name of the file, so if you renamed the standard osc1.sql.gz to something else it wont work, try renaming & backup again. B) Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
v3locity Posted May 19, 2008 Author Share Posted May 19, 2008 It's fixed now. Whoever was supposed to up the db back to phpmyadmin at our host did it incorrectly. Everything is back to the way it was. I do have a number of other issues still pending though. It seems OSC doesn't like the Windows OS. Thanks for the help and the quick reply. Link to comment Share on other sites More sharing options...
arietis Posted May 20, 2008 Share Posted May 20, 2008 I do have a number of other issues still pending though. It seems OSC doesn't like the Windows OS. i run osc on my windows laptop all the time with no issues. if you're having a specific problem, let us know what it is and we can probably help you work through it. but apache, php and mysql are pretty portable, so you should be able to run on windows with no problems. Link to comment Share on other sites More sharing options...
v3locity Posted May 23, 2008 Author Share Posted May 23, 2008 The only issue I seem to not be able to get figured out is email. I turned it off for right now but I will have to come up with a solutions for it soon. Link to comment Share on other sites More sharing options...
arietis Posted May 25, 2008 Share Posted May 25, 2008 The only issue I seem to not be able to get figured out is email. on a windows system, i believe you need to set your email transport method to 'smtp' instead of 'sendmail' in admin -> configuration -> email settings. try that. 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.