My forum has been removed by............
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=14996
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: My forum has been removed by............
Posted By: Lynford
Subject: My forum has been removed by............
Date Posted: 09 May 2005 at 5:42pm
|
..........the hosting company (Purplenames.com)
The abuse dept have sent me this:
The abuse team have said that there are multiple connections being opened to a database wwwforum.mdb on your site. These connections are not being closed or terminated, this is causing an abnormal load on the server that is effecting other users. Can you please modify your scripts so close these database connections. Once I inform them that the changes have been made they say they'll bring the site back online and monitor it for 24 hours to check that the same issue doesn't arise again.
Can anyone tell me what this means please, and what I can do about it ?
Does it mean that people are logging on for long periods of time, without logging off ? A lot of members access the board from work, and leave it in the background while they are working.
Any help would be gratefully appreciated  |
Replies:
Posted By: dj air
Date Posted: 09 May 2005 at 7:04pm
|
firstly if the board is very busy/big i would advise upgrading to MSSQL version. it means that there are alot of people accessing the database, have you modified the system or using data on other pages because it maybe those pages that are coursing the problems. because the forum closess connections etc as soon as possible., but as i said i would recommend upgrading to the MSSQL Version. |
Posted By: WebWiz-Bruce
Date Posted: 10 May 2005 at 4:38am
|
I hate hosting companies like this as they should get their facts straight when they say things like:- 'These connections are not being closed or terminated' This is completely untrue, as I have spent many an if not days checking all database connections are closed. I am so sure of this that I challenge anyone to find a connection that is left open and will give a free link removal key to anyone that does find a database connection left open!! The problem with forum software is it puts a heavy load on the database and on a busy forum this will use up the small pool of Access database connections shared between all sites on the server. This is what your host is probably referring to. You may need to move across to MS SQL Server to give your forum the resources it requires. Please also forward onto your web host that 'All database connections are closed' and refer them to this post if they have anything to say on the matter. ------------- 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: xeerex
Date Posted: 10 May 2005 at 8:48am
That's just plain dumb. Now I could see warning the customer is the site was getting hammered with traffic, but closing sites based on the file size of the database? If they are that stupid, then yeah get a new host. 
Just like everyone else here, I can attest that -borg-'s code is pretty much rock solid. My largest forum has over 16k members, peaks at over 100 active users on certain days, is ~16MB in size, and runs on Access. Tell your host they are morons -- after you change hosts.  ------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
wrote:Posted By: simon121
Date Posted: 10 May 2005 at 9:07am
i would like to host at web wiz but i live in israel and how i be able to pay them?  i dont have credit card..------------- http://pakapaka.info/forum"> 
|
Posted By: dj air
Date Posted: 10 May 2005 at 9:12am
|
you can use paypal (not sure if israel is on there). or if a bank account send a wire tranfer.. or send a cheque that is only options open to you . |
Posted By: Lynford
Date Posted: 10 May 2005 at 9:06pm
|
Just had a thought (now that is unusual !!)
Is it possible that these 'multiple connections' they are talking about could be:
1) Peoples own avatars.
2) A large thread we have with pictures on it
These are both remotely linked from Photobucket etc.
If this is the case, could I upload these to the site, and link them from there ?
Thanks for all of your help
 |
Posted By: michael
Date Posted: 10 May 2005 at 10:19pm
|
I don't think how this can have anything to do with it. Like the others said, you obviously have a fairly large mdb and if it goes into memory for forum connection it slows all down.... Try to find a good sql server host and you won't have those problems. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: Restricted View
Date Posted: 11 May 2005 at 7:15am
|
Just to backup what Lynford has said (i'm trying to help him sort this whole mess out) the board is pretty busy, its got about 1500 memeber (i'd guess 500+ are regulars eeither posting or just browsing) and is pretty busy, shifting 30/40/50GB of traffic a month. I've no idea how big the access database is (still havent got ftp access back from purplenames) but i'm sure its a biggun!
Whilst the members have a whip-round to raise the cash to upgrade to a MS SQL database we're planning on making a few changes to the board to try and solve the problems in the short term just to shut up the hosting company, can someone advise if they will be any good to help the performance:
Here's what we plan
- limit to 20 topics displayed per page
- Only display 10 posts per page when viewing a topic
- Disable search faciitly (if possible)
- Remove some of the threads that have 1000/2000/3000+ posts in them
All in an effort to try and speed things up and reduce load on the server when opening any page by limiting the content that needs to be accessed at any time.
Can anyone recommend anything else or advise if any of these things will be pointless.
Many thanks
Alex
|
Posted By: dj air
Date Posted: 11 May 2005 at 7:21am
|
with the finugures mentioned there it will be hard to reduce it to a satifcatuary figure. MSSQL is the only option i would say. because with what you are saying you would need to empty very regular. also the search engine is not disable able unless yopu code it yourself. but that wont do that much really .. as its as a whole to big. |
Posted By: Restricted View
Date Posted: 11 May 2005 at 7:31am
Thanks,
we're aware that we need to move over to ms sql, but these will only be a stopgap measure in desparation to get the hosting company off our backs in the meantime, hope to upgrade asap!
We just find it stange that the hosting company have only justed picked up on this when the forum has been running in its current state for about a ywear now. Oh well....
 |
Posted By: dj air
Date Posted: 11 May 2005 at 7:35am
|
it might be that fasthosts have just started getting onto them. but they should really have asked him to sort the problem within x days else it will be suspended. in desperation...lol.. i would also do a Compact & Repair on the database. when there is access to it. |
Posted By: Restricted View
Date Posted: 11 May 2005 at 7:53am
| Just got ftp access the access database is 220MB! I assume that i can just open it up using access on my pc, run the compression wizard and then upload it to the webserver again and it will run without any problems? |
Posted By: dj air
Date Posted: 11 May 2005 at 8:51am
|
as long as you close the forum first then download, use Compact and repair and re uplaod. you ca ntry the one in the admin area but people seem to have problems with it. i had to read that twice 220 meg. thats why they don't want it on the server. a couple people on the site and thats half a gig of ram taken. as Access is a flat file. and has to load all of it |
Posted By: xeerex
Date Posted: 11 May 2005 at 9:01am
|
220MB is crazy for an Access forum. Not only do you need to c/r it, but
you also need to spend some time removing topics and deleting old
members.
------------- http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers? http://www.smartergeek.com - web design | pc support | training | podcasts | video production |
Posted By: Restricted View
Date Posted: 11 May 2005 at 1:57pm
You're quite right! Did did a compress/repair today and got the database bown to 90MB, we're going to delete moast of the old posts and some expired users tomorrow so hopefully the database will be brought down to <30MB which will have to do for a few weeks until we can get the system using MS SQL instead. Thanks to everyone for their advice and help  |
Posted By: dj air
Date Posted: 11 May 2005 at 2:18pm
| once the posts,topics and users have been deleted make sure to do another Compact and repair as access doesn't decrease automaticlly |
Posted By: Restricted View
Date Posted: 11 May 2005 at 7:12pm
Thanks for the advice, will do!
|
Posted By: Lynford
Date Posted: 20 May 2005 at 10:45am
|
Yeah, thanks for the help everyone
Until we go MS SQL there's some housekeeping to be done
 |