Hi Bruce,
It seems this has turned into a small disaster. My developer was up half of the night trying to get us back online, and it's still not working properly. Here is the site if you have a minute to take a look:
https://top40musiconcd.com/forum
The forum home page looks functional, but when you click on any of the three forums, there are errors shown at the top and none of the topics are displayed:
SELECT * FROM (SELECT TOP 24 tblTopic.Topic_ID, tblTopic.Poll_ID, tblTopic.Moved_ID, tblTopic.Subject, tblTopic.Icon, tblTopic.Start_Thread_ID, tblTopic.Last_Thread_ID, tblTopic.No_of_replies, tblTopic.No_of_views, tblTopic.Locked, tblTopic.Priority, tblTopic.Hide, tblThread.Message_date, tblThread.Message, tblThread.Author_ID, tblAuthor.Username, LastThread.Message_date AS LastMessageDate, LastThread.Author_ID AS LastTreadDate, LastAuthor.Username AS LastUsername, tblTopic.Event_date, tblTopic.Event_date_end, tblTopic.Rating, tblTopic.Rating_Votes , ROW_NUMBER() OVER (ORDER BY tblTopic.Priority DESC, tblTopic.Last_Thread_ID DESC) AS RowNum FROM tblTopic WITH (NOLOCK) , tblThread WITH (NOLOCK) , tblThread AS LastThread WITH (NOLOCK) , tblAuthor WITH (NOLOCK) , tblAuthor AS LastAuthor WITH (NOLOCK) WHERE ( tblThread.Author_ID = tblAuthor.Author_ID AND LastThread.Author_ID = LastAuthor.Author_ID AND tblTopic.Start_Thread_ID = tblThread.Thread_ID AND tblTopic.Last_Thread_ID = LastThread.Thread_ID AND (tblTopic.Priority = 3 OR tblTopic.Moved_ID = 8 OR tblTopic.Forum_ID = 8) ) ) AS PagingQuery WHERE RowNum BETWEEN 1 AND 24 ;
We were using a very old version of Web Wiz before migrating to the new server. I can find out the exact version if needed, but it was possibly as old as 2004 and ran on an Access database.
After moving to a new VPS, we updated Web Wiz to the latest version. Other than the noted 25-page bug mentioned earlier, it was running smoothly using the old Access database. Despite this, I mentioned to my developer what you said about being surprised that Access was still working with so many topics and posts. We knew the day was coming when we'd have to migrate to SQL.
Last night around 11:45 PM Central, the entire site went down (not just the forum), and neither of us were working on the site at the time. My developer was able to get our main website back up and running quickly, but the forum has been down ever since. When it first happened, he said "The forum database is giving an error, which is causing an error on the main site. Unfortunately, there's nothing specific about the error."
That's when he went to work (at 1:00 AM) on trying to convert the Access database to SQL, and what you see on our site is as far as he got a few hours later.
If you have any suggestions on where to go from here, please let me know. Thank you so much!
Topic Options
Post Options
Thanks(0)
