Upgraded from D6.20 to D7.0, install looked OK but the first thing I do is create a new image style and I get this error

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tuneup_drupal7.image_effects' doesn't exist: SELECT image_effects.* FROM {image_effects} image_effects ORDER BY image_effects.weight ASC; Array ( ) in image_effects() (line 976 of /home/tuneup/public_html/drupal/modules/image/image.module).

Now I get that same error every time I go to config/media/image-styles.

I got a similar error earlier using the Media module so I deleted the database, restored from backup and reinstalled. Now I get this one with no other contrib modules enabled. I'm running php 5.2.15 and MySQL 5.0.91

Comments

berdir’s picture

berdir
Primary language German
Location Switzerland
commented

What modules did you have installed on your old site? image?

Edit: This happened when image.module was already installed once, but I thought we fixed it.

the fatman’s picture

the fatman commented

Yes I did have image installed on my old site.

I should be able to go back to the 6.20 site, should I do that and uninstall image?

the fatman’s picture

the fatman commented

I can confirm that it's because Image was active on my old site.

I restored from my backup, uninstalled image and did the upgrade again and it all works fine now. I still have the problem site active in another directory if you need me to do any testing with it.

Thanks

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Closed (duplicate)

Ok, it turns out that we messed up that update function, it has been fixed in another issue: #933498: Image effects table created with incorrect table name in upgrade path.