Upgraded to 5.31 and now images are missing ...
 

I upgraded from 4.8 to 5.31 and now when I access my photopost dir all my images are shown as blank. The db record is still there with associated comments, view etc but the images themselves dont show.

When I FTP in the images are there.

When i look at the source code it looks like the images are indeed in the correct path.

When i run the scan database tool though in admin it basically says all the images are missing and deletes their record from the database.

Any ideas how I can fix or regenerate all the images ?

You would restore the photos table and run the 485 upgrade ONLY ONCE. Basically it has been ran more than once which caused your issue