Select command denied to user + error= sites/all/modules/views/includes/view.inc

[lance1413]

2 databases, Drupal and CIVICRM, Drupal needs Select permision.

 

Drupal =    database name = dop10xxxxxxx56    description = dopexxxxxxpal           

CIVCRM =  database name = civicrmxxxxxal        description= civicxxxxxdal

 

 

Godaddy Shared Grid hosting

Lynix

Drupal 6x

MYSQL 5x

CIVICRM Module

Views Module

 

 

Error:

 

user warning: SELECT command denied to user 'dop1027705351256'@'173.201.196.144' for table 'civicrm_eventcivicrm_event' query: SELECT civicrm_event.id AS id FROM civicrmdoperdal.civicrm_eventcivicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0) AND (civicrm_event.is_template = 0)) AND ((DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') <= '2010-12' AND DATE_FORMAT(CONVERT_TZ(civicrm_event.start_date, 'UTC', 'America/New_York'), '%Y-%m') >= '2010-12')) in /home/content/88/6754888/html/doxxxxal/sites/all/modules/views/includes/view.inc on line 775

 

 

My settings.php currently has the following per instructions:

 

$db_url['default'] = 'mysqli://dop1026:[email protected]/dop101256';

$db_url['civicrm'] ='mysql://civicrmdl:[email protected]/civicral';

 

$db_prefix = array(

  'default'                                  => '',

  'civicrm_acl'                              => 'civicrmdol.',

  'civicrm_acl_cache'                        => 'civicrmdopl.',

  'civicrm_acl_contact_cache'                => 'civicrmdopl.',

  'civicrm_acl_entity_role'                  => 'civicrmdopl.',

  'civicrm_activity'                        => 'civicrmdopl.',

  'civicrm_activity_assignment'              => 'civicrmdol.',

  'civicrm_activity_target'                  => 'civicrmdopl.',

 

 

I am stuck and not sure what I need to do to fix problem

 

[Pikachu2000]

The user needs to have the proper privileges granted. You should probably call GoDaddy's tech support.

[lance1413]

Tried that. The support rep couldn't help me or didn't want to.

 

The changes I made to my php file which i posted to this board were designed to allow select permission. Ant ideas why it's not working and what I need to do?

[Pikachu2000]

Are you using the user that is created as a default when the database is created, or is this an additional user you created after creating the database?

[lance1413]

The Drupal database was setup as part of the Drupal setup process with godaddy. The civi database I setup maually. Both databases were asked for at the time of the civi installation. The Civi install is designed to create the civi database, but because I am using godaddy I had to setup manually. Once I set up the civi database in godaddy, I had to enter the user name and password into the civi setup screen to complete the installation of civicrm.

[Pikachu2000]

That's odd. I have a couple sites with GoDaddy, and whenever I've set up databases, the default user always has all the privileges already granted. There used to be an option to create a user with 'read-only' privileges, but I just looked and can't even find that anymore.

[lance1413]

And that's my problem.  I did the scripting to the php to try and solve the problem but it's not working. Any ideas?

 

The php should work.