This error flags when we create anything, event, database article entry, anything.  Using MySQL 8.0

 

SELECT badge FROM `core_member_badges` WHERE member=1
IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'member=?' at line 1 (1064)
#0 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Db/Select.php(383): IPS\_Db->preparedQuery()
#1 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Db/Select.php(441): IPS\Db\_Select->runQuery()
#2 [internal function]: IPS\Db\_Select->rewind()
#3 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Member/Member.php(5675): iterator_to_array()
#4 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Member/Member.php(5833): IPS\_Member->badgeIds()
#5 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Content/Item.php(513): IPS\_Member->achievementAction()
#6 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Content/Item.php(138): IPS\Content\_Item::createFromForm()
#7 /srv/data/web/vhosts/www.8bitrp.com/htdocs/applications/calendar/modules/front/calendar/submit.php(114): IPS\Content\_Item::create()
#8 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Dispatcher/Controller.php(90): IPS\calendar\modules\front\calendar\_submit->submit()
#9 /srv/data/web/vhosts/www.8bitrp.com/htdocs/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#10 /srv/data/web/vhosts/www.8bitrp.com/htdocs/index.php(13): IPS\_Dispatcher->run()
#11 {main}

 

MySQL added 'member' as a reserved keyword in 8.0.17 and 8.0.18 and then removed it again (thanks Oracle!).

I have submitted a change for this, but an alternative fix would be to upgrade to a newer version of MySQL 8.0.x