Right I managed to get myself suspended at the weekend for pressing a button in the ACP control panel on phpBB after upgrading to phpBB 3.
My fault for blindly pressing buttons without full understanding. It was to do with the search indexing.
Now from posting on the phpBB forum and some discussions via the ticket system with Matt I understand it is to do with the number of sql queries the search indexing executes within a set time frame.
However I don't know how to limit the number of queries it makes. It might help if I understand fully how the search indexing works, I haven't been able to find any info on this.
Also what is the difference between the sql search, and the full text native search. What are the pros and cons between the two. I choose to do full text native search at the weekend as from what I understood this is how phpBB2 worked.
So how do I limit the number of queries the search indexing tries to do, so I can restart it from the ACP.
Or alternatively is it better for me.....
Close the forums again
Export the database
Install the database on my local webserver
Run the search indexng
Export the database and re-import back to Xilo.
I am a bit dubious on the latter as I am not sure how different webserver set-ups will affect the database tables? I think the local webserver I have (xampp) is running mysql 4 and the one on Xilo is mysl5.
Does it make a difference or is it just easier to limit the queries?
This is only the first forum of four which I have upgraded so far and it is by far the smallest.