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



Jon

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.

Hi,

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?.



Thanks

Hi,



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 ?



Thanks



Leo