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 »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Base table or view not found
Pages: [1]

Author Topic: Base table or view not found  (Read 2720 times)

msn

  • I post frequently
  • ***
  • Posts: 152
  • Karma: 6
  • Please talk to the other site
Base table or view not found
December 01, 2011, 01:03:08 pm
CiviCRM 4.0.7
Drupal 7.8
Views3


I made a specific field with a yes/no radio button. Placed it also in a useraccount pofile for selection.

I made a view with some CiviCRM fields, this view works fine.

When I add this specific field to the view I get an error:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mytable.civicrm_value_privacy_5' doesn't exist

The field exist in the mysql database.

Is this a bug, maybe there is a solution?



Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Base table or view not found
December 01, 2011, 03:13:51 pm
See here http://wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration for integration notes.
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.

msn

  • I post frequently
  • ***
  • Posts: 152
  • Karma: 6
  • Please talk to the other site
Re: Base table or view not found
December 01, 2011, 05:46:37 pm
OK, thanks!

ouyang1512

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 7.12
  • MySQL version: MySQL 5.1.52
  • PHP version: 5.3.6
Re: Base table or view not found
December 02, 2011, 07:16:22 am
I am actually having the similar problem. In my case, it seems that the views is not selecting the table from civicrm database, but from the drupal database. I did follow the views 3 integration instructions to update the settings.php. Not sure if it is because the drupal db user does not have the select privilege in civicrm db. I do not have the control over the db administration, so have to wait until the admin responses.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Base table or view not found

This forum was archived on 2017-11-26.