X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fpost_update.php;h=f9649961d9ca0d087d6b9a8eeea1dde591ac7305;hb=e301fa083291f2df98192532c9c5cba03abfeb5a;hp=b2d682d722545386b3e180fa300257bca17ee12d;hpb=3463a442badb575f024a090f371d4f75c89d9b78;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`");