saul kirsch Posted September 28, 2006 Posted September 28, 2006 HI, I have been building my shop for 3 days getting more and more comfortable with OSC.. Then, a few hours ago, I was tweaking the colors, and decided I would roll back to a previously saved backup. So i did that - and since then - disaster!!! I cannot view my shop, nor most of my admin, related to products. I get the error shown below: 1146 - Table 'double8_shop.whos_online' doesn't exist delete from whos_online where time_last_click < '1159461388' [TEP STOP] I have reason to believe that it is related to a table that I imported when building a particular product. Does anyone know how I can delete a particular product (I cannot access the "products" in admin at this time... or any suggestiong to solve this? I have been pulling my hair out for 4 hours. :'( Would love some good advice, thanks saul
jpweber Posted September 28, 2006 Posted September 28, 2006 Probably the database wasn't correctly installed. Go into your includes/database_tables.php and make sure you defined your database. Also make sure you defined it in admin/includes/database_tables.php. Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...
ddp Posted September 28, 2006 Posted September 28, 2006 Saul I searched the forums using google(see my signature on how to do this) and found this: http://www.oscommerce.com/forums/lofiversion/i...hp/t181595.html I think it is the same as your problem. Backup before making changes. Backup before making changes! Backup before making changes!! You did do a backup? eh?
241 Posted September 28, 2006 Posted September 28, 2006 go to your hosts control panel phpmyadmin and run this sql TRUNCATE TABLE whos_online No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
dittones Posted September 28, 2006 Posted September 28, 2006 Dear saul, Whenever you do a restore from an Admin backup...first statement in your sql script is to delete the table and then to recreate the table and data from what you backed up... I hope this helps dittone.com
saul kirsch Posted September 28, 2006 Author Posted September 28, 2006 Dear saul,Whenever you do a restore from an Admin backup...first statement in your sql script is to delete the table and then to recreate the table and data from what you backed up... I hope this helps dittone.com HI Dittones, can you please be more specific. How do I do that? thanks saul
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.