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
Comment #1
Prof. Dr. YoMan commentedChanged category to bug report.
Cant get it fixed. And from what i have found some others where run into the same problems.
Comment #2
Prof. Dr. YoMan commentedAfter some actual checking i found out that there is an bugreport with discussion already.
http://drupal.org/node/219808