Jump to content

MySQL 8.0.17 breaks a bunch of queries


irokin

Recommended Posts

MEMBER is now a reserved word which breaks a bunch of queries involving columns named member. Why anyone thought that was a good idea to include in a patch release I have no idea. Only way to fix right now (without finding all the instances of queries involving member and quoting them with backticks) is to dump all your tables and downgrade to 8.0.16.

 

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-17.html#mysqld-8-0-17-feature

Link to comment
Share on other sites

If you want a quick way of seeing if you're affected, when logged in as an admin you'll see an error along the lines of "Template core/front/global/updateWarning is throwing an error." (assuming the template you're using hasn't removed the update notification). Alternatively if you login to the Admin CP you'll see a similar error that will prevent you accessing anything.

Link to comment
Share on other sites

  • 2 weeks later...
10 hours ago, xdrox said:

I confirm. DO NOT, I repeat, DO NOT upgrade to Mysql 8, you'll regret it for hours.

I disagree. Yes, mysql 8.0.17 breaks things so don't upgrade to that version, but previous versions are Ok. 

I am running my forum on Percona 8.0.15 for months now, it's flawless. I also tried the original MySQL 8, same thing (before 8.0.17).

 

Link to comment
Share on other sites

  • 3 weeks later...

Still getting a few bad queries after 4.4.6

SELECT * FROM `ibf_core_post_before_registering` AS `core_post_before_registering` WHERE member=1234

system/Member/Member.php(4254): IPS\_Member->_processPostBeforeRegistering(NULL)

and

applications/core/modules/front/discover/popular.php(449): IPS\Db\_Select->setKeyField('member')

And another unrelated one in gallery in a compiled template along the lines of

image_= IS NULL

 

Link to comment
Share on other sites

4 hours ago, irokin said:

Still getting a few bad queries after 4.4.6


SELECT * FROM `ibf_core_post_before_registering` AS `core_post_before_registering` WHERE member=1234

system/Member/Member.php(4254): IPS\_Member->_processPostBeforeRegistering(NULL)

and


applications/core/modules/front/discover/popular.php(449): IPS\Db\_Select->setKeyField('member')

Fixed in 4.4.6 (104039)
 

4 hours ago, irokin said:

And another unrelated one in gallery in a compiled template along the lines of

Need more info. Record from System Logs

Link to comment
Share on other sites

On 9/1/2019 at 8:30 PM, irokin said:

And another unrelated one in gallery in a compiled template along the lines of


image_= IS NULL

 

This doesn't look like a MySQL 8 issue on the surface - I'd bet you have some Gallery data in your database that isn't quite right, but a full stacktrace would be needed.

Link to comment
Share on other sites

On 9/2/2019 at 3:08 PM, newbie LAC said:

Fixed in 4.4.6 (104039)

I can still see it unquoted in my 4.4.6 update bundle

$where = $secret ? array( 'member=? OR secret=?', $this->member_id, $secret ) : array( 'member=?', $this->member_id );

 

9 hours ago, bfarber said:

I'd bet you have some Gallery data in your database that isn't quite right

Very possible

Link to comment
Share on other sites

  • 1 month later...

It should be, yes. If you encounter any issues we will treat them as bugs and correct them for the next maintenance release. To that end, I think there are 1 or 2 outlier MySQL 8.0.17 issues corrected for 4.4.8 (things that you would only hit in specific scenarios and won't really affect your day to day use of the software).

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...