[drupal-devel] [bug] table and db prefix problems in 4.6RC

[chueewowee]

Issue status update for http://drupal.org/node/19595

 Project:      Drupal
 Version:      4.5.2
 Component:    base system
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  chueewowee
 Updated by:   chueewowee
 Status:       active

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


chueewowee