While running update.php after updating site from 5.x to 6.3 and modules from 5.x to 6.x modules the following happens:

First:
Unknown column 'f.nid' in 'field list' query: INSERT INTO drupal_image SELECT DISTINCT f.nid, f.fid, f.filename FROM drupal_files f INNER JOIN drupal_node n ON f.nid = n.nid WHERE n.type='image' AND f.filename IN ('_original', 'thumbnail', 'preview') in /homepages/xxx/xxx/xxx/drupal/sites/all/modules/image/image.install in Zeile 252.

Then:
Table 'xxx.drupal_file_revisions' doesn't exist query: DELETE FROM drupal_file_revisions WHERE EXISTS (SELECT * FROM drupal_image WHERE drupal_image.fid = drupal_file_revisions.fid) in /homepages/xxx/xxx/xxx/drupal/sites/all/modules/image/image.install in Zeile 255.

After the update the drupal_image table is empty and all images are "lost".

How to fix this? Thx.

Comments

Prof. Dr. YoMan’s picture

Category: support » bug

Changed category to bug report.

Cant get it fixed. And from what i have found some others where run into the same problems.

Prof. Dr. YoMan’s picture

Status: Active » Closed (duplicate)

After some actual checking i found out that there is an bugreport with discussion already.

http://drupal.org/node/219808