(PHP 5.2.4, MySQL 5.0.45, Drupal 5.7.1)

I have prefixes on my tables and I suspect this may be creating problems for the module. This is what I get when I perform a search/replace:

    * user warning: Table 'DBNAME.node_revisions' doesn't exist query: select * from node_revisions where body like 'SEARCHTERM'; in /usr/share/drupal-5.7/includes/database.mysql.inc on line 172.
    * user warning: Table 'DBNAME.cache' doesn't exist query: DELETE FROM `cache` in /usr/share/drupal-5.7/includes/database.mysql.inc on line 172.
. . .
0 node body revisions replaced

Comments

regx’s picture

regx commented

I think the problem is that I didn't put the tablenames in brackets {tablename}
If you can try that and let me know if it fixes the problem, I will fix it and post an update.
If you can't try this for whatever reason, please let me know and I will try to replicate and fix the problem.

regx’s picture

regx commented

Yep, I just consulted the api docs, and that is definitely the problem. I will post an update later today.

I have had the brackets cause problems in older Drupal installations, mostly during setup and since I don't use db prefixes commonly I just got in the habit of ommiting them.

Thank you very much for bringing this bug to my attention.

regx’s picture

regx commented

OK, I just commited the changes. A new release DRUPAL-5--1-1 should be available shortly. Or you can grab from CVS now.

regx’s picture

regx commented
Status: Active » Fixed

Just marking this as fixed.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.