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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Long term release support (Moderators: mathieu, Eileen, youngjin) »
  • DB Error: syntax error
Pages: [1]

Author Topic: DB Error: syntax error  (Read 2172 times)

cllrstephen

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Wordpress 4.1.1
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.29
DB Error: syntax error
March 20, 2015, 09:59:01 am
Hi,

I am a absolute new user.  Having just signed up with A2Hosting.com, I installed Wordpress and CiviCRM and have imported around 3000 records.  It seems to work OK but every time I try to modify the date field in a contact record, I just get:

Sorry but we are not able to provide this at the moment.
DB Error: syntax error
Return to home page.

details of my setup at a2hosting.com -

CiviCRM version: 4.4.13-wordpress
CMS version: Wordpress 4.1.1
MySQL version: 5.5.34-cll-lve
PHP version: 5.3.29

I am completely baffled however, I bet you will laugh at this and know the answer instantly.

I would appreciate any advice.

Yours,  Stephen.

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: DB Error: syntax error
March 20, 2015, 11:47:58 am
Stephen - Can you get the Apache and CiviCRM error logs? Apache probably through your control panel, CiviCRM is in wordpress/wp-content/plugins/files/civicrm/ConfigAndLog.
cividesk -- CiviCRM delivered ... your way!

cllrstephen

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Wordpress 4.1.1
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.29
Re: DB Error: syntax error
March 21, 2015, 01:42:07 pm
Thank you for your response.

Well this is a mystery  ???   Today I have logged in and the error is not happening.

One thing I have noticed is this error in a dialog box

"Timestamps reported by MySQL (eg "2015-03-21 15:27") and PHP (eg "2015-03-21 19:27" ) are mismatched."  I can guess that this is not relevant but I thought I'd mention it.

I have attached the CIVICRM log and I would be grateful if you or anyone could advise me if anything in it looks suspicious.  I did see some errors but I have no idea what they mean.  I could not find an Apache error log in my control panel; sorry.

Thanks again.

Stephen.


cllrstephen

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Wordpress 4.1.1
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.29
Re: DB Error: syntax error
March 21, 2015, 04:42:53 pm
Just as an update; I am now having the same issue when adding a new contact.

cllrstephen

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Wordpress 4.1.1
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.29
Re: DB Error: syntax error
March 21, 2015, 06:14:55 pm
Mar 22 01:10:50  [info] $Fatal Error Details = Array
(
    [message] => Supervised rule for Individual does not exist
   
Code: [Select]
=>
)


Mar 22 01:10:50  [info] $backTrace = #0 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(322): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Dedupe/Finder.php(116): CRM_Core_Error::fatal("Supervised rule for Individual does not exist")
#2 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Contact.php(1139): CRM_Dedupe_Finder::dupesByParams((Array:3), "Individual", "Supervised", (Array:1))
#3 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Edit/Individual.php(152): CRM_Contact_Form_Contact::checkDuplicateContacts((Array:51), (Array:0), NULL, "Individual")
#4 [internal function](): CRM_Contact_Form_Edit_Individual::formRule((Array:51), (Array:1), NULL)
#5 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm.php(1598): call_user_func((Array:2), (Array:51), (Array:1), NULL)
#6 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(314): HTML_QuickForm->validate()
#7 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(135): CRM_Core_Form->validate()
#8 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(128): CRM_Core_QuickForm_Action_Upload->realPerform(Object(CRM_Contact_Form_Contact), "upload")
#9 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload->perform(Object(CRM_Contact_Form_Contact), "upload")
#10 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Contact), "upload")
#11 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(339): HTML_QuickForm_Page->handle("upload")
#12 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#13 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(301): CRM_Utils_Wrapper->run("CRM_Contact_Form_Contact", "New Contact", (Array:1))
#14 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(76): CRM_Core_Invoke::runItem((Array:13))
#15 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#16 /home/tadleyce/public_html/wp-content/plugins/civicrm/civicrm.php(515): CRM_Core_Invoke::invoke((Array:3))
#17 [internal function](): CiviCRM_For_WordPress->invoke("")
#18 /home/tadleyce/public_html/wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1))
#19 /home/tadleyce/public_html/wp-admin/admin.php(212): do_action("toplevel_page_CiviCRM")
#20 {main}

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Long term release support (Moderators: mathieu, Eileen, youngjin) »
  • DB Error: syntax error

This forum was archived on 2017-11-26.