CiviCRM Community Forums (archive)

Hi, I'm posting here since the issue appears related to the Webform/Civicrm table, but I'm not sure how.  If the issue is better located elsewhere, I'll be happy to move it.

I'm trying to access Administer > Localization > Address Settings with my super user account (Drupal user 1).  When I click on the menu link (/civicrm/admin/setting/preferences/address?reset=1), I get the below screen (I've switched out my db username and Drupal database name):

DB Error: insufficient permissions
Error Details
Database Error Code: SELECT command denied to user 'civicrm_db_default_user'@'localhost' for table 'webform_civicrm_forms', 1142
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -26
    [message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] => SELECT cforms.nid, node.title FROM drupal_db.webform_civicrm_forms cforms
JOIN drupal_db.node ON cforms.nid = node.nid AND node.status = 1  [nativecode=1142 ** SELECT command denied to user 'civicrm_db_default_user'@'localhost' for table 'webform_civicrm_forms']
    [type] => DB_Error
    [user_info] => SELECT cforms.nid, node.title FROM drupal_db.webform_civicrm_forms cforms
JOIN drupal_db.node ON cforms.nid = node.nid AND node.status = 1  [nativecode=1142 ** SELECT command denied to user 'civicrm_db_default_user'@'localhost' for table 'webform_civicrm_forms']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT cforms.nid, node.title FROM drupal_db.webform_civicrm_forms cforms
JOIN drupal_db.node ON cforms.nid = node.nid AND node.status = 1  [nativecode=1142 ** SELECT command denied to user 'civicrm_db_default_user'@'localhost' for table 'webform_civicrm_forms']"]
)
I'm not sure how the Webform CiviCRM table on my Drupal database is related to the CiviCRM Address Settings.  And I'm not sure how to resolve.  I tried yesterday giving my Civicrm db user the sufficient permissions in the Drupal database, but the permissions got all messed up and I had to delete my user and start over (I'm admittedly a newbie in the SQL realm).  That was not fun.  I've been able to access the Address Settings screen before (it's probably been months since the last time, so a lot has transpired since then).  We're on Drupal 7, CiviCRM 4.4.6, Webform 7.x-4.0-rc4, Webform CiviCRM Integration 7.x-4.8.

Any ideas anybody on how to get back my Address Settings screen?  Thanks!

I tried yesterday giving my Civicrm db user the sufficient permissions in the Drupal database, but the permissions got all messed up and I had to delete my user and start over (I'm admittedly a newbie in the SQL realm).  That was not fun.

Sorry - you might have to try again - always easier the second time and good to learn in any case

That or work out why the CiviCRM user is trying to query a drupal table.

Michael

Gentlemen, thanks so much for your thoughtful responses.  Pete, you nailed a short-term fix.  I turned off the webform_civicrm module for a few minutes and was able to access the address settings screen to make the change I needed.  The moment I turned the module back on, the error came up again.

Michael, thank you for your encouragement. It appears that unless upgrading to Webform 4.0 (from 4.0-rc4) fixes my issue, I'll have to get back on the horse and tackle the slippery world of MySQL permissions.  Here's to learning!

I suspect you're right, Pete. This one threw me for a loop, and it just doesn't seem to be a code-based/caused issue.

Ah ha! I thought I recognized that code. Here it is:
https://github.com/sgladstone/com.pogstone.fancytokens/blob/master/fancytokens.php#L106

I will update the README for my "fancy tokens" extension so that the database user permission requirement is mentioned.

Thank you, Sarah!