I have updated CSCART 1.3.5. to 1.3.5 (SP4) work fine. But I need update to CSCART 2.0.5. Becomme this error
Status: Done
Status: Changing database structure…
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Database error: Table ‘cart.cscart_stat_search_robots’ doesn’t exist (1146)
Invalid query: ALTER TABLE cscart_stat_search_robots
CONVERT TO CHARACTER SET utf8;
--------------------------------------------------------------------------------
Backtrace: File: /home/shop2/core/fn.database.php
Line: 233
Function: db_error
File: /home/shop2/upgrade135sp4-205.php
Line: 197
Function: db_query
What is wrong!
Please help
I have seen lots of guys complaining about same problem. Please developer do something
I have also faced same thing. I have tried to look into upgrade script and change_structure.sql, I have seen that upgrade script deletes all tables in db, and then while restoring database it creates new tables and alter any table structure if necessary.
But in change_structure.sql file where alter stat_search_robots query is return,
ALTER TABLE
cscart_stat_search_robots
CONVERT TO CHARACTER SET utf8;
ALTER TABLE cscart_stat_search_robots
CHANGE robot_id
robot_id
mediumint(8) unsigned NOT NULL auto_increment first, COMMENT=‘’, DEFAULT CHARSET=‘utf8’;
```
but till this stage there is no table created in db with this name, and script is trying to attempt alter structure of that table. so I guess this problem raised.
After this error if we look in database there are few tables missing, like stored_session. So i have imported these tables from fresh 2.0.5 database but still it’s not working.
I am clueless. Please anyone can assist in this.
HI,
I did a minor change in change_structure.sql file and it worked. As I have mentioned in my last msg that it seems upgrade script is not creating cscart_stat_search_robots table itself. So I have added table create query before alter cscart_stat_search_robots query in change_structure.sql file
Add this
[QUOTE]CREATE TABLE IF NOT EXISTS cscart_stat_search_robots
(
robot_id
mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
id
varchar(64) NOT NULL DEFAULT ‘’,
name
varchar(128) NOT NULL DEFAULT ‘’,
cover_url
varchar(255) NOT NULL DEFAULT ‘’,
details_url
varchar(255) NOT NULL DEFAULT ‘’,
owner_name
varchar(128) NOT NULL DEFAULT ‘’,
owner_url
varchar(255) NOT NULL DEFAULT ‘’,
owner_email
varchar(64) NOT NULL DEFAULT ‘’,
status
varchar(64) NOT NULL DEFAULT ‘’,
purpose
varchar(64) NOT NULL DEFAULT ‘’,
type
varchar(64) NOT NULL DEFAULT ‘’,
platform
varchar(64) NOT NULL DEFAULT ‘’,
availability
varchar(64) NOT NULL DEFAULT ‘’,
exclusion
varchar(64) NOT NULL DEFAULT ‘’,
exclusion_useragent
varchar(255) NOT NULL DEFAULT ‘’,
noindex
varchar(64) NOT NULL DEFAULT ‘’,
host
varchar(32) NOT NULL DEFAULT ‘’,
robot_from
varchar(64) NOT NULL DEFAULT ‘’,
useragent
varchar(255) NOT NULL DEFAULT ‘’,
language
varchar(32) NOT NULL DEFAULT ‘’,
description
text NOT NULL,
history
text NOT NULL,
environment
varchar(64) NOT NULL DEFAULT ‘’,
modified_date
int(11) unsigned NOT NULL DEFAULT ‘0’,
modified_by
varchar(255) NOT NULL DEFAULT ‘’,
PRIMARY KEY (robot_id
)
) ENGINE=MyISAM DEFAULT CHARSET=‘utf8’;
[/QUOTE]
Before
[QUOTE]ALTER TABLE cscart_stat_search_robots
CONVERT TO CHARACTER SET utf8;
ALTER TABLE cscart_stat_search_robots
CHANGE robot_id
robot_id
mediumint(8) unsigned NOT NULL auto_increment first, COMMENT=‘’, DEFAULT CHARSET=‘utf8’;
[/QUOTE]
(I am attaching my modified change_structure.sql with this message too)
After this change upgrade script worked smoothly, and it passed all upgrade stages successfully (below urls changed in address bar while upgrade)
/upgrade135sp4-204.php?step=rebuild_data
/upgrade135sp4-204.php?step=rebuild_others
I got “The database upgrade is finished successfully!” message at end. I was excited that things worked but when I accessed frontend it is giving error
[QUOTE]Database error: Unknown column ‘user_type’ in ‘where clause’ (1054)
Invalid query: DELETE FROM cscart_user_session_products WHERE user_type = ‘U’ AND timestamp < 1244814909[/QUOTE]
Now what to do???
Hureeeeeeee… Puzzle solved,
CS2.0.5 is upgraded successfully from 1.3.5 SP4,
In continuation to my previous message. As per error user_type field was missing in cscart_user_session_products table. So I have simply run alter query to add this field in table.
Alter Query
[QUOTE]ALTER TABLE cscart_user_session_products
ADD COLUMN user_type
char(1) NOT NULL default ‘R’;[/QUOTE]
- Login to phpmyadmin, select cs 2.0.5 database
- Run above given query, and all set.
- Login to cs2.0.5 admin panel, all data seems to be imported (I need to check if everything is imported properly, it was 693 MB database)
Now checking store, if any error occurs.
Thanks dude!
This worked!!
Although none of my images have been restored!
Any one know how to fix this eror? Trying to Upgrade to version 2.0.8
Status: Done
Status: Changing database structure…
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Database error: Table ‘gwmarket.cscart_stat_search_robots’ doesn’t exist (1146)
Invalid query: ALTER TABLE cscart_stat_search_robots
CONVERT TO CHARACTER SET utf8;
--------------------------------------------------------------------------------
Backtrace: File: /home/content/g/l/o/globalwm/html/test/core/fn.database.php
Line: 311
Function: db_error
File: /home/content/g/l/o/globalwm/html/test/upgrade135sp4-208.php
Line: 197
Function: db_query