CiviCRM Community Forums (archive)

1) I received the cannot build Admin Menus - See screen shot
2) When trying to update the database as instructed in the green font, I get the following error.
3) The table that the script is trying to update, in fact DOES NOT exists, see database tables screen shot.


After a couple of failed installations, I did delete all civi* tables, and all civi* components and files ==> find . -name \*civicrm\* and delete all of it and started from new.

System info follows.
civicrm-4.0.7-joomla.zip

PHP Built On     Linux  2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686
Database Version     5.0.77-log
Database Collation     utf8_general_ci
PHP Version     5.2.10
Web Server     Apache/2.2.3 (CentOS) DAV/2 mod_python/3.2.8 Python/2.4.3 mod_ssl/2.2.3 OpenSSL/0.9.8e-fips-rhel5 SVN/1.4.2 Phusion_Passenger/2.2.7 mod_perl/2.0.4 Perl/v5.8.8
WebServer to PHP Interface     apache2handler
Joomla! Version     Joomla! 1.7.3 Stable [ Ember ] 14-Nov-2011 14:00 GMT
Joomla! Platform Version     Joomla Platform 11.2.0 Stable+Modified [ Omar ] 27-Jul-2011 00:00 GMT
User Agent     Opera/9.80 (Macintosh) Presto/2.9.168 Version/11.52

ERROR Follows

Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value v,
       civicrm_option_group g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Table 'MyTable.civicrm_option_value' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value v,
       civicrm_option_group g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Table 'MyTable.civicrm_option_value' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT v.name as valueName, v.value, g.name as optionName
FROM   civicrm_option_value v,
       civicrm_option_group g
WHERE  ( g.name = 'directory_preferences'
OR       g.name = 'url_preferences' )
AND    v.option_group_id = g.id
AND    v.is_active = 1
 [nativecode=1146 ** Table 'MyTable.civicrm_option_value' doesn't exist]"]
)[/color]


Screen Shots Attached

I have another civicrm running in this server -- running under joomla 1.6 and civicrm 3 and it runs just fine. I know it's not the same, I thought about trying4 with 1.7.

I am not sure about blaming mysql version, the script is simply failing on updating a table that does not exist.

I will stick with version 3 and joomla 16 until the bugs on 4/1.7 are worked out.