Base table or view not found: 1146 Table 'fgoffices.system' doesn't exist

[firstglance]

Upgrade was going great till the step where it was supposed to rebuild the menus.  Then I got the following error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fgoffices.system' doesn't exist: SELECT name, status FROM system WHERE type = 'module' AND schema_version <> -1; Array ( ) in CRM_Utils_System_Drupal->getModules() (line 868 of /home/fgoffices/fgoffices.org/drupal-7.14/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php).

The table name should have the drupal_ prefix.  How do I correct this?

[firstglance]

Fixed it by changing line 868 in file mentioned above to include the prefix.

    $q = db_query('SELECT name, status FROM system WHERE type = \'module\' AND schema_version <> -1');

to:

    $q = db_query('SELECT name, status FROM drupal_system WHERE type = \'module\' AND schema_version <> -1');

I assume this is a bug in the install that should be fixed where it identifies the prefix to use.

[cognoscento]

I've had exactly the same problem.

Code: [Select]

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'interpca_drupalc2.system' doesn't exist: SELECT name, status FROM system WHERE type = 'module' AND schema_version <> -1; Array ( ) in CRM_Utils_System_Drupal->getModules() (line 868 of /home/interpca/public_html/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php).
I'd prefer not to edit files, but if that's the only solution I guess I'll do it. Maybe someone involved with the dev team might chime in on this?

[TheoRichel]

I am having a similar/identical problem after upgrading to Civicrm 4.2 on D6. This is my message

user warning: Table 'theorichel_grk.system' doesn't exist query: SELECT name, status FROM system WHERE type = 'module' AND schema_version <> -1 in /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Utils/System/Drupal6.php on line 798.

I wouldnt know how to alter that line.

Thx

TR

[planetwebb]

As a reference, I was seeing a similar error message on a fresh Drupal install (separate databases).  After playing around, I reinstalled Drupal without a prefix and so far, no error messages...

Keith

[TheoRichel]

OOops. It was right before my eyes. Sorry. I have a vision problem (http://www.richel.org/nefritis_eng ).

[TheoRichel]

But I fail nevertheless. When I replace 'system' in that query with and underscore 'drupal_system' the error message stays there, but when I replace it with a dot it can apparently find it, but then I get a denial message:

user warning: SELECT command denied to user 'theorichel_tri'@'localhost' for table 'system' query: SELECT name, status FROM drupal.system WHERE type = 'module' AND schema_version <> -1 in /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Utils/System/Drupal6.php on line 798.

What to do now?

[Kurund Jalmi]

This was a bug and fix will be available in next release. You can get the patch from https://fisheye2.atlassian.com/changelog/CiviCRM?cs=42140

Hth
Kurund

[TheoRichel]

That did it, many thanks!