CiviCRM Community Forums (archive)

Hi
new joomla 1.6 and CiviCRM 4 beta2 installation gives following errors under Localization as well as under Settings - Miscellaneous:

/home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 543 , nullHandler, /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2420 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1606 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 145 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 1328 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Admin/Form/Setting/Localization.php, checkTriggerViewPermission, 92 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, buildQuickForm, 326 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 284 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 115 /home/boite/public_html/joom16/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 196 /home/boite/public_html/joom16/administrator/components/com_civicrm/admin.civicrm.php, invoke, 77 /home/boite/public_html/joom16/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45 /home/boite/public_html/joom16/libraries/joomla/application/component/helper.php, require_once, 152 /home/boite/public_html/joom16/administrator/includes/application.php, renderComponent, 154 /home/boite/public_html/joom16/administrator/index.php, dispatch, 47

Also had two other problems:

1. The events do not show up front end: I created a menu to events listing which produces a blank page.
The link generated is this:
index.php?option=com_civicrm&view=Events&layout=eventlisting

However, this html link shows the events correctly:

index.php?option=com_civicrm&task=civicrm/event/ical&reset=1&page=1&html=1


2. In profile search, clicking on the profile View link brings you back to a fresh search instead of displaying the profile view.

any suggestions?
thank you very much
Michael

Hi Kurud
thank you for helping, it is much appreciated.

yes, they are in the same database and a lot of CiviCRM is working fine. I have created groups, contribution and membership pages, events. As admin superuser, everything is set to Allowed in access control.

Lobo answered my other entry about the same problem, but he didn't have any suggestions because he could reproduce the error.

I have since installed joomla 1.6 and civicrm 4 beta2 on my mac using MAMP and it works without any problems.
So it must be a server problem.  I have access to two servers and the problem is the same on both servers.

Previously I was using joomla 1.5 and civicrm 3.3.5 without any problems on these servers, so something is wrong with the combination joomla 1.6/civicrm 4 beta2 on the same servers.

One other thing, I can't delete the civicrm table entries in the database. If I try to empty the table, I get this message:

Cannot delete or update a parent row: a foreign key constraint fails

TRUNCATE `civicrm_country`
MySQL said:
#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`joom16co_test/civicrm_state_province`, CONSTRAINT `FK_civicrm_state_province_country_id` FOREIGN KEY (`country_id`) REFERENCES `civicrm_country` (`id`))

So, something has obviously gone wrong with the creation of the database.

Any suggestions??

thank you

Michael