dsinozic Posted October 17, 2005 Posted October 17, 2005 My webshop has crashed down when i was trying to restore a backup. The message is the folloving: 1146 - Table 'usr_web63_1.sessions' doesn't exist select value from sessions where sesskey = '3611ad1fab11c7318fcdaa41d5be541f' and expiry > '1129554851' [TEP STOP] PLEASE HELP ME !!! What can i do? I can't even login to admin area!
cssystems Posted October 17, 2005 Posted October 17, 2005 My webshop has crashed down when i was trying to restore a backup. The message is the folloving: 1146 - Table 'usr_web63_1.sessions' doesn't exist select value from sessions where sesskey = '3611ad1fab11c7318fcdaa41d5be541f' and expiry > '1129554851' [TEP STOP] PLEASE HELP ME !!! What can i do? I can't even login to admin area! try re-installing the databases to the oringal defualt setup with oscommerce and then run your backup. It might be just corrupt when you have tried to do the reinstall. Hope this helps
niknakgroup Posted October 17, 2005 Posted October 17, 2005 All you need to do is reinstate the sessions table - open your original osc download and look for the sql file, then open it and copy the portion relating to the sessions table. Copy this and paste it into your sql control panel. I would imagine at some point you have tried to clean your sessions table and clicked "Drop" instead of "EMPTY" - without this table, your store will never work! Hope that helps Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) }
dsinozic Posted October 18, 2005 Author Posted October 18, 2005 SQL control panel...hmm...i don't know if i have it. I can only delete or make sql databases in ma webhost control panel. I've tryed to reinstall the oscommerce and i get the message when i finish: Warning: main(includes/languages/.php): failed to open stream: No such file or directory in /home/htdocs/web63/html/webshop/catalog/includes/application_top.php on line 285 Fatal error: main(): Failed opening required 'includes/languages/.php' (include_path='.:/usr/share/php') in /home/htdocs/web63/html/webshop/catalog/includes/application_top.php on line 285 What can I do??? PLEASE HELP I can login into admin area and tryed to make a new restore and i get a new message: 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''8-color Epson UltraChrome Hi-Gloss? pigment inkset for archiva insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('149', '4', 'EPSON STYLUS PHOTO R1800', '8-color Epson UltraChrome Hi-Gloss? pigment inkset for archival-quality glossy and matte photos Fade-resistant photos lasting up to 100-200 years? Output photos up to 13\"-wide Speeds through a 11\" x 14\" photo in under 2 minutes [TEP STOP] Sorry for my bad english. What do I have to do now?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.