XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. 2.5.x Support 
  4.  / Is xoops having problems with a large amount of blocks-sql queries?
Register
1
kerkyra
Is xoops having problems with a large amount of blocks-sql queries?

  • 2011/7/19 14:30

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


Hallo there, i'm having a problem which i cannot figure out.

In http://www.mykerkyra.gr if i add one more block to the front page, it just shows a white screen.

I have tried to figure out what was causing the problems and I think it has to do with the number of sql queries above 110 or something like that.

If i deactivate a block (anyone) it works fine. If i activate it again and comment out the sql queries in it it works fine (with no data of course) - but it loads the block.

So right now i deactivated the comments block to make the site working again.

Any ideas on how this can be fixed? Or why this is happening?

Thanks
2
kerkyra
Re: Is xoops having problems with a large amount of blocks-sql queries?

  • 2011/7/19 15:09

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


it seems the debugging has something to do with it also. If i turn it off the site starts working. Otherwise i get blank pages randomly :/
whttp://www.guidemap.gr - Beta is out...
3
kerkyra
Re: Is xoops having problems with a large amount of blocks-sql queries?

  • 2011/7/21 11:58

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


bump? :(
whttp://www.guidemap.gr - Beta is out...
4
kerkyra
Xoops White pages

  • 2011/7/21 14:13

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


I did a lil digging around and came to the conclusion that it was the gzip compression that was causing all this. I'm not sure why.

here is what i did to 'fix' this...not sure if this is an actual fix but works for me right now, so please if someone else knows a better fix post it.

in file class/xoopskernel.php

line 124
change this
Quote:

ob_start('ob_gzhandler');


with this
Quote:

ob_start('ob_gzhandler');
ob_end_clean();
header("Content-Encoding: none");


Aparently something is going wrong with the qzip compression. Hope it helps someone...
5
kerkyra
Re: Is xoops having problems with a large amount of blocks-sql queries?

  • 2011/7/22 12:37

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


i also noticed a big difference in loading times by doing that! my sites now actually run faster! is that logical?
6
Yurdal
Re: Is xoops having problems with a large amount of blocks-sql queries?

  • 2011/7/22 12:46

  • Yurdal

  • Friend of XOOPS

  • Posts: 386

  • Since: 2005/3/27


i remember there where some problesm with the gzip function on old xoops core but i thought it was fixed
I dont have any problems with my websites (all 2.4.5 and 2.5.1a) but i made the tweak you described here and im not sure if it loads faster but i feel it is some faster, can another people confirm this ?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

448 user(s) are online (354 user(s) are browsing Support Forums)

Members: 0

Guests: 448

more...

Donat-O-Meter

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

Latest GitHub Commits