My forum has encountered a problem.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

My forum has encountered a problem.

Post 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()
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post by gch5185 »

This is urgent. Please provide me a solution asap. Thanks.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70180
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: My forum has encountered a problem.

Post 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.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post 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. :(
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70180
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: My forum has encountered a problem.

Post 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.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post 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. :/
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51547
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: My forum has encountered a problem.

Post 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.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post 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:
Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: My forum has encountered a problem.

Post by Pit$Bull »

We cannot really recommend a host, but we do recommend that you visit WebHostingTalk
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post by gch5185 »

Thank you for lending me helping hands, my friends. Appreciate that. :)
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post 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.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51547
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: My forum has encountered a problem.

Post by stevemaury »

You need to contact your host. Something is funky with its MySQL server.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Lumpy Burgertushie
Registered User
Posts: 68113
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: My forum has encountered a problem.

Post 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?
gch5185
Registered User
Posts: 122
Joined: Sun Nov 26, 2006 3:29 am

Re: My forum has encountered a problem.

Post by gch5185 »

Thank you and sorry. :)
Locked

Return to “[3.0.x] Support Forum”