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

SimpleInvoices Group Forum Forums Fearless359 SimpleInvoices Discussion Group SqlPatchManager::runSqlPatch() error. See error log for more information. Reply To: SqlPatchManager::runSqlPatch() error. See error log for more information.

#1156
mmmsabeel
Participant

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 1 month, 1 week ago by mmmsabeel.