PDOException Object
(
[message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(1' at line 1
[string:Exception:private] =>
[code:protected] => 42000
[file:protected] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS `m2epro_order`_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS `m2epro_order`_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 340
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS `m2epro_order`_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci
)
)
[7] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 608
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS `m2epro_order`_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci
)
)
[8] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/community/Ess/M2ePro/Model/Upgrade/MySqlSetup.php
[line] => 64
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE IF NOT EXISTS `m2epro_order`_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci;
)
)
[9] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/community/Ess/M2ePro/sql/M2ePro_setup/mysql4-upgrade-4.2.9-5.0.0.php
[line] => 394
[function] => run
[class] => Ess_M2ePro_Model_Upgrade_MySqlSetup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE IF NOT EXISTS m2epro_order_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(10) NOT NULL,
order_id INT(11) UNSIGNED NOT NULL,
`action` VARCHAR(50) NOT NULL,
params LONGTEXT NOT NULL,
creator_type TINYINT(2) NOT NULL DEFAULT 0,
update_date DATETIME DEFAULT NULL,
create_date DATETIME DEFAULT NULL,
PRIMARY KEY (id),
INDEX `action` (`action`),
INDEX creator_type (creator_type),
INDEX order_id (order_id)
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci;
)
)
[10] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/community/Ess/M2ePro/sql/M2ePro_setup/mysql4-upgrade-4.2.9-5.0.0.php
)
[function] => include
)
[11] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 437
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 4.2.9
[2] => 5.2.0
)
)
[12] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 320
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 4.2.9
[1] => 5.2.0
)
)
[13] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[15] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[16] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[17] => Array
(
[file] => /var/www/vhosts/sillyjokes.co.uk/httpdocs/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '_change (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
component VARCHAR(1' at line 1
)
)