uc_catalog_update_7001 fails if uc_catalog_images and files tables are out of sync

thanks for the reply...

nothing gets logged to watchdog - curious I know...

My upgrade was this (I might should have mentioned the 5->6, sorry)

anyway, here's what I am working with...

5.x (bare minimum ubercart/drupal install - up to date on core & modules - in production & working)

to 6.x (bare minimum ubercart/drupal install - up to date on core & modules - tested & working)

to 7.x (...)

with regards to my ubercart setup - it's pretty basic - store, cart, product, catalog, payment method pack - just a good many products.

I have it setup now where I can roll (with ease) to either the 5.x, 6.x, or 7.x post upgrade if there's something I should look at.

I've tried running the process several times over the past couple of days starting from the 5.x using the activation/updating of modules in different orders etc, but with no workable results...I've even gone and "re-saved" all of the store settings once upgrade to 6 was complete, and re-save settings on the product node type, and the taxonomy terms as well - hoping something might give.

updated to D7

activate additional D7 core modules
(contextual links
Field
Field SQL Storage
Field UI
File
Image
Overlay
Shortcut
Toolbar)

run cron (just to be sure)

3 orphaned actions (user_block_ip_action, imagecache_flush_action, imagecache_generate_all_action) exist in the actions table. Remove orphaned actions

clear caches via phpmyadmin (covering my bases)

verify update.php [No pending updates.] (extra coverage)

update d6 cck field (only one: field_image_cache) to D7

remove old ubercart files, copy 7.x-3.2 to modules directory

run update.php (34 pending updates)

wait 5min...

stops on "Completed 9 of 34. / Updating uc_catalog module"

browser reload/stop

message generated:

An unrecoverable error has occurred. You can find the error message below. It is advised to copy it to the clipboard for reference.
Please continue to the error page

An AJAX HTTP request terminated abnormally. Debugging information follows. Path: http://mywebsite.com/update.php?op=selection&token=no7ycZWAAv51vR5dXqCXL... StatusText: ResponseText: ReadyState: 4

click link to error page, generates this message:

The update process was aborted prematurely while running update #7001 in uc_catalog.module. All errors have been logged. You may need to check the watchdog database table manually.

after all of this, watchdog displays the following: (I also checked in the database itself, nothing there..)

these are all content_migrate related - there were no entries related to the ubercart update?

php 09/12/2012 - 18:25 Notice: Undefined index: product in content_migrate... admin
php 09/12/2012 - 18:25 Notice: Undefined index: default_image in content... admin
php 09/12/2012 - 18:24 Notice: Undefined index: data in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: list in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined variable: node in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: data in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: list in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined variable: node in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: default_image in content... admin
php 09/12/2012 - 18:24 Notice: Undefined index: product in _content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: default_image in content... admin
php 09/12/2012 - 18:24 Notice: Undefined index: product in content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: default_image in content... admin
php 09/12/2012 - 18:24 Notice: Undefined index: product in content_migrate... admin
php 09/12/2012 - 18:24 Notice: Undefined index: default_image in content... admin
system 09/12/2012 - 18:24 content_migrate module enabled. admin
system 09/12/2012 - 18:24 content_migrate module installed. admin

stopping this update process right there...

did I miss something? was there a different order to this process? Like I've said, over the past couple of days I've tried different (undocumented at the moment) procedures like updating ubercart first - attempting to activate ubercart, then updating etc...

also, being that update.php isn't generating anything to watchdog, is there somewhere else to look, or is there some way I can get a more verbose error from this process?

re-running update reports that there are 25 pending updates...

hangs right away.

went into mysql and emptied all cache tables, re-run update.php (2nd try)

still hangs on Updating uc_catalog module - nothing in watchdog

will be back soon with second test case - updating ubercart first results

same results when updating ubercart modules first...

stops on "Completed 9 of 34. / Updating uc_catalog module"

same errors - no watchdog entries available.

will run & document a couple more test cases over the next couple of hours

thank you for your time & patience...

First off, let me say thank you longwave - you really went the extra mile here.

Hopefully this also helps anyone else out who encounters this.

I tested out the patch, and it worked - and as you'd mentioned, the catalog images didn't come through. Which is kinda ok, because there are only 13. My alternate plan was to wipe out the catalog module & taxonomy before upgrading to 7, then adding it back properly once everything else was in working order.

Once again, many thanks!

-TrevorLee