[For 1.8] MyBB-PageManager

[Rika]

If you're using the example banlist page it looks like that:

Ah, didn't realize it was a test page.

[SvePu]

Version 2.1.0 online! - I've updated first post with some infos & update notes.

[RocketFoot]

Version 2.1.0 online! - I've updated first post with some infos & update notes.

Updated but I am getting this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1064 - 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 ')' at line 1QueryELECT gid, title FROM mybb_usergroups WHERE gid IN ()

[SvePu]

Hi, thx for your hint....which php & sql version you have?

[RocketFoot]

Hi, thx for your hint....which php & sql version you have?

php 5.6.24

MySQL 5.6.35

[SvePu]

Hmmm..I've tested it on PHP 5.6 and 7.1 without errors.

Could you post the content of the pages cache, please?

Home » Tools & Maintenance » Cache Manager » pages

[RocketFoot]

Hmmm..I've tested it on PHP 5.6 and 7.1 without errors.

Could you post the content of the pages cache, please?

Home » Tools & Maintenance » Cache Manager » pages

This is current as I have reverted back to build #2

Array
(
   [parts] => Array
       (
           [pid] => 1
           [name] => 71-73 Part Numbers
           [url] => parts
           [online] => 1
       )

   [1972] => Array
       (
           [pid] => 4
           [name] => 1972 Mustang Data
           [url] => 1972
           [online] => 1
       )

   [1973] => Array
       (
           [pid] => 5
           [name] => 1973 Mustang Data
           [url] => 1973
           [online] => 1
       )

   [1971] => Array
       (
           [pid] => 6
           [name] => 1971 Mustang Data
           [url] => 1971
           [online] => 1
       )

   [diagrams] => Array
       (
           [pid] => 7
           [name] => Wiring Diagrams
           [url] => diagrams
           [online] => 1
       )

   [chat] => Array
       (
           [pid] => 8
           [name] => 7173 Pony Chat
           [url] => chat
           [online] => 1
       )

   [rules] => Array
       (
           [pid] => 9
           [name] => Rules
           [url] => rules
           [online] => 1
       )

   [7173buyersguide] => Array
       (
           [pid] => 24
           [name] => 71-73 Mustang Buyers Guide
           [url] => 7173buyersguide
           [online] => 1
       )

)

[SvePu]

Ok, thx .... please deactivate (not uninstall) plugin in ACP and reactivate it...

---

I wrote a small update fix tool for issues like this.

1. Download the tool package from here
   
2. Unzip package and copy "pagemanager_update_fix.php" into your forum plugins folder
   
3. Activate the tool once from ACP
   

[RocketFoot]

Ok, that seems to have fixed the issue when I clicked the Page Manager settings link.  Everything looks good now but I will test it out and let you know. 

Can I remove the update_fix tool from my plugins or does it need to stay activated?

[SvePu]

The fix tool removes itself after running.