Sorry in advace for hijacking, but it seems to me we have the same issue.
Originally Posted by
xchs
Hi shojib,
try this:
- Run the Contao Install Tool again
- Deselect the checkbox for `tl_files` DROP INDEX `path`
- Update all other database tables
- At the very end, finally update the `tl_files` DROP INDEX `path`
Will not work, because DROP INDEX `path` can not be deselected. It's in the updater source code. I think the update procedure is faulty. I always run into problems when I try to update a 2.11 to 3.1 and it's always the same.
The two lines giving me the headaches are these:
Code:
system\modules\core\library\Contao\Database\Updater.php, line 468:
$this->Database->query("ALTER TABLE `tl_files` DROP INDEX `path`");
same file line 470:
$this->Database->query("ALTER TABLE `tl_files` ADD UNIQUE KEY `pid_name` (`pid`, `name`)");
If I comment these lines out I don't get errors, but I don't get a finished successful update either, because:
Code:
same file line 472:
// Remove the "mooType" field (triggers the version 3.1 update)
$this->Database->query("ALTER TABLE `tl_content` DROP `mooType`");
...and the same time my database update list looks like this:
Code:
Add new columns
ALTER TABLE `tl_content` ADD `mooType` varchar(32) NOT NULL default '';
Change existing columns
ALTER TABLE `tl_member` CHANGE `autologin` `autologin` varchar(32) NULL default NULL;
ALTER TABLE `tl_style` CHANGE `whitespace` `whitespace` char(1) NOT NULL default '';
ALTER TABLE `tl_calendar_events` CHANGE `startTime` `startTime` int(10) unsigned NULL default NULL;
ALTER TABLE `tl_calendar_events` CHANGE `endTime` `endTime` int(10) unsigned NULL default NULL;
ALTER TABLE `tl_calendar_events` CHANGE `startDate` `startDate` int(10) unsigned NULL default NULL;
ALTER TABLE `tl_calendar_events` CHANGE `endDate` `endDate` int(10) unsigned NULL default NULL;
Drop existing columns
ALTER TABLE `tl_files` DROP INDEX `pid_name`;
As you can see, first it drops the field, then it wants to add the field and it's a never ending cycle. I didn't delve any deeper to other fields, but the mooType one stuck to my eye.
Bookmarks