Web Wiz Forums - Only 25 pages of topics showing

Only 25 pages of topics showing

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31824
Printed Date: 27 March 2026 at 9:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Only 25 pages of topics showing

Posted By: aaronk
Subject: Only 25 pages of topics showing
Date Posted: 03 April 2025 at 3:50am

We recently moved our site to a different server and updated Web Wiz Forums to the latest version. Our forum used to display several hundred pages of topics, but now it only shows 25. Old topics will come up in search results, but I can't find anywhere in the admin panel that allows me to change the total number of pages. I verified that "Any Date" is selected in both the admin panel and on the forum page, and that's the only option I can see that would limit the number of pages. I also tried changing the page number in the URL to something higher than 25, but it just shows no topics on those pages.

Is there something else that could be going wrong?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 April 2025 at 8:06am

All the topics for the forum should display as there isn't an option to show only the first 25 topics.

I suspect it could be a date issue, does the old server and the new server both use the same date format, eg. day/month/year

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: aaronk
Date Posted: 03 April 2025 at 2:28pm

Thanks for the reply, Bruce. In the forum MS Access database, it looks like all the Topics are in MM/DD/YYYY format, yet the forum is displaying DD MONTH, YEAR. In the Topics table of the database, the oldest entry is 8/31/2004 9:05:33 AM and the newest is 4/1/2025 7:51:07 PM, so at least there is consistency between the dates on the old server and the new one.

In my control panel, the format was set to Day/Month/Year. I changed that to Month/Day/Year to match what shows in the table, but it still shows the formatting as 27 March 2025 at 3:14PM on the forum, so nothing updated when I changed the setting. It also still shows 25 pages of topics, but we should have 500 pages (10,000 topics).

Is there another step I need to take after updating the date format in the panel?

Posted By: WebWiz-Bruce
Date Posted: 03 April 2025 at 2:38pm

There is nothing to update it seems like there is possibility a difference between the old server and the new.

I am very surprised that Access is till running with 10,000 forum posts as its only a flat file and is able to handle allot of data. It could be that the Access database is corrupted. I would strongly advise upsizing the Access database to SQL Server.

Posted By: aaronk
Date Posted: 03 April 2025 at 3:10pm

Ha! It's actually 10,000 topics. There are 66,000 posts. File size is 106 MB.

I'll have to ask my developer to change it to a SQL database, as that's beyond my skillset.

Thanks again.

Posted By: aaronk
Date Posted: 04 April 2025 at 7:13am

My developer was able to successfully convert to SQL but then Web Wiz shows this error:

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Forum Administrator.

Support Error Code:- err_SQLServer_getSessionData()_get_session_data
File Name:- functions_session_data.asp
Forum Version:- 12.07

Any ideas?

Posted By: WebWiz-Bruce
Date Posted: 04 April 2025 at 7:33am

Many of the tools that convert an Access database to SQL Server database, have to make guesses for some of the data types for table columns and doesn't always get it right.

I would advise that you created a new SQL Server database for Web Wiz Forums and use that to compare it with the database you migrated from Access.

Posted By: aaronk
Date Posted: 04 April 2025 at 2:30pm

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!

Posted By: WebWiz-Bruce
Date Posted: 04 April 2025 at 2:38pm

It looks like your developer has modified the code to show the database query in the web browser instead of running it.

Try replacing the forum_topics.asp file with the original, and any other files that might have been modified and see if that fixes the issue.

Posted By: aaronk
Date Posted: 04 April 2025 at 2:55pm

I've passed this message onto him, so hopefully when he wakes up that will solve the issue.

If we aren't able to get it running properly again, what is your fee for converting our Access database to a functioning SQL database?

Posted By: WebWiz-Bruce
Date Posted: 04 April 2025 at 3:32pm

It has been about a decade, maybe longer, since we last converted an Access database to SQL Server, and so regretfully we do not have the tools to do this anymore.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: aaronk
Date Posted: 04 April 2025 at 3:35pm

OK, in that case, wish us luck!