PDOException Object
(
    [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'event_type_id'; check that column/key exists
    [string:Exception:private] => 
    [code:protected] => 42000
    [file:protected] => /home/officeshop/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
    [line:protected] => 276
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/officeshop/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 276
                    [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] => /home/officeshop/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 397
                    [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] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 612
                    [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] => /home/officeshop/public_html/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] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 360
                    [args] => Array
                        (
                            [0] => /home/officeshop/public_html/app/code/core/Mage/Reports/sql/reports_setup/mysql4-upgrade-0.7.3-0.7.4.php
                        )

                    [function] => include
                )

            [5] => Array
                (
                    [file] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 273
                    [function] => _modifyResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => upgrade
                            [1] => 0.7.3
                            [2] => 0.7.10
                        )

                )

            [6] => Array
                (
                    [file] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 217
                    [function] => _upgradeResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 0.7.3
                            [1] => 0.7.10
                        )

                )

            [7] => Array
                (
                    [file] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 153
                    [function] => applyUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [8] => Array
                (
                    [file] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/App.php
                    [line] => 363
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [9] => Array
                (
                    [file] => /home/officeshop/public_html/app/code/core/Mage/Core/Model/App.php
                    [line] => 295
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [10] => Array
                (
                    [file] => /home/officeshop/public_html/app/Mage.php
                    [line] => 596
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => 
                                    [scope_type] => store
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [11] => Array
                (
                    [file] => /home/officeshop/public_html/index.php
                    [line] => 78
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => store
                        )

                )

        )

    [previous:Exception:private] => 
    [errorInfo] => Array
        (
            [0] => 42000
            [1] => 1091
            [2] => Can't DROP 'event_type_id'; check that column/key exists
        )

)