Tagged: runSqlPatch SqlPatchManager
July 11, 2020 at 1:35 pm #938facerParticipant
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:
 => 1364
 => 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?August 13, 2020 at 10:42 pm #1105kerrywwParticipant
Did you find a solution to this as I’m having the same problem myself.
Thx.August 15, 2020 at 2:06 am #1109
Check the tmp/log/php.log file for additional information. If info present, please zip it and attach to a replay to this message.August 27, 2020 at 8:56 pm #1113ramanc51Participant
I am also having same issue, PHP-7.4, simpleinvoice-2013.1, MYSQL server -8.0.21, PHP log attached.
Attachments:August 28, 2020 at 2:09 am #1116
You need to upgrade your SI version. Check out the Version Update Process topic on simpleinvoices.group.October 20, 2020 at 12:44 am #1156mmmsabeelParticipant
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_logADD UNIQUE INDEX
[20-Oct-2020 12:42:29 Asia/Colombo] PdoDb – query(): Execute error.Array
 => 23000
 => 1062
 => 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
idint(11) UNSIGNED NOT NULL,
domain_idint(11) UNSIGNED NOT NULL,
namevarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
street_addressvarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
street_address2varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
cityvarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
statevarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
zip_codevarchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
countryvarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
phonevarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
mobile_phonevarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
faxvarchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
signaturevarchar(255) COLLATE utf8_unicode_ci NOT […]
MySQL said: Documentation
#1050 – Table ‘si_biller’ already exists
October 20, 2020 at 2:04 am #1158mmmsabeelParticipant
- This reply was modified 1 year, 7 months ago by mmmsabeel.
i fixed the above issue and now getting
[20-Oct-2020 14:32:34 Asia/Colombo] PdoDb – debugger(): ALTER TABLE
type_idINT(11) UNSIGNED NULL;
[20-Oct-2020 14:32:34 Asia/Colombo] PdoDb – query(): Execute error.Array
 => 42000
 => 1091
 => Can’t DROP ‘id’; check that column/key exists
)October 21, 2020 at 9:15 am #1162
The content of the si_invoice_item_attachments table should be empty. So DROP it, then try accessing SI again.November 30, 2020 at 10:10 pm #1247
Same issue here. I’ve attached PHP.log. It doesn’t make much sense to me.November 30, 2020 at 10:12 pm #1248December 1, 2020 at 6:52 am #1250
Make sure you have all the Requirements specified to the right set.
December 1, 2020 at 7:15 am #1252
- This reply was modified 1 year, 5 months ago by RRowley.
OK, better thought. What is the content of your si_index table? Typically, it will contain 1 record as follows:
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.December 9, 2020 at 2:13 am #1262
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.
- You must be logged in to reply to this topic.