Page 1 of 1

The maximum is 30 characters.

Posted: Fri Apr 17, 2015 6:22 pm
by Valcaoz
I keep getting this error everytime I try to install phpBB3 software 3.1.3

Code: Select all

Index name 'forums_search_wordmatch_un_mtch' on table 'forums_search_wordmatch' is too long. The maximum is 30 characters.

Re: The maximum is 30 characters.

Posted: Fri Apr 17, 2015 6:43 pm
by KevC
Your table prefix is too long.

It needs to be 6 characters or less.
forums_ is 7

Re: The maximum is 30 characters.

Posted: Thu Sep 14, 2017 2:45 pm
by abcEzy
KevC wrote:
Fri Apr 17, 2015 6:43 pm
Your table prefix is too long.

It needs to be 6 characters or less.
forums_ is 7
Hi,

Can you help please? I've been having issues with upgrading the forum for 6 weeks now :(

I'm having the same problem, I've done some searches on google and came across this post among some others, but this one seems to be more of what I'm experiencing.

I get this:

General Error:Index name 'wwdfm_user_notifications_user_id' on table 'wwdfm_user_notifications' is too long. The maximum is 30 characters

you said it needs to be 6 or less, so... in bold above is the prefix, 6 chars... and still the error, stuck at 11%.

Could you help?

Thanks in advance :)

Re: The maximum is 30 characters.

Posted: Thu Sep 14, 2017 2:54 pm
by abcEzy

Re: The maximum is 30 characters.

Posted: Thu Sep 14, 2017 4:15 pm
by stevemaury
Post a screenshot from phpMyAdmin showing the structure of your user_notifications table.

Re: The maximum is 30 characters.

Posted: Wed Sep 27, 2017 6:02 am
by abcEzy
stevemaury wrote:
Thu Sep 14, 2017 4:15 pm
Post a screenshot from phpMyAdmin showing the structure of your user_notifications table.
HI, here ya go, sorry for the delay, been having real bad internet probs here for weeks :(

https://i.imgur.com/yFvrYa8.png

Image