Upgrade from 2.3.5 or 3.0.0 to 3.0.1 error

[Crimzin]

Hi All,

When I try upgrading the site it fails.

I used the following: https://www.formalms.org/reference-guid ... ade-2.html

Then once the upgrade finishes I get the following:


Fatal error: Uncaught RuntimeException: Unable to create the cache directory (C:\inetpub\wwwroot\FormaLMS301/files/cache/twig/43). in C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Cache\FilesystemCache.php:57 Stack trace: #0 C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Environment.php(409): Twig\Cache\FilesystemCache->write() #1 C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Environment.php(381): Twig\Environment->loadClass() #2 C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Environment.php(359): Twig\Environment->loadTemplate() #3 C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Environment.php(318): Twig\Environment->load() #4 C:\inetpub\wwwroot\FormaLMS301\appCore\Template\TwigManager.php(113): Twig\Environment->render() #5 C:\inetpub\wwwroot\FormaLMS301\lib\mvc\lib.controller.php(152): appCore\Template\TwigManager->render() #6 C:\inetpub\wwwroot\FormaLMS301\appCore\controllers\HomepageAdmController.php(95): Controller->render() #7 C:\inetpub\wwwroot\FormaLMS301\lib\mvc\lib.controller.php(58): in C:\inetpub\wwwroot\FormaLMS301\vendor\twig\twig\src\Cache\FilesystemCache.php on line 57

Also once you ran the upgrade and try and run it again it fails.

Please in future when running upgrades let the script be smart enough that when the new table exits not to fail but rather check it and upgrade if necessary. This will help a lot in the attempt to run the upgrade the second time.

I am now unable to continue. I tried upgrading from version 2.3.0 to 3.0.1 and also from 3.0.0 to 3.0.1

I get the same result.

[alfa24]

Double check /files folder permissions.
It should be 777

[Crimzin]

I am running formalms in windows 2019 server on IIS.

I will add the IIS user to the permissions.

[GEWadmin]

after setting the permissions I am able to log into the site.

It states that the db needs to be upgraded.

so it did a partial upgrade the first time.

but now it fails on second try.


Upgrade in progress
Upgrade database error


Upgrading to version: 3.0.0
Result: ERROR !!!

Upgrade db with file: C:\inetpub\wwwroot\FormaLMS301/upgrade/data/upg_data/30000_db.sqlTable 'dashboard_permission' already exists Duplicate foreign key constraint name 'config_layout_fk' Duplicate entry 'ignore_score' for key 'core_setting.PRIMARY' Duplicate entry 'use_sender_aclname' for key 'core_setting.PRIMARY' Duplicate entry 'mail_sender_name_from' for key 'core_setting.PRIMARY' Duplicate entry 'customer_help_name_from' for key 'core_setting.PRIMARY' Duplicate entry 'send_ccn_for_system_emails' for key 'core_setting.PRIMARY' Duplicate entry 'UserCourseInsertOverbooking' for key 'core_event_class.class_2'

anoither question.

I can not upload images to the post?

[alfa24]

It seems the partial upgrade is not working as it should.
It's probably a bug.
You have two choices:

1) redo a full upgrade if you can restore a working backup of your 2.3.5
2) ask a Mysql DBA to fix the bug and make the partial upgrade work.

[GEWadmin]

reloaded DB

Upgrade in progress
Upgrade database error


Upgrading to version: 2.4.0
Result: ERROR !!!

Upgrade db with file: C:\inetpub\wwwroot\FormaLMS301/upgrade/data/upg_data/20400_db.sqlTable 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.core_setting' doesn't exist Table 'formalms3.learning_report_schedule' doesn't exist Table 'formalms3.core_st' doesn't exist Table 'formalms3.core_role' doesn't exist Table 'formalms3.learning_courseuser' doesn't exist Table 'formalms3.core_field_userentry' doesn't exist

[alfa24]

I don't know what are you doing exactly.
It's impossible you don't have a core_setting table (otherwise Forma wouldn't work). Double check your db name.

[GEWadmin]

I am trying to upgrade from version 2.3.0 CE to 3.0.3

[alfa24]

Are you able to have a working 2.3.0?

[GEWadmin]

Yes 2.3.0 is working perfectly