Διαδικασία αναβάθμισης cscart 1.3.5sp4 σε 2.0.8
-
Upload
panos-kyriakakis -
Category
Documents
-
view
23 -
download
2
description
Transcript of Διαδικασία αναβάθμισης cscart 1.3.5sp4 σε 2.0.8
server backup :cscart_category_imagescscart_common_imagescscart_conf_group_imagescscart_detailed_imagescscart_product_images backup1.sql
2 backup backup2.sql
backup1.sql uedit textpad v5 ( bug ) CREATE TABLE DEFAULT CHARSET=latin1 ( ) textpad unix utf8 backup1U.sql uedit .
backup2.sql uedit textpad CREATE TABLE DEFAULT CHARSET=latin1 ( ) .
collation utf8_general_ci backup1U.sql backup2.sql phpmyadmin console mysql -u root -p --default_character_set=utf8 clever < clever_clever2.sql
query
CREATE TABLE IF NOT EXISTS `cscart_stat_requests` (`req_id` int(11) unsigned NOT NULL AUTO_INCREMENT,`timestamp` int(11) unsigned NOT NULL DEFAULT '0',`url` text NOT NULL,`title` varchar(255) NOT NULL DEFAULT '',`https` char(1) NOT NULL DEFAULT 'N',`loadtime` int(11) unsigned NOT NULL DEFAULT '0',`sess_id` int(11) unsigned NOT NULL DEFAULT '0',`request_type` int(11) unsigned NOT NULL DEFAULT '0',PRIMARY KEY (`req_id`),KEY `sess_id` (`sess_id`),KEY `request_type` (`request_type`),KEY `timestamp` (`timestamp`)) ENGINE=MyISAM ;
CREATE TABLE IF NOT EXISTS `cscart_stat_sessions` (`sess_id` int(11) unsigned NOT NULL AUTO_INCREMENT,`os` varchar(30) NOT NULL DEFAULT '',`client_type` char(1) NOT NULL DEFAULT 'U',`browser_id` int(11) unsigned NOT NULL DEFAULT '0',`robot_id` int(11) unsigned NOT NULL DEFAULT '0',`user_agent` varchar(255) NOT NULL DEFAULT '',`screen_x` int(11) unsigned NOT NULL DEFAULT '0',`screen_y` int(11) unsigned NOT NULL DEFAULT '0',`color` int(11) unsigned NOT NULL DEFAULT '0',`client_language` varchar(5) NOT NULL DEFAULT '',`session` varchar(32) NOT NULL DEFAULT '',`host_ip` int(11) unsigned NOT NULL DEFAULT '0',`proxy_ip` int(11) unsigned NOT NULL DEFAULT '0',`ip_id` int(11) unsigned NOT NULL DEFAULT '0',`uniq_code` int(11) unsigned NOT NULL DEFAULT '0',`referrer` text NOT NULL,`referrer_scheme` varchar(32) NOT NULL DEFAULT '',`referrer_host` varchar(128) NOT NULL DEFAULT '',`engine_id` int(11) unsigned NOT NULL DEFAULT '0',`phrase_id` int(11) unsigned NOT NULL DEFAULT '0',`timestamp` int(11) unsigned NOT NULL DEFAULT '0',`expiry` int(11) unsigned NOT NULL DEFAULT '0',PRIMARY KEY (`sess_id`),KEY `session` (`session`,`expiry`),KEY `browser_id` (`browser_id`),KEY `ip_id` (`ip_id`),KEY `engine_id` (`engine_id`),KEY `phrase_id` (`phrase_id`),KEY `robot_id` (`robot_id`),KEY `timestamp` (`timestamp`)) ENGINE=MyISAM ;
CREATE TABLE IF NOT EXISTS `cscart_stat_search_robots` (`robot_id` int(11) 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;
CREATE TABLE IF NOT EXISTS `cscart_addons` (`addon` varchar(32) NOT NULL DEFAULT '',`status` char(1) NOT NULL DEFAULT 'A',`options` text NOT NULL,`priority` tinyint(4) NOT NULL DEFAULT '0',`dependencies` varchar(255) NOT NULL DEFAULT '',PRIMARY KEY (`addon`),KEY `priority` (`priority`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `cscart_addon_descriptions` (`addon` varchar(32) NOT NULL DEFAULT '',`object_id` varchar(64) NOT NULL DEFAULT '',`object_type` char(1) NOT NULL DEFAULT '',`description` varchar(255) NOT NULL DEFAULT '',`tooltip` text NOT NULL,`lang_code` varchar(2) NOT NULL DEFAULT '',PRIMARY KEY (`addon`,`object_id`,`object_type`,`lang_code`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
images
1.3.5 images135
upgrade135sp4-208p1.php .
2.0.8 191
2.0.8 : cscart_addons cscart_addon_descriptions script :cscart_installmentscscart_shippings_suppliers .
1.3.5 198
TroubleshootingThumbnails
thumbnails upgrade script. server images thumbnails thumbnails .
MySQL server has gone away
restore mysql ERROR 2006 (HY000) at line 352: MySQL server has gone away my.ini max_allowed_packet 100M.
Restore
restore SQLDumpSplitter encoding directives server utf8.