CiviCRM Community Forums (archive)

Hi all,

I'm running Joomla 1.5
PHP 5.2.12
MySQL: 4.1.20

I installed: civicrm-3.1.beta5-joomla-alt.zip per the Instructions. After install I tried going to Components-->CiviCRM and I get the following Error:

    Sorry. A non-recoverable error has occurred.

    DB Error: syntax error

    Database Error Code: 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 '(MINUTE, cache_date, NOW()) > 0 )' at line 7, 1064

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]
    [type] => DB_Error
    [user_info] =>
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
DELETE     g
FROM       civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
WHERE      g.group_id IN (
    SELECT id
    FROM   civicrm_group
    WHERE  TIMESTAMPDIFF(MINUTE, cache_date, NOW()) > 0   
)
 [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 '(MINUTE, cache_date, NOW()) > 0   
)' at line 7]"]
)


Can anyone help me?
Thanks...really can't wait to get this baby up and running!

I am getting the same error and our server is configured with the correct MySql & PHP.  I was trying to update an event.

    Sorry. A non-recoverable error has occurred.

    DB Error: no database selected

    Database Error Code: MySQL server has gone away, 2006

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -14
    [message] => DB Error: no database selected
    [mode] => 16
    [debug_info] =>
(
  SELECT *
  FROM     civicrm_menu
  WHERE    path in ( 'civicrm/event/manage', 'civicrm/event', 'civicrm' )
            AND domain_id = 1
  ORDER BY length(path) DESC
  LIMIT    1
)

UNION (
  SELECT *
  FROM   civicrm_menu
  WHERE  path IN ( 'navigation' )
          AND domain_id = 1
)
 [nativecode=2006 ** MySQL server has gone away]
    [type] => DB_Error
    [user_info] =>
(
  SELECT *
  FROM     civicrm_menu
  WHERE    path in ( 'civicrm/event/manage', 'civicrm/event', 'civicrm' )
            AND domain_id = 1
  ORDER BY length(path) DESC
  LIMIT    1
)

UNION (
  SELECT *
  FROM   civicrm_menu
  WHERE  path IN ( 'navigation' )
          AND domain_id = 1
)
 [nativecode=2006 ** MySQL server has gone away]
    [to_string] => [db_error: message="DB Error: no database selected" code=-14 mode=callback callback=CRM_Core_Error::handle prefix="" info="
(
  SELECT *
  FROM     civicrm_menu
  WHERE    path in ( 'civicrm/event/manage', 'civicrm/event', 'civicrm' )
            AND domain_id = 1
  ORDER BY length(path) DESC
  LIMIT    1
)

UNION (
  SELECT *
  FROM   civicrm_menu
  WHERE  path IN ( 'navigation' )
          AND domain_id = 1
)
 [nativecode=2006 ** MySQL server has gone away]"]
)


That query / error indicates that your logged in Joomla user doesn't have a linked CiviCRM contact. Have you tried logging out and back in to Joomla admin site?

We've not seen that error before so I not sure what's going on. I assume this is a new installation, so you might try uninstalling and then installing the latest version (3.1.2) and see if that helps. I would also double-check the MySQL version your host is running.

Hi, I've bumped this because I'm having exactly the same error as Gemma.

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
DELETE FROM civicrm_acl_cache
WHERE  modified_date IS NULL OR (TIMESTAMPDIFF(MINUTE, modified_date, NOW()) >= 0)
 [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 '(MINUTE, modified_date, NOW()) >= 0)' at line 2]
    [type] => DB_Error
    [user_info] =>
DELETE FROM civicrm_acl_cache
WHERE  modified_date IS NULL OR (TIMESTAMPDIFF(MINUTE, modified_date, NOW()) >= 0)
 [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 '(MINUTE, modified_date, NOW()) >= 0)' at line 2]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
DELETE FROM civicrm_acl_cache
WHERE  modified_date IS NULL OR (TIMESTAMPDIFF(MINUTE, modified_date, NOW()) >= 0)
 [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 '(MINUTE, modified_date, NOW()) >= 0)' at line 2]"]
)

My setup on a dedicated managed server:

Joomla 1.5.18
PHP 5.2.13
MySQL 5.0.83 and I've definitely got Innodb enabled

mysql> show storage engines;
+------------+---------+------------------------------------------------------------+
| Engine     | Support | Comment                                                    |
+------------+---------+------------------------------------------------------------+
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     |
| HEAP       | YES     | Alias for MEMORY                                           |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  |
| MERGE      | YES     | Collection of identical MyISAM tables                      |
| MRG_MYISAM | YES     | Alias for MERGE                                            |
| ISAM       | YES     | Obsolete storage engine, now replaced by MyISAM            |
| MRG_ISAM   | YES     | Obsolete storage engine, now replaced by MERGE             |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys |
| INNOBASE   | YES     | Alias for INNODB                                           |
| BDB        | YES     | Supports transactions and page-level locking               |
| BERKELEYDB | YES     | Alias for BDB                                              |
| NDBCLUSTER | NO      | Clustered, fault-tolerant, memory-based tables             |
| NDB        | NO      | Alias for NDBCLUSTER                                       |
| EXAMPLE    | NO      | Example storage engine                                     |
| ARCHIVE    | NO      | Archive storage engine                                     |
| CSV        | NO      | CSV storage engine                                         |
| BLACKHOLE  | NO      | Storage engine designed to act as null storage             |
+------------+---------+------------------------------------------------------------+

I've checked all the suggestions made in the thread above, including the civicrm_contact table and I do exist there as the only user.
If this is an issue with linking the civicrm user to the joomla user, how/where would that link show?

Unlike Gemma, I don't have the option of changing to Drupal.

cheers,
H.[/code]