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.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #938
    facer
    Participant

    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?

    #1105
    kerryww
    Participant

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

    Thx.

    #1109
    RRowley
    Participant

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

    #1113
    ramanc51
    Participant

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

    Attachments:
    You must be logged in to view attached files.
    #1116
    RRowley
    Participant

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

    #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 day, 10 hours ago by mmmsabeel.
    #1158
    mmmsabeel
    Participant

    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
    )

    #1162
    RRowley
    Participant

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

Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.