connexion impossible admin joomla après installation de civicrm

[yvescamara]

Bonjour à tous et merci d'avance pour l'aide,

Après installation et première utilisation de civicrm 4.4.4 sur joomla 2.5.19, et une fois déconnecté, je n'arrive plus à accéder à l'administrateur de mon site. Je travaille en local avec wamp 2.4, PHP 5.4, Mysql 5.6.
tout marche correctement sans civicrm.

l'erreur que j'ai la suivante: Warning: mysqli_error() expects parameter 1 to be mysqli, resource given in C:\wamp\www\siteyves\administrator\components\com_civicrm\civicrm\CRM\Core\Error.php on line 182.

DB Error: no such table
Error Details
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table 'baseyves.civicrm_acl_contact_cache' doesn't exist]
    [type] => DB_Error
    [user_info] => TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table 'baseyves.civicrm_acl_contact_cache' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="TRUNCATE TABLE civicrm_acl_contact_cache [nativecode=1146 ** Table 'baseyves.civicrm_acl_contact_cache' doesn't exist]"]
).

Avez des solutions?

merci

[diegov]

You can run the following on your MySQL to create that table:

Code: [Select]

CREATE TABLE IF NOT EXISTS `civicrm_acl_contact_cache` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
  `user_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact (could be null for anon user)',
  `contact_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact',
  `operation` enum('All','View','Edit','Create','Delete','Grant','Revoke') COLLATE utf8_unicode_ci NOT NULL COMMENT 'What operation does this user have permission on?',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UI_user_contact_operation` (`user_id`,`contact_id`,`operation`),
  KEY `FK_civicrm_acl_contact_cache_contact_id` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

ALTER TABLE `civicrm_acl_contact_cache`
  ADD CONSTRAINT `FK_civicrm_acl_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_civicrm_acl_contact_cache_user_id` FOREIGN KEY (`user_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE;



[yvescamara]

Yes!!

everything works fine, thank you for your quick help.

Tout marche correctement, Merci de votre aide.

 

[yvescamara]

 
finalement, le problème revient chaque fois que je reste longtemps sans activité. Comme ci la table s'auto supprimait à chaque déconnexion de l'administrateur.
Pensez vous que je dois relancer le code à chaque connexion? Je ne risque pas de perdre tout mon travail ?

Merci pour votre aide.

[diegov]

Very weird (sorry, I can't speak French and I know that I'm writing to the French group...).
The MySQL command that runs automatically on CiviCRM (truncate, as you saw in the error), would only make the table empty, not drop it. So after the MySQL command I sent, the table should be there, clear most of the time as it's only cache stuff.
When you say "déconnexion de l'administrateur" is it the the Joomla! administration or the MySQL administration?

[yvescamara]

thank you for your answer ( I don't speak very well english to),

I talk about Joomla! administrator's deconnection. That often happens when I stay a time without activity on the admin. It asks me to reconnect, and the error appears.
I deleted my browser cache, but no change.