Thinking of trying punbb...

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
BellyBelly
Registered User
Posts: 68
Joined: Sun Aug 17, 2003 3:40 am
Location: Melbourne, Australia

Thinking of trying punbb...

Post by BellyBelly » Mon Feb 27, 2006 8:51 am

I don't mean to sound rude, but I am thinking of trying out punbb because I have had some ongoing issues for which I have posted in here so many times but no-one can give me an answer or one which has worked with the ongoing problems I have had.

One of the more minor ones you can see the issue posted here - I still have this problem and it's getting worse.

Secondly I still have a problem with my wordmatch tables crashing, and for years I have argued with my host Textdrive who swear black and blue that it is not them, it is phpbb. My database is a little over 300MB and crashes all the time resulting in repairs all the time and sometimes I can't even fix them with mysql they are that bad. Today for example, I almost lost everything.

Like I say, I don't mean to be rude, I have defended phpbb and questioned their servers to the enth degree but I am running out of steam and no-one seems to be able to help. I'm looking into punbb which will be a real test to see where the problem lies, but I wish I didn't have to move but my users are getting very fed up, and so are all the moderators and myself. We're growing so fast and I need a reliable setup. If anyone can offer some insight into these problems, if they are common, heard of, any fixes I will appreciate it. I don't want to downgrade anything on the server.
Kelly Zantey
Director, BellyBelly & Toys4Tikes
http://www.bellybelly.com.au | http://www.toys4tikes.com.au

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Post by karlsemple » Mon Feb 27, 2006 8:56 am

i see in that one link you have posted that geocator suggested getting your mysql logs and viewing them ....di this not shed any light on the problem? it certainly should show which queries were casuing the crash and why?
Image

BellyBelly
Registered User
Posts: 68
Joined: Sun Aug 17, 2003 3:40 am
Location: Melbourne, Australia

Post by BellyBelly » Mon Feb 27, 2006 9:04 am

They told me the errors said something about too many connections in search_wordmatch - I have emailed them for the exact error. But they are very shitty with me for all this, it takes down the mysql server everytime for their other clients too.
Kelly Zantey
Director, BellyBelly & Toys4Tikes
http://www.bellybelly.com.au | http://www.toys4tikes.com.au

m3zzr
Registered User
Posts: 435
Joined: Tue May 18, 2004 8:53 pm
Location: St. Helens, UK
Contact:

Post by m3zzr » Mon Feb 27, 2006 9:07 am

sounds like a major problem with your host.. probally over subscribed their mysql server and never take anything from a host with 100% face value...

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Post by karlsemple » Mon Feb 27, 2006 9:08 am

BellyBelly wrote: They told me the errors said something about too many connections in search_wordmatch - I have emailed them for the exact error. But they are very *beep* with me for all this, it takes down the mysql server everytime for their other clients too.



then this is nothing to do with phpbb but rather a host limitation.....
Image

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Mon Feb 27, 2006 2:25 pm

There will be the same number of connections to the search tables as any other table in PHPBB. Well, actually fewer, because it is only accessed by two actions - posting a new message, and doing a search.

And 300 MB is a relatively tiny database; just ONE database for one of our clients is 377 tables, 62,683,001 records, and 17.2 GB. They have others varying from 2 to 15 GB.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

BellyBelly
Registered User
Posts: 68
Joined: Sun Aug 17, 2003 3:40 am
Location: Melbourne, Australia

Post by BellyBelly » Tue Feb 28, 2006 2:50 am

Well the bad news is that I sent a link to one of them to see this discussion and the forum couldnt connect at the time, so they thought that was funny. How much downtime does this forum have? Or other forums of this size? I'm running repairs almost on a daily basis, sometimes several times a day. I feel stuck between a rock and a hardplace with both sides fiercely passionate that it's not them. Yet I have nothing to go on.
Kelly Zantey
Director, BellyBelly & Toys4Tikes
http://www.bellybelly.com.au | http://www.toys4tikes.com.au

p3980
Registered User
Posts: 1311
Joined: Sat Jul 23, 2005 5:02 pm

Post by p3980 » Tue Feb 28, 2006 2:55 am

This forum is near a move, so downtime is expected :D
Support Request Template <> Knowledge Base<>starfoxtj's Admin Toolkit
Member of the Unofficial Forum for phpBB.com Supporters
Image

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Tue Feb 28, 2006 5:31 am

They thought it was funny, eh? Of course, they wouldn't have known about statistics like:
Our users have posted a total of 1948349 articles
We have 236911 registered users


As p says, tomorrow is moving day, to larger quarters. :)
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

