## 2011-08-25 16:24:58
## 5244 ## QUERY
SQL: CREATE TABLE `eavblog_posts_text` (
  `value_id` int NOT NULL auto_increment COMMENT 'Value Id',
  `entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Id',
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store Id',
  `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_ENTITY_TYPE_ID` (`entity_type_id`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_STORE_ID` (`store_id`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_ENTITY_ID` (`entity_id`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_ATTRIBUTE_ID_VALUE` (`attribute_id`, `value`),
  INDEX `IDX_EAVBLOG_POSTS_TEXT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`, `value`),
  CONSTRAINT `FK_EAVBLOG_POSTS_TEXT_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `eav_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_EAVBLOG_POSTS_TEXT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_EAVBLOG_POSTS_TEXT_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Eav Entity Value Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
TIME: 0.0028

## 2011-08-25 16:24:58
EXCEPTION
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'value' used in key specification without a key length' in /var/www/magento1.local/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/magento1.local/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/magento1.local/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/magento1.local/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/www/magento1.local/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /var/www/magento1.local/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE `e...', Array)
#5 /var/www/magento1.local/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE `e...', Array)
#6 /var/www/magento1.local/lib/Varien/Db/Adapter/Pdo/Mysql.php(1968): Varien_Db_Adapter_Pdo_Mysql->query('CREATE TABLE `e...')
#7 /var/www/magento1.local/app/code/core/Mage/Eav/Model/Entity/Setup.php(1358): Varien_Db_Adapter_Pdo_Mysql->createTable(Object(Varien_Db_Ddl_Table))
#8 /var/www/magento1.local/.modman/Magentotutorial_Complexworld/code/sql/complexworld_setup/mysql4-install-0.1.0.php(17): Mage_Eav_Model_Entity_Setup->createEntityTables('eavblog_posts')
#9 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(624): include('/var/www/magent...')
#10 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.1.0')
#11 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('0.1.0')
#12 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#13 /var/www/magento1.local/app/code/core/Mage/Core/Model/App.php(408): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#14 /var/www/magento1.local/app/code/core/Mage/Core/Model/App.php(336): Mage_Core_Model_App->_initModules()
#15 /var/www/magento1.local/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#16 /var/www/magento1.local/index.php(81): Mage::run('', 'store')
#17 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'value' used in key specification without a key length' in /var/www/magento1.local/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/magento1.local/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/magento1.local/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/magento1.local/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/magento1.local/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE `e...', Array)
#4 /var/www/magento1.local/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE `e...', Array)
#5 /var/www/magento1.local/lib/Varien/Db/Adapter/Pdo/Mysql.php(1968): Varien_Db_Adapter_Pdo_Mysql->query('CREATE TABLE `e...')
#6 /var/www/magento1.local/app/code/core/Mage/Eav/Model/Entity/Setup.php(1358): Varien_Db_Adapter_Pdo_Mysql->createTable(Object(Varien_Db_Ddl_Table))
#7 /var/www/magento1.local/.modman/Magentotutorial_Complexworld/code/sql/complexworld_setup/mysql4-install-0.1.0.php(17): Mage_Eav_Model_Entity_Setup->createEntityTables('eavblog_posts')
#8 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(624): include('/var/www/magent...')
#9 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.1.0')
#10 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('0.1.0')
#11 /var/www/magento1.local/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#12 /var/www/magento1.local/app/code/core/Mage/Core/Model/App.php(408): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#13 /var/www/magento1.local/app/code/core/Mage/Core/Model/App.php(336): Mage_Core_Model_App->_initModules()
#14 /var/www/magento1.local/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#15 /var/www/magento1.local/index.php(81): Mage::run('', 'store')
#16 {main}

## 2011-08-25 16:24:58
## 5244 ## TRANSACTION ROLLBACK
TIME: 0.0001