Installation in Zk 1.3.2 build 59 gives problems

[espaan]

Hi,

I try to install the current master branch in Zikula 1.3.2 build 59 and get the following error on install:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ezcomments.ui_hooks.comments.ui_view' for key 'myindex'

It gives a lot of hook messages.
I have included part of the trace below.
#10 /Users/erik/Documents/Zikula/GitEZComments/src/modules/EZComments/lib/EZComments/Installer.php(28): HookUtil::registerSubscriberBundles(Array)

[espaan]

Ok update, I was upgrading an older site from 112 to 128 to 132 and it fell over hook stuff. So if the install is not going well due to whatever the hook db entries are still there and re-installing gives problems. Removing by hand every hook item for ezcomments and re-install clean works now.

[craigh]

that may mean that it didn't uninstall well (if you had uninstalled it).

On Dec 28, 2011, at 12:46 PM, Erik Spaan wrote:

Hi,

I try to install the current master branch in Zikula 1.3.2 build 59 and get the following error on install:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ezcomments.ui_hooks.comments.ui_view' for key 'myindex'

It gives a lot of hook messages.
I have included the trace below.

#0 Er heeft zich een uitzondering voorgedaan in /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection.php, regel 1082.
#1 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO hoo...', Array)
#3 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection/UnitOfWork.php(647): Doctrine_Connection->insert(Object(Doctrine_Table), Array)
#4 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection/UnitOfWork.php(571): Doctrine_Connection_UnitOfWork->processSingleInsert(Object(Zikula_Doctrine_Model_HookSubscriber))
#5 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Connection/UnitOfWork.php(81): Doctrine_Connection_UnitOfWork->insert(Object(Zikula_Doctrine_Model_HookSubscriber))
#6 /Applications/MAMP/htdocs/zk132/lib/vendor/Doctrine/Doctrine/Record.php(1718): Doctrine_Connection_UnitOfWork->saveGraph(Object(Zikula_Doctrine_Model_HookSubscriber))
#7 /Applications/MAMP/htdocs/zk132/lib/Zikula/HookManager/Storage/Doctrine.php(39): Doctrine_Record->save()
#8 /Applications/MAMP/htdocs/zk132/lib/Zikula/HookManager.php(105): Zikula_HookManager_Storage_Doctrine->registerSubscriber('EZComments', NULL, 'subscriber.ezco...', 'ui_view', 'ui_hooks', 'ezcomments.ui_h...')
#9 /Applications/MAMP/htdocs/zk132/lib/util/HookUtil.php(155): Zikula_HookManager->registerSubscriberBundle(Object(Zikula_HookManager_SubscriberBundle))
#10 /Users/erik/Documents/Zikula/GitEZComments/src/modules/EZComments/lib/EZComments/Installer.php(28): HookUtil::registerSubscriberBundles(Array)
#11 [internal function]: EZComments_Installer->install()
#12 /Applications/MAMP/htdocs/zk132/system/Extensions/lib/Extensions/Api/Admin.php(891): call_user_func(Array)
#13 [internal function]: Extensions_Api_Admin->initialise(Array)
#14 /Applications/MAMP/htdocs/zk132/lib/util/ModUtil.php(1089): call_user_func(Array, Array)
#15 /Applications/MAMP/htdocs/zk132/lib/util/ModUtil.php(1194): ModUtil::exec('Extensions', 'admin', 'initialise', Array, true, NULL)
#16 /Applications/MAMP/htdocs/zk132/system/Extensions/lib/Extensions/Controller/Admin.php(612): ModUtil::apiFunc('Extensions', 'admin', 'initialise', Array)
#17 [internal function]: Extensions_Controller_Admin->initialise(Array)
#18 /Applications/MAMP/htdocs/zk132/lib/util/ModUtil.php(1089): call_user_func(Array, Array)
#19 /Applications/MAMP/htdocs/zk132/lib/util/ModUtil.php(1168): ModUtil::exec('Extensions', 'admin', 'initialise', Array, false, NULL)
#20 /Applications/MAMP/htdocs/zk132/index.php(78): ModUtil::func('Extensions', 'admin', 'initialise', Array)
#21 {main}

---

Reply to this email directly or view it on GitHub:
#28

[espaan]

Hey, got it working. Was indeed more or less my own fault. When it finds an error during install, the hooks are not removed. So when you fix some db issue the and try to install again the hooks are already listed and the installation gives this hook already exists message.

So not sure if it can be made more robust or that it was an user error in my case.

[espaan]

I think this one can be closed. If something goes wrong during install it is hard to predict what was wrong and remove all that stuff again.