CiviCRM Community Forums (archive)

I have downloaded civicrm-4.4.5-joomla.zip and I have decompressed this into the joomla tmp folder and have the "Install From Directory" pointed to the correct directory. When the install completes i see
CiviCRM
CiviCRM component files have been UPGRADED successfully.
Please run the CiviCRM Database Upgrade Utility now. This utility will check your database and perform any needed upgrades.

Also review the Upgrade Guide for any additional steps required to complete this upgrade.

When I click on the Database Upgrade Utility I get:

CiviCRM-001 - An error has occurred.
<div id="crm-container" class="crm-container" lang="en" xml:lang="en"> <style type="text/css" media="screen">@import url(/administrator/css/civicrm.css);</style> <style type="text/css" media="screen">@import url(/administrator/css/extras.css);</style> <div class="messages status no-popup"> <div class="icon red-icon alert-icon"></div> <span class="status-fatal">Sorry but we are not able to provide this at the moment.</span> <div class="crm-section crm-error-message">Version information missing in civicrm database.</div> <p><a href="http://my.dyndns-at-home.com/administrator/" title="Main Menu">Return to home page.</a></p> </div> </div> <script language="JavaScript"> function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } } </script>

Return to Control Panel

I had to run a script that I downloaded to create the tables for the site.  I also ran the following command to set the version and it did not change anything.
 UPDATE civicrm_domain SET version = '4.4.5' WHERE id = 1;

What am I missing?

Database Version    5.5.37-0ubuntu0.14.04.1
Database Collation    utf8_general_ci
PHP Version    5.5.9-1ubuntu4
Web Server    Apache/2.4.7 (Ubuntu)

What exactly happened here? Did you first run a script to make the tables and then run the installer?

If you ran the install for the first time and saw:

CiviCRM component files have been UPGRADED successfully.

that indicates that CiviCRM was once there.

What I would suggest is that you:

1. Remove entirely all tables starting with civicrm_ from your database
2. Run the installer again

and then stop there and tell us what happened.

Everything installed as I posted previously.  Again THANK YOU!

Now when I go through the Configuration Checklist I get the following error on my page:

Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Return to home page.

In my log file I see:

Undefined index: id in /www/administrator/components/com_civicrm/civicrm/CRM/Contact/Page/AJAX.php on line 892, referer: http://my.host.com/administrator/index.php?option=com_civicrm


Please advise.

Here is what I get:

backTrace

#0 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /www/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: unknown error", -1, 16, (Array:2), "DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter r...")
#4 /www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-1, 16, (Array:2), "DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter r...")
#5 /www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -1, NULL, NULL, "DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter r...", "DB_Error", TRUE)
#6 /www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, "1370 ** alter routine command denied to user 'joomla'@'localhost' for routine...")
#7 /www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric")
#9 /www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric")
#10 /www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric")
#11 /www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(160): DB_DataObject->query("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric")
#12 /www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(908): CRM_Core_DAO->query("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric", TRUE)
#13 /www/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php(3058): CRM_Core_DAO::executeQuery("DROP FUNCTION IF EXISTS civicrm_strip_non_numeric")
#14 /www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1557): CRM_Contact_BAO_Contact::triggerInfo((Array:3), NULL)
#15 /www/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(1580): CRM_Core_DAO::triggerRebuild()
#16 /www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Phone.php(73): CRM_Core_DAO::checkSqlFunctionsExist()
#17 /www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Block.php(373): CRM_Core_BAO_Phone::add((Array:7))
#18 /www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Location.php(66): CRM_Core_BAO_Block::create("phone", (Array:15), NULL)
#19 /www/administrator/components/com_civicrm/civicrm/CRM/Contact/Form/Domain.php(289): CRM_Core_BAO_Location::create((Array:15), TRUE)
#20 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(261): CRM_Contact_Form_Domain->postProcess()
#21 /www/administrator/components/com_civicrm/civicrm/CRM/Core/StateMachine.php(160): CRM_Core_Form->mainProcess()
#22 /www/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(60): CRM_Core_StateMachine->perform(Object(CRM_Contact_Form_Domain), "next", "Next")
#23 /www/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Contact_Form_Domain), "next")
#24 /www/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Domain), "next")
#25 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(339): HTML_QuickForm_Page->handle("next")
#26 /www/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#27 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(297): CRM_Utils_Wrapper->run("CRM_Contact_Form_Domain", "Organization Address and Contact Info", NULL)
#28 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#29 /www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#30 /www/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:3))
#31 /www/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#32 /www/libraries/joomla/application/component/helper.php(380): require_once("/www/administrator/components/com_civicrm/admin.civicrm.php")
#33 /www/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent("/www/administrator/components/com_civicrm/admin.civicrm.php")
#34 /www/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#35 /www/administrator/index.php(46): JAdministrator->dispatch()
#36 {main}
Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Error Details
Return to home page.

Any my error log reflects:
[Tue Jun 10 09:13:15.188034 2014] [:error] [pid 8487] [client 174.60.116.149:59630] PHP Notice:  Undefined index: permission_operator in /www/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Dashboard.php on line 140, referer: http://my.hose.com/administrator/index.php?option=com_civicrm
[Tue Jun 10 09:13:15.415868 2014] [:error] [pid 8487] [client 174.60.116.149:59630] PHP Notice:  Undefined index: id in /www/administrator/components/com_civicrm/civicrm/CRM/Contact/Page/AJAX.php on line 892, referer: http://my.hose.com/administrator/index.php?option=com_civicrm

The error "alter routine command denied to user 'joomla'@'localhost'" means your MySQL user lacks sufficient rights. Ask your host to fix that.

Your last posting that you fixed it is not very helpful to others that are experiencing the same issue. If you remember and are able to, please post your fix. After all, we are open source community. We need to fully share our experiences especially on difficult bugs and conflicts. Thank you.