Error Upgrading to Version 07.00.07

As always, you should be backing up your website before installing any new extensions, just in case something happens.

In the case of version 07.00.07, you may run into such an issue.

If you get a fatal error related to a database query, you may have orphaned URL records in your database. To confirm this, first run the query below.

SELECT u.* FROM activeforums_URL u  
LEFT OUTER JOIN activeforums_Topics t  
ON t.TopicId = u.TopicId  
WHERE t.TopicId IS NULL  

If you have more than one result in that query, you'll need to run the next query to remove them. This is because you've had topics created in the past that had custom a URL associated to it, but the topic has since been deleted. (This is fixed in recent versions.)

DELETE u FROM activeforums_URL u  
LEFT OUTER JOIN activeforums_Topics t  
ON t.TopicId = u.TopicId  
WHERE t.TopicId IS NULL