182
actually. trencaspammers worked for a while but now i have a spammer that can get through. . . so annoying.
183
yep. it's annoying. happened to my site recently.
Trencaspammers is the best i've tried:
trencaspammers - block comment spamming in wordpress for xoops
Trencaspammers is the best i've tried:
trencaspammers - block comment spamming in wordpress for xoops
185
Anyone? Does the above quote mean that XOOPS leaves the database connections open so that they eventually add up to 50K and crash the system? Is this true? Is this configurable? And, if so, how? It's very irritating to have the site crash on such a regular basis. I'd love to blame my webhost completely, but something tells me there's more to this story. . .
186
these are all reasonable actions to take. I have this problem but my host has a limit of 50,000 per hour or some time increment like that. I asked them to increase it and they were not very responsive. I will definitely consider switching hosts, because this problem happens all the time now that I have a decent amount of web activity (like 10 users at a time).
But my question is: what is a reasonable level of db queries for xoops? I cached all the modules and blocks that I could, but many modules and blocks don't function correctly when cached, so there is a limit to how much you can push on that lever. This happens a lot when I am editing the site or adding content, but I can't imagine hitting 50,000/hour with such regularity.
Also, see this post:
max_questions resource limit exceeded
But my question is: what is a reasonable level of db queries for xoops? I cached all the modules and blocks that I could, but many modules and blocks don't function correctly when cached, so there is a limit to how much you can push on that lever. This happens a lot when I am editing the site or adding content, but I can't imagine hitting 50,000/hour with such regularity.
Also, see this post:
max_questions resource limit exceeded
187
yes. i too have a lot of google hits. I also found in other threads here that it helps to optimize the use of module and block caching. my site did not have any caching on blocks or modules. So, I configured those appropriately and am going to see if this helps.
I received the following message from my web host in regard to this proglem:
Quote:
Can anyone help me understand what is meant by the script not closing the connection after a request is made and the connection this has to exceeding the limit? I'm a bit unclear on that. Also, does this make sense for XOOPS?
I received the following message from my web host in regard to this proglem:
Quote:
You are getting 'max_questions' error, because your script is not closing the connection when a request is finished. This is typical of the scripts out there this limit is hourly, so every hour it should reset, you are using resources more than 50,000 and this is causing the error. So please check the script at your end or we suggest you to signup for the virtual or dedicated server, where you can set your own limits.
Can anyone help me understand what is meant by the script not closing the connection after a request is made and the connection this has to exceeding the limit? I'm a bit unclear on that. Also, does this make sense for XOOPS?
188
I have a SQL database max_questions resource problem also. So, I will try to give as much info as possible.
My site regularly goes down and leads to a blank page. I first noticed this when I was making a lot of changes to the site and uploading lots of database tables. Apparently, my web host limits the number of database queries over some unknown time frame to 50000. Sometimes the site will go down for just a few minutes, and other times for up to one hour when this limit has been reached. The error max_questions error shows up when the site is down and I log into phpMyAdmin. The databases that normally show up, do not, and an SQL error message shows up indicating that the max_questions limit of 50K has been reached. The webhost told me that this will always reset within an hour.
This first showed up as only a problem when I was doing extensive upgrading of modules or database tables and running a lot of queries. But now the problem shows up repeatedly and on a daily basis even when no extensive database changes or site development is happening. My site has recently been receiving more user and robot activity, but it is still very low traffic on average, receiving a max of 3000 unique visits a day. Hits on on the order of 100K per day. Still, I feel either the limit of 50K queries is low, or for some reason XOOPS is running a lot of database activity upon page loading that may not be necessary.
Thoughts?
My site regularly goes down and leads to a blank page. I first noticed this when I was making a lot of changes to the site and uploading lots of database tables. Apparently, my web host limits the number of database queries over some unknown time frame to 50000. Sometimes the site will go down for just a few minutes, and other times for up to one hour when this limit has been reached. The error max_questions error shows up when the site is down and I log into phpMyAdmin. The databases that normally show up, do not, and an SQL error message shows up indicating that the max_questions limit of 50K has been reached. The webhost told me that this will always reset within an hour.
This first showed up as only a problem when I was doing extensive upgrading of modules or database tables and running a lot of queries. But now the problem shows up repeatedly and on a daily basis even when no extensive database changes or site development is happening. My site has recently been receiving more user and robot activity, but it is still very low traffic on average, receiving a max of 3000 unique visits a day. Hits on on the order of 100K per day. Still, I feel either the limit of 50K queries is low, or for some reason XOOPS is running a lot of database activity upon page loading that may not be necessary.
Thoughts?
189
After several unsuccessful attempts I finally got it to work and thought it might be helpful to other newbies to post the exact code here. . . It will save you some time futzing with it. My index-template.php file within the new directory with the same name as my default theme is:
Quote:
You can edit text within the quotes, so that the "separator" is anything you want. I chose ' | ' and the 'next' and 'previous' are likewise anything you want, like forward, back or whatever.
Quote:
<?php /* Don't remove this line */ if (!defined('XOOPS_ROOT_PATH')) { exit; }?>
<?php //This is WordPress main content Template ?>
<div id="wpMainContent">
<?php if ($posts) { foreach ($posts as $post) { start_wp(); ?>
<?php the_date('','<h2>','</h2>'); ?>
<div class="post">
<h3 class="storytitle" id="post-<?php the_ID(); ?>"><a href="<?php echo get_permalink() ?>" rel="bookmark" title="Permanent Link: <?php the_title(); ?>"><?php the_title(); ?></a></h3>
<div class="meta"><?php echo _WP_TPL_FILED_UNDER ?><?php the_category() ?> - <?php the_author_posts_link() ?> @ <?php the_time() ?> <?php edit_post_link(); ?></div>
<div class="storycontent">
<?php the_content(); ?>
<br clear=left>
</div>
<div class="feedback">
<?php link_pages('<br />Pages: ', '<br />', 'number'); ?>
<?php comments_popup_link(_WP_TPL_COMMENT0, _WP_TPL_COMMENT1, _WP_TPL_COMMENTS); ?>
</div>
<!--
<?php trackback_rdf(); ?>
-->
<?php } } else { // end foreach, end if any posts ?>
<?php include(dirname(dirname(dirname(__FILE__))) . '/wp-comments.php'); ?>
</div>
<p>Sorry, no posts matched your criteria.</p>
<?php } ?><font size=2><b><?php posts_nav_link(' | ','<- Previous','Next ->'); ?></font></b>
<p class="credit"><?php echo $wpdb->querycount; ?> queries. <?php timer_stop(1); ?> sec.<br /><cite>Powered by <a href="http://www.kowa.org/" title="NobuNobu XOOPS"><strong>WordPress Module</strong></a> based on <a href="http://wordpress.xwd.jp/" title="Powered by WordPress Japan"><strong>WordPress ME</strong></a> & <a href="http://www.wordpress.org/" title="Powered by WordPress"><strong>WordPress</strong></a></cite></p>
</div>
You can edit text within the quotes, so that the "separator" is anything you want. I chose ' | ' and the 'next' and 'previous' are likewise anything you want, like forward, back or whatever.
190
this exact thing happened to me and it took me forever to figure it out, and it was indeed related to having gzip turned on. you can see it upon first cookie but after that white page and no source info.
Note to all - turn gzip off!
Note to all - turn gzip off!
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|