DB max_questions

Hej friends.

Can somebody tell me how can i fix this problem with my DB

I don't have sooo many visitors on my site but i still get this error and on my site comes message database query error

 

here is problem

 

Database error in SKANDY radio ***
Query:
SET NAMES 'utf8'

Mysql error:
User 'SKANDY' has exceeded the 'max_questions' resource (current value: 100000)

Found error in file /mounted-storage/sc46039-DIJF/skandy.net/inc/db.inc.php
at line 37. Called db_res function 
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/db.inc.php
[line] => 37
[function] => db_res
[args] => Array
(
[0] => SET NAMES 'utf8'
)

)

[2] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/modules.inc.php
[line] => 22
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/db.inc.php
)

[function] => require_once
)

[3] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/admin.inc.php
[line] => 23
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/modules.inc.php
)

[function] => require_once
)

[4] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/design.inc.php
[line] => 23
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/admin.inc.php
)

[function] => require_once
)

[5] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/profiles.inc.php
[line] => 22
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/design.inc.php
)

[function] => require_once
)

[6] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/watermark/php/helpers.inc.php
[line] => 9
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/profiles.inc.php
)

[function] => require_once
)

[7] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/watermark/php/consts.inc.php
[line] => 41
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/watermark/php/helpers.inc.php
)

[function] => require_once
)

[8] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/base/php/header.inc.php
[line] => 16
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/watermark/php/consts.inc.php
)

[function] => require_once
)

[9] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/header.inc.php
[line] => 184
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/webmods/base/php/header.inc.php
)

[function] => require_once
)

[10] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/ray/modules/global/inc/header.inc.php
[line] => 10
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/header.inc.php
)

[function] => include
)

[11] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/inc/header.inc.php
[line] => 174
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/ray/modules/global/inc/header.inc.php
)

[function] => require_once
)

[12] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/ASMconfig.php
[line] => 2
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/inc/header.inc.php
)

[function] => require_once
)

[13] => Array
(
[file] => /mounted-storage/sc46039-DIJF/skandy.net/ASMdisplay.php
[line] => 2
[args] => Array
(
[0] => /mounted-storage/sc46039-DIJF/skandy.net/ASMconfig.php
)

[function] => include
)

)


Called script: /ASMdisplay.php

Request parameters:
Array
(
[aid] => 5
[__utma] => 3875762.584071687483026400.1224616944.1224616944.1224616944.1
[__utmb] => 3875762.6.10.1224616944
[__utmc] => 3875762
[__utmz] => 3875762.1224616944.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
[__qca] => 1224347139-2761150-84029219
[__qcb] => 317023568
[HstCla184368] => 1256154101765
[HstCnv184368] => 1
[HstC1p184368] => 1256154079109
[HstCup184368] => 6
[c_ppu_184368] => 6
[c_old_pagid_184368] => 0
)


--
Auto-report system

Here Only 1 problem

Mysql error:
User 'SKANDY' has exceeded the 'max_questions' resource (current value: 100000)

Your SQL server overloaded - restart it

 - sammie

There is not problem with script.

It's working as well. But my host provider telling me at i have so many connections on server.

 

Mysql error:
User 'SKANDY' has exceeded the 'max_questions' resource (current value: 100000)

 

And i had 158 unique visit yesterday .

I don't think this is SO much if we se another web sites which have more more visitors then me.

 

I just can't  understand at i have so many questions to DB.

 

When 100000 questions is over then my site display error message and send to me on mail this error rapport .

And it keeping sending to me this mail every time someone visit my site..

 

It's reseting by self after one houre.

 

Question is how can i change it?

Or how can i loose this problem?

 

Because this is unprofessional.

What if i tomorrow  get 1000 visitors at same time?

My site will be all the time OFF?

 

Can i make it changed or i maybe must change host provider?

MySQL can monitor resource usage - this helps your Hosting to keep a record of how many queries your site is consuming. On shared hosts, this can be used to limit the maximum number of queries per domain, leading to less burden on the server.

Your Hosting chose to set this maximum limit to 100000 queries. You can either contact them and ask them to increase the max_questions limit, or try to keep the usage of your site so low that the limit is not crossed.

Or you can change your Hosting

Regards

Artur A

 

 Hi Artur.

 

Thanks for your post.

Can you tell me how can i keep the usage of my site so that i have max_questions under this limit.

 

I really don't have so many visitors.

or there is something in script what making this max_questions so high.

 

I don't understand so much about MySql.

 

In 6.2 we already closed guestbook and comments for non-members. Now you can apply this fix for guestbook.php Change this code if ( !$ip ) to this one: if ( !$ip || $record_sender == 0) For preventing comments posting disable free mode and remove 'post comment' actions from 'non-members' level.