I was talking to our hosting provider today and they told us our hosting account was suspended due to excessive mysql queries.

What they told me is that the tables causing this problem are:
j17_assets, j17_bsms_studies, and j17_bsms_mediafiles.

We have over 1200 studies in our website. What can we do to prevent this?

Thank you

Erik Chavez

Who is your hosting provider? I haven't heard of this problem before.

You can get an idea of the queries being run by turning on debug. My guess is that you have a very popular site!

What are the number of hits to studies/media files you are getting?

The table #__assets is troubling, though. My understanding is this table should only be accessed when attempting to edit a record, not view it - but I could be wrong.

If anyone else has had this happen I'd like to know.

Tom

My hosting provider is fatcow.com, this morning I talked to them and told me I had to fix this in less than an hour.

Our website is ccsuncity.org
Can you give me more instructions?

Thank you

Erik

Errors

JDatabaseMySQL::query: 1054 - Unknown column 'componentid' in 'field list' SQL=SELECT id, componentid, link, params FROM j17_menu WHERE link LIKE '%com_biblestudy%';
Information


Backtrace

Call stack
# Function Location
1 JSite->dispatch() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/index.php:43
2 JComponentHelper::renderComponent() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/includes/application.php:191
3 require_once() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/helper.php:156
4 JController->execute() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/biblestudy.php:23
5 biblestudyController->display() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/controller.php:684
6 JController->display() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/controller.php:29
7 biblestudyViewstudieslist->display() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/controller.php:650
8 JView->display() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/views/studieslist/view.html.php:440
9 JView->loadTemplate() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/view.php:180
10 include() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/view.php:582
11 JView->loadTemplate() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/views/studieslist/tmpl/default.php:9
12 include() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/application/component/view.php:582
13 getListing() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/views/studieslist/tmpl/default_main.php:124
14 getCell() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/helpers/listing.php:156
15 getLink() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/helpers/listing.php:416
16 getItemidLink() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/helpers/listing.php:466
17 JDatabaseMySQL->query() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/components/com_biblestudy/helpers/helper.php:32
18 JError::raiseError() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/database/database/mysql.php:512
19 JError::raise() /hermes/waloraweb036/b659/moo.ccsuncity/beta/jupgrade/libraries/joomla/error/error.php:250
Profile Information

Application 0.119 seconds (+0.119); 0.40 MB (+0.404) - afterLoad
Application 2.407 seconds (+2.288); 3.78 MB (+3.379) - afterInitialise
Application 2.537 seconds (+0.131); 4.24 MB (+0.452) - afterRoute

What version of JBS are you using, Erik? What version of Joomla?

JBS 7.0.1 and Joomla Version 1.7.3