Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
irokin Posted July 30, 2019 Share Posted July 30, 2019 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 More sharing options...
Daniel F Posted July 31, 2019 Share Posted July 31, 2019 We have fixed this for an upcoming release. Link to comment Share on other sites More sharing options...
All Astronauts Posted July 31, 2019 Share Posted July 31, 2019 Well this is annoying... <looks at own apps...> Link to comment Share on other sites More sharing options...
irokin Posted July 31, 2019 Author Share Posted July 31, 2019 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 More sharing options...
bfarber Posted July 31, 2019 Share Posted July 31, 2019 This will be fixed in our upcoming 4.4.6 maintenance release (for our core software - we can't speak as to any third party code). Link to comment Share on other sites More sharing options...
xdrox Posted August 11, 2019 Share Posted August 11, 2019 I confirm. DO NOT, I repeat, DO NOT upgrade to Mysql 8, you'll regret it for hours. Link to comment Share on other sites More sharing options...
Adriano Faria Posted August 11, 2019 Share Posted August 11, 2019 On 7/31/2019 at 12:23 PM, bfarber said: we can't speak as to any third party code Maybe this could be posted by IPS on Contributors Chat so devs can plan updates to their resources. Link to comment Share on other sites More sharing options...
b416 Posted August 11, 2019 Share Posted August 11, 2019 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 More sharing options...
bfarber Posted August 12, 2019 Share Posted August 12, 2019 On 8/10/2019 at 9:59 PM, Adriano Faria said: Maybe this could be posted by IPS on Contributors Chat so devs can plan updates to their resources. Done Link to comment Share on other sites More sharing options...
irokin Posted September 2, 2019 Author Share Posted September 2, 2019 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 More sharing options...
newbie LAC Posted September 2, 2019 Share Posted September 2, 2019 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 More sharing options...
bfarber Posted September 3, 2019 Share Posted September 3, 2019 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 More sharing options...
irokin Posted September 3, 2019 Author Share Posted September 3, 2019 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 More sharing options...
newbie LAC Posted September 4, 2019 Share Posted September 4, 2019 4 hours ago, irokin said: I can still see it unquoted in my 4.4.6 update bundle Download files from client area Where are 3 versions of 4.4.6 4.4.6 - 104038 4.4.6 - 104039 4.4.6 - 104040 Link to comment Share on other sites More sharing options...
b416 Posted October 30, 2019 Share Posted October 30, 2019 Hi, Is it safe now to upgrade to MySQL 8.0.17 with IPS 4.4.7 ? On my test site it seems to be working, but did only a couple of elementary tests... Link to comment Share on other sites More sharing options...
bfarber Posted October 31, 2019 Share Posted October 31, 2019 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 More sharing options...
b416 Posted October 31, 2019 Share Posted October 31, 2019 Well, I did it in production yesterday and so far so good. I am using the Percona flavor. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.