Error pages due to large PhpBB DB file?

Involved Joined: Dec 28, 2003 Posts: 276 Location: Israel

They always ask if you're running phpbb with phpnuke, and when you answer yes, they say they do not support it. Sad

Sells PC To Pay For Divorce Joined: Posts: 5661

well then say NO !

Posted: Tue Oct 11, 2005 4:39 am

But is our phpbb exactly the same as the original? I mean, if they suggest a fix in a certain file, will it be the same as our phpnuke?

Posted: Tue Oct 11, 2005 4:43 am

most things are the same.
but i dont think they will suggest some "fix".,but something different.
Just try it and then ill advice you to contact chatserv with whatever they told you.

Posted: Sat Oct 22, 2005 12:25 pm

Dear hitwalker, please follow the link for their fixes:
http://www.phpbb.com/phpBB/viewtopic.php?p=1818449&sid=5fdd37c5ee9f962d14d742bf9e9cc215#1818449

A. In the first link, paragraph #2, they suggest a bugfix in functions_search.php. I'd like your adivce if this is a real fix, as I coul find another "$stopword_array" (with no "s") just 3 lines above the line they suggest to fix. so maybe this should be fixed as well?

B. Same link, paragraph #3. I've tried the code they gave, also have tried to change it to work with my PhpNuke, but couldn't make it work.

C. Yet have not tried their #4 paragraph, as I've yet not build the stopwords list. But I guess the code in that paragraph, will have to be changed as well, right?

D. Second link - rebuild search MOD - will this work for phpnuke with phpbb? I remember seeing somewhere someone saying it won't work with phpnuke.

TIA!

Posted: Sat Oct 22, 2005 1:32 pm

yes i read it..
well its for you to decide what to do...
But to my opinion ,if it was me i would probably choose for the search_stopwords fix.

as they believe it would help a lot..

But my problem in believing this story of you is that i know a lot of sites running on phpbb with huge databases,and compared to yours is a tiny one..

And those sites run smoothly,with no problem.
so thats why i have my doubts if this is realy the reason.
Another reason could be the performance of your server.

Posted: Sat Oct 22, 2005 1:50 pm

Let's start with the server's performance. My site it hosted at site5.com, and that's the response I've just got:
=====
I have checked server load and mysql process, everything seems to be stable. Also, I checked your site
couln't find out any slowness. Can you make sure local connection.
=====
For the other issue, my db total size is 114.3mb exactly. The nuke_bbsearch_wordmatch size alone is 60.9mb and the nuke_bbsearch_wordlist size is 7.5mb. Couldn't this be a problem?

If not, how could I check things out? Many of my users complains about error pages (404) after submitting messages. after Raven's advice to optimize the db, it dropped dramaticly, but still consists. some have rated it to occur once in 10 posts.

I myself have encoutered these problems, though I would have reated it with a lower grade.

Any idea how to proceed?

Posted: Sat Oct 22, 2005 2:03 pm

Well ill ask around at some friends with the huge databases...
Im contacting someone now...
Ill post it here.

Posted: Sat Oct 22, 2005 2:29 pm

Thanks alot, hitwalker!
I appreciate it...

Posted: Sat Oct 22, 2005 5:23 pm

well i got the first reply,as far as i understand he said its nothing...
he didnt say how large his one was but i know its huge..
but i expected that ...
for example,look at some big phpnuke sites,some of them have or had 500 to 1000 users online,think about the tables they create with searches.
a good thing would be trying to find out the server specs your site runs on.

Posted: Sat Oct 22, 2005 5:37 pm

Quote:

a good thing would be trying to find out the server specs your site runs on.

What specs exactly would you need?
Will this be enough? http://www.hagigim.com/analyze.php

Posted: Sat Oct 22, 2005 6:11 pm

please remove that file,for your own security

Posted: Sat Oct 22, 2005 6:16 pm

with specifications i mean from the server itself..
memory/ram etc...all that speed s..t
And try to find out how many pages it generates in 5 minutes..,queries etc...

Posted: Sun Oct 23, 2005 12:02 am

I hope this can help: http://67.43.15.2/~netadmin/index.php
Anyway, I've sent them an email a second ago...

Posted: Sun Oct 23, 2005 7:01 am

well it looks ok,but doesnt says much..
remember the info phpbb shows at the bottom?
The total queries?
How many pages in the last 5 minutes?...
gzip on or of?
debug on or off....etc...

Posted: Sun Oct 23, 2005 7:14 am

Quote:

remember the info phpbb shows at the bottom?
The total queries?

Sorry, I could find nothing alike. where should I find it?

Quote:

gzip on or of?

Off

Quote:

debug on or off

Off

What else?

Posted: Sun Oct 23, 2005 7:27 am

well looking at settings they use ,turn on gzip and debug,and look in your admin config whatever if you can find something like showing page generation and queries to be shown,usualy in the footer.

Posted: Sun Oct 23, 2005 7:40 am

Turning gzip on, results with this:
Warning: ob_start(): output handler 'ob_gzhandler' cannot be used twice in /home/hagigim/public_html/includes/page_header.php on line 98

Showing above every post...

Posted: Sun Oct 23, 2005 7:44 am

Also couldn't find where to turn the debug mode on, nor the option to show number of queries...

Posted: Sun Oct 23, 2005 7:47 am

well if you didnt do it already turn gzip off.

Posted: Sun Oct 23, 2005 7:50 am

well keep forgetting your not running standalone..phpbb

Posted: Sun Oct 23, 2005 7:51 am

Of course I did.
BTW, the poge_header.php relevant part is:

Code:

// gzip_compression


//


$do_gzip_compress = FALSE;


if ( $board_config['gzip_compress'] )


{


   $phpver = phpversion();





   $useragent = (isset($_SERVER["HTTP_USER_AGENT"]) ) ? $_SERVER["HTTP_USER_AGENT"] : $HTTP_USER_AGENT;





   if ( $phpver >= '4.0.4pl1' && ( strstr($useragent,'compatible') || strstr($useragent,'Gecko') ) )


   {


      if ( extension_loaded('zlib') )


      {


         ob_start('ob_gzhandler');   [color=red]<<<<<<<<<< This is line 98![/color]


      }


   }


   else if ( $phpver > '4.0' )


   {


      if ( strstr($HTTP_SERVER_VARS['HTTP_ACCEPT_ENCODING'], 'gzip') )


      {


         if ( extension_loaded('zlib') )


         {


            $do_gzip_compress = TRUE;


            ob_start();


            ob_implicit_flush(0);





            header('Content-Encoding: gzip');


         }


      }


   }


}

Posted: Sun Oct 23, 2005 7:53 am

well your server is already set to gzip i guess,so twice it will give that error..

Posted: Sun Oct 23, 2005 7:56 am

So, what next? i'm hopeless!

Posted: Sun Oct 23, 2005 8:00 am

well if i look in your forum i get ...
Cannot modify header information - headers already sent by