Hi,
I want to upgrade my store from 1.3.5 sp4 to last version. According to cscart team intructions,I must upgrade each version untill I reach the last one.
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
OK, Now I created the missing table using this code :
CREATE TABLE cscart_sessions
(
session_id
varchar(32) NOT NULL default '',
expiry
int(11) unsigned NOT NULL default '0',
data
mediumblob,
PRIMARY KEY (session_id
),
KEY src
(session_id
,expiry
)
) Type=MyISAM;
But after that step, I still have troubles (unknown column, other missing tables).
And CSCART help team is so busy… (3 days to obtain an answer).
Really think about changing for a free solution…