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

SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › Install a db 2011 si version with 2019 or 2020 si version

Tagged: , , , , , ,

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • March 18, 2021 at 5:15 am #1397
    radiocampustours
    Participant

    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

    March 18, 2021 at 5:46 am #1398
    RRowley
    Participant

    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.
    March 18, 2021 at 5:50 am #1399
    radiocampustours
    Participant

    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

    March 18, 2021 at 5:53 am #1402
    RRowley
    Participant

    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.

    March 18, 2021 at 6:05 am #1403
    radiocampustours
    Participant

    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

    March 18, 2021 at 7:19 am #1406
    RRowley
    Participant

    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.

    March 19, 2021 at 2:19 am #1421
    radiocampustours
    Participant

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

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.