[mmmsabeel]

i performed this update on top of previous version of si which was running perfectly on php7. after php 7+ update the pdf generation stopped working therefore installed this 2019 master file. this is running on justhost linux server. i tried restoring and reinstalling this but getting the same issue, till 318 update there is no issue. and the system freezes from there. there is also no error reported in the log file so i cannot troubleshoot it. i tried with a fresh install with new database, it worked.

[mmmsabeel]

hello. im also stuck on this 318 foreign key patch. when clicked update i dont get any php error log.
but get 500 Server Error
A misconfiguration on the server caused a hiccup. Check the server logs, fix the problem, then try again.
URL: http://teknotrack.lk/inv1/inv1/index.php?case=run

[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
)

[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 5 years ago by mmmsabeel.

[Author]

Posts