Install a db 2011 si version with 2019 or 2020 si version

[radiocampustours]

Hello,
I had a 5.6 php server and as I updated it I can not use my 2011 si version. I am now with php 7.4. I d like to get a bit help in order to be able to continue to use it. I have an error with si 2019 as I want to patch the db. The error is “SqlPatchManager::runSqlPatch() error. See error log for more information.” as I click on the button “Update.” I do not know how to find the error log as I use a a shared hosting.

What should I do please ?

By the way I also tried to install the 2020 version and I also have an error which is “Fatal error: Uncaught TypeError: Return value of Inc\Claz\SystemDefaults::getDelete() must be of the type int, string returned in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/SystemDefaults.php:216 Stack trace: #0 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/modules/system_defaults/manage.php(28): Inc\Claz\SystemDefaults::getDelete() #1 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/index.php(440): include(‘/home/clients/e…’) #2 {main} thrown in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/SystemDefaults.php on line 216” as I click on the “SI Default” button.

Regards,
Stéphane
Radio Campus Tours

[RRowley]

In the si_system_defaults table, find the row with “name = delete.” The value in it needs to be a 0 or 1. It probably has a “T” or “F”, or “Y” or “N”. Change it to “1” or “0” respectively.

• This reply was modified 3 years, 8 months ago by RRowley.

[radiocampustours]

Hi,
I have a new error as I tried a minute ago to reinstall the 2020 version.

Fatal error: Uncaught TypeError: Return value of Inc\Claz\Db::query() must be of the type bool or null, object returned in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/Db.php:134 Stack trace: #0 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/modules/install/structure.php(16): Inc\Claz\Db->query(‘– phpMyAdmin S…’) #1 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/index.php(440): include(‘/home/clients/e…’) #2 {main} thrown in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/Db.php on line 134

I can not end it…

How should I do to solve this issue ? Is there a clue for my 2011 db version ?

Regards,
Stéphane

• This reply was modified 3 years, 8 months ago by radiocampustours.

[RRowley]

You have to load and successfully run the master_2019.2 update before you can load the master_2020 version. Please make sure that you process it in this order.

[radiocampustours]

As a summary

I have installed a new version of si 2020. First of all I had an error. By the end si has made updates, I can access to the dashbord. I still have an error I mentionned earlier as I click on the SI default button

“Fatal error: Uncaught TypeError: Return value of Inc\Claz\SystemDefaults::getDelete() must be of the type int, string returned in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/SystemDefaults.php:216 Stack trace: #0 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/modules/system_defaults/manage.php(28): Inc\Claz\SystemDefaults::getDelete() #1 /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/index.php(440): include(‘/home/clients/e…’) #2 {main} thrown in /home/clients/ea27f7cbee09d7101a32496af37c62cf/web/facturier2020/Inc/Claz/SystemDefaults.php on line 216”

I can not find in the si_system_defaults table the row with “name = delete.” I only have two rows “sub_customer” and “product_groups.”

Where is my bug please ?

Regards,
Stéphane

• This reply was modified 3 years, 8 months ago by radiocampustours.
• This reply was modified 3 years, 8 months ago by radiocampustours.

[RRowley]

A user has encountered this issue before. The problem is the value in the database for the si_system_defaults table on the row with the name of “Delete”, is not correct. It likely contains a Y or N, or a T or F. Change this value manually to be 1 or 0 respectively.

[radiocampustours]

Thank you for the tip, as I did, everything is now ok

[Author]

Posts