1
yasir
beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/12 23:15

  • yasir

  • Not too shy to talk

  • Posts: 109

  • Since: 2005/5/16


hello my xoops folder have been suspend because of module newbb 3.07 arabic

i guess i have to use some caching methods rather that upgrading to dedicated server

my site is sMicroTech.com on hostgator.com

the report by my host company (with some cleaning)
Quote:
Hello,

I apologize, but I was forced to suspend the directory {xoops home} as

multiple scripts inside were causing high loading issues on the server. Due

to it affecting all of the other accounts on the system, we had to take

immediate action for the health of the server.

Please be aware, we do not normally disable directories except in rare cases

where multiple scripts are causing issues. We believe this is the only way

to prevent a server crash and potential loss of data.

In general, introducing new indexes, cleaning databases, optimizing existing

code, upgrading to the latest versions and adding some sort of caching

mechanism, where the script does not need to generate a new page with every

request, helps to lower the over load that a script will cause. Likely the

original author or support group of the software that you are using will be

able to help you to understand how to add something of this nature.

If you reply back to this with your IP address () we will be more than happy

to go ahead enable HTTP access for you, so that you can safely work on the

script without it causing further issues.

Please let us know how you would like to proceed.

Processes run by {me}:
{xoops home}/modules/newbb/viewtopic.php (multiple lines about this PHP

file)

MySQL queries:

1532497 db_user localhost db_name Query 0 Sending data SELECT COUNT(*) as

count FROM *_bb_topics t LEFT JOIN *_bb_posts p ON p.post_id =

t.topic_last_post_id WHERE (p.post_time > 0 OR t.topic_sticky=1) AND

t.forum_id = 32 AND t.approved = 1 0 0 3

{xoops home}/modules/newbb/viewtopic.php?post_id=*****
{xoops home}/modules/profile/user.php?xoops_redirect={xoops home}/mod
{xoops home}/

2
wishcraft
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended

I suggest you run x-forum, it is better, also enable the file based cache on the module in your general preferences. The only problem with the file based cache is if your forum is really big you will end up with stuff like a 10GB file cache in xoops_data..

The other things that could be causing this is a DOS attack or some heavily loaded bot crawling your site, this form of harvesting is seen as malicious for some of the bots and i suggest you run xortify client on your machine with protector possibly.

Yeah I am aware of the heavy load caused by newbb that is why I started xforum and removed some of the bulk from it as well as adding multifielding and multilingual features. You can get X-Forum from: http://code.google.com/p/chronolabs/d ... =xoops2.5_xforum_5.85.zip

And you can get Xortify from: http://code.google.com/p/chronolabs/d ... xoops2.5_xortify_3.05.zip - Xortify will also prevent spammers form signing up and spamming your forum. I am talking to stop forum spam about using there spam samples database to make a hierestic checking spam content addition to xortify so things are given a percentile and check whether they are spam or not.. Still waiting on pauls response.

There is a script with X-Forum which allows you to cross over to it from newbb.. It shouldn't need any modification with your existing version, but if you need any help my email address and IM details (not available to midday AEST tomorrow) are on my profile.
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/SimonXaies
github.com/Chronolabs-Cooperative
facebook.com/SimonSXaies

3
Dante7237
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 14:48

  • Dante7237

  • Friend of XOOPS

  • Posts: 294

  • Since: 2008/5/28


That is a pretty old version of Newbb.
Newbb/CBB is on 4.x now in the sourceforge repository.

There are a number of errors in older newbb installs that are vulnerable.
Try a newer version and see if that helps.
The more I know, the more I know that I really didn't wanna know.

4
wishcraft
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended

Still uses the same engine on mysql dante, as well as having the same long queries.. Xforum at least doesn't use any FULLTEXT Indicies and only has InnoDB tables which ahve a much better performance than the otherone which uses heavy processors as well as an old dbase structure.
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/SimonXaies
github.com/Chronolabs-Cooperative
facebook.com/SimonSXaies

5
Dante7237
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 14:59

  • Dante7237

  • Friend of XOOPS

  • Posts: 294

  • Since: 2008/5/28


I apologize but I simply don't see where you promoting modules that you have created is solving anything.

He's using NewBB, why not attempt to troubleshoot the issue first?
The more I know, the more I know that I really didn't wanna know.

6
Peekay
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 21:20

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


CBB 3.08 is, AFAIK, a stable version of the module which works with PHP 5. It was (AFAIK again) the forum module used here on XO for a very long time so it shouldn't have any significant performance issues. It's the closest version to the one you've got, so I would suspect there will be few database differences. You'll find CBB 3.08 on Sourceforge.

Whichever version you choose, CBB or Xforum, to preserve your forum posts, back up your DB and try the upgrade off-line first on a localhost setup, using XAMPP etc.
A thread is for life. Not just for Christmas.

7
yasir
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 22:54

  • yasir

  • Not too shy to talk

  • Posts: 109

  • Since: 2005/5/16


thank u everybody so much
i guess CBB4 will have better compatibility/stability
& xForum will give me better performance because of its caching

so i'll try CBB4 first

would someone provide me the link to final stable CBB,by going to
Module Repository : HOME : Communication : Forums
i couldn't find it !!!

8
yasir
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 22:59

  • yasir

  • Not too shy to talk

  • Posts: 109

  • Since: 2005/5/16


my xoops_data already get so huge , so i have to clear it once every while :( (my xoops is 2.4.5)
how big the caching will be (my total DB is about 98MB,almost half of it is by newbb)

did u try switching from CBB3.07 to xForum by urself!

9
yasir
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 23:06

  • yasir

  • Not too shy to talk

  • Posts: 109

  • Since: 2005/5/16


thank u Peekay for ur advice
infact i always notice many differences between my localhost & my server
i setup Apache,PHP,MySQL manually after i download them from their original website

10
Peekay
Re: beacuse newbb multiple scripts caused high loading issues ,my is suspended
  • 2012/6/13 23:59

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


It is obviously best if you can get your localhost to match your server. If you go to the XAMPP website they naturally want you to use the latest version, but you can download older versions of XAMPP from here.

You have to look closely to find out the PHP/Apache/MySQL versions included in the download, but they are listed under 'Version History'.

For example, I use XAMPP 1.73 because it matches my VPS server config as closely as I can get (apart from a small incremental difference in the MySQL version). Getting the PHP versions to match is probably the most significant task if you want to ensure your localhost site will work properly online.

I would also recommend upgrading from Xoops 2.4 to 2.5. The whole 2.4 series was pretty poor IMHO. Once again, try this on localhost before doing it on your live site.
A thread is for life. Not just for Christmas.

Login

Username:
Password:

Lost Password? Register now!

Who's Online

80 user(s) are online (43 user(s) are browsing Support Forums)


Members: 0


Guests: 80


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits