Simpleinvoices

Created Tuesday 17 May 2022

Websites

https://github.com/fearless359/simpleinvoices

https://simpleinvoices.group/

https://simpleinvoices.group/installation/

https://github.com/fearless359/simpleinvoices/tree/master_2023

https://github.com/fearless359/simpleinvoices/tree/master_2020

installed
apache24
php 7.4.29
mariadb106-client-10.6.7_3
mariadb106-server-10.6.7_3
configured custom.config.php
imported si data into database
connected to si from firefox displaying UPDATE page

• Previously applied patches skipped to #234 *

SQL patch 234, Add eway customer ID has already been applied in release 20100315
SQL patch 235, Add eway card holder name has already been applied in release 20100315
SQL patch 236, Add eway card number has already been applied in release 20100315
SQL patch 237, Add eway card expiry month has already been applied in release 20100315
SQL patch 238, Add eway card expirt year has already been applied in release 20100315
SQL patch 239, cronlog - add invoice id has already been applied in release 20100321
SQL patch 240, si_system_defaults - add composite primary key has already been applied in release 20100305
SQL patch 241, si_system_defaults - add composite primary key has already been applied in release 20100409
SQL patch 242, Add cost to products table has already been applied in release 20100409
SQL patch 243, Add reorder_level to products table has already been applied in release 20100409
SQL patch 244, Create inventory table has already been applied in release 20100409
SQL patch 245, Preferences - make locale null field has already been applied in release 20100419
SQL patch 246, Preferences - make language a null field has already been applied in release 20100419
SQL patch 247, Custom fields - make sure domain_id is 1 has already been applied in release 20100419
SQL patch 248, Make SimpleInvoices faster - add index has already been applied in release 20100419
SQL patch 249, Make SimpleInvoices faster - add index has already been applied in release 20100419
SQL patch 250, Make SimpleInvoices faster - add index has already been applied in release 20100419
SQL patch 251, Make SimpleInvoices faster - add index has already been applied in release 20100419
SQL patch 252, Language - reset to en_US - due to folder renaming has already been applied in release 20100419
SQL patch 253, Add PaymentsGateway API ID field has already been applied in release 20110918
SQL patch 254, Product Matrix - update line items table has already been applied in release 20130313

SQL patch 255, Product Matrix - update line items table has not been applied to the database
SQL patch 256, Product Matrix - update line items table has not been applied to the database
SQL patch 257, Product Matrix - update line items table has not been applied to the database
SQL patch 258, Product Matrix - update line items table has not been applied to the database
SQL patch 259, Product Matrix - update line items table has not been applied to the database
SQL patch 260, Product Matrix - update line items table has not been applied to the database
SQL patch 261, Product Matrix - update line items table has not been applied to the database
SQL patch 262, Add product attributes system preference has not been applied to the database
SQL patch 263, Product Matrix - update line items table has not been applied to the database
SQL patch 264, Product - use notes as default line item description has not been applied to the database
SQL patch 265, Product - expand/show line item description has not been applied to the database
SQL patch 266, Product - expand/show line item description has not been applied to the database
SQL patch 267, Product Matrix - insert attribute types has not been applied to the database
SQL patch 268, Product Matrix - insert attribute types has not been applied to the database
SQL patch 269, Product Matrix - insert attribute types has not been applied to the database
SQL patch 270, Make SimpleInvoices faster - add index has not been applied to the database
SQL patch 271, Make SimpleInvoices faster - add index has not been applied to the database
SQL patch 272, Add product attributes system preference has not been applied to the database
SQL patch 273, Make SimpleInvoices faster - add index has not been applied to the database
SQL patch 274, Only One Default Variable name per domain allowed - add unique index has not been applied to the database
SQL patch 275, Make EMail / Password pair unique per domain - add unique index has not been applied to the database
SQL patch 276, Each invoice Item must belong to a specific Invoice with a specific domain_id has not been applied to the database
SQL patch 277, Add Index for Quick Invoice Item Search for a domain_id has not been applied to the database
SQL patch 278, Each Invoice Item can have only one instance of each tax has not been applied to the database
SQL patch 279, Drop unused superseded table si_product_matrix if present has not been applied to the database
SQL patch 280, Each domain has their own extension instances has not been applied to the database
SQL patch 281, Each domain has their own custom_field id sets has not been applied to the database
SQL patch 282, Each domain has their own logs has not been applied to the database
SQL patch 283, Match field type with foreign key field si_user.id has not been applied to the database
SQL patch 284, Make si_index sub_node and sub_node_2 fields as integer has not been applied to the database
SQL patch 285, Fix compound Primary Key for si_index table has not been applied to the database
SQL patch 286, Speedup lookups from si_index table with indices in si_invoices table has not been applied to the database
SQL patch 287, Populate additional user roles like domain_administrator has not been applied to the database
SQL patch 288, Fully relational now - do away with the si_index table has not been applied to the database
SQL patch 289, Each cron_id can run a maximum of only once a day for each domain_id has not been applied to the database
SQL patch 290, Set all Flag fields to tinyint(1) and other 1 byte fields to char has not been applied to the database
SQL patch 291, Clipped size of zip_code and credit_card_number fields to realistic values has not been applied to the database
SQL patch 292, Added Customer/Biller User ID column to user table has not been applied to the database
SQL patch 293, Add department to the customers has not been applied to the database
SQL patch 294, Add custom_flags table for products. has not been applied to the database
SQL patch 295, Add net income report. has not been applied to the database
SQL patch 296, Add past due report. has not been applied to the database
SQL patch 297, Add User Security enhancement fields and values has not been applied to the database
SQL patch 298, Add Signature field to the biller table. has not been applied to the database
SQL patch 299, Add check number field to the payment table. has not been applied to the database
SQL patch 300, Add install complete table. has not been applied to the database
SQL patch 301, Add last_activity_date, aging_date and aging_value to invoices. has not been applied to the database
SQL patch 302, Added owing to invoices table has not been applied to the database
SQL patch 303, Add invoice custom field report extension to standard application and add sales_representative field. has not been applied to the database
SQL patch 304, Add default_invoice field to the customers table. has not been applied to the database
SQL patch 305, Add expense tables to the database. has not been applied to the database
SQL patch 306, Clean up default_tax_id and default_tax_id_2 for products has not been applied to the database
SQL patch 307, Fix cron_log cron_id data type has not been applied to the database
SQL patch 308, Remove dup id key from invoice_item_attachments and fix products_attributes type_id data type has not been applied to the database
SQL patch 309, Rename userid to user_id in log table has not been applied to the database
SQL patch 310, Make record unique id fields consistent in size and properties has not been applied to the database
SQL patch 311, Remove default from all id fields. has not been applied to the database
SQL patch 312, Remove default from domain_id & set misc id characteristics. has not been applied to the database
SQL patch 313, Use common characteristics for all non-autoincrement id type fields. has not been applied to the database
SQL patch 314, Create the index items for all auto increment fields. has not been applied to the database
SQL patch 315, Make all tables InnoDB, utf8 and utr8_unicode_ci has not been applied to the database
SQL patch 316, Change character type field settings to charset utf8 collate utf8_unicode_ci has not been applied to the database
SQL patch 317, Additional field characteristic setting changes prior to declaring foreign keys. has not been applied to the database
SQL patch 318, Add foreign keys to tables. has not been applied to the database
SQL patch 319, Add set_aging field to si_preferences has not been applied to the database
clicked UPDATE » error message: SqlPatchManager::runSqlPatch() error. See error log for more information.
info from tmp/log/php.log
[17-May-2022 11:49:08 Australia/Sydney] PdoDb - debugger(): CREATE TABLE `si_products_attributes` (`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

[17-May-2022 11:49:08 Australia/Sydney] PdoDb - backtrace: Array
(

10. dropped

Table 'si_products_attributes' » solved

11. Table 'si_products_values' already exists » dropped table
12. in si_index table changed value of sub_node_2 to 0
13. all patches applied
14. error Unable to create public/data.json file
15. created public folder access 755
16. working > extremly slow > unusable

Update from 19 to 20

After patches applied » error

Fatal error: Uncaught Error: Class 'NumberFormatter' not found in /srv/http/si20/Inc/Claz/Util.php:264 Stack trace: #0 /srv/http/si20/Inc/Claz/Invoice.php(347): Inc\Claz\Util::numberTrim() #1 /srv/http/si20/Inc/Claz/Invoice.php(155): Inc\Claz\Invoice::getInvoices() #2 /srv/http/si20/Inc/Claz/Invoice.php(107): Inc\Claz\Invoice::manageTableInfo() #3 /srv/http/si20/modules/invoices/manage.php(29): Inc\Claz\Invoice::getAllWithHavings() #4 /srv/http/si20/index.php(446): include('/srv/http/si20/...') #5 {main} thrown in /srv/http/si20/Inc/Claz/Util.php on line 264