Search options (Page 172 of 307)

On second thought, I have one idea: try running these

analyze table users

analyze table posts

analyze table groups

That's really odd: there is some really poor query optimizing being done there.
I think the issue might be the group by statement: could you try removing some of the reputation mod's edits to the query (so the group by, the join, and the reputation table's columns) and posting an EXPLAIN for that query?

Well, reputation isn't the issue here
Have you made any other changes to the DB since I had you create that index?

Already in the works
http://dev.punbb.org/ticket/50

reviewum.com: what Bekko suggested will look like an image placed at the top of your forum (if I'm reading the CSS right).

A database doesn't have fields: a table does. Make sure you're creating a database, not a table within an existing database.

Bekko is suggesting that you create a new redirect forum (you can set a redirect URL for empty forums so that the link actually points somewhere else) that can only be seen by Guests. That way, guests only see the forum (which says something like "You must register to view the forum") and when they click on the link, they're taken to register.php

Use phpMyAdmin, yeah

OK, use mysqldump to get the database from the old server

Well, I'd suggest you allocate more memory to MySQL since you have 2GB of it
Other than that, try and figure out what's using up that memory

willray: Do you have SSH access either with your old host or with your new host?