CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Language and Locality »
  • Francophone User Group (Moderators: mathieu, xavier) »
  • connexion impossible admin joomla après installation de civicrm
Pages: [1]

Author Topic: connexion impossible admin joomla après installation de civicrm  (Read 1315 times)

yvescamara

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: civicrm 4.4.5
  • CMS version: Joomla 2.5.19
  • MySQL version: 5.6.12
  • PHP version: 5.4.12
connexion impossible admin joomla après installation de civicrm
April 30, 2014, 05:38:42 am
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

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 0
    • dotPro Tecnologia e Comunicação
  • CiviCRM version: 4.3.5
  • CMS version: Joomla! 3.1.x
  • MySQL version: 5.3
  • PHP version: 5.3
Re: connexion impossible admin joomla après installation de civicrm
April 30, 2014, 06:31:41 am
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

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: civicrm 4.4.5
  • CMS version: Joomla 2.5.19
  • MySQL version: 5.6.12
  • PHP version: 5.4.12
Re: connexion impossible admin joomla après installation de civicrm
April 30, 2014, 07:26:30 am
Yes!! ;D ;D

everything works fine, thank you for your quick help.

Tout marche correctement, Merci de votre aide.

 ;D

yvescamara

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: civicrm 4.4.5
  • CMS version: Joomla 2.5.19
  • MySQL version: 5.6.12
  • PHP version: 5.4.12
Re: connexion impossible admin joomla après installation de civicrm
May 01, 2014, 06:26:29 am
 ???
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

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 0
    • dotPro Tecnologia e Comunicação
  • CiviCRM version: 4.3.5
  • CMS version: Joomla! 3.1.x
  • MySQL version: 5.3
  • PHP version: 5.3
Re: connexion impossible admin joomla après installation de civicrm
May 02, 2014, 11:41:04 am
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

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: civicrm 4.4.5
  • CMS version: Joomla 2.5.19
  • MySQL version: 5.6.12
  • PHP version: 5.4.12
Re: connexion impossible admin joomla après installation de civicrm
May 03, 2014, 08:24:20 am
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.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Language and Locality »
  • Francophone User Group (Moderators: mathieu, xavier) »
  • connexion impossible admin joomla après installation de civicrm

This forum was archived on 2017-11-26.