PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'log_customer' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /home/rcos3601/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 277
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/rcos3601/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 277
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS log_customer;
CREATE TABLE log_customer (
`log_id` int(10) unsigned NOT NULL auto_increment,
`visitor_id` bigint(20) unsigned default NULL,
`customer_id` int(11) NOT NULL default '0',
`login_at` datetime NOT NULL default '0000-00-00 00:00:00',
`logout_at` datetime default NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Customers log information'
)
)
[1] => Array
(
[file] => /home/rcos3601/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 401
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS log_customer;
CREATE TABLE log_customer (
`log_id` int(10) unsigned NOT NULL auto_increment,
`visitor_id` bigint(20) unsigned default NULL,
`customer_id` int(11) NOT NULL default '0',
`login_at` datetime NOT NULL default '0000-00-00 00:00:00',
`logout_at` datetime default NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Customers log information'
)
)
[2] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 636
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS log_customer;
CREATE TABLE log_customer (
`log_id` int(10) unsigned NOT NULL auto_increment,
`visitor_id` bigint(20) unsigned default NULL,
`customer_id` int(11) NOT NULL default '0',
`login_at` datetime NOT NULL default '0000-00-00 00:00:00',
`logout_at` datetime default NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Customers log information';
-- DROP TABLE IF EXISTS log_quote;
CREATE TABLE log_quote (
`quote_id` int(10) unsigned NOT NULL default '0',
`visitor_id` bigint(20) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`deleted_at` datetime default NULL,
PRIMARY KEY (`quote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quote log data';
-- DROP TABLE IF EXISTS log_summary;
CREATE TABLE log_summary (
`summary_id` bigint(20) unsigned NOT NULL auto_increment,
`type_id` smallint(5) unsigned default NULL,
`visitor_count` int(11) NOT NULL default '0',
`customer_count` int(11) NOT NULL default '0',
`add_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`summary_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Summary log information';
-- DROP TABLE IF EXISTS log_summary_type;
CREATE TABLE log_summary_type (
`type_id` smallint(5) unsigned NOT NULL auto_increment,
`type_code` varchar(64) NOT NULL default '',
`period` smallint(5) unsigned NOT NULL default '0',
`period_type` enum('MINUTE','HOUR','DAY','WEEK','MONTH') NOT NULL default 'MINUTE',
PRIMARY KEY (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Type of summary information';
insert into log_summary_type (`type_id`,`type_code`,`period`,`period_type`) values
(1,'hour',1,'HOUR'),(2,'day',1,'DAY')
/* ,(3,'week',1,'WEEK'),(4,'month',1,'MONTH') */;
-- DROP TABLE IF EXISTS log_url;
CREATE TABLE log_url (
`url_id` bigint(20) unsigned NOT NULL default '0',
`visitor_id` bigint(20) unsigned default NULL,
`visit_time` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='URL visiting history';
-- DROP TABLE IF EXISTS log_url_info;
CREATE TABLE log_url_info (
`url_id` bigint(20) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`referer` varchar(255) default NULL,
PRIMARY KEY (`url_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Detale information about url visit';
-- DROP TABLE IF EXISTS log_visitor;
CREATE TABLE log_visitor (
`visitor_id` bigint(20) unsigned NOT NULL auto_increment,
`session_id` char(64) NOT NULL default '',
`first_visit_at` datetime default NULL,
`last_visit_at` datetime NOT NULL default '0000-00-00 00:00:00',
`last_url_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='System visitors log';
-- DROP TABLE IF EXISTS log_visitor_info;
CREATE TABLE log_visitor_info (
`visitor_id` bigint(20) unsigned NOT NULL default '0',
`http_referer` varchar(255) default NULL,
`http_user_agent` varchar(255) default NULL,
`http_accept_charset` varchar(255) default NULL,
`http_accept_language` varchar(255) default NULL,
`server_addr` bigint(20) default NULL,
`remote_addr` bigint(20) default NULL,
PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Additional information by visitor';
)
)
[3] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Log/sql/log_setup/mysql4-install-0.7.0.php
[line] => 113
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS log_customer;
CREATE TABLE log_customer (
`log_id` int(10) unsigned NOT NULL auto_increment,
`visitor_id` bigint(20) unsigned default NULL,
`customer_id` int(11) NOT NULL default '0',
`login_at` datetime NOT NULL default '0000-00-00 00:00:00',
`logout_at` datetime default NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Customers log information';
-- DROP TABLE IF EXISTS log_quote;
CREATE TABLE log_quote (
`quote_id` int(10) unsigned NOT NULL default '0',
`visitor_id` bigint(20) unsigned default NULL,
`created_at` datetime NOT NULL default '0000-00-00 00:00:00',
`deleted_at` datetime default NULL,
PRIMARY KEY (`quote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quote log data';
-- DROP TABLE IF EXISTS log_summary;
CREATE TABLE log_summary (
`summary_id` bigint(20) unsigned NOT NULL auto_increment,
`type_id` smallint(5) unsigned default NULL,
`visitor_count` int(11) NOT NULL default '0',
`customer_count` int(11) NOT NULL default '0',
`add_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`summary_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Summary log information';
-- DROP TABLE IF EXISTS log_summary_type;
CREATE TABLE log_summary_type (
`type_id` smallint(5) unsigned NOT NULL auto_increment,
`type_code` varchar(64) NOT NULL default '',
`period` smallint(5) unsigned NOT NULL default '0',
`period_type` enum('MINUTE','HOUR','DAY','WEEK','MONTH') NOT NULL default 'MINUTE',
PRIMARY KEY (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Type of summary information';
insert into log_summary_type (`type_id`,`type_code`,`period`,`period_type`) values
(1,'hour',1,'HOUR'),(2,'day',1,'DAY')
/* ,(3,'week',1,'WEEK'),(4,'month',1,'MONTH') */;
-- DROP TABLE IF EXISTS log_url;
CREATE TABLE log_url (
`url_id` bigint(20) unsigned NOT NULL default '0',
`visitor_id` bigint(20) unsigned default NULL,
`visit_time` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='URL visiting history';
-- DROP TABLE IF EXISTS log_url_info;
CREATE TABLE log_url_info (
`url_id` bigint(20) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`referer` varchar(255) default NULL,
PRIMARY KEY (`url_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Detale information about url visit';
-- DROP TABLE IF EXISTS log_visitor;
CREATE TABLE log_visitor (
`visitor_id` bigint(20) unsigned NOT NULL auto_increment,
`session_id` char(64) NOT NULL default '',
`first_visit_at` datetime default NULL,
`last_visit_at` datetime NOT NULL default '0000-00-00 00:00:00',
`last_url_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='System visitors log';
-- DROP TABLE IF EXISTS log_visitor_info;
CREATE TABLE log_visitor_info (
`visitor_id` bigint(20) unsigned NOT NULL default '0',
`http_referer` varchar(255) default NULL,
`http_user_agent` varchar(255) default NULL,
`http_accept_charset` varchar(255) default NULL,
`http_accept_language` varchar(255) default NULL,
`server_addr` bigint(20) default NULL,
`remote_addr` bigint(20) default NULL,
PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Additional information by visitor';
)
)
[4] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 376
[args] => Array
(
[0] => /home/rcos3601/public_html/app/code/core/Mage/Log/sql/log_setup/mysql4-install-0.7.0.php
)
[function] => include
)
[5] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 276
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.7
)
)
[6] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 240
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.7
)
)
[7] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 161
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 399
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /home/rcos3601/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 329
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/rcos3601/public_html/app/Mage.php
[line] => 627
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[11] => Array
(
[file] => /home/rcos3601/public_html/index.php
[line] => 83
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'log_customer' already exists
)
)