By cubano on

Hi. I upgraded my Drupal site because of badly needed utf-8 search; both test and production sites show the same error in the logs:

/update.php?op=update
user error: Table 'DB73503.variable' doesn't exist query: SELECT * FROM variable WHERE name = 'update_start' AND value LIKE '%;"' en /home/htdocs/www.elcolectivo.com/includes/database.mysql.inc en la línea 125.

My drupal tables have a prefix, which I had previously declared and changed as stated in the installation files.

Other than that, everything tested works and all additional modules (instant messenger, image, front_page, smileys) function as expected. Good work drupals!.

Somebody else had the same problem? Anyone upgrading tables with prefixes?

Comments

cubano’s picture

cubano commented

The error is in update.php, line 90.

The line 90 should be modified to:
$result = db_query("SELECT * FROM {variable} WHERE name = 'update_start' AND value LIKE '%;\"'"); or
$result = db_query("SELECT * FROM your_db_prefix_variable} WHERE name = 'update_start' AND value LIKE '%;\"'");

All mysql scripts on update.php should actually be modified as well.