No one has screwed up. The end of FFVII was just a look at the long term future after the meteor events. Other stuff still took place before that happened. FF:AC is showing some of these events. It does not change the fact that hundreds of years later that scene will take place (the one with Red XIII and Midgar covered in plants).