[RRowley]

Import the sql file in the attached zip to create an empty table named, si_invoice_item_attachment. Then access SI. It should have updates to apply. Select UPDATE and hopefully it will complete the update of your database.

This missing table is probably something that I created manually in the past, forgot about it and thought it was part of the standard application. It isn’t used at all but since the patch manager expects it, it needs to be there.

Let me know how this works.

Attachments:

1. si_invoice_item_attachments.zip

[RRowley]

When you pull your schema, please do include the following tables: si_extensions, si_sql_patchmanager & si_system_defaults. The data in these tables don’t contain any secure/personal information. This is a little more work than just dumping the schema, but not too much.

[RRowley]

I would appreciate a copy of your database schema. You can download it with phpMyAdmin and exclude data from it and I’ve added the ability to attach files to this forum. I want to see if there is something in the structure that prevents the update script from working.

[RRowley]

I’m interested in correcting the problem with applying patches to the DB with the master_2019.2.1_beta version. Any chance you can provide me with a dump of your database structure? Also, what version of php and mysql are you running (xampp version OK if using)?

[RRowley]

You should already have the setting in the custom.config.php file. It looks like this:

local.locale = en_US
local.precision = 2

This of course if for USA and two decimal place precision. If you look in the “lang” directory, you will see all the different country codes for languages supported on the system. Find yours and replace “en_US” with the file name of your language.

[RRowley]

Can you supply a screen shot of the database request? If it is the step I believe it is, it is not able to access your database which means some setting is incorrect.

Also, you might try putting single quotes around the database password to see if that helps.

[RRowley]

I just uploaded a change that uses the local.locale setting in the custom.config.php file to format the amount fields in the invoices and payments lists. I believe this will address the issue you pointed out. The version for this update is: 2019.2.1 – 20190613.

[RRowley]

Click on the Settings tab and then on the Inv Prefs menu option. You can set the currency symbol to use as well as the currency formatting code country in each of the invoice preference records.

[RRowley]

It is a good idea but not something that can yet be done.

[RRowley]

Sorry but no. You can disable them.

[RRowley]

Note that 2919.1.1 version has now been merged into the master_2019 version as officially released for general use. Enjoy!

[RRowley]

Well to answer myself, the purpose was originally to add changes that I needed for my business. After time, the purpose grew to include the need to support current versions of PHP, MySQL and support libraries. The original version of SI (which is an amazing piece of work in and of itself), had not been maintained since 2013. Given that the number of changes I had made to that version we to great for anyone to review and accept into the original repository, I sought to have the Fearless359 repository separated from the original. That was granted and since then, many updates have been made to it. These are best summarized in the ChangeLog file that can be accessed via the About link at the top right of each page.

Currently, Fearless359 SI has two primary versions: “master” and “master_2019”. The “master” version can run on PHP 5.6x and up (tested to PHP 7.2x so far). Whereas the “master_2019” version is meant for PHP 7.x and up.

“master_2019” has also been updated to include supported versions of libraries to maintain the manage screen tables, the jQuery libraries, etc.

There is a “master_2019_1” version that is available that has been updated to use a the SwiftMailer library for emails and the MPDF library (that comes with SwiftMailer) to generate PDF files. That are currently supported libraries and replace the PHP email and FPDF libraries of which FPDF isn’t currently supported.

There was some discussion at one point about making the Fearless359 version the current version for the standard SI but nothing has come of this to date. If however that becomes an option, I will support reintegrating Fearless359 SI with the standard SI making it a single source library again.

[Author]

Posts