Unable to see all Lists since Server upgraded to MySQL 8.0.36

  • Resolved guezz007

    (@guezz007)


    9 months, 2 weeks ago

    Hi,

    Recently our server updated their Server to MySQL 8.0.36

    Since theor update, we cannot see the mailing list or any other lists. The error on one of the “Manage Lists” page is

    WordPress database error: [Incorrect DATETIME value: ”]
    SELECT * FROM wp_wpmlmailinglists ORDER BY IF (wp_wpmlmailinglists.modified = ” OR wp_wpmlmailinglists.modified IS NULL,1,0), wp_wpmlmailinglists.modified DESC LIMIT 0 , 15;

    What should we update the database table values to resolve the issue? I’m guessing somewhere in the structure.

    Please assist.

    Regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Tribulant Software

    (@contrid)

    Hi and sorry for the delay.

    We had to discuss this internally before providing an answer.

    We believe that a customer of ours also faced a similar issue but with another plugin. We ran an SQL query for him to resolve it, but it’s not the ideal fix for everyone so we’re going to try another method to resolve this. If you’d like to follow up on this, you can submit a ticket on our support site. We’ll try to work on this shortly.

    Plugin Author Tribulant Software

    (@contrid)

    We started applying code changes to fix this in our extensions and plugins. It will be fixed in the next version. Since you have a ticket open with us on our support site, we’ll send you the fixed version there once we finalise it. Thanks for your patience :)!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Unable to see all Lists since Server upgraded to MySQL 8.0.36’ is closed to new replies.