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

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)
   
Reply
#52
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)
Reply
#53
quoting worked! thank you very much :)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)