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 ''id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'point' at line 2
[string:Exception:private] =>
[code:protected] => 42000
[file:protected] => /var/www/html/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/html/public_html/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /var/www/html/public_html/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/html/public_html/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/html/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /var/www/html/public_html/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 aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /var/www/html/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 389
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /var/www/html/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 327
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[7] => Array
(
[file] => /var/www/html/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 593
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[8] => Array
(
[file] => /var/www/html/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 575
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction (
'id' int(11) NOT NULL auto_increment,
'store_id' smallint(5) unsigned NOT NULL,
'summary_id' int(11) NOT NULL,
'balance_change' int(11) NOT NULL,
'balance_change_spent' int(11) NOT NULL,
'action' varchar(30) NOT NULL,
'comment' varchar(255) NOT NULL,
'notice' varchar(255) NOT NULL,
'change_date' datetime NOT NULL,
'expiration_date' datetime NULL,
'customer_name' varchar(255) NOT NULL,
'customer_email' varchar(255) NOT NULL,
PRIMARY KEY ('id'),
CONSTRAINT 'AW_POINTS_TRANSACTION_FK' FOREIGN KEY ('summary_id') REFERENCES aw_points_summary ('id') ON DELETE CASCADE,
KEY 'AW_POINTS_TRANSACTION_ACTION' ('action'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE_SPENT' ('balance_change_spent'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE' ('balance_change'),
KEY 'AW_POINTS_TRANSACTION_CHANGE_DATE' ('change_date'),
KEY 'AW_POINTS_TRANSACTION_EXPIRATION_DATE' ('expiration_date')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rule (
'rule_id' int(10) unsigned NOT NULL auto_increment,
'sort_order' int(10) unsigned NOT NULL default '0',
'name' varchar(255) NOT NULL default '',
'description' text NOT NULL,
'from_date' date default '0000-00-00',
'to_date' date default '0000-00-00',
'customer_group_ids' text,
'is_active' tinyint(1) NOT NULL default '0',
'conditions_serialized' mediumtext NOT NULL,
'website_ids' text,
'points_change' int(11) NOT NULL,
'static_blocks_ids' text,
PRIMARY KEY ('rule_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_invitatioin (
'invitation_id' INT UNSIGNED NOT NULL AUTO_INCREMENT,
'customer_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'date' DATETIME NOT NULL ,
'email' VARCHAR( 255 ) NOT NULL ,
'referral_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'protection_code' CHAR(32) NOT NULL,
'signup_date' DATETIME DEFAULT NULL,
'store_id' SMALLINT(5) UNSIGNED NOT NULL,
'message' TEXT DEFAULT NULL,
'status' SMALLINT(5) UNSIGNED NOT NULL,
UNIQUE KEY 'email' ('email'),
PRIMARY KEY ('invitation_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rate (
'id' int(10) unsigned NOT NULL auto_increment,
'website_ids' text,
'customer_group_ids' text,
'direction' smallint(3) NOT NULL,
'points' int(11) NOT NULL,
'money' float NOT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction_orderspend (
'id' int(11) unsigned NOT NULL auto_increment,
'transaction_id' int(11) NOT NULL,
'order_increment_id' varchar(50) NOT NULL,
'points_to_money' decimal(12,4) NOT NULL,
'base_points_to_money' decimal(12,4) NOT NULL,
PRIMARY KEY ('id'),
KEY 'points_order_increment_id' ('order_increment_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[9] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 933
[function] => multiQuery
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction (
'id' int(11) NOT NULL auto_increment,
'store_id' smallint(5) unsigned NOT NULL,
'summary_id' int(11) NOT NULL,
'balance_change' int(11) NOT NULL,
'balance_change_spent' int(11) NOT NULL,
'action' varchar(30) NOT NULL,
'comment' varchar(255) NOT NULL,
'notice' varchar(255) NOT NULL,
'change_date' datetime NOT NULL,
'expiration_date' datetime NULL,
'customer_name' varchar(255) NOT NULL,
'customer_email' varchar(255) NOT NULL,
PRIMARY KEY ('id'),
CONSTRAINT 'AW_POINTS_TRANSACTION_FK' FOREIGN KEY ('summary_id') REFERENCES aw_points_summary ('id') ON DELETE CASCADE,
KEY 'AW_POINTS_TRANSACTION_ACTION' ('action'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE_SPENT' ('balance_change_spent'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE' ('balance_change'),
KEY 'AW_POINTS_TRANSACTION_CHANGE_DATE' ('change_date'),
KEY 'AW_POINTS_TRANSACTION_EXPIRATION_DATE' ('expiration_date')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rule (
'rule_id' int(10) unsigned NOT NULL auto_increment,
'sort_order' int(10) unsigned NOT NULL default '0',
'name' varchar(255) NOT NULL default '',
'description' text NOT NULL,
'from_date' date default '0000-00-00',
'to_date' date default '0000-00-00',
'customer_group_ids' text,
'is_active' tinyint(1) NOT NULL default '0',
'conditions_serialized' mediumtext NOT NULL,
'website_ids' text,
'points_change' int(11) NOT NULL,
'static_blocks_ids' text,
PRIMARY KEY ('rule_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_invitatioin (
'invitation_id' INT UNSIGNED NOT NULL AUTO_INCREMENT,
'customer_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'date' DATETIME NOT NULL ,
'email' VARCHAR( 255 ) NOT NULL ,
'referral_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'protection_code' CHAR(32) NOT NULL,
'signup_date' DATETIME DEFAULT NULL,
'store_id' SMALLINT(5) UNSIGNED NOT NULL,
'message' TEXT DEFAULT NULL,
'status' SMALLINT(5) UNSIGNED NOT NULL,
UNIQUE KEY 'email' ('email'),
PRIMARY KEY ('invitation_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rate (
'id' int(10) unsigned NOT NULL auto_increment,
'website_ids' text,
'customer_group_ids' text,
'direction' smallint(3) NOT NULL,
'points' int(11) NOT NULL,
'money' float NOT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction_orderspend (
'id' int(11) unsigned NOT NULL auto_increment,
'transaction_id' int(11) NOT NULL,
'order_increment_id' varchar(50) NOT NULL,
'points_to_money' decimal(12,4) NOT NULL,
'base_points_to_money' decimal(12,4) NOT NULL,
PRIMARY KEY ('id'),
KEY 'points_order_increment_id' ('order_increment_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[10] => Array
(
[file] => /var/www/html/public_html/app/code/local/AW/Points/sql/points_setup/mysql4-install-1.0.php
[line] => 122
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE IF NOT EXISTS aw_points_summary (
'id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'points' int(11) NOT NULL,
'balance_update_notification' TINYINT DEFAULT NULL,
'points_expiration_notification' TINYINT DEFAULT NULL,
'points_for_subscription_granted' TINYINT DEFAULT NULL,
'points_for_registration_granted' TINYINT DEFAULT NULL,
'points_for_tags_granted' TEXT,
PRIMARY KEY ('id'),
UNIQUE KEY 'AW_POINTS_SUMMARY_CUSTOMER_ID' ('customer_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction (
'id' int(11) NOT NULL auto_increment,
'store_id' smallint(5) unsigned NOT NULL,
'summary_id' int(11) NOT NULL,
'balance_change' int(11) NOT NULL,
'balance_change_spent' int(11) NOT NULL,
'action' varchar(30) NOT NULL,
'comment' varchar(255) NOT NULL,
'notice' varchar(255) NOT NULL,
'change_date' datetime NOT NULL,
'expiration_date' datetime NULL,
'customer_name' varchar(255) NOT NULL,
'customer_email' varchar(255) NOT NULL,
PRIMARY KEY ('id'),
CONSTRAINT 'AW_POINTS_TRANSACTION_FK' FOREIGN KEY ('summary_id') REFERENCES aw_points_summary ('id') ON DELETE CASCADE,
KEY 'AW_POINTS_TRANSACTION_ACTION' ('action'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE_SPENT' ('balance_change_spent'),
KEY 'AW_POINTS_TRANSACTION_BALANCE_CHANGE' ('balance_change'),
KEY 'AW_POINTS_TRANSACTION_CHANGE_DATE' ('change_date'),
KEY 'AW_POINTS_TRANSACTION_EXPIRATION_DATE' ('expiration_date')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rule (
'rule_id' int(10) unsigned NOT NULL auto_increment,
'sort_order' int(10) unsigned NOT NULL default '0',
'name' varchar(255) NOT NULL default '',
'description' text NOT NULL,
'from_date' date default '0000-00-00',
'to_date' date default '0000-00-00',
'customer_group_ids' text,
'is_active' tinyint(1) NOT NULL default '0',
'conditions_serialized' mediumtext NOT NULL,
'website_ids' text,
'points_change' int(11) NOT NULL,
'static_blocks_ids' text,
PRIMARY KEY ('rule_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_invitatioin (
'invitation_id' INT UNSIGNED NOT NULL AUTO_INCREMENT,
'customer_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'date' DATETIME NOT NULL ,
'email' VARCHAR( 255 ) NOT NULL ,
'referral_id' INT( 10 ) UNSIGNED DEFAULT NULL ,
'protection_code' CHAR(32) NOT NULL,
'signup_date' DATETIME DEFAULT NULL,
'store_id' SMALLINT(5) UNSIGNED NOT NULL,
'message' TEXT DEFAULT NULL,
'status' SMALLINT(5) UNSIGNED NOT NULL,
UNIQUE KEY 'email' ('email'),
PRIMARY KEY ('invitation_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_rate (
'id' int(10) unsigned NOT NULL auto_increment,
'website_ids' text,
'customer_group_ids' text,
'direction' smallint(3) NOT NULL,
'points' int(11) NOT NULL,
'money' float NOT NULL,
PRIMARY KEY ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS aw_points_transaction_orderspend (
'id' int(11) unsigned NOT NULL auto_increment,
'transaction_id' int(11) NOT NULL,
'order_increment_id' varchar(50) NOT NULL,
'points_to_money' decimal(12,4) NOT NULL,
'base_points_to_money' decimal(12,4) NOT NULL,
PRIMARY KEY ('id'),
KEY 'points_order_increment_id' ('order_increment_id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[11] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /var/www/html/public_html/app/code/local/AW/Points/sql/points_setup/mysql4-install-1.0.php
)
[function] => include
)
[12] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 421
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 1.6.0
)
)
[13] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.6.0
)
)
[14] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[15] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 412
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[16] => Array
(
[file] => /var/www/html/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 338
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[17] => Array
(
[file] => /var/www/html/public_html/app/Mage.php
[line] => 640
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[18] => Array
(
[file] => /var/www/html/public_html/index.php
[line] => 93
[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 ''id' int(11) NOT NULL auto_increment,
'customer_id' int(11) NOT NULL,
'point' at line 2
)
)