Author |
Message |
26/01/2005 05:42:12
|
perroski
Newbie
Joined: 26/01/2005 05:28:55
Messages: 2
Offline
|
Hello all,
I've recently been having this one weird problem with my guestbook. I've searched all the threads in here and found nothing on how to fix it so maybe I may be the only one with this problem. Here is the error message I'm receiving:
MySQL Error : Query Error
Error Number: 1226 User 'xxxxxx_xxxx' has exceeded the 'max_questions' resource (current value: 50000)
Date : Tue, January 25, 2005 20:24:29
IP : xxx.xxx.xxx.xx
Referer :
PHP Version : 4.3.10
OS : FreeBSD
Server : Apache/1.3.31 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.10 mod_ssl/2.8.19 OpenSSL/0.9.7c
Here's a link to my guestbook:
http://crowncitee.com/guestbook/index.php
Also when this happens my gallery gets this message:
Notice: Undefined index: debug_mode in /xxxxx/xxxxxx/xxxxxx/gallery/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query
Here's a link to my gallery:
http://crowncitee.com/gallery
Do any of you savvy people know what can be causing this or recommend a fix?.
TIA!
Perroski
|
|
26/01/2005 09:43:47
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
Sounds like the problem is not with the guestbook but a MySql issue. Here is some info about it:
http://dev.mysql.com/doc/mysql/en/user-resources.html
As the server runs, it counts the number of times each account uses resources. If an account reaches its limit on number of connections within the last hour, further connections for the account are rejected until that hour is up. Similarly, if the account reaches its limit on the number of queries or updates, further queries or updates are rejected until the hour is up. In all such cases, an appropriate error message is issued.
You should check with your host.
|
|
26/01/2005 09:45:50
|
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
|
This is what a search on google produced - "Max_Questions i think is a setting that limits how many querys you can run in a set ammount of time. you might want to contact your host."
|
Carbonize
I am not the maker of the Advanced Guestbook
get Lazarus |
|
26/01/2005 09:47:58
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
Isn't that what I said?
|
|
26/01/2005 09:57:38
|
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
|
Check the times :p I was on the reply page as you posted yours.
|
Carbonize
I am not the maker of the Advanced Guestbook
get Lazarus |
|
26/01/2005 09:59:36
|
Anonymous
|
b.s.
|
|
26/01/2005 10:11:06
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
Forget about it.
|
|
26/01/2005 10:12:15
|
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
|
Already have lol. Time to de-ice the batmobile.
|
Carbonize
I am not the maker of the Advanced Guestbook
get Lazarus |
|
26/01/2005 12:15:20
|
amber222
Graduate
Joined: 07/05/2004 21:13:07
Messages: 586
Offline
|
Carbonize wrote:Already have lol. Time to de-ice the batmobile.
Great... however, that post was not directed at you.
|
|
26/01/2005 12:44:42
|
JTD
Graduate
Joined: 08/05/2004 21:52:50
Messages: 529
Location: Arkansas
Offline
|
Ok play nice kiddies.
|
LINK-> Use Lazarus Guestbook |
|
26/01/2005 20:41:47
|
perroski
Newbie
Joined: 26/01/2005 05:28:55
Messages: 2
Offline
|
Thank you all for the great help, I will contact my host and see what is going on.
Perroski
|
|
16/03/2005 03:14:51
|
Anonymous
|
I'm having the same problem. It just started recently and has happened twice now. Each time it clears up by itself. Here's what my error is:
MySQL Error : Connection Error
Error Number: 1040 Too many connections
Date : Tue, March 15, 2005 15:34:44
IP : 207.89.155.80
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Referer :
PHP Version : 4.3.10
OS : Linux
Server : Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4
PHP/4.3.10 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7d
I called my hosting service and they said it's a script error. I should be using a connect() not a pconnect().
I have no idea where in the code that call is made. But it was the same deal as described in a prior post. My hosting service said I have a 50,000 limit so it stops working for a while and then it clears up. I don't know if someone or a bot is hitting my guestbook, but my site does not get that much traffic so I'm very surprised to be getting anywhere close to a 50,000 queries number.
Any ideas?
|
|
16/03/2005 03:27:32
|
Ely
Newbie
Joined: 16/03/2005 03:17:57
Messages: 1
Offline
|
Hey, I just registered and posted this so when someone posts a reply, I'll get e-mail notification. Thanks.
|
|
16/03/2005 10:13:40
|
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
|
The guestbook does not use pconnect. connect means ust connect, get the information and then disconnect. pconnect means connect and stay connected.
|
Carbonize
I am not the maker of the Advanced Guestbook
get Lazarus |
|
16/03/2005 10:15:28
|
Carbonize
Master
Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline
|
Having said that I think I may of found a bug. Am stepping through the code now.
|
Carbonize
I am not the maker of the Advanced Guestbook
get Lazarus |
|
|