MicrosoftThanks for the guide, really easy to follow and worked great. I did find a small issue at step 22 where the command returned the following error:
PHP Fatal error: Uncaught mysqli_sql_exception: Failed to generate invisible primary key. Auto-increment column already exists. in /home/site/wwwroot/library/classes/Installer.class.php:1288
Stack trace:
#0 /home/site/wwwroot/library/classes/Installer.class.php(1288): mysqli_query(Object(mysqli), 'CREATE TABLE `a...')
#1 /home/site/wwwroot/library/classes/Installer.class.php(325): Installer->execute_sql('CREATE TABLE `a...')
#2 /home/site/wwwroot/library/classes/Installer.class.php(273): Installer->load_file('/home/site/wwwr...', 'Main')
#3 /home/site/wwwroot/library/classes/Installer.class.php(1217): Installer->load_dumpfiles()
#4 /home/site/wwwroot/contrib/util/installScripts/InstallerAuto.php(127): Installer->quick_install()
#5 {main}
thrown in /home/site/wwwroot/library/classes/Installer.class.php on line 1288
The resolution was as follows:
1) Login to Azure Database for MySQL flexible server, click on Databases blade and delete the openemr database which has just been created.
2) Click on the Server Parameters blade, select the All filter, search for sql_generate_invisible_primary_key and set to NO. Press Save
3) Go back to the command prompt and rerun the command from step 22.
