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

[facer]

running Mysql Ver 8.0.20 and PHP 7.4.3 on ubuntu

I dropped the database and imported the backup first

I upgraded to master_2019.2 when it starts to patch the database it comes up with error: SqlPatchManager::runSqlPatch() error. See error log for more information.

When I look inside the log file I see:
[1] => 1364
[2] => Field ‘sql_patch_ref’ doesn’t have a default value

II have the setting “sql_mode=” in the my.cnf

Any ideas about what this can be?

[kerryww]

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

Thx.

[RRowley]

Check the tmp/log/php.log file for additional information. If info present, please zip it and attach to a replay to this message.

[ramanc51]

I am also having same issue, PHP-7.4, simpleinvoice-2013.1, MYSQL server -8.0.21, PHP log attached.

Attachments:

1. php.zip

[RRowley]

You need to upgrade your SI version. Check out the Version Update Process topic on simpleinvoices.group.

[mmmsabeel]

hello. i get these error when updating patch. master 2019

[20-Oct-2020 12:40:57 Asia/Colombo] SqlPatchManager::runSqlPatch() – PdoDb – query(): Execute error. See error_log.
[20-Oct-2020 12:42:29 Asia/Colombo] PdoDb – debugger(): ALTER TABLE si_cron_log ADD UNIQUE INDEX CronIdUnq (domain_id, cron_id, run_date);
[20-Oct-2020 12:42:29 Asia/Colombo] PdoDb – query(): Execute error.Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry ‘1-96-2016-09-01’ for key ‘CronIdUnq’
)

so when i tried to manually import the full sql i get this error.

— Table structure for table si_biller
—

CREATE TABLE si_biller (
id int(11) UNSIGNED NOT NULL,
domain_id int(11) UNSIGNED NOT NULL,
name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
street_address varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
street_address2 varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
city varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
state varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
zip_code varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
country varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
phone varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
mobile_phone varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
fax varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
email varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
signature varchar(255) COLLATE utf8_unicode_ci NOT […]
MySQL said: Documentation

#1050 – Table ‘si_biller’ already exists

• This reply was modified 4 years, 1 month ago by mmmsabeel.

[mmmsabeel]

i fixed the above issue and now getting
[20-Oct-2020 14:32:34 Asia/Colombo] PdoDb – debugger(): ALTER TABLE si_invoice_item_attachments DROP INDEX id;ALTER TABLE si_products_attributes MODIFY type_id INT(11) UNSIGNED NULL;
[20-Oct-2020 14:32:34 Asia/Colombo] PdoDb – query(): Execute error.Array
(
[0] => 42000
[1] => 1091
[2] => Can’t DROP ‘id’; check that column/key exists
)

[RRowley]

The content of the si_invoice_item_attachments table should be empty. So DROP it, then try accessing SI again.

[Steve2020]

Same issue here. I’ve attached PHP.log. It doesn’t make much sense to me.

[Steve2020]

Ok, another try of attaching the phplog.

Attachments:

1. phplog.txt

[RRowley]

Make sure you have all the Requirements specified to the right set.

• This reply was modified 3 years, 11 months ago by RRowley.

[RRowley]

OK, better thought. What is the content of your si_index table? Typically, it will contain 1 record as follows:

node: invoice
sub_node: 1
sub_node_2: 0
domain_id: 1

The key here are the sub_node and sub_node_2 values. I suspect one of them, probably sub_node_2, is equal to blank and needs to be numeric.

[Steve2020]

Ok. Many thanks. I managed to upgrade somehow. However, when I go to invoices it simply says “Loading…” Same with customers and products “Loading…”.

When I try to create an invoice, it will load both the products and the customers, but not when I go to /index.php?module=customers&view=manage or index.php?module=invoices&view=manage.

[Author]

Posts