XF 1.5 PHPBB3 Import Moderation que and Memory issue

[fjrthommo]

I've just installed Xenforo and imported my PHPBB3 forum and everything imported across seemingly great.
However, ALL posts and threads from day dot have been put into a moderation cue and every time I log in an attempt to approve a post I exceed the memory limit. I believe it's this moderation que that is causing the memory issue. I've found the following mass approval script but I'm a little unsure of where to run it and see if it solves the issue.

https://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/

The memory limit error I receive:

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8208 bytes) in /home/fjr13or/public_html/Forum/library/XenForo/Permission.php on line 80

Do I run the scripts here:


Thanks
Thommo

 

[Paul B]

You would run those queries in phpMyAdmin in the query window.
Make sure you select the correct database first.

However, it would be useful to try and understand why the posts have been imported as moderated.
There must be a flag or setting in the phpBB database which has been misinterpreted in the XF importer.

 

[fjrthommo]

None the wiser as to why the posts came in as moderated, but the scripts worked and all appears to be fine.