Below follows the PHP error message:

Message
Table 'dr_drupal.dr_dr_term_data' doesn't exist query: SELECT * FROM dr_dr_term_data WHERE tid = "13" in /Volumes/Files/Users/chuee/Sites/drupal/includes/database.mysql.inc on line 66.

Severity
error

My tables are prefixed with 'dr_'
The value $db_prefix = 'dr_'; has been inserted into settings.php

An example of the actual tables from the database.mysql can be seen to be:

-- Table structure for table 'term_hierarchy'
create table dr_term_hierarchy (
  tid int(10) unsigned NOT NULL default '0',
  parent int(10) unsigned NOT NULL default '0',
  KEY tid (tid),
  KEY parent (parent)
) TYPE=MyISAM;

When checking all tables in through the dba.module, similar errors are given for non-core modules such as store.module. So the arror applies accross the board.

The behaviour when creating content is like this: A post is accepted for publication according to inspection of the content list, and as according the log, eg.:

page: added test conspiracy content.
Severity
notice
Hostname
127.0.0.1),

.

However when clicking on a category term to view publications in the category browser, a blank pageis returned. When a category has no posts a normal page with message is displayed: 'There are currently no posts in this category.'

John Plum

CommentFileSizeAuthor
#1 dr_mightyz-mightyzero.sql195.39 KBchueewowee
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

chueewowee’s picture

Title: table and db prefix problems in 4.6RC » without prefix in 4.6RC
FileSize
195.39 KB

I tried the same database, but stripped the prefix and all works ok. The bug occured with the latest 4.6RC version.

I am attaching a database with the prefix dr_ attached to all tables for your convenience.

chueewowee’s picture

chueewowee’s picture

Title: without prefix in 4.6RC » Table Prefix problem: test without prefix in 4.6RC passes

I'm updating the title here, as I switch post from version 4.52 to cvs (my error). I cannot seem to ba able to edit the post

chueewowee’s picture

Title: Table Prefix problem: test without prefix in 4.6RC passes » einstalled database without prefix.

and the problem vanished from a working site

killes@www.drop.org’s picture

We do not prefix the database defefinitions by default. this will be taken care of by the to be installer.