[kerryww]

I uploaded the 2020_2 files and updated the config file but I get the page shown in the screenshot. When I press the Update button I get this error
SqlPatchManager::runSqlPatch() error. See error log for more information.

When I go to the error log in /tmp/log/php.log there is nothing there.

Attachments:

1. 

   Screenshot_2022-08-01_20-31-37.png
   

[kerryww]

Hi.

I tried to do an update a couple of years ago and ran into problems. What I had runnung, was working, so I just stayed with the old version.

I have tried to update with a copy on my localhost but up came this error:
SqlPatchManager::runSqlPatch() error. See error log for more information.

I first started using SI back in August 2006. So that’s 16 years I’ve been using SI. It has been a very good run.

But, I’ve deceided to move on. I’ve spent days trying to get SI to work but it just keeps ending in errors, errors and more errors. I give up.

I thank all the people involved with SI and wish you all the best for the future.

Thanks again for your help.

Kind regards

Kerry Whitfield

• This reply was modified 1 year, 8 months ago by kerryww.
• This reply was modified 1 year, 8 months ago by kerryww.

[kerryww]

Here are the error files.

Attachments:

1. php5.txt
2. php6.txt

[kerryww]

Hi. Thanks so much for your help! Much appreciated!

Here’s the error from the websites root directory PhP.log file.

[23-Jul-2022 13:33:15 America/Los_Angeles] PHP Warning: “continue” targeting switch is equivalent to “break”. Did you mean to use “continue 2”? in /home/ozwebexp/ozwebexpress.com.au/simpleinvoicesmaster/simpleinvoices-master/library/HTMLPurifier/HTMLPurifier.standalone.php on line 10943

I tried to go to line 10943 of HTMLPurifier.standalone.php and add a “2” after “continue” but no love there.

I’ve also included a copy of the PhP.log file from tmp/log/php.log

There is nothing in the the tmp/log/si.log file. Nor is there anything in the Apache file.

Thx again for your help.

Kerry

[kerryww]

Problem solved.

I’ve just now uploaded the SimpleInvoices Master files and connected to the database and it works. About the only thing not working is the logo doesn’t appear in the PDF invoice. But I see there’s a solution for that, so I’ll get onto that now.

For those who are having the same problem. A little more info about my situation, I’m on a shared host with Dreamhost and using PHP 7.2.

[kerryww]

Hi, thanks for the info and help, but eventhough I’ve followed your directions and attemped the proceedure numerous times I still keep getting the same error in the log file.

Do you have any other suggestions?

Thanks again for your help.

Log file error:

[14-Aug-2020 00:09:54 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch318() = Unable to set Foreign Keys.
[14-Aug-2020 00:15:48 America/Los_Angeles]
Unable to apply patch 318. Found foreign key table columns with values not in
the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

There two ways to fix this situation. Either change the row columns to reference
an existing record in the REFERENCE TABLE, or delete the rows that contain
the invalid columns.

To do this, the following example of the SQL statements to execute for the test
case where the ‘cron_log’ table contains invalid values ‘2’ and ‘3’ in the
‘cron_id’ column. The SQL statements to consider using are:

UPDATE si_cron_log SET cron_id = 6 WHERE cron_id IN (2,3);
—- or —-
DELETE FROM si_cron_log WHERE cron_id IN (2,3);

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
invoices biller_id biller id 0
invoices customer_id customers id 0
invoices type_id invoice_type inv_ty_id 0
invoices preference_id preferences pref_id 0

[14-Aug-2020 00:15:48 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch318() = Unable to set Foreign Keys.

Attachments:

1. 

   Screenshot-from-2020-08-14-17-20-51.png
   

[kerryww]

Did you find a solution to this as I’m having the same problem myself.

Thx.

[Author]

Posts