Дмитрий Федюк (07.05.2011 19:59) писал:
ошибка следующего содержания, видимо с доступом я проверил из виндовс что на папку "magento" и все вложенные папки имеется доступ на запись:
почему возникает эта ошибка?
PDOException Object
(
[message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'event_type_id'; check that column/key exists
[string:private] =>
[code:protected] => 42000
[file:protected] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 277
[trace:private] => Array
(
[0] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 277
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => ALTER TABLE report_event
DROP INDEX `event_type_id`,
ADD INDEX `IDX_EVENT_TYPE` (`event_type_id`)
)
)
[1] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 401
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => ALTER TABLE report_event
DROP INDEX `event_type_id`,
ADD INDEX `IDX_EVENT_TYPE` (`event_type_id`)
)
)
[2] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 636
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
ALTER TABLE report_event
DROP INDEX `event_type_id`,
ADD INDEX `IDX_EVENT_TYPE` (`event_type_id`);
ALTER TABLE report_event
ADD CONSTRAINT `FK_REPORT_EVENT_TYPE` FOREIGN KEY (`event_type_id`)
REFERENCES report_event_types (`event_type_id`)
ON UPDATE CASCADE
ON DELETE CASCADE;
ALTER TABLE report_event
DROP INDEX `subject_id`,
ADD INDEX `IDX_SUBJECT` (`subject_id`);
ALTER TABLE report_event
DROP INDEX `object_id`,
ADD INDEX `IDX_OBJECT` (`object_id`);
ALTER TABLE report_event
DROP INDEX `subtype`,
ADD INDEX `IDX_SUBTYPE` (`subtype`);
ALTER TABLE report_event
DROP INDEX `store_id`;
ALTER TABLE report_event
CHANGE `store_id` `store_id` smallint(5) unsigned NOT NULL;
ALTER TABLE report_event
ADD CONSTRAINT `FK_REPORT_EVENT_STORE` FOREIGN KEY (`store_id`)
REFERENCES core_store (`store_id`)
ON UPDATE CASCADE
ON DELETE CASCADE;
)
)
[3] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Reports\sql\reports_setup\mysql4-upgrade-0.7.3-0.7.4.php
[line] => 66
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
ALTER TABLE report_event
DROP INDEX `event_type_id`,
ADD INDEX `IDX_EVENT_TYPE` (`event_type_id`);
ALTER TABLE report_event
ADD CONSTRAINT `FK_REPORT_EVENT_TYPE` FOREIGN KEY (`event_type_id`)
REFERENCES report_event_types (`event_type_id`)
ON UPDATE CASCADE
ON DELETE CASCADE;
ALTER TABLE report_event
DROP INDEX `subject_id`,
ADD INDEX `IDX_SUBJECT` (`subject_id`);
ALTER TABLE report_event
DROP INDEX `object_id`,
ADD INDEX `IDX_OBJECT` (`object_id`);
ALTER TABLE report_event
DROP INDEX `subtype`,
ADD INDEX `IDX_SUBTYPE` (`subtype`);
ALTER TABLE report_event
DROP INDEX `store_id`;
ALTER TABLE report_event
CHANGE `store_id` `store_id` smallint(5) unsigned NOT NULL;
ALTER TABLE report_event
ADD CONSTRAINT `FK_REPORT_EVENT_STORE` FOREIGN KEY (`store_id`)
REFERENCES core_store (`store_id`)
ON UPDATE CASCADE
ON DELETE CASCADE;
)
)
[4] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 376
[args] => Array
(
[0] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Reports\sql\reports_setup\mysql4-upgrade-0.7.3-0.7.4.php
)
[function] => include
)
[5] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 289
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 0.7.3
[2] => 0.7.10
)
)
[6] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 233
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.3
[1] => 0.7.10
)
)
[7] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\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] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\App.php
[line] => 399
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\App.php
[line] => 329
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\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] => C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\index.php
[line] => 80
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[errorInfo] => Array
(
[0] => 42000
[1] => 1091
[2] => Can't DROP 'event_type_id'; check that column/key exists
)
)
Error in file: "C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Reports\sql\reports_setup\mysql4-upgrade-0.7.3-0.7.4.php" - SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'event_type_id'; check that column/key exists
#0 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(390): Mage::exception('Mage_Core', 'Error in file: ...')
#1 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.7.3', '0.7.10')
#2 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.7.3', '0.7.10')
#3 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\App.php(399): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\code\core\Mage\Core\Model\App.php(329): Mage_Core_Model_App->_initModules()
#6 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\app\Mage.php(627): Mage_Core_Model_App->run(Array)
#7 C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\magento\index.php(80): Mage::run('', 'store')
#8 {main}