| Author |
 Topic Search  Topic Options
|
mikemorrison 
Newbie
Joined: 03 June 2008
Status: Offline
Points: 9
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Posts not accessible
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
mikemorrison
Newbie
Joined: 03 June 2008
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
billd3
Senior Member
Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 June 2008 at 9:24pm |
|
Sounds like a corrupt database....IMO
|
|
BillD
http://theamcpages.com
http://theamcforum.com
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
mikemorrison
Newbie
Joined: 03 June 2008
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
