hugh

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • July 6, 2023 at 7:47 pm in reply to: upgrade 2019.2 to 2023 fatal error – referencing column incompatible #1938
    hugh
    Participant

    Hi RRowley,

    Thanks, I appreciate your detailed response.

    I followed your steps but encountered problems when importing the data…issues with incorrect column counts.

    Given the ongoing issues, I decided to install a separate fresh new 2023 version and keep the 2019.2 version running for reference with the old data.

    Thanks again and keep up the great work.

    Hugh

    July 4, 2023 at 3:33 pm in reply to: upgrade 2019.2 to 2023 fatal error – referencing column incompatible #1931
    hugh
    Participant

    Hi RRowley,

    Thanks for your help. The file is attached.

    Hugh

    Attachments:
    1. structure-only-mysimpleinvoicesdb-202307050830.zip
    October 12, 2022 at 8:28 pm in reply to: Update from master_2019.2 to master_2020 #1806
    hugh
    Participant

    When I after changing the “>” to “>=” above I loaded the page and this time got a series of patches to apply. I proceeded but got this error

    “SqlPatchManager::runSqlPatch() error. See error log for more information.”

    The last section of the log which mentions errors with Foreign keys is attached.

    Any ideas?

    thanks,

    Hugh

    Attachments:

    1. runSqlPatchError.png

    October 12, 2022 at 8:13 pm in reply to: Update from master_2019.2 to master_2020 #1805
    hugh
    Participant

    Thanks RRowley. I’ll get onto that. Thanks for your answer.

    cheers,

    Hugh

    October 10, 2022 at 10:51 pm in reply to: Update from master_2019.2 to master_2020 #1803
    hugh
    Participant

    Hi,

    First…thanks for the wonderful effort to keep SimpleInvoices alive.

    I am using SimpleInvoices on a LinuxMint 21 OS.

    I have a similar issue to Bruce when attempting to upgrade from 2019.2 to 2020.
    On page load I get a request to install essential data which I accept. I then get the options to [Start…] or [Install Sample…]. If I select [Start…] it returns to the page which offers to install essential data.

    The custom.config.ini file was successfully updated/created from the custom.config.php file.

    I have a working version of 2019.2 on the same Mint21 computer so the database is populated with data and is working OK.

    I do not see any PHP errors when I use “E_ALL”. I do see some warnings.

    I do not see any messages prompting to patch the data so I presume the database is not being seen, or accessed. I noted the installation steps state “….the databasePassword value needs to be withing quotes…” so I have tried using single (‘) and double (“) quotes around the password in custom.config.ini.

    Has anyone got any suggestions on how I can debug the problem?

    thanks,

    Hugh

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)