X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Fpost_update.php;h=f9649961d9ca0d087d6b9a8eeea1dde591ac7305;hb=d3cdfa610852f5dbda9bc3e29df6524eb504d068;hp=b2d682d722545386b3e180fa300257bca17ee12d;hpb=3f0656fdbd9f6201f75e05445a864065783c24af;p=friendica.git diff --git a/include/post_update.php b/include/post_update.php index b2d682d722..f9649961d9 100644 --- a/include/post_update.php +++ b/include/post_update.php @@ -239,7 +239,7 @@ function post_update_1206() { logger("Start", LOGGER_DEBUG); $r = q("SELECT `contact`.`id`, `contact`.`last-item`, - (SELECT MAX(`changed`) FROM `item` FORCE INDEX (`uid_wall_changed`) WHERE `wall` AND `uid` = `user`.`uid`) AS `lastitem_date` + (SELECT MAX(`changed`) FROM `item` USE INDEX (`uid_wall_changed`) WHERE `wall` AND `uid` = `user`.`uid`) AS `lastitem_date` FROM `user` INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`");