upgrade from 0.4.6 to version 0.7.1

[paynor]

Was using 0.4.6 with mysql on PHP 5.4. Recently noted issue with my hoster's antispam script that gives baikal html error:
"exception 'ErrorException' with message 'fopen(/tmp/phplog/phprunning): failed to open stream: Permission non accordée' in /usr/local/phpbin/php/anti_spam.php:1"

So decided to upgrade to latest baikal as a workaground
Looked at the baikal upgrade documentation and noted that the "Upgrading from versions earlier than 0.6..." was fixed in 0.7.1.
Noted also that 0.7.1 needs at least PHP 7.1.
So:
-mysql backup done
-ftp backup done.
-Upgraded PHP to 7.1 and transferred files to new php server
-overwrote baikal with baikal 0.7.1 except for Specific folder (config folder did not exist on 0.4.6 installation).
-experienced problems with the ytml file as in #946, #961 and #962.
-so manually edited ytml file with mysql details.
Now get the following errors in the upgrade wizard:

Upgrading Baïkal from version 0.4.6 to version 0.7.1
Errors
Uncaught exception during upgrade: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc NOT NULL, calendarid integer, principaluri text, access integer ' at line 2 in /home/n/o/ftp_MYSITE/baikal/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php:370 Stack trace: #0 /home/n/o/ftp_MYSITE/baikal/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php(370): PDO->exec('CREATE TABLE ca...') #1 /home/n/o/ftp_MYSITE/baikal/Core/Frameworks/BaikalAdmin/Controller/Install/VersionUpgrade.php(68): BaikalAdmin\Controller\Install\VersionUpgrade->upgrade('0.4.6', '0.7.1') #2 /home/n/o/ftp_MYSITE/baikal/Core/Frameworks/Flake/Core/Render/Container.php(69): BaikalAdmin\Controller\Install\VersionUpgrade->render() #3 /home/n/o/ftp_MYSITE/baikal/Core/Frameworks/Flake/Controller/Page.php(90): Flake\Core\Render\Container->renderBlocks() #4 /home/n/o/ftp_MYSITE/baikal/html/admin/install/index.php(100): Flake\Controller\Page->render() #5 {main}

Error Baïkal has not been upgraded. See the section 'Errors' for details.

[marcelbrueckner]

I've had a similar issue when I tried to upgrade from 0.4.5 to 0.7.1. My solution has been that I've made an intermediate upgrade from 0.4.5 to 0.6.1 prior upgrading to 0.7.1. See #942 (comment) and subsequent comments for some details.

[ByteHamster]

@paynor Do you use MySQL or some other SQL-based database like MariaDb or PostgreSQL? Syntax error in the SQL statement sounds like you are not using MySQL.

[paynor]

No, using MySQL.
Finally got 0.7.1 working by going back to PHP 5.4 and copying my 0.4.6 backup and reverting to the 0.4.6 database backup.
Then upgrading to 0.6.1, moving to PHP 7.1, then upgrading to 0.7.0 and finally 0.7.1.

But now have another problem: when moved back to the PHP 7.1 server, I copied to baikal/baikal (a second level named baikal) before doing the upgrade to 0.7.0 and 0.7.1. Only then noticed the extra baikal level in the root. It works, but all my preexisting devices are configured for a different path (just one baikal in the root). To avoid reconfiguring all my devices I tried just copying the entire installation to the top baikal level (one level up). The result: just blank pages on MYSITE/baikal/html and MYSITE/baikal/html/admin. Probably relatively simple to solve with a config change. Where is the root path configured?

[ByteHamster]

There is a base_uri field in config/baikal.yaml (see example file)

[ByteHamster]

Sounds like this issue is solved :)