Tutorial needed to upgrade from simpleinvoices 2011 to 2023

SimpleInvoices Group Forum Forums Fearless359 SimpleInvoices Discussion Group Tutorial needed to upgrade from simpleinvoices 2011 to 2023

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #1991
    abek
    Participant

    Tutorial needed to upgrade from simpleinvoices 2011 to 2023 (VERSION)

    What matters to me is that I have both environments (VERSIONS) running. I would like to import the data from the OLD Database of which I have the 2011 installation, into the 2023 (version) environment of simpleinvoices.

    I have downloaded all versions, but somehow this doesn’t work with tons of error messages.

    Does anyone have any experience with this to help? Or the steps for updating …to the latest version

    • This topic was modified 6 months, 2 weeks ago by abek.
    #1993
    abek
    Participant

    i got these error while upgrade from 2019.2

    #1994
    abek
    Participant

    i’m getting these ERROR’s after updating form 2020 to 2023

    [05-Nov-2023 00:52:30 America/Los_Angeles]
    Unable to apply patch 331. Found foreign key table columns with NULL values or
    values not in the reference table column. The following list shows what values in foreign
    key columns are missing from reference columns.

    The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

    FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
    ———————— —————— ———————– ——— ————-
    invoice_item_tax invoice_item_id invoice_items id 10
    invoice_item_tax invoice_item_id invoice_items id 11
    invoice_item_tax invoice_item_id invoice_items id 12
    invoice_item_tax invoice_item_id invoice_items id 13

    [05-Nov-2023 00:52:30 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
    [05-Nov-2023 00:53:47 America/Los_Angeles]
    Unable to apply patch 331. Found foreign key table columns with NULL values or
    values not in the reference table column. The following list shows what values in foreign
    key columns are missing from reference columns.

    The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

    FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
    ———————— —————— ———————– ——— ————-
    invoice_item_tax invoice_item_id invoice_items id 10
    invoice_item_tax invoice_item_id invoice_items id 11
    invoice_item_tax invoice_item_id invoice_items id 12
    invoice_item_tax invoice_item_id invoice_items id 13

    [05-Nov-2023 00:53:47 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
    [05-Nov-2023 00:55:35 America/Los_Angeles]
    Unable to apply patch 331. Found foreign key table columns with NULL values or
    values not in the reference table column. The following list shows what values in foreign
    key columns are missing from reference columns.

    The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

    FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
    ———————— —————— ———————– ——— ————-
    invoice_item_tax invoice_item_id invoice_items id 10
    invoice_item_tax invoice_item_id invoice_items id 11
    invoice_item_tax invoice_item_id invoice_items id 12
    invoice_item_tax invoice_item_id invoice_items id 13

    05-Nov-2023 00:55:35 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
    [05-Nov-2023 01:09:41 America/Los_Angeles]
    Unable to apply patch 331. Found foreign key table columns with NULL values or
    values not in the reference table column. The following list shows what values in foreign
    key columns are missing from reference columns.

    The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

    FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
    ———————— —————— ———————– ——— ————-
    invoice_item_tax invoice_item_id invoice_items id 11
    invoice_item_tax invoice_item_id invoice_items id 12
    invoice_item_tax invoice_item_id invoice_items id 13

    [05-Nov-2023 01:09:41 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.

    • This reply was modified 6 months, 2 weeks ago by abek.
    Attachments:
    #1997
    abek
    Participant

    ERROR after pressing the UPDATE BUTTON

    #1999
    abek
    Participant

    Upgrade vieuw

    #2007
    RRowley
    Participant

    Concerning unable to apply foreign key changes error, the exception message tells you what the issue is. From your error log:

    The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.
    
    FOREIGN KEY      TABLE COLUMN    REFERENCE TABLE COLUMN INVALID VALUE
    ————————         ——————          ———————–        ———    ————-
    invoice_item_tax invoice_item_id invoice_items   id     10
    invoice_item_tax invoice_item_id invoice_items   id     11
    invoice_item_tax invoice_item_id invoice_items   id     12
    invoice_item_tax invoice_item_id invoice_items   id     13
    

    This is saying that there are si_invoice_item_tax table records with an id of 10, 11, 12 and 13, containing invoice_item_id values that do not exist in the si_invoice_items table.

    There are two ways to resolve this. One is to create si_invoice_itens records that contain these values. The other is to delete these records from the si_invoice_item_tax table. Since the orphaned records are likely left over from the deletion of si_invoice_items records that failed to delete associated tax records, the solution to delete the si_invoice_item_tax records with id values of 10, 11, 12 and 13 is likely the best solution.

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