[TYPO3-english] Error upgrading from 6.2 to 7.6

[Gunnar Jonsson]

I am trying to upgrade to TYPO3 7 and get the following error messages when running Upgrade Wizard and "Update database schema: Modify tables and fields"
Update failed!
Update process not fully processed. This can happen because of dependencies of table fields and indexes. Please repeat this step! Following errors occurred:
SQL-ERROR: Data truncated for column 'image' at row 172
SQL-ERROR: Data truncated for column 'media' at row 171
I repeated this step several times with the same result.
Any idea what kind of problem this is? And how to solve it?
Regards
Gunnar Jonsson

[Marcel Rosenberger]

The error means that you have values in the columns "image" and "media" which are incompatible with the new column definition.

You can execute the following directly to the database before running the update wizard again:

UPDATE pages SET media = '0' WHERE media IS NULL;
UPDATE tt_content SET image = '0' WHERE image IS NULL;
UPDATE tt_content SET media = '0' WHERE media IS NULL;

This solved the error for me.

Regards
Marcel