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 »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2
Pages: [1]

Author Topic: PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2  (Read 971 times)

atly

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7.32
  • MySQL version: 5.5.40
  • PHP version: 4.2.9
PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2
November 07, 2014, 02:44:09 am
After a recent update to CiviCRM 4.5.2 we are getting the following error whenever we try to log in:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_xxxx.civicrm_group' doesn't exist: SELECT cgr.group_id AS group_id FROM {civicrm_group_roles_rules} cgr INNER JOIN {civicrm_group} cg ON cg.id = cgr.group_id WHERE (cgr.role_id = :db_condition_placeholder_0) AND (cg.saved_search_id IS NULL ) ; Array ( [:db_condition_placeholder_0] => 4 ) in civicrm_group_roles_add_remove_groups() (line 664 of /home/xxxx/public_html/sites/all/modules/civicrm/drupal/modules/civicrm_group_roles/civicrm_group_roles.module).

I am also unable to change user permissions and my new users seem to be getting the same problem when trying to reset their passwords.

Our CiviCRM and Drupal share the same database. The common answer I seem to get from googling the problem is that it's a database referencing issue. Unfortunately, I'm not exactly sure if my current problem is actually a database referencing issue and I hope someone can help me?

Thanks.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2
November 10, 2014, 01:41:14 am
Can you check if the table xxxx_xxxx.civicrm_group actually exists in your DB.  If not, something went wrong during the upgrade and you should probably attempt  the upgrade again using a backup database from before the upgrade.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2
November 18, 2014, 09:15:00 am
See also http://forum.civicrm.org/index.php/topic,34830.0.html .

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • PDOException SQLSTATE[42S02]:Base table or view not found after upgrade to 4.5.2

This forum was archived on 2017-11-26.