[TYPO3-english] Upgrade from 6.2 LTS to 7 LTS

[Michael Schams]

Hi Dennis,

I assume you try the upgrade on a clone of the production site. So you
can "play" around a little without messing up the live site, right?

What happens if you open the Install Tool in your 6.2.30 instance and
run Important Actions -> Compare database

Is the database clean *before* you start to upgrade?

As far as I can see, the following SQL statements fail:

ALTER TABLE pages CHANGE media media int(11) unsigned NOT NULL default
'0';
ALTER TABLE pages_language_overlay CHANGE media media int(11) unsigned
NOT NULL default '0';
ALTER TABLE tt_content CHANGE image image int(11) unsigned NOT NULL
default '0';
ALTER TABLE tt_content CHANGE media media int(11) unsigned NOT NULL
default '0';

Given the fact all other statements don't report an issue, it looks
like a problem with the datatype int(11) and the default value 0 in
quotes.

Which database server and version are you using?
Any special settings?


Cheers
Michael

On Tue, 2017-02-28 at 16:12 +0100, Dennis Hoffland wrote:
> Hello,
> 
> I'm pretty much stuck with my upgrade due to the errors in the
> database relations (See image Upgrade_3, preventing the completion of
> final step of the database section of the Upgrade Wizard).
> 
> Is there some solution to fix these errors manually (phpMyAdmin) or
> should I resort to starting with an empty 7.6 CMS and re-entering all
> the content elements (which of course would be a major setback).
> 
> Kind regards,
> 
> Dennis
> 
> P.S. If you require more info for an answer please let me know!
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>