Hi cubist,
OK, so I'm not sure why you got this issue while updating the core package, but here is what I would do to fix it, and to make sure everything is okay:
- Extract the ZIP file, and find the SQL updates files in /extensions/com_cck/admin/install/upgrades/
- The SQL query you reported is in the 3.5.0.sql file, so I would start with this one.
- Remove the 1st of 1st 2 queries, and then process others with PhpMyAdmin.
- Then process/import other files from 3.5.1 to 3.7.2
After that, at least we'll be sure to have the correct database structure/data.
Then try to upload SEBLOD core package again on the Joomla! installer. If there is no issue, you're fine.
If there is still an SQL issue, you would need to update one more thing with PhpMyAdmin, before trying to upload it again:
> in the #__extensions table, search for: type="component" AND element="com_cck", and in the manifest_cache column, update the "version" to "3.7.2".
> upload the package again.
Hope this helps.
Regards,
Saba.