gofigure Posted October 17, 2008 Posted October 17, 2008 I hope someone can help me, I contacted my webhost support this morning & I'm not getting a response. After I tried to restore the database from my admin panel I got a syntax error : 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 '' insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('32', '1', 'Big Lucky PUG Buddha', ' I deleted that product and now All of my products show this error when you click on them: 1146 - Table 'd60528555.sessions' doesn't exist select value from sessions where sesskey = 'd482c7238d631060ded334b22f2d6177' and expiry > '1224284902' [TEP STOP] I can access the table and database through MYPHP and the database and all the products are still there.What can I do to restore? Thanks in advance.
failsafe Posted October 18, 2008 Posted October 18, 2008 1146 - Table 'd60528555.sessions' doesn't existselect value from sessions where sesskey = 'd482c7238d631060ded334b22f2d6177' and expiry > '1224284902' I can access the table and database through MYPHP and the database and all the products are still there.What can I do to restore? Are you saying that your sessions table exists? Strange, since the error seems to suggest it does not exist. If you check using phpMyAdmin an find it's not there. perhaps you could recreate it using: CREATE TABLE `sessions` ( `sesskey` varchar(32) NOT NULL default '', `expiry` int(11) unsigned NOT NULL default '0', `value` text NOT NULL, PRIMARY KEY (`sesskey`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Silly question, but you are checking the new database aren't you, and your configure.php files do refer to the new database don't they? :)
gofigure Posted October 18, 2008 Author Posted October 18, 2008 Hi, I finally heard back from support & also remembered that I could access the backups from my ftp program so uploaded the database before all the errors & it's back working. Only thing is what started the whole thing was changing a configure file for a different https url for a shared SSL certificate. The one that the support tutorial gave me wasn't correct. So I'm back to figuring out the correct one or buying a dedicated one. Thanks so much for your help.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.