Announcement

Collapse
No announcement yet.

MySQL Error 1785 after upgrading

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] MySQL Error 1785 after upgrading

    Hello,

    I have successfully updated my forum from vB 3.8.9 to vB 4.2.5. Simultaneously changed from php5.2 and MySQL4 to php 7.1 and MySQL5.7.

    Everything is going well so far, but unfortunately I can not maintain the forum anymore. When i deleting posts or topics, I get this strange error message:

    Invalid SQL:

    DELETE searchcore, searchcore_text
    FROM searchcore AS searchcore JOIN
    searchcore_text AS searchcore_text ON
    searchcore.searchcoreid = searchcore_text.searchcoreid
    WHERE searchcore.groupcontenttypeid = 2 AND
    searchcore.groupid = 17970;

    MySQL-Error : Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
    Error-Code. : 1785
    Time : Wednesday, 04.12.2019 @ 00:14:05
    Date : Wednesday, 04.12.2019 @ 00:14:05
    Skript : http://www.******/postings.php?do=do...threadid=17970
    Referrer : https://www.******/postings.php
    Class : vB_Database_MySQLi
    MySQL-Version : 5.7.27-log
    PHP: 7.1.33
    Google finds almost nothing about error code 1785.
    Does anyone have an idea or solution?

    Thanks!!!


  • #2
    vBulletin 4.2.5 wasn't designed for GTID Consistency. The underlying software is a decade old. The default for GTID Mode is off in MySQL 5.7. You can turn GTID mode off with this variable - https://dev.mysql.com/doc/refman/5.7...svar_gtid_mode

    You can read more about this here: https://dev.mysql.com/doc/refman/5.7...trictions.html

    If you need help with changing your MySQL configuration, you'll need to talk to your hosting provider or server administrator.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X