Anybody else having sql problems?

[vsev12]

Whenever I access my site, every 2-3 page views I get an mysql access error.. after refreshing, half the time it loads fine.
any ideas?

-Vladas

[vsev12]

more particular the error says:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /www/f/flashgamesit/htdocs/games.php on line 15

here is an example of one of the game pages:
http://www.flashgamesite.com//games.php?id=25


this is really throwing me for the loop, since there were over 10,000 game views in the past month, so the only thing i can think off is mysql access issues. I might be wrong, since it is fine 50% of the time.

Please help

[Croc Hunter]

*Looks into crystal ball for mysql server number..

[vsev12]

Crystall ball unwillingly spits out number....... #..........

10

-Vladas

[coldhead]

Just a thought.

check the id that is being passed in the links

http://www.flashgamesite.com//cats.php?id=1

is there a valid category for the id number given in the link.

[vsev12]

oh absolutely, the website has been working flawlessly with the same code for the past month and a half. And just currently for the past couple hours I have been receiving the error on 50% of loads, the other 50% to the same exact pages are fine.

thanks you for the idea though coldhead

-Vladas

[josmani]

I am having exactly the same problems. What the h.. is happening?

[tmushy]

having the sample problems

[josmani]

Try http://www.haftawrang.com/opendoc.php?id=2102 it only half the time. Try refreshing it couple of times and you'll see the problem.

[vsev12]

Looks like the issue has been resolved.
Good job powweb

-Vladas

[vsev12]

still getting the errors... somebody do something about this please.!!

[Croc Hunter]

Do you have your own custom php.ini?
Powweb made changes to the global php.ini these last few weeks. I doubt that is the problem but it's an easy 'fix' to try. See: http://support.powweb.com/index.php?category=PHP/MySQL&topic_id=57 to make the php.ini and put it inside your htdocs. If it doesn't fix you can always delete it.

mysql10 hmmm..

[vsev12]

Thanks-a-ton Croc Hunter,
Uploading that particular php.ini file has definetely worked. I would have definetely never thought up of doing something like that. But it seems to have worked I browsed through 100 of pages that had the 50/50 chance of getting that particular error earlier and so far so good! Hopefully that did it

+198327493874 reputation points to you

-Vladas
http://flashgamesite.com

[codefreak]

There is also a script available to keep your php.ini up to date with Powweb's and add your own changes when it does. http://tips-scripts.com/?tip=php_ini#tip

[hollywoodnorth]

same here SQL03..........loads fine 66% of time.... :( :( :( same ol' same ol' here with POWWEB :(

[RTH10260]

oh absolutely, the website has been working flawlessly with the same code for the past month and a half. And just currently for the past couple hours I have been receiving the error on 50% of loads, the other 50% to the same exact pages are fine.Just reviewed this thread again, and from your description of intermittent availability it seems to me, that you too are hitting the hourly connect and / or query limits of Powweb's service. The limits are per database username, so the solution to this is to spread the load among the possible three database users you may define.

The coding solution has just been shown once again by mitchind here:
http://forum.powweb.com/showthread.php?p=310873#post310873

[RTH10260]

same here SQL03..........loads fine 66% of time.... :( :( :( same ol' same ol' here with POWWEB :(That's not a real good error description ! What does the application tell you, what mysql error number and error text do you see ?

Did you track your uage numbers ? Possibly the connection and query limits are plaguing you too. Check my above post to vsev12.

[vsev12]

RHT10260,

I didnt have a php.ini file in my htdocs folder, and after I uploaded the one from the older posts, I have had no issues what so ever, even though traffic was nearly double the day after I was having problems.

Also, I wasnt aware that there were limits on the database usage, I thought storage, bandwidth & requests all counted the same :confused:

-Vladas
http://flashgamesite.com

[RTH10260]

Also, I wasnt aware that there were limits on the database usage, I thought storage, bandwidth & requests all counted the same :confused: Limits mentioned here: Terms Of Service http://powweb.com/PowWeb/Company/Policy/TOS

Changes have been notified over time in the Announcments forum.

[vsev12]

Thx for the link RHT, while reading the TOS.. I found something very interesting:

99.9% Uptime: PowWeb has a 99.9% average uptime across our entire network at large, which includes webservers, mailservers, and more - as a whole. If a single server is temporarily offline, the rest of the PowWeb servers remain unaffected and uninterrupted, thus contributing to our overall uptime.

YEAH RIGHT!! :eek: :rolleyes:
Between server uptime, logs, mysql and the almost nightly "maintenance sessions" the uptime has been nowhere near that.

They seem to be very precise and up to the second with the "Excessive amounts of resources used" e-mails.. and not all that speedy with the "Due to the performance failure of our servers we are going to reimburse you the cost of the past month's hosting", June has been nothing but hell with Powweb. Hope the rest of you are having a better experience

Have a good weekend

-Vladas

[hollywoodnorth]

I am down and up and down and up all NIGHT now also...... HELP US PLEASE>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


www.hollywoodnorthreport.com

[Croc Hunter]

..[snip] ..while reading the TOS.. I found something very interesting:.. [snip]... Between server uptime, logs, mysql and the almost nightly "maintenance sessions" the uptime has been nowhere near that. June has been nothing but hell with Powweb.Hooray!!.. you finally read the TOS you were supposed to read and agreed to upon sign-up. Well, if you comprehend it properly YEAH, IT IS RIGHT!! Powweb does have more than a few servers and downtime is calculated accross ALL servers. Logs have nothing to do with it and I think announced maintenence should not count although I believe it does. Also, while you might have trouble accessing a particular server it does not mean it is actually 'down'.

They seem to be very precise and up to the second with the "Excessive amounts of resources used"I am sure glad of that. It is resource abusers who drag the servers down to a snails pace, causing the majority of problems here for everyone on that server. I wonder.. have you ever been shutdown for abuse vsev12?.

All that at hand. If you have a legitimate complaint email support@powweb.com because there is no guarantee staff will even see it here. This is a user helping user forum. And frankly us users find inaccurate rant posts don't help anyone. I love a good rant post as much as the next user, but let's keep it accurate to help solve these issues.

[RTH10260]

I am down and up and down and up all NIGHT now also...... HELP US PLEASE>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>I asked you before for a better description of the error situation as reply to your previous post. Such things as MySql error numbers and messages help to determine the exact nature of your problem. Check the Apache error log, sometime (not always) you find some extra useful information there, but actually your application should provide this stuff.

Now the intermittent up's and down's decribe pretty neatly, that your application in at the higher end in respect to the usage numbers of the database.

Let me repeat my reply just given in this same thread (you do read the communications, dont you ?):
Just reviewed this thread again, and from your description of intermittent availability it seems to me, that you too are hitting the hourly connect and / or query limits of Powweb's service. The limits are per database username, so the solution to this is to spread the load among the possible three database users you may define.

The coding solution has just been shown once again by mitchind here:
http://forum.powweb.com/showthread.php?p=310873#post310873

[vsev12]

Dear Croc Hunter,
While I am still please with Powweb hosting, I still believe there’s room for improvement.

Also, while you might have trouble accessing a particular server it does not mean it is actually 'down'.

If me and my visitors have trouble accessing particular server on which my web page is hosted, I could care less if the server is still plugged into the power outlet or not and if its literally 'down', so I don’t really understand what you are trying to say by that.

Also, no, I haven't even come close to being shut down due to personal server abuse.

And yes this is a user help user forum, and the issue that I started the thread with has been solved about 5 posts later, so I figured I would throw a random rant in.

Take care everyone

-Vladas