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.
Get Involved
Forum rules
READ: phpBB.com 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.
Locked
User avatar
javiexin
Code Contributor
Posts: 1157
Joined: Wed Oct 12, 2011 11:46 pm
Location: Madrid, Spain
Name: Javier
Contact:

Changing the db prefix breaks installation

Post by javiexin »

Hello,

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,
-javiexin

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

Re: Changing the db prefix breaks installation

Post by Mick »

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

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.


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?
Locked

Return to “[3.1.x] Support Forum”