BellyBelly
Registered User
Posts: 68
Joined: Sun Aug 17, 2003 3:40 am
Location: Melbourne, Australia

Post by BellyBelly » Thu Mar 09, 2006 9:33 pm

I don't think I am going to get anywhere with them but I would like to see if there is anyway I can get more answers. I don't want to move then realise I have the same problem.

Here is the error I get requiring the repair, it comes up when you are editing - that's when you realise you have it. From memory posting new posts is fine, but editing exisiting ones does this:
Error in deleting post

DEBUG MODE

SQL Error : 1034 Incorrect key file for table 'phpbb_search_wordmatch'; try to repair it

DELETE FROM phpbb_search_wordmatch WHERE post_id IN (397421)

Line : 419
File : functions_search.php


It does this several times a day.
Kelly Zantey
Director, BellyBelly & Toys4Tikes
http://www.bellybelly.com.au | http://www.toys4tikes.com.au

~AJK~
Registered User
Posts: 1807
Joined: Fri Feb 03, 2006 7:19 pm
Location: Not sure anymore

Post by ~AJK~ » Thu Mar 09, 2006 10:08 pm

I have two ideas for you.

First, repair your tables. You may just have some db issues. Second, rebuild your search tables. Rebuilding your search tables is based on this mod: Rebuild Search MOD to recreate your search_wodlist table.

Repairing your tables is based on a fix from espicom:Note: You may have to run this tool more than once.
espicom wrote: The following program will allow you to repair all MySQL tables associated with your PHPBB system. It is probably not a good idea to leave this file on your board without putting it into a password-protected area. While it isn't "dangerous", it does lock tables during the repair operation, so someone could cause time-out errors by repeatedly calling it.

Code: Select all

<?php
// Check and repair all tables in a PHPBB structure

// verify that we're supposed to run
// change 'PX42m3' to something unique for your site, so it will only
// execute if you call it as 'http://mysite.com/fixtables.php?PX42m3=1'
if (!isset($_GET['PX42m3']))
{
	header("Location: http://127.0.0.1/");
	die();
}

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'config.php');

// connect to the database server
$db = mysql_connect($dbhost,$dbuser,$dbpasswd);
if (!$db) die("Unable to connect to database!\n");

// select the PHPBB database
mysql_select_db($dbname,$db);

// get a list of tables for this PHPBB
$tablequery = "show tables like '".$table_prefix."%'";
$tablelist = mysql_query($tablequery,$db);


// cycle through them for repair
while ($tar = mysql_fetch_array($tablelist))
{
	$tablename = $tar[0];
	// output some verbosity for comfort
	echo "Now checking and repairing table $tablename ... ";
	$repres = mysql_query("repair table $tablename");
	$result = mysql_fetch_array($repres);
	echo $result['Msg_text'] . "<br>\n";
}

?>
Save this file as "fixtables.php" in your phpbb root directory. This is the same directory where you will find "config.php". You can execute it by pointing your browser at your normal PHPBB URL and adding "/fixtables.php?" and your chosen "secret code" to the end of it. For example, if you normally visit your forum by typing "http://my.sitename.com/phpbb/", you start this process by going to the URL "http://my.sitename.com/phpbb/fixtables.php?PX42m3=1".

For a small board, the response will be pretty quick; it will take longer to run if errors are found and you have large tables.

If the "secret code" isn't on the URL line, this program will harmlessly redirect the user to a non-existant URL on their own computer. Well, it SHOULD be non-existant.. :)

(edit) Sometimes, an "Error 145" will require two repair passes to resolve. I don't know why, other than maybe the first pass does enough repair to allow the second one to finish the job.
After running this tool, if you still have questions, concerns, or even if you want to report back that it worked, please post it here in this same thread. Good luck!
If the solutions posted above worked can you add [SOLVED] to beginning the subject of your first post to help others? Click on the "EDIT" button next to your FIRST post in the thread.
Click the following: Help for Newbies | Support Request Template
No PM's Please

BellyBelly
Registered User
Posts: 68
Joined: Sun Aug 17, 2003 3:40 am
Location: Melbourne, Australia

Post by BellyBelly » Thu Mar 09, 2006 10:11 pm

Thanks! I run repairs all the time so hopefully the rebuild will help. I will ask my hubby to give it a try tonight and will let you know how I go. Thanks so much, I really want to resolve this issue and hopefully not move!!! (which I am practically being forced to do!)
Kelly Zantey
Director, BellyBelly & Toys4Tikes
http://www.bellybelly.com.au | http://www.toys4tikes.com.au

Locked

Return to “2.0.x Support Forum”