Installing gallery 3.0.0 rc4 gives 'error creating menus'

Phoca Gallery - image gallery extension
Dougj
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 16 Oct 2010, 18:10

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by Dougj »

I have te same issue with Phocagallery and did have the same issue with akeeba as soon as the brand new site with new DB was created. The akeeba developers blames it on joomla 1.6 corrupting some tables at times but has no fix other than a workaround for akeeba

Quote from Akeeba developer:

"There seems to be an intermittent issue with the extensions installer in Joomla! 1.6.0. I confirmed this with other developers and, for the life of us, we can't replicate it in order to report and/or fix it. Rumor has it that there will be a ton of com_installer patches in the upcoming Joomla! 1.6.1.

Anyway. For now, I'll just have to give you a workaround. Using phpMyAdmin edit your jos_menu table. Find the row where menutype=main, title=COM_AKEEBA and link=index.php?option=com_akeeba. Delete that row. Now you should be able to install Akeeba Backup on your site."

Maybe the same is true for phocagallery if someone can find the row to be deleted.

Must be a joomla core issue as previously staed in this forum

D.
tcoibion
Phoca Newbie
Phoca Newbie
Posts: 7
Joined: 14 Mar 2011, 22:54

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by tcoibion »

Dougj wrote:I have te same issue with Phocagallery and did have the same issue with akeeba as soon as the brand new site with new DB was created. The akeeba developers blames it on joomla 1.6 corrupting some tables at times but has no fix other than a workaround for akeeba

Quote from Akeeba developer:

"There seems to be an intermittent issue with the extensions installer in Joomla! 1.6.0. I confirmed this with other developers and, for the life of us, we can't replicate it in order to report and/or fix it. Rumor has it that there will be a ton of com_installer patches in the upcoming Joomla! 1.6.1.

Anyway. For now, I'll just have to give you a workaround. Using phpMyAdmin edit your jos_menu table. Find the row where menutype=main, title=COM_AKEEBA and link=index.php?option=com_akeeba. Delete that row. Now you should be able to install Akeeba Backup on your site."

Maybe the same is true for phocagallery if someone can find the row to be deleted.

Must be a joomla core issue as previously staed in this forum

D.
I have no row created for the phoca gallery menu in this table, so I just like to know how to create it..
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48714
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by Jan »

Hi, yes this seems to be some problem in Joomla! installation.

There are different ways to fix it, e.g. in Phoca Gallery I solved it such way (described in posts above)
I have no row created for the phoca gallery menu in this table, so I just like to know how to create it..
Hmmm, this is more a question on some Joomla! core developer to get info, what all is done by installing an extensions and what is added to the database. :-( :idea:

Jan
If you find Phoca extensions useful, please support the project
lilou
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 04 Apr 2011, 21:48

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by lilou »

Hi,
I solved the same problem updating the SQL request, the title seems to be Phoca Gallery and not phocagallery in jos_menu table.

This SQL request works for me and the menu "phoca-gallery" is now in the components admin menu.

Code: Select all

UPDATE `jos_menu` 
SET `published` =  '1', 
`component_id` = ( SELECT extension_id 
FROM `jos_extensions` 
WHERE element = 'com_phocagallery' ) 
WHERE `title` LIKE '%Phoca Gallery%';
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48714
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
RCheesley
Phoca Member
Phoca Member
Posts: 12
Joined: 16 Aug 2008, 11:40

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by RCheesley »

Think I know what the problem is.

I compared your extension to ones which worked with the admin menus, and Phoca Gallery does not have anything populated in the component_id field - which is the FK relating back to the extensions table. As soon as I populated this with the appropriate ID for com_phocagallery, it worked.

Ruth
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48714
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by Jan »

Yes, I hope Joomla! developers will fix it soon, maybe it is fixed in 1.6.2 :idea:
If you find Phoca extensions useful, please support the project
RaulOne
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 31 May 2011, 17:18

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by RaulOne »

I would like to share my experience, as i had the problem maybe i can help.. First than all i downloaded and "tried" to install the component. Didn't succes :( Just got the beautiful white page. :x

Solution: Find and open php.ini, change max_execution_time = 30 for max_execution_time = 300. :twisted:

Then i tried again and the component was installed but with some warnings I can't remember now, and without admin menus. Tried doing some sql queries, creating tables, etc.. Didn't worked. And then uninstalling and installing again. Still didn't worked. :cry: I was about to call to the Pentagon And C.I.A. to demand an inmediate solution :?: but i tried again and woohoo it worked! :cry:

Solution: After uninstalling, drop all the tables and rows related to phoca from the joomla database (after uninstalling they are still there causing problems if you want to try to install again). :twisted:

Basically my problem was that after trying to install the first time without success, the joomla database was contamined with phoca data that was causing all this problems. Just uninstall phoca component. clean the database manually and install normally 8)

Cheers!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48714
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by Jan »

Hi,
Solution: Find and open php.ini, change max_execution_time = 30 for max_execution_time = 300
or see:
https://www.phoca.cz/documents/16-joomla ... -in-joomla

Anyway thank you for this guide, I hope, it will help other users.

Thank you, Jan
If you find Phoca extensions useful, please support the project
RaulOne
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 31 May 2011, 17:18

Re: Installing gallery 3.0.0 rc4 gives 'error creating menus

Post by RaulOne »

Nice to know how to install large components without modifing max execution time, since working on third-party servers maybe is not easy to modify like in localhost :D

I did that also (without knowing was a solution to install large components) but still wasn't working, because I still had to clean the database, after the first install/uninstall process :D

Greetings
Post Reply