# HG changeset patch # User Dan # Date 1261188279 18000 # Node ID 91911e183685e7fcc21f33fa21a97b9d82d456cb # Parent 4829d15d27827f919dabb2c97c57c15212922ede Forgot table_prefix in the logs table migrator diff -r 4829d15d2782 -r 91911e183685 install/schemas/upgrade/1.1.6-1.1.7.php --- a/install/schemas/upgrade/1.1.6-1.1.7.php Fri Dec 18 21:01:09 2009 -0500 +++ b/install/schemas/upgrade/1.1.6-1.1.7.php Fri Dec 18 21:04:39 2009 -0500 @@ -4,7 +4,7 @@ global $db, $session, $paths, $template, $plugins; // Common objects -$q = $db->sql_query('SELECT user_id, username FROM users;'); +$q = $db->sql_query('SELECT user_id, username FROM ' . table_prefix . 'users;'); if ( !$q ) $db->_die(); @@ -15,7 +15,7 @@ } $db->free_result(); -$q = $db->sql_query('SELECT author FROM logs WHERE author_uid = 1;'); +$q = $db->sql_query('SELECT author FROM ' . table_prefix . 'logs WHERE author_uid = 1;'); if ( !$q ) $db->_die(); @@ -26,7 +26,7 @@ if ( isset($map[ $row['author'] ]) && !is_valid_ip($row['author']) && !in_array($row['author'], $updated) ) { $author = $db->escape($row['author']); - $sql = "UPDATE logs SET author_uid = {$map[ $row['author'] ]} WHERE author = '$author';"; + $sql = "UPDATE " . table_prefix . "logs SET author_uid = {$map[ $row['author'] ]} WHERE author = '$author';"; if ( !$db->sql_query($sql) ) $db->_die(); $updated[] = $row['author'];