Thoughts on manual update (from 2.6 to 2.9)

**jimmy2** · 12/14/2014, 22:36

i tried to update from 2.6 to 2.9 and so far i noticed couple of things:

1) before replacing the old files with new ones, i should delete the new localconfig.php file to keep all the settings?
2) during the installation tool i need to use the "drop tables" update first and after that run the "alter tables" update? (it didnt work vice versa for some reason)
3) after the successful upgrade, i somehow need to change the date format on the news articles? (if it was just "14-12 Headline" before, then the updated system will display it as "2014-14-12 23:30 Headline" for some reason. dunno how to change it back tho)

**jimmy2** · 12/14/2014, 23:45

ok, so now i tried to add a new article to the updated system, but nothing was added after save&close, so now i dont really want to update the live system...

should i upgrade from 2.6.0 to 2.6.1 to all the way up to 2.7.0 step-by-step with files from here?:
https://github.com/contao/core/releases?after=2.7.3
and then try 2.7.0 to 2.9.0? and then 2.9 to 3.4?
kinda awful....

**jimmy2** · 12/15/2014, 02:37

the update also seems to replace a Print button with a PDF button...
(but my other update was a success, so i might try it on a live server too)

**jimmy2** · 12/15/2014, 03:06

ok so i noticed that the new 2.9 version added 2 new sections called Extension catalog and Extension manager, but when i opened it up, it sayd that i have to enable soap.dll in php config... after i did that the page gave me an error and when i opened the install tool again, it gave me 2 new options to drop somekind of tables... after i did that, it still didnt work and now gives 4 errors:

Code:

Warning: SoapClient::SoapClient(): php_network_getaddresses: getaddrinfo failed: No such host is known. in system\modules\rep_client\RepositoryBackendModule.php on line 139
Warning: SoapClient::SoapClient(http://www.contao.org/services/repository.wsdl): failed to open stream: php_network_getaddresses: getaddrinfo failed: No such host is known. in system\modules\rep_client\RepositoryBackendModule.php on line 139
Warning: SoapClient::SoapClient(): I/O warning : failed to load external entity "http://www.contao.org/services/repository.wsdl" in \test\system\modules\rep_client\RepositoryBackendModule.php on line 139
Fatal error: Uncaught exception SoapFault with message SOAP-ERROR: Parsing WSDL: Couldn't load from 'http://www.contao.org/services/repository.wsdl' : failed to load external entity "http://www.contao.org/services/repository.wsdl" thrown in system\modules\rep_client\RepositoryBackendModule.php on line 139

**jimmy2** · 12/15/2014, 03:33

^-- dunno what is that related to (maybe uniserverZ dns settings?), but after i did 2.9 to 2.11.17 upgrade, i got this error with no home page at all:

Code:

There are pages on the top-level which are not website root pages. Creating websites without a website root page is no longer supported, so please ensure that all pages are grouped under a website root page.

so i did this:
https://community.contao.org/en/show...ll=1#post91152
(created a new structure page and moved all pages into that new root page[select all(except the root) and move])
it gave another error on top after that, but when i re-entered the page, it was gone... (and everything seems to be working)

**jimmy2** · 12/15/2014, 04:13

ok that went quite well after i also re-did the whole structure, but after i replaced 2.11.17 files with 3.0.0 files i got this error on update step3:

Code:

Fatal error: Cannot redeclare class tl_extension in X:\system\cache\dca\tl_extension.php on line 530

and the 530th line just says "}"

so what now

edit*
i removed the whole tl_extension part from the end of the tl_extension.php file and ran the update again, but now i only get this error:

Code:

Fatal error: Cannot redeclare class tl_extension in X:\system\modules\development\dca\tl_extension.php on line 257

and i only get this text... it previously showed me the install tool again when i re-entered the ../install.php address... now only this error..

edit2*
lol... now i removed the whole tl_extension part from the dev\dca\tl_extension.php file also and was able to run the alter table updates (Y) :d
why does the extension part cause such an error though?

**jimmy2** · 12/15/2014, 05:08

now almost all fixed, but couple of alter tables still come up in the install tool and there is no root page anymore...?
and i think this error has got something to do with it:

None of the active website root pages without an explicit DNS setting has the language fallback option set, which means that these websites are only available in the one language you have defined in the page settings! Visitors and search engines who do not speak this language will not be able to browse your website.

i did enter "localhost" into the site structure root page and then the error went away in the CMS admin panel, but there is still no home page...
i also gave uniserver.exe admin rights and it did start behaving differently, but still cant connect to the database with "localhost" - have to use the local ip...

so how is all this related to each other?-.-

edit*
now i also found some corrupt files with the check tool:

Code:

.gitignore
.htaccess.default
contao/file.php
contao/files.php
contao/help.php
contao/index.php
contao/install.php
contao/main.php
contao/page.php
contao/password.php
contao/popup.php
contao/preview.php
contao/switch.php
index.php
README.md
robots.txt
system/config/agents.php
system/config/codeMirror.php
system/config/countries.php
system/config/languages.php
system/config/tcpdf.php
system/config/timezones.php
system/config/tinyFlash.php
system/config/tinyMCE.php
system/config/tinyNews.php
system/initialize.php
system/modules/calendar/config/config.php
system/modules/calendar/dca/tl_calendar.php
system/modules/calendar/dca/tl_calendar_events.php
system/modules/calendar/dca/tl_module.php
system/modules/calendar/dca/tl_user.php
system/modules/calendar/dca/tl_user_group.php
system/modules/calendar/languages/de/default.php
system/modules/calendar/languages/de/modules.php
system/modules/calendar/languages/de/tl_calendar.php
system/modules/calendar/languages/de/tl_calendar_events.php
system/modules/calendar/languages/de/tl_module.php
system/modules/calendar/languages/de/tl_user.php
system/modules/calendar/languages/de/tl_user_group.php
system/modules/calendar/languages/en/default.php
system/modules/calendar/languages/en/modules.php
system/modules/calendar/languages/en/tl_calendar.php
system/modules/calendar/languages/en/tl_calendar_events.php
system/modules/calendar/languages/en/tl_module.php
system/modules/calendar/languages/en/tl_user.php
system/modules/calendar/languages/en/tl_user_group.php
system/modules/calendar/templates/cal_default.html5
system/modules/calendar/templates/cal_default.xhtml
system/modules/calendar/templates/cal_mini.html5
system/modules/calendar/templates/cal_mini.xhtml
system/modules/calendar/templates/event_full.html5
system/modules/calendar/templates/event_full.xhtml
system/modules/calendar/templates/event_list.html5
system/modules/calendar/templates/event_list.xhtml
system/modules/calendar/templates/mod_event.html5
system/modules/calendar/templates/mod_event.xhtml
system/modules/comments/config/config.php
system/modules/comments/dca/tl_comments.php
system/modules/comments/dca/tl_content.php
system/modules/comments/dca/tl_module.php
system/modules/comments/languages/de/modules.php
system/modules/comments/languages/de/tl_comments.php
system/modules/comments/languages/de/tl_content.php
system/modules/comments/languages/de/tl_module.php
system/modules/comments/languages/en/modules.php
system/modules/comments/languages/en/tl_comments.php
system/modules/comments/languages/en/tl_content.php
system/modules/comments/languages/en/tl_module.php
system/modules/comments/templates/ce_comments.html5
system/modules/comments/templates/ce_comments.xhtml
system/modules/comments/templates/com_default.html5
system/modules/comments/templates/com_default.xhtml
system/modules/faq/config/config.php
system/modules/faq/dca/tl_faq.php
system/modules/faq/dca/tl_faq_category.php
system/modules/faq/dca/tl_module.php
system/modules/faq/dca/tl_user.php
system/modules/faq/dca/tl_user_group.php
system/modules/faq/languages/de/default.php
system/modules/faq/languages/de/modules.php
system/modules/faq/languages/de/tl_faq.php
system/modules/faq/languages/de/tl_faq_category.php
system/modules/faq/languages/de/tl_module.php
system/modules/faq/languages/de/tl_user.php
system/modules/faq/languages/de/tl_user_group.php
system/modules/faq/languages/en/default.php
system/modules/faq/languages/en/modules.php
system/modules/faq/languages/en/tl_faq.php
system/modules/faq/languages/en/tl_faq_category.php
system/modules/faq/languages/en/tl_module.php
system/modules/faq/languages/en/tl_user.php
system/modules/faq/languages/en/tl_user_group.php
system/modules/faq/templates/mod_faqreader.html5
system/modules/faq/templates/mod_faqreader.xhtml
system/modules/listing/config/config.php
system/modules/listing/dca/tl_module.php
system/modules/listing/languages/de/modules.php
system/modules/listing/languages/de/tl_module.php
system/modules/listing/languages/en/modules.php
system/modules/listing/languages/en/tl_module.php
system/modules/listing/templates/list_default.html5
system/modules/listing/templates/list_default.xhtml
system/modules/news/config/config.php
system/modules/news/dca/tl_module.php
system/modules/news/dca/tl_news.php
system/modules/news/dca/tl_news_archive.php
system/modules/news/dca/tl_user.php
system/modules/news/dca/tl_user_group.php
system/modules/news/languages/de/default.php
system/modules/news/languages/de/modules.php
system/modules/news/languages/de/tl_module.php
system/modules/news/languages/de/tl_news.php
system/modules/news/languages/de/tl_news_archive.php
system/modules/news/languages/de/tl_news_comments.php
system/modules/news/languages/de/tl_user.php
system/modules/news/languages/de/tl_user_group.php
system/modules/news/languages/en/default.php
system/modules/news/languages/en/modules.php
system/modules/news/languages/en/tl_module.php
system/modules/news/languages/en/tl_news.php
system/modules/news/languages/en/tl_news_archive.php
system/modules/news/languages/en/tl_news_comments.php
system/modules/news/languages/en/tl_user.php
system/modules/news/languages/en/tl_user_group.php
system/modules/news/templates/mod_newsreader.html5
system/modules/news/templates/mod_newsreader.xhtml
system/modules/news/templates/news_full.html5
system/modules/news/templates/news_full.xhtml
system/modules/news/templates/news_latest.html5
system/modules/news/templates/news_latest.xhtml
system/modules/news/templates/news_short.html5
system/modules/news/templates/news_short.xhtml
system/modules/newsletter/config/config.php
system/modules/newsletter/dca/tl_member.php
system/modules/newsletter/dca/tl_module.php
system/modules/newsletter/dca/tl_newsletter.php
system/modules/newsletter/dca/tl_newsletter_channel.php
system/modules/newsletter/dca/tl_newsletter_recipients.php
system/modules/newsletter/dca/tl_user.php
system/modules/newsletter/dca/tl_user_group.php
system/modules/newsletter/languages/de/default.php
system/modules/newsletter/languages/de/modules.php
system/modules/newsletter/languages/de/tl_member.php
system/modules/newsletter/languages/de/tl_module.php
system/modules/newsletter/languages/de/tl_newsletter.php
system/modules/newsletter/languages/de/tl_newsletter_channel.php
system/modules/newsletter/languages/de/tl_newsletter_recipients.php
system/modules/newsletter/languages/de/tl_user.php
system/modules/newsletter/languages/de/tl_user_group.php
system/modules/newsletter/languages/en/default.php
system/modules/newsletter/languages/en/modules.php
system/modules/newsletter/languages/en/tl_member.php
system/modules/newsletter/languages/en/tl_module.php
system/modules/newsletter/languages/en/tl_newsletter.php
system/modules/newsletter/languages/en/tl_newsletter_channel.php
system/modules/newsletter/languages/en/tl_newsletter_recipients.php
system/modules/newsletter/languages/en/tl_user.php
system/modules/newsletter/languages/en/tl_user_group.php
system/modules/newsletter/templates/nl_default.html5
system/modules/newsletter/templates/nl_default.xhtml
system/themes/default/basic.css
system/themes/default/help.css
system/themes/default/hover.js
system/themes/default/iefixes.css
system/themes/default/images/close.gif
system/themes/default/images/header.gif
system/themes/default/images/header_.gif
system/themes/default/images/settings.gif
system/themes/default/install.css
system/themes/default/login.css
system/themes/default/main.css
system/themes/default/popup.css
system/themes/default/src/basic.css
system/themes/default/src/help.css
system/themes/default/src/hover.js
system/themes/default/src/iefixes.css
system/themes/default/src/install.css
system/themes/default/src/login.css
system/themes/default/src/main.css
system/themes/default/src/popup.css
system/themes/default/src/switch.css
system/themes/default/switch.css
system/themes/tinymce.css
Missing optional files

templates/music_academy.sql

?

and i ran these updates via phpmyadmin...:

Code:

ALTER TABLE `tl_member` CHANGE `autologin` `autologin` varchar(32) NULL default NULL;
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;

then replaced all the 3.0.0 files with 3.1.5 files an got this error after running 3.1 update button:

Code:

Fatal error: Uncaught exception Exception with message Query error: Can't DROP 'path'; check that column/key exists (ALTER TABLE `tl_files` DROP INDEX `path`) thrown in X:\system\modules\core\library\Contao\Database\Statement.php on line 282
#0  X:\system\modules\core\library\Contao\Database.php(202): Contao\Database\Statement->query('ALTER TABLE `tl...')
#1  X:\system\modules\core\library\Contao\Database\Updater.php(468): Contao\Database->query('ALTER TABLE `tl...')
#2  X:\contao\install.php(986): Contao\Database\Updater->run31Update()
#3  X:\contao\install.php(544): InstallTool->update31()
#4  X:\contao\install.php(181): InstallTool->runDatabaseUpdates()
#5  X:\contao\install.php(1001): InstallTool->run()
#6 {main}

??

**jimmy2** · 12/15/2014, 09:25

its probably a good idea to clear all the cache before any upgrade? do i have to rebuild the search index after every purge also?
wonder why is this not mentioned in the update 'manual'...