Database error message after moving to another server

General Forums Installation & Upgrade
#1

Hello there,



I tried to move a cs-cart installation from one server to another server. Everything is the same (number of database tables, files etc.) Now we get an database error message. On the other server the installation is working properly. Can anybody help what to do? I am using the latest version of CS-CART.



The message is:





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

[font=Courier][size=3]Invalid query:[/size][/font] DELETE FROM cscart_user_session_products WHERE user_type = 'U' AND timestamp < 1326197222[/color]

[color=#000000][font=Courier][size=3]Backtrace:[/size][/font][/color]

File: C:\Inetpub\vhosts\belettering-online.nl\httpdocs\core\fn.database.php

Line: 259

Function: db_error

File: C:\Inetpub\vhosts\belettering-online.nl\httpdocs\core\fn.init.php

Line: 718

Function: db_query

File: C:\Inetpub\vhosts\belettering-online.nl\httpdocs\init.php

Line: 206

Function: fn_init_user

File: C:\Inetpub\vhosts\belettering-online.nl\httpdocs\admin.php

Line: 24

Function: require



Thanks in advance for your reply.



Edwin

#2

My guess would be the database name itself.?

#3

Renamed everything properly in the config.local.php, so do not understand what's wrong.



This is some more information about the database.



phpMyAdmin - 2.11.6

[list]

[]MySQL client version: 5.0.22

[]Used PHP extensions: mysqli

[/list]



[list]

[]Server versie: 5.0.45-community-nt

[]Protocol version: 10

[*]Server: localhost via TCP/IP

[/list]

#4

You are “missing” customer sessions, flush the tables (truncate)

#5

Problem is solved…some some tables weren't installed