CIVICRM4: Error building Admin Menus

[vasacampana]

In Joomla 1.6, CIVICRM 4 installation gives error
        Error building Admin Menus
        Installing component was successful.
No item menu is displayed for CiviCRM, but if I go directly to the admin page, it seems to work.
Thank you.

[Hershel]

Hmmm, now we have two posts with the same issue. Can you post your PHP version and also let us know if your Joomla is fresh or was upgraded?

Thanks.

[vasacampana]

Yes, a new fresh installation of J1.6 and CiviCRM 4.
Here following, the requested info.
If you need more info, please let me know.
Thank you.


PHP Built On    Linux wh03.spin.it 2.6.26-1-xen-686 #1 SMP Fri Mar 13 22:30:40 UTC 2009 i686
Database Version    5.0.51a-24+lenny5-log
Database Collation    utf8_general_ci
PHP Version    5.2.6-1+lenny10
Web Server    Apache
WebServer to PHP Interface    cgi-fcgi
Joomla! Version    Joomla! 1.6.3 Stable [ Onward ] 18-Apr-2011 23:00 GMT
User Agent    Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1


Relevant PHP Settings
Setting    Value
 
Safe Mode    Off
Open basedir    None
Display Errors    On
Short Open Tags    On
File Uploads    On
Magic Quotes    On
Register Globals    Off
Output Buffering    Off
Session Save Path    /var/lib/php5
Session Auto Start    0
XML Enabled    Yes
Zlib Enabled    Yes
Disabled Functions    None
Mbstring Enabled    Yes
Iconv Available    Yes


PHP Version 5.2.6-1+lenny10

System    Linux wh03.spin.it 2.6.26-1-xen-686 #1 SMP Fri Mar 13 22:30:40 UTC 2009 i686
Build Date    Mar 19 2011 01:39:23
Server API    CGI/FastCGI
Virtual Directory Support    disabled
Configuration File (php.ini) Path    /etc/php5/cgi
Loaded Configuration File    /etc/php5/cgi/php.ini
Scan this dir for additional .ini files    /etc/php5/cgi/conf.d
additional .ini files parsed    /etc/php5/cgi/conf.d/ZendOptimizer.ini, /etc/php5/cgi/conf.d/curl.ini, /etc/php5/cgi/conf.d/gd.ini, /etc/php5/cgi/conf.d/imagick.ini, /etc/php5/cgi/conf.d/mhash.ini, /etc/php5/cgi/conf.d/mysql.ini, /etc/php5/cgi/conf.d/mysqli.ini, /etc/php5/cgi/conf.d/odbc.ini, /etc/php5/cgi/conf.d/pdo.ini, /etc/php5/cgi/conf.d/pdo_mysql.ini, /etc/php5/cgi/conf.d/pdo_odbc.ini, /etc/php5/cgi/conf.d/suhosin.ini, /etc/php5/cgi/conf.d/xmlrpc.ini
PHP API    20041225
PHP Extension    20060613
Zend Extension    220060519
Debug Build    no
Thread Safety    disabled
Zend Memory Manager    enabled
IPv6 Support    enabled
Registered PHP Streams    zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps
Registered Stream Socket Transports    tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters    string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

Suhosin logo This server is protected with the Suhosin Patch 0.9.6.2
Copyright (c) 2006 Hardened-PHP Project

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
    with Zend Optimizer v3.3.9, Copyright (c) 1998-2009, by Zend Technologies
    with Suhosin v0.9.27, Copyright (c) 2007, by SektionEins GmbH

[Hershel]

What is your MySQL version?

[vasacampana]

version    5.0.51a-24+lenny5-log
version comment    (Debian)
version compile machine    i486
version compile os    debian-linux-gnu

[Hershel]

This may be the problem. On the about CiviCRM page http://civicrm.org/aboutcivicrm it says CiviCRM requires:

MySQL 5.1.x+ with InnoDB support

Can you upgrade and then retry?

[bizzynate]

I can confirm this problem. I've installed CiviCRM 4.0.1 into a Joomla 1.6.3 installation running on MySQL v 5.1.53 and had the same problem: no menus are created in the Administrator panel Components menu. I don't think it's a MySQL issue. I think it might be an issue with CiviCRM's use of the Joomla API.

[bizzynate]

I have also found a workaround, which may shed light on the problem.

CiviCRM is being added as an administrator menu to the jos_menu table in Joomla, however it's missing it's component_id number. Looking this number up from the jos_extensions table and adding the missing value will cause the menu to display under Components as it should.

[Donald Lobo]

hey bizzynate:

any chance u can take a look at the install code and figure out what needs to be fixed in the installer and/or the xml files.

thanx

lobo

[ben168]

I got the same problem with a fresh install of J1.6.3 and CiviCRM 4.0.1 on localhost using WAMP server running on a Windows Vista.
PHP 5.2.8, MySQL 5.1.30.
Thanks to bizzynate's workaround, I could fanally manage to get the CiviCRM menu.

Here is what I did :
Using PHPMyAdmin, I browsed my joomla site database.
1. Get the extension_id of civicrm in the jos_extensions table (in my case it was 10002)
2. Go in the jos_menu table and look for the comcivicrmmenu alias.
3. Update this record by putting the correct value in the component_id field (in my case the correct value was 10002).

That's all.

I hope developpers will quickly find what was wrong in the installation process.
Ben

[Donald Lobo]

Was this a clean install or did u get an error the first time (typically due to permissions) and then try the install again?

This has happened to me due to the latter multiple times. The J! 1.6 installer aborts the install process due does not clean up the menu entry and hence the second install cannot create the menu item.

I dont now a workaround for this right now. Would be great if someone more familiar with joomla can take a look and figure out a potential solution

lobo

[bmw]

This did not work for me. The correct component_id number was already there.

[diegov]

I'd like to report that the same happened to me, using CiviCRM 4.0.5 and Joomla! 1.7.

The work around did a great job. The id was "0" to the component in the _menu table.

Maybe it's because the tables got random names in this version of Joomla...