Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Error after changing database Rate Topic   - - - - -

 
  • jbenitos
  • Senior Member
  • Members
  • Join Date: 09-Dec 09
  • 173 posts

Posted 07 April 2010 - 12:03 PM #1

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:

Database error: Table 'thepetexpe1.cscart_sessions' doesn't exist (1146)
Invalid query: SELECT * FROM cscart_sessions WHERE session_id = 'l7nu62a00ghfi2b6oek6e8vic6' AND area = 'C'


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

 
  • roban
  • Senior Member
  • Moderators
  • Join Date: 23-Oct 06
  • 1132 posts

Posted 07 April 2010 - 01:58 PM #2

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?

 
  • TexasGuy
  • Senior Member
  • Members
  • Join Date: 18-Mar 10
  • 546 posts

Posted 07 April 2010 - 03:31 PM #3

Unlikely but possible: the expected table prefix is changed.

 
  • jbenitos
  • Senior Member
  • Members
  • Join Date: 09-Dec 09
  • 173 posts

Posted 07 April 2010 - 06:33 PM #4

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

 

Posted 30 October 2013 - 10:46 AM #5

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
Database error: Table 'myshop_upgra2.cscart_sessions' doesn't exist (1146)
Invalid query: SELECT * FROM cscart_sessions WHERE session_id = 'ivl0digbr744stabfmt9u1ujh1' AND area = 'C'

Can anyone help me ?

Thanks

Leo