upgrading to drupal6 makes image-6.x-1-x-dev a dull boy

this is really a duplicate of http://drupal.org/node/217515 but this has a better description of the problem so i'm marking that as the dupe.

ok, I just went on trying to figure out what is happening, I tried to restart from a safe point the upgrade, and it gave me a different error. First this:

also I noticed this:

I'm going to try again... maybe :-\

Probably the same problem without any host change. This was rather a new install -- started as 5.6.

Errors during update:

There are warnings about directories not existing when trying to set default path or edit image; no image is visible. Gallery structure, captions, etc. are preserved. Database after the update has 'files' table (fid, uid, filename/path/mime/size, status, timestamp) with seemingly correct data (file paths, uids, ...) and empty 'image' and 'image_attach' tables. There is no 'file_revisions' table.

Current directory structure is: www/files/images, drupal's 'File system path' is set to 'files' (that's correct) and 'Default image path' is set to 'images' (that's correct too, but not changeable in the current state). Database paths in the 'files' table look like: 'files/images/name.png'.

After uninstalling and reenabling all works fine (you have to recreate all the galeries for that) , the only difference i can see is that 'image' table got populated with some data: fids from 'files' table, 'nids' i don't know from where and 'image_size' equal to '_original' in every row. Should be easy enough to make such a query manually.

Note: for removing the module i did: disable, uninstall and remove by hand all rows from files table concerning images (that's easy to filter too if you know a bit of sql).

Check these for troubles with MySQL < 4.1: http://drupal.org/node/208785

and this for troubles with a pre-existing image table: http://drupal.org/node/235227

Dunno where the file_revisions table should have been added; have you tried a new install of drupal 5 or 6 for that, instead of an upgrade? (If it's still a problem with the new install, you should open an issue in core.)

Anyhow, the table data for file_revisions, for MySQL, is:

Luck!

Thank you for your answer.

I think i may have found another source of this (MySQL 5.0.44, it was a clean install of 5.6, so i believe that's something new).

Seems the 'file_revisions' table is renamed to 'upload' in 6.x (see http://api.drupal.org/api/function/system_update_6022/6). You run the system update before the modules updates, so the table will be probably already renamed when the module updates.

There's also a comment in the source saying that only the upload is supposed to use this table, but i don't know if that matters. Anyway, I've just checked that I don't have 'file_revisions' neither in the upgraded one nor in an almost fresh 6.x install and yet all works fine (but I did have it in 5.6).

Hi all!

While upgrading my Drupal 5.7 to Drupal 6.2 I also got some errors.

1. First I got a function-not-found-error for function image_get_sizes():
   An error occurred. http://domain.tld/update.php?id=3&op=do <br /> Fatal error: Call to undefined function image_get_sizes() in /home/name/www/drupal-6.0/sites/all/modules/image/image.install on line 250
   To fix that I had to add include('image.module') on top of image.install file.
2. Second I got the error "Unknown column 'f.nid'" and "Table 'x.file_revisions' doesn't exist" like described above.
   To fix that I had to replace the line
   $ret[] = update_sql("INSERT INTO {image} SELECT DISTINCT f.nid, f.fid, f.filename FROM {files} f INNER JOIN {node} n ON f.nid = n.nid WHERE n.type='image' AND f.filename". $cond);
   with this line:
   $ret[] = update_sql("INSERT INTO {image} SELECT DISTINCT u.nid, f.fid, f.filename FROM {files} f INNER JOIN {upload} u ON f.fid = u.fid where f.filename". $cond);
   and line
   $ret[] = update_sql("DELETE FROM {file_revisions} WHERE EXISTS (SELECT * FROM {image} WHERE {image}.fid = {file_revisions}.fid)");
   with line
   $ret[] = update_sql("DELETE FROM {upload} WHERE EXISTS (SELECT * FROM {image} WHERE {image}.fid = {upload}.fid)");
3. After running update.php I had to remove the include('image.module') from file image.install

I don't know if this is the 100 % correct way of how to do it, but I see all images and everything is fine ... hmmm all? ... there was small village of indomitable Gauls ...

Anyway: Currently I can not select the image gallery to which an image belongs. While using Drupal 5.x there was an image gallery field in the taxonomy section (now called vocabularies) but after upgrading to Drupal 6.2 I see there only the taxonomies but no combobox for the galleries. I also found no information in the database where this relationship (which image belongs to which gallery) has been saved.
Suprisingly the gallery is working, but I can not change the relationship between image an gallery.
But maybe that topic is also denoted to the alpha state of this module.

Many thanks and good luck.

I've had similar problems and am following this closely.

Shai

I've upgraded from a 5.2 to 6.2, with same problems. I applied the suggestions of max9 at comment #9 and seems resolved them! Many thx! :-)

Hi fulvioz!

You are welcome.

In the meantime I solved the problem, that I could not select the image gallery an image belongs to. That happens only because the taxonomy/category forgets the association to the image-type. To solve that go to 'Administer > Contentmanagement > Categories' click on 'edit vocabulary' of the vocabulary(s) with the type 'image' and check there 'Image' under the section 'Types'. That's it! Now, you can associate an image with a gallery on the edit page of an image.

You may have the same problem.

I also had that problem after updating from Drupal 5.2 to 5.7 and at the same time I updated the image module to 5.x-1.8 (don't know the previous version). Of course, it also happend while updating Drupal 5.2 to 6.2 with the necessary update of the image-module.

Good luck

Hi all,
a newbie here.
I read the thread with interest. My situation is that I am not a techie really, and am waiting for an upgrade procedure that ensures smooth upgrade from Drupal 5.x to 6.x with Image module upgrade, whilst keep all previous galleries, images etc in tact.Does anyone know if there will be an upgrade path provided soon please?

I have raised this in a support request ( http://drupal.org/node/246512 )

thanks
Mark

Hi Mark,

There will certainly be an upgrade path for the Image module that will not require patching or other super-geeky activities. You just have to be patient.

I came to Drupal as a non-techy. One thing I've realized about this whole open-source adventure is that identifying oneself as a "geek-in-training" as opposed to a "non-geek" helps one to be a more a part of the community and ends up getting you more help from the techies. "Geek-in-training" doesn't have to communicate a professional goal. Identifying as such does, however, communicate an openness to learning new things that will certainly earn you "points" with the coders in this community.

Offering to help with documentation or testing can also communicate to the people who are actually upgrading the code that the people "waiting in line" for the code are willing to help out where they can.

At this point, patience is your biggest asset. D6 was released in February. I'm not planning to launch any D6 sites until Sept. or Oct. so that I give plenty of time for the module upgrades to happen. If you plan for that and your expectations are in line, then not having various modules ready won't feel so disconcerting. FYI, I thought I was ready to relaunch my blog in D6 when I saw that the image module had been upgraded, but decided against that when I saw that the image module upgrade isn't really done yet. I haven't even considered launching new sites that I build for people or upgrading existing sites that I've built in D6.

I hope this helps, and I hope you don't get too frustrated by all this. When you learn how to navigate this process, you can leverage an amazing tool and have fun with the community.

Sincerely,

Shai Gluskin
http://content2zero.com

Hi Shai,
I agree with you there. I need to be more patient. With such a great tool as Drupal it's like having a new toy to play with every day.
I shall just have to sit and wait patiently won't I.

I have 2 sites which I use for family members. One is using Drupal 5 and the other Drupal 6. I have about half a dozen other modules installed, including Image and SMF Forum. Maybe I missed it, but there was no preparation for the sudden pulling of the SMFForum module. Rather a shame, since I invested quite a bit of time on it! I think there's a valuable lesson there.

But back to Drupal and Image module. It's wonderful and my users love the galleries, and posting image nodes, in both sites.

So I shall wait patiently for the upgrade path before upgrading from Drupal 5 to 6. I shall enjoy both sites in the meantime.

Regarding the other advice, yes, indeed I agree, and have offered to test any new versions.

Always willing to do so in order to help the developers.

Thanks for your advice.

Mark

subscribing

ok.. i ran into the same issue. after upgrading from 5.x to 6.2 all my images were gone. I had same SQL errors during the upgrade as #3 had. Here is a "magic" query to rebuild the image table which got messed up during the upgrade:

Note: this query is meant to be executed after the upgrade to 6.x with errors in the image upgrade part - not before!

Cheers!
Paul.

Thank you for that concise solution to my problem, Paul.

-Jeff