a few troubles on install/migration

[craftee123]

I just did a fresh 4.4.4 install on Wordpress and then migrated our database in. Almost everything works well, but there are as few kinks that I'm stuck on. I'd love any help.

First, I cannot access either  the Base Directory Path and URL settings (/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1) or the Configuration Checklist (/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/configtask&reset=1). Both give me the same error:

"Forbidden You don't have permission to access /wp-admin/admin.php on this server."

I am logged in as a WordPress Administrator and seem to have access to every other Settings page.

Second, I cannot create a new contact without an email address. I can add a contact if he/she has an email address, but when there isn't one present, I get the following error:

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 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1, 1064
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    [ code] => -2
   

[message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [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 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
    [type] => DB_Error
    [user_info] => INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [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 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO dedupe (id1, id2, weight) SELECT 0 id1, 0 id2, 0 weight LIMIT 0 GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight) [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 'GROUP BY id1, id2 ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)' at line 1]"]
)

I'm having trouble deciphering the error. Hopefully it's something simple. Can anyone help?

[Hershel]

You could try installing CiviCRM into a spare database and then copy the _domain and _settings tables from the fresh install into your existing one.

Or consider running:

Code: [Select]

UPDATE `civicrm_domain` SET `config_backend`=NULL ;
but that will lose any localization settings you may have.