Hello all.. I've migrated my forum to a VPS account at a new host and seem to have a plethora of issues.
Here is what I see (or don't see) so far...
Some lines in the .htaccess file had to be commented out for the forum to display at all.
Main Forum now displays, but there is no left column (with islands).
There is nothing listed under Active Topics/Active Posts tab and no error shown.
following in error log when trying to list a users posts:
Script: XXX/XXX/XXX/scripts/userposts.inc.php - Line: 113
SELECT COUNT(t3.POST_ID)
FROM ubbt_TOPICS as t1,
ubbt_FORUMS as t2,
ubbt_POSTS as t3
WHERE t3.USER_ID = 980 AND t3.TOPIC_ID = t1.TOPIC_ID
AND t1.FORUM_ID = t2.FORUM_ID AND t2.FORUM_ID in ( )
AND t3.POST_IS_APPROVED = '1' AND t2.FORUM_IS_ACTIVE = '1'
ORDER BY t3.POST_POSTED_TIME DESC
- 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 ')
AND t3.POST_IS_APPROVED = '1' AND t2.FORUM_IS_ACTIVE = '1'
ORDER BY t' at line 6
Any help, or advice where to start would be greatly appreciated.
Bill
