Page 1 of 1

My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:01 pm
by gch5185

Code: Select all

SQL ERROR [ mysql4 ]

Got error 28 from storage engine [1030]

SQL

SELECT l.*, f.* FROM phpbb_profile_lang l, phpbb_profile_fields f WHERE l.lang_id = 1 AND f.field_active = 1 AND f.field_no_view = 0 AND l.field_id = f.field_id ORDER BY f.field_order

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_profile_fields.php
LINE: 218
CALL: dbal_mysql->sql_query()

FILE: includes/functions_profile_fields.php
LINE: 370
CALL: custom_profile->build_cache()

FILE: viewtopic.php
LINE: 1294
CALL: custom_profile->generate_profile_fields_template()

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:03 pm
by gch5185
This is urgent. Please provide me a solution asap. Thanks.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:06 pm
by KevC
Well bumping after 2 minutes doesn't help.

In that 2 minutes you could have used search and found out that you need to contact your hosts.
Your database is running out of space.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:25 pm
by gch5185
Is there any way how to reduce my database?

I found something in my control panel. Fulltext mysql and Fulltext native (active). Can you explain which one do we use?

Are you the error above has something to do with the size of database? I checked in my cPanel. The size of my database is 200MB at first. After that, I had deleted my search indexes and the size has been shrunk to 130MB. Yet, the error is still there. :(

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:28 pm
by KevC
You can EMPTY (not DROP) the contents of the search tables but that will only help for so long and it will stop everyone finding any results by searching.

Ultimately you need to talk to your hosts.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:36 pm
by gch5185
Yes, I know the effect of that action. For your information, I have removed the indexes, yet the error is still there. Before this, the database size is 200MB and I had reduced it to 130MB. I am still receiving the error. :roll:

I don't like to talk to my host, they are not good in support. :/

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:38 pm
by stevemaury
It has nothing to do with the size of YOUR database - it has to do with the available disk space on your host's MySQL server. Contact them. Nothing we can do.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:43 pm
by gch5185
stevemaury wrote:It has nothing to do with the size of YOUR database - it has to do with the available disk space on your host's MySQL server. Contact them. Nothing we can do.
Are you sure with the statement above? If it is true, I wanna make them to taste my fist. Lame hosting. :evil:

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 5:45 pm
by Pit$Bull
We cannot really recommend a host, but we do recommend that you visit WebHostingTalk

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 6:04 pm
by gch5185
Thank you for lending me helping hands, my friends. Appreciate that. :)

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 6:14 pm
by gch5185
Wait a second, I have something to add.

Example, http://www.domain.com is my main forum and I have http://www.seconddomain.com pointing to the same database of my first forum. They are actually one database with two interfaces.

Allow me to elaborate my problem. Every time I browse viewtopic, viewprofile or anything related to profiles and users, the error will show up. On the other hand, this error doesn't appear in my seconddomain. How can this be?

Anyway, the error is inconsistent. It will happen every 5 to 10 minutes, then it will be okay for a few minutes, after that it will happen again. Hmmm.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 6:46 pm
by stevemaury
You need to contact your host. Something is funky with its MySQL server.

Re: My forum has encountered a problem.

Posted: Sat Jan 23, 2010 9:14 pm
by Lumpy Burgertushie
please stop arguing about it.

it is not a phpbb problem , it is a problem with the database server that your account is on.

there are probably hundreds of other accounts on that server as well.

CONTACT your HOST.


good luck,
robert

Re: My forum has encountered a problem.

Posted: Sun Jan 24, 2010 6:35 am
by gch5185
Thank you and sorry. :)