diff options
| author | Oleg Pudeyev <oleg@bsdpower.com> | 2012-04-05 17:35:27 -0400 |
|---|---|---|
| committer | Oleg Pudeyev <oleg@bsdpower.com> | 2012-04-05 17:35:27 -0400 |
| commit | 2b2286a46c56b8a9e5444fd06eff263f880e0c78 (patch) | |
| tree | e693c1eca3107ace209922f5bbd2ac215c037bac | |
| parent | de1e343c5b408da09448b3150cfec2de75afd04a (diff) | |
| download | forums-2b2286a46c56b8a9e5444fd06eff263f880e0c78.tar forums-2b2286a46c56b8a9e5444fd06eff263f880e0c78.tar.gz forums-2b2286a46c56b8a9e5444fd06eff263f880e0c78.tar.bz2 forums-2b2286a46c56b8a9e5444fd06eff263f880e0c78.tar.xz forums-2b2286a46c56b8a9e5444fd06eff263f880e0c78.zip | |
[ticket/10605] Fix left join usage.
Previously this produced broken SQL:
SELECT p.msg_id FROM phpbb_privmsgs p
LEFT JOIN 0 phpbb_privmsgs_to ON (p.msg_id = t.msg_id)
WHERE t.user_id IS NULL LIMIT 500 OFFSET 0
PHPBB3-10605
| -rw-r--r-- | phpBB/install/database_update.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 116e6ea9a6..0737061887 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -2039,7 +2039,7 @@ function change_database_data(&$no_updates, $version) ), 'LEFT_JOIN' => array( array( - 'FROM' => array(PRIVMSGS_TO_TABLE, 't'), + 'FROM' => array(PRIVMSGS_TO_TABLE => 't'), 'ON' => 'p.msg_id = t.msg_id', ), ), |