4.4.5 install not completing on Joomla

[thebrightknight72]

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)

[thebrightknight72]

My Joomla! Version is Joomla! 2.5.20 Stable [ Ember ] 30-April-2014 14:00 GMT

[Hershel]

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

[thebrightknight72]

I first did the install and got the errors.  Next i found the table build script, ran that and got the same error?  I never saw anywhere to configure CiviCRM for the database or exactly what to setup in the database.  I think I got lost somewhere.

[Hershel]

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.

[thebrightknight72]

Thank you very much for your help.  Once I was able to get all of the civicrm tables removed I got the following:

CiviCRM
CiviCRM component files and database tables have been INSTALLED successfully.
Please review the Installation Guide for any additional steps required to complete the installation.

Then use the Configuration Checklist to review and configure CiviCRM settings for your new site.

Additional Resources:

Create front-end forms and searchable directories using Profiles
Create online contribution pages
Create events with online event registration
We have integrated KCFinder with CKEditor and TinyMCE, which enables user to upload images. Note that all the images uploaded using KCFinder will be public.

Have you registered this site at CiviCRM.org? If not, please help strengthen the CiviCRM ecosystem by taking a few minutes to fill out the site registration form. The information collected will help us prioritize improvements, target our communications and build the community. If you have a technical role for this site, be sure to check Keep in Touch to receive technical updates (a low volume mailing list).

Now time to learn this new system!

[thebrightknight72]

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.

[Hershel]

Enable debugging and post the full error message.

[thebrightknight72]

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

[thebrightknight72]

Also here are the error details:

Database Error Code: alter routine command denied to user 'joomla'@'localhost' for routine 'manch_doyles.civicrm_strip_non_numeric', 1370
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'joomla'@'localhost' for routine 'manch_doyles.civicrm_strip_non_numeric']
    [type] => DB_Error
    [user_info] => DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'joomla'@'localhost' for routine 'manch_doyles.civicrm_strip_non_numeric']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP FUNCTION IF EXISTS civicrm_strip_non_numeric [nativecode=1370 ** alter routine command denied to user 'joomla'@'localhost' for routine 'manch_doyles.civicrm_strip_non_numeric']"]
)


[Hershel]

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

[thebrightknight72]

Great thank you, I was able to fix it.

[bmw]

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.