Error after changing database

Hi everyone,

After changing my databse, and updating it in the configuration.local file I now get the following error on the main website page:

[QUOTE]Database error: Table ‘thepetexpe1.cscart_sessions’ doesn’t exist (1146)

Invalid query: SELECT * FROM cscart_sessions WHERE session_id = ‘l7nu62a00ghfi2b6oek6e8vic6’ AND area = ‘C’[/QUOTE]

And there is a load of information in the backtrace block underneath it.

Does anyone know what I might be doing wrong?

Many thanks


What do you mean by “changing my database”? If you created a new database and imported the sql file you downloaded from your old database, were the CS-Cart versions the same?

Unlikely but possible: the expected table prefix is changed.


I had to create a new MySQL database as the host said they had problems with a MySQL server.

I just created a new database. But I guess I need to export the data from the old one and import it into the new one?.



I face exactly the same issue. I want to upgrade my store from 1.3.5 sp4 to last version.

The trouble occurs when uprgading from 1.3.5 sp4 to 2.0.8.

I must dump the database from 1.2.5 sp4 (no trouble for that).

And then, go to 2.0.8 new database (clean install with demo data), and import the dump.sql I created in the step before. As there is an important chage in data structure, I must launch a specific php script provided by sccart team.

But When importing dump file, I obtain this message :

Deprecated: Function set_magic_quotes_runtime() is deprecated in /homez.44/myshop/www/v208/prepare.php on line 53

[color=#000000][font=Courier][size=3]Database error:[/size][/font][/color] Table 'myshop_upgra2.cscart_sessions' doesn't exist b[/b]

[color=#000000][font=Courier][size=3]Invalid query:[/size][/font][/color] SELECT * FROM cscart_sessions WHERE session_id = 'ivl0digbr744stabfmt9u1ujh1' AND area = 'C'

Can anyone help me ?