| Author |
Topic Search Topic Options
|
Lynford
Groupie
Joined: 14 December 2004
Status: Offline
Points: 171
|
Post Options
Thanks(0)
Quote Reply
Topic: My forum has been removed by............ 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 
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
 |
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 May 2005 at 8:48am |
|
|
|
|
 |
simon121
Groupie
Joined: 28 December 2004
Location: Israel
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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 .
|
 |
Lynford
Groupie
Joined: 14 December 2004
Status: Offline
Points: 171
|
Post Options
Thanks(0)
Quote Reply
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 
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
 |