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) »
  • enregistrement d'activité
Pages: [1]

Author Topic: enregistrement d'activité  (Read 607 times)

ziako

  • I post occasionally
  • **
  • Posts: 39
  • Karma: 0
    • CPE 31-Le travail en temps partagé
  • CiviCRM version: 4.7.23
  • CMS version: Joomla 3.7.4
  • MySQL version: 5.5.14
  • PHP version: 5.6.2
enregistrement d'activité
August 21, 2014, 02:39:22 am
Bonjour,

Je saisi une activité pour un contact avec ou sans des champs personnalisés après enregistrement  j'ai ce message d'erreur :
administrator\components\com_civicrm\civicrm\CRM\Core\Error.php(149)...etc..etc..

Détails débug :
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
    [type] => DB_Error
    [user_info] => INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]"]
)

L'activité est pourtant enregistrée dans le contact, mais il est impossible d'afficher le contenu de l'onglet activité alors que les autres onglets affichent bien le contenu dans la consultation de la fiche du contact

wamp / joomla 2.5.24 /Civi 4.4.5 /php 5.4.16....même problème sur le site en production

Quelqu'un à une idée de l'origine du Pb?? merci

ziako

  • I post occasionally
  • **
  • Posts: 39
  • Karma: 0
    • CPE 31-Le travail en temps partagé
  • CiviCRM version: 4.7.23
  • CMS version: Joomla 3.7.4
  • MySQL version: 5.5.14
  • PHP version: 5.6.2
Re: enregistrement d'activité
August 22, 2014, 06:42:08 am
Quote from: ziako on August 21, 2014, 02:39:22 am
Bonjour,

Je saisi une activité pour un contact avec ou sans des champs personnalisés après enregistrement  j'ai ce message d'erreur :
administrator\components\com_civicrm\civicrm\CRM\Core\Error.php(149)...etc..etc..

backTrace

#0 C:\wamp\www\cpe31gest\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 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB.php(969): PEAR_Error->PEAR_Error("DB Error: syntax error", -2, 16, (Array:2), "INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#4 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-2, 16, (Array:2), "INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#5 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1905): PEAR->raiseError(NULL, -2, NULL, NULL, "INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...", "DB_Error", TRUE)
#6 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#8 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#9 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(2421): DB_common->query("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#10 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\DB\DataObject.php(1613): DB_DataObject->_query("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#11 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\DAO.php(160): DB_DataObject->query("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#12 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\DAO.php(908): CRM_Core_DAO->query("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...", TRUE)
#13 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Activity\BAO\Activity.php(392): CRM_Core_DAO::executeQuery("INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record...")
#14 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Activity\Form\Activity.php(1104): CRM_Activity_BAO_Activity::create((Array:85))
#15 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Activity\Form\Activity.php(1073): CRM_Activity_Form_Activity->processActivity((Array:85))
#16 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\Form.php(261): CRM_Activity_Form_Activity->postProcess()
#17 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\QuickForm\Action\Upload.php(151): CRM_Core_Form->mainProcess()
#18 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\QuickForm\Action\Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Activity_Form_Activity), "upload")
#19 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\HTML\QuickForm\Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Activity_Form_Activity), "upload")
#20 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\packages\HTML\QuickForm\Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Activity_Form_Activity), "upload")
#21 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\Controller.php(339): HTML_QuickForm_Page->handle("upload")
#22 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Utils\Wrapper.php(117): CRM_Core_Controller->run()
#23 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\Invoke.php(297): CRM_Utils_Wrapper->run("CRM_Activity_Form_Activity", "Nouvelle activité", (Array:1))
#24 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#25 C:\wamp\www\cpe31gest\administrator\components\com_civicrm\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#26 C:\wamp\www\cpe31gest\components\com_civicrm\civicrm.php(86): CRM_Core_Invoke::invoke((Array:2))
#27 C:\wamp\www\cpe31gest\components\com_civicrm\civicrm.php(11): civicrm_invoke()
#28 C:\wamp\www\cpe31gest\libraries\joomla\application\component\helper.php(380): require_once("C:\wamp\www\cpe31gest\components\com_civicrm\civicrm.php")
#29 C:\wamp\www\cpe31gest\libraries\joomla\application\component\helper.php(348): JComponentHelper::executeComponent("C:\wamp\www\cpe31gest/components/com_civicrm/civicrm.php")
#30 C:\wamp\www\cpe31gest\includes\application.php(194): JComponentHelper::renderComponent("com_civicrm")
#31 C:\wamp\www\cpe31gest\index.php(42): JSite->dispatch()
#32 {main}


Détails débug :
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
    [type] => DB_Error
    [user_info] => INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT IGNORE INTO civicrm_activity_contact ( activity_id, contact_id, record_type_id ) VALUES ( 3586, 40274,  ); [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]"]
)

L'activité est pourtant enregistrée dans le contact, mais il est impossible d'afficher le contenu de l'onglet activité alors que les autres onglets affichent bien le contenu dans la consultation de la fiche du contact.

L'édition de la liste des activités provoque le même genre d'erreur !

wamp / joomla 2.5.24 /Civi 4.4.5 /php 5.4.16....même problème sur le site en production

Quelqu'un à une idée de l'origine du Pb?? merci
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Language and Locality »
  • Francophone User Group (Moderators: mathieu, xavier) »
  • enregistrement d'activité

This forum was archived on 2017-11-26.