Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

how to fix 1146 table error..please help


gofigure

Recommended Posts

Posted

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.

Posted
1146 - Table 'd60528555.sessions' doesn't exist

select 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? :)

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...