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 »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • a few troubles on install/migration
Pages: [1]

Author Topic: a few troubles on install/migration  (Read 579 times)

craftee123

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
a few troubles on install/migration
April 08, 2014, 07:47:49 am
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:

Quote
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?
« Last Edit: April 08, 2014, 08:35:09 am by craftee123 »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: a few troubles on install/migration
April 08, 2014, 09:11:59 am
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.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • a few troubles on install/migration

This forum was archived on 2017-11-26.