I was using the Open Calais module on a large D5 site to auto-tag content. I'm upgrading that site to D6 and having issues upgrading Open Calais.

I've deleted the D5 Open calais files and replaced them with the D6 files. I took care of the different way that RDF is handled, too.

But when it's time to run update.php....the process stalls and never completes.

1. What could be causing this? My other modules all updated just fine.
2. How can I work around this?

If I uninstall the module completely, then install the new version, what happens to the vocabulary terms attached to my nodes that were generated by Open Calais? When I uninstall Open Calais, do I lose the Open Calais vocabularies and all their terms?

I realize the D6 version lets me automatically tag old content, but for various reasons, this isn't an option.

So why's it so tricky to upgrade this and do the taxonomy terms generated by open calais disappear when you uninstall the module?

Comments

febbraro’s picture

febbraro commented

This is very likely caused by the database upgrades in calais_update_6300. There was a sweeping change in the normalization of the data that, in dbs with a ton of records, could take a VERY long time. If this is your problem (seems to be) consider commenting out calais_update_6300, and extracting the SQL queries to a separate script(s) and running them offline (not subject to PHP timeouts, etc)

Just remember if you do that to update the schema version of the opencalais module in the {system} table to get it back on the upgrades path without running 6300 next time there is an update.

If you do develop that separate SQL script, would you mind posting it here as I'm sure there are a few other people that could use it.

bflora’s picture

bflora commented

Hi there!

I hired someone to work on this for me. He got it working by editing the existing upgrade script, which apparently was duplicating tables. I'll ask him about those edits, and if they're coherent, can post them here.

febbraro’s picture

febbraro commented

Thanks, we'd love any refinements you were able to come up with. Good luck on the D6 upgrade!

febbraro’s picture

febbraro commented
Status: Active » Closed (fixed)