Update from 3.2.10 to 3.5.40

[luciby]

Hellow, I try to update contao from 3.2.10 to 3.5.40. Backend works OK, but I can't open menu Theme. I get error:

PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Table 'mydatabasename.tl_image_size' doesn't exist (DELETE FROM tl_image_size WHERE NOT EXISTS (SELECT * FROM tl_theme WHERE tl_image_size.pid = tl_theme.id))' thrown in C:\xampp\htdocs\myprojectname\system\modules\core\ library\Contao\Database\Statement.php on line 295

I try update database with install.php tool but then I get error:

Fatal error: Uncaught exception Exception with message Query error: Can't DROP INDEX `username`; check that it exists (ALTER TABLE `tl_member` DROP INDEX `username`, ADD UNIQUE KEY `username` (`username`)) thrown in system\modules\core\library\Contao\Database\Statem ent.php on line 295

What is gone wrong?

[zoglo]

Seems to be very old and I don't think I can help you here.
Is there any possibility for you to update to another version?

If you know SQL, you could create those tables yourself.

Sadly Contao 3.2 has been EoL for almost 9 years now.
Maybe if you somehow update to 3.2.21, maybe these migrations have been fixed in those versions.
https://github.com/contao/core/compare/3.2.10...3.2.21

https://github.com/contao/core/releases/tag/3.2.21

[luciby]

Yes, I made tables by myself and it's work.

I have another problem....I can't see advanced modules under Content menu in backend....where is that stored in db?