Posts not accessible
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=25785
Printed Date: 03 April 2026 at 2:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Posts not accessible
Posted By: mikemorrison
Subject: Posts not accessible
Date Posted: 03 June 2008 at 11:29pm
Hi, I have had some people register on my forum - http://www.harboroughtennis.co.uk/forum/ - and post some comments. Even though these posts can be seen in a list on the main forum page, the comments themselves are no longer visible, as if they were never made.
Is this something to do with how they set themselves up as members? Because even as the admin, I can't access the comments they made.
Odd. Any help would be greatly appreciated.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 June 2008 at 9:49am
It could be you are using Access as the backend database.
The Access version, as mentioned on the download page, is only intended for testing and not supported in a production environment as Access isn't really up to the job.
You should look instead at using mySQL or SQL Server as the database backend.
You may also want to try running the 'Resync Posts and Topics Tool' from the admin area and see if that fixes your issue.
-------------
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: mikemorrison
Date Posted: 04 June 2008 at 12:13pm
Thanks very much for your reply - I did that, and it simply deleted most of the posts that some of the users couldn't access, leaving only one with a couple of replies made a couple of days ago. Looking at the 'Server Compatibility Test' section, I get the following results:
Pass:
The Web Wiz License Server has been sucessfully connected to
| Upload Component Test |
The 'File System Object' needs to be installed on the server in
combination with one of the components below in order for Upload
Features to work.
File System Object (FSO) - Installed
Persits AspUpload - Installed
Dundas Upload - NOT Installed
SoftArtisans FileUp (SA FileUp) - NOT Installed
aspSmartUpload - NOT Installed
AspSimpleUpload - NOT Installed
|
| Email Component Test |
One
of the following components needs to be installed on the server in
combination with an SMTP Server for the Email Features to work.
CDOSYS - Installed
CDONTS - Installed
JMail - Installed
JMail ver.4+ - Installed
AspEmail - NOT Installed
AspMail - NOT Installed |
Does that make the problem any clearer? I presume also that only with the email components installed will email notification work? Thanks again.
|
Posted By: WebWiz-Bruce
Date Posted: 04 June 2008 at 12:53pm
The compatibility test in this case won't tell us anything, it just tells you if your web host supports the advanced features such as email notification and file and image uploading.
The resync post and topic count will not delete any posts or topics, it's simply updates the statistics in the tables but doesn't remove anything.
The problem is that you are using Access which is not supported in a production environment as it's not up to the job, hence why you are probally getting strange things happen. If you can I would suggest that you look at installing the mySQL or SQL Server versions instead.
-------------
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: billd3
Date Posted: 04 June 2008 at 9:24pm
Sounds like a corrupt database....IMO
-------------
BillD
http://theamcpages.com
http://theamcforum.com
|
Posted By: WebWiz-Bruce
Date Posted: 05 June 2008 at 8:38am
Very likely with Access.
mikemorrion you should try downloading the Access database, open it in MS Access, and select the 'Compact and Repair Database' option, then reupload it to the server again. Hopefully that would fix the corruption.
However, I would still recommend upsizing to SQL Server. Access is a desktop database and was only ever supported in the web environment because back in the 90's MS didn't have anything else for web site databases that didn't cost £20,000. Now things have moved on with the free SQL Server Express, Microsoft are now dropping support for Access in the web environment. They are pushing web hosts to move over to x64, however there are no 64 bit drivers for Access.
-------------
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: mikemorrison
Date Posted: 06 June 2008 at 2:53pm
Thanks very much for your help, guys. Problem for me is, I know nothing about databases (major flaw!) - so is there an easy way of saving the settings and posts that I already have, then setting up the mySQL version instead and reloading them? Or is it a straight replacement which leaves me at square 1 again?
Thanks again,
Mike
|
Posted By: WebWiz-Bruce
Date Posted: 06 June 2008 at 4:04pm
mySQL is a very different database to Access so migrating to mySQL would be very difficult and many who try don't end up with stable databases.
Instead I recommend using SQL Server, it is by far the best database to use with ASP being that they are both from Microsoft.
MS Access has an Upsize Tool built into it which will upsize your present database to SQL Server for you so you don't loose any posts. The Access 2007 Upsize Tool I find works best and use it here on an almost daily biases to upsize databases for our web hosting clients.
If you are not familiar with database and don't like getting your hands dirty with all the technically stuff you maybe interested in our Web Wiz Forums Hosted Solutions. With the hosted solutions we manage all the hard stuff for you like installation, upgrading, etc. and are even on hand to help with setting up your forums.
For more on our Web Wiz Forums Hosted Solutions see the link below:-
http://www.webwiz.net/webhosting/community_hosting.asp - http://www.webwiz.net/webhosting/community_hosting.asp
-------------
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
|
|