CiviCRM Community Forums (archive)

Hi,
I've been trying to get this working for a week now and have tried 6 different installs with varying degrees of success, but none of them is working completely.

So, I've just installed civicrm-3.2.beta5-joomla with Joomla 1.5.18 and I have this error whe I click on the civicrm link on the components menu:

Error Details:

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]"]
)

which, reading from other threads, led me to look in the civicrm_contact table to see if a contact had been created. Sure enough that table is empty.

I've tried logging out of Joomla and in again but that hasn't helped.

So I tried manually creating a user, but that didn't work either and it may be becasue I don't know what to put in some fields (such as the Hash field).

I got a 'success' message at the time of install and all the database tables seem to be in place.

Any suggestions as to where to go next would be welcome.

cheers,
Helen

 



[/code]

Hi Kurund,
Thanks, but as I previously mentioned, I did try that and it didn't work.

I've now created an entry in civicrm_uf_match that links the user id to the contact I created in the civicrm_contact table and now I can access the civicrm administrator, however, I cannot (for example) change the localisation settings. I get the the following error when I try and save the changes:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT dedupe.id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Individual' AND civicrm_contact.is_deleted = 0
                GROUP BY dedupe.id HAVING SUM(weight) >= 20
                ORDER BY SUM(weight) desc [nativecode=1111 ** Invalid use of group function]
    [type] => DB_Error
    [user_info] => SELECT dedupe.id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Individual' AND civicrm_contact.is_deleted = 0
                GROUP BY dedupe.id HAVING SUM(weight) >= 20
                ORDER BY SUM(weight) desc [nativecode=1111 ** Invalid use of group function]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT dedupe.id
                FROM dedupe JOIN civicrm_contact USING (id)
                WHERE contact_type = 'Individual' AND civicrm_contact.is_deleted = 0
                GROUP BY dedupe.id HAVING SUM(weight) >= 20
                ORDER BY SUM(weight) desc [nativecode=1111 ** Invalid use of group function]"]

So a small amount of progress, but I think there must be still something missing from the contact.

cheers,
Helen[/code]

Yep, tried that too, several times - I think I'm on at least my 7th install.

It installs and works perfectly on my localhost but the moment I install on (not move to) the live server, I get these issues.
I'm using a very reputable host and it's a dedicated, managed server, as against my localhost which is a bog standard WAMP setup.

As far as I can see, the server configuration meets what is required for CiviCRM and Innodb is turned on.

Any suggestions on where to look next?

cheers,
Helen

Well, thanks for trying.
I'm going to perservere with this, so if anyone has any suggestions...

cheers,
Helen