CiviCRM Community Forums (archive)

Hi All,

As we were working towards adding Ubercart and it's dependencies somewhere along the way our ability to login became an issue.

We are using CiviCRM 3.0.3, Drupal 6.14, PHP 5.2.9, MySQL 5.0.67, and Apache 2.2

When anyone (including the drupal user1 account) tries to log in they get :


I have been able to get the system to allow for new Drupal users to create an account, but any account that had rights to anything CiviCRM related gets the "You are not authorized to access this page." error.

Please, we are in our peak conference sign-up season and I need to get this fixed.

Thank you all for your help.

Patrick

Unfortunately we would not be able to afford to hire someone.  I have never used IRC, so will need to learn how to connect and post comments ( was on my to-do list anyway...)

But in the meantime here is a blurb from my system log file:

Feb 26 17:31:45 www drupal: http://www.nchea.org|1267227105|php|66.249.71.66|http://www.nchea.org/events/2009-04-27/2010-02-27||0||Table 'drupaldb.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id,    civicrm_event.start_date AS civicrm_event_start_date,    civicrm_event.title AS civicrm_event_title  FROM civicrm_event civicrm_event   WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0))     AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-21600)), '%Y-%m-%d') <= '2009-04-27' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-21600)), '%Y-%m-%d') >= '2009-04-27'))    ORDER BY civicrm_event_start_date ASC  in /srv/www/htdocs/sites/all/modules/views/includes/view.inc on line 769.
Feb 26 17:33:17 www drupal: https://www.nchea.net|1267227197|access denied|98.175.60.226|https://www.nchea.net/civicrm//user/login|https://www.nchea.net/user/login|0||civicrm/user/login


I am using a separate database for drupal and civicrm.  To my very untrained eye the section: "Table 'drupaldb.civicrm_event' doesn't exist query" looks like drupal is trying to find a table named 'civicrm_event' that is in cividb database.  Am I reading that right?

Is there a way to change the drupal database so it uses a different user as User1? My thinking is that if I can get logged in as the Drupal Admin (who isn't part of one of the CiviCRM roles that is setup), I could better figure out how to fix the larger problem.

Thanks again for all of your help!
Patrick