Thread Rating:
  • 2 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.8] MyBB-PageManager

two months ago, our webhoster updated MySQL to the latest version 8. But since then, some our Plugins aren't working smoothly. I want to update the content of the additional pages created with the Page Manager (Version 2.1.3), but after i press the save button, i get an error massage (see picture).
I know the syntax changed a little bit in the latest MySQL version. But i'm a total beginner with MySQL, so i have no idea, what and where i have to make adjustments to make that plugin work correctly.

Thank you for reading

Attached Files Thumbnail(s)
This user has been denied support. This user has been denied support.
groups is a reserved keyword since mysql 8.0.2 - you'll have to quote it

$query = $db->simple_select('pages','pid,name,url,groups,deviceselect,online','enabled=1');

if quoting does not work you can also put * instead of pid,name,url, groups, ...

or maybe your mybb_pages table has no groups entry at all but it should've been added by the plugin's update code (which runs when you deactivate/activate)
quoting worked! thank you very much :)

Forum Jump:

Users browsing this thread: 1 Guest(s)