Help.. this is all I need...

[Nestle]

Hi there is there anyone techy on tonight, I have just been to look at my site and found my site down, I then get this from my hoasting :
Your site was suspended because it was causing excessive load on the server due to some sql queries:

1055274 deni3504_ localhost deni3504_a 919 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055268 deni3504_ localhost deni3504_a 939 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055232 deni3504_ localhost deni3504_a 1042 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055224 deni3504_ localhost deni3504_a 1071 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055220 deni3504_ localhost deni3504_a 1090 Query select x.*, y.p_filename, y.width, y.height, z.comments

If you know how to rectify this, we can unsuspend your site for the purpose of allowing you to remedy this problem.
I have no idea what this means, this comapany I use is driving me bonkers.
Can you change your hoasting provider for another one?.
So any help welcomed.
:unsure:

[MrTempleDene]

I think you'd be best contacting the people who designed it, they may have added something to the e-commerce program that has caused it, are you running os-commerce? or something else.

[Nestle]

Hi there my site was designed by the very talented Daffs(alison), but I cant get her.

[Lemon]

I can't help I'm afraid, but I am sure you will get it sorted soon, try not to panic too much !!

[Nestle]

;) what can I say I was born to worry, thanks for the support.
:hissyfit: :hissyfit: :laugh:

[Ravenfire]

Who are you using for your hosting?

[MrTempleDene]

D'oh, stupid of me, of course it was Daffs

She'd be the best person to help, I'm sure she'll be around soon.

[Nestle]

Compila
They never tell you anything, just take your site off and never say a word to help you out.
ahhh, and it is always after hours this happend.

[Ravenfire]

Do you have a guestbook or anything like that on there

[Ravenfire]

have to say it seems a strange sql query to me and when I have tried to see if anyone has had anything similar on OSCommerce they havent!

[Nestle]

no guestbook, nothing a few weeks back I had a contact us thing but alison took it off as I was getting Spam(lots).
only photos and some static pages

[Daffs]

Just sent it to my H for him to look, never seen anything like it before.

[Ravenfire]

Me either Daffs and cant believe the webhosts were so unhelpful!

[Daffs]

Can't believe they suspended it without notice either. My H will have a look in mo, he's on the phone

[Nestle]

Thank you both, this company is like this all the time, one min ok the next oh site down, and you have to contact them to ask why, time to move me thinks!!!

[Nestle]

This is all they have said:
Dear Sir/Madam

Your site was suspended because it was causing excessive load on the server due to some sql queries:

1055274 deni3504_ localhost deni3504_a 919 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055268 deni3504_ localhost deni3504_a 939 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055232 deni3504_ localhost deni3504_a 1042 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055224 deni3504_ localhost deni3504_a 1071 Query select x.*, y.p_filename, y.width, y.height, z.comments

1055220 deni3504_ localhost deni3504_a 1090 Query select x.*, y.p_filename, y.width, y.height, z.comments

If you know how to rectify this, we can unsuspend your site for the purpose of allowing you to remedy this problem.

Regards

The Support Team
Compila Limited

[Daffs]

My h doesn't know enough, I have asked some other people.

[Nestle]

ok, I have e-mailed them and asked them to put it back on, not sure if they will do this but worth a try.

[Ravenfire]

Have you added any new images recently

[Nestle]

mmmm on Sunday just some place card pictures

[Ravenfire]

Have to say its all very strange. It can't be anything to do with the install that Daffs has done as she has done loads of them and never had this before.

Added to which I googled for this error and it could find nothing - which is very rare. If its only just happened then Im guessing that either maybe its something you have done to the site recently or its actually your webhosts that have the problem!

[Nestle]

i can see this is going to go bad by the sound of things, all I have done was add three pictures on Sunday small ones too, today i was just checking the orders and yesterday too.
God whats happened, what do you think my options are?.
Be kind

[Ravenfire]

Personally I would get the site back up, copy all the files and do a database backup and move elsewhere!

[Nestle]

i am trying to but they are not responding to my e-mail.

[Daffs]

Don't panic. I have Arianna taking a look now. You might have to change host but you will need to get it back up live so we can do a database backup, etc. Will mail you!

[Nestle]

you are a star

[Dino]

I wish I had seen this yesterday. Daffs, it could be the database connection in the configure.php files. They need to be set to non-persistent, I had a similar problem with one of my oscommerce installs.

This line in configure.php should be set as:

define('USE_PCONNECT', 'false'); // use persistent connections?

If that doesn't solve it then sorry I don't know but the hosting company is very poor to suspend the website just like that. When I had the problem I had at least some time to sort it out.

Karen

[Ravenfire]

Hmm seems already to be set as that

[Dino]

Oh dear, sorry that didn't help, hope Arianna finds the problem, all very strange.

But I would still move hosts whatever the outcome, just taking down the site without any warning is not on.

Karen

[Arianna]

Oh dear, sorry that didn't help, hope Arianna finds the problem, all very strange.

But I would still move hosts whatever the outcome, just taking down the site without any warning is not on.

Karen

Hi Karen,

I agree about the behaviour of the hosts and how they've handled this. I know if we discover any issues with any of the sites on our servers, we contact the customer and say that their site is having an issue, this is what it is doing, here are some possible ways to fix it. If that doesn't work we'd be happy to look at it and fix it at the support fee costs.

Unless we had notification to remove a site for legal reasons, we don't remove the sites without first speaking to the client.

I think the company have handled it very poorly. :-(

Arianna

[Nestle]

Thank you for all your help, lets just say I have made my mind up, they a bunch of twats.

[Dino]

Thank you for all your help, lets just say I have made my mind up, they a bunch of twats.

Don't worry if you'd rather not say, but do you mind me asking who your current hosts are, just so I can avoid them in the future.

Thanks

Karen

[Nestle]

Compila

[Ravenfire]

Did you sort this out now

[Nestle]

Well I think so I have signed up witht he recmender person and she says she will get back to me with all the details once they are all set, then I have to pass them onto alison to do the techie stuff.

[Ravenfire]

As far as I am aware everything is set up for you on this, you just need to move across your files and database and point your domain name to the new server. If you are unsure about how to do this catch me on msn this evening.

[Tanya]

is it all sorted now?? I am with Compila but I've never really had a problem with them but I know their customer service skills are cr*p.