Changing the db prefix breaks installation

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
Forum rules
READ: Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
User avatar
Code Contributor
Posts: 1157
Joined: Wed Oct 12, 2011 11:46 pm
Location: Madrid, Spain
Name: Javier

Changing the db prefix breaks installation

Post by javiexin »


I have recently installed a new development forum using 3.1.3, and I found an annoying bug that made me waste a very long time, that would not like others to suffer from.

The issue is with the DB table prefix. Specifically, if during the installation process, you change the default prefix phpbb_ to something longer (in my case it was just phpbb3_ for historical reasons in my forum), then the installation process fails giving a very unclear error as to the cause of this. The exact error given I don't remember, and I don't have it handy now, but it was something like "Index name too long" on the un_mtch index for the search_wordmatch table.

So, my request that there should be some provision in the installation process to block this issue from happening, like giving a warning/error when the prefix is longer that expected, or at the very least showing this as a limitation in the associated field comments text (_EXPLAIN language description).

Another (better) alternative would be to allow for longer identifiers, or for the core to not exhaust the identifier length.

Thanks in advance,

PD: I do not have access to the bugtracker, so if someone wants to open an issue there, please go ahead.
User avatar
Support Team Member
Support Team Member
Posts: 23055
Joined: Fri Aug 29, 2008 9:49 am

Re: Changing the db prefix breaks installation

Post by Mick »

javiexin wrote:I do not have access to the bugtracker
"The more connected we get the more alone we become" - Kyle Broflovski©
User avatar
Lumpy Burgertushie
Registered User
Posts: 68543
Joined: Mon May 02, 2005 3:11 am

Re: Changing the db prefix breaks installation

Post by Lumpy Burgertushie »

or, when you get the error simply change the table prefix to a shorter one.

I agree the error message could be better.

and, I think this is basically a problem with your database settings not allowing more than x number of characters, not a problem with phpbb not allowing it.

I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.

Return to “[3.1.x] Support Forum”