Can't Install phpBB on localhost!

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
amir_rezas
Registered User
Posts: 2
Joined: Tue Feb 10, 2015 3:42 pm

Can't Install phpBB on localhost!

Post by amir_rezas »

Hello

I did all complete until advance settings !
and I get this error when I want to skip advance setting


General Error
Index name 'phpbb_1search_wordmatch_un_mtch' on table 'phpbb_1search_wordmatch' is too long. The maximum is 30 characters.

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 2119
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 664
CALL: phpbb\db\tools->sql_create_unique_index()

FILE: [ROOT]/install/install_install.php
LINE: 1218
CALL: phpbb\db\tools->sql_create_table()

FILE: [ROOT]/install/install_install.php
LINE: 99
CALL: install_install->load_schema()

FILE: [ROOT]/install/index.php
LINE: 409
CALL: install_install->main()

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()

please help me.
thanks

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69739
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Can't Install phpBB on localhost!

Post by KevC »

It tells you the problem in the first line.

You need to make your prefix shorter.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

amir_rezas
Registered User
Posts: 2
Joined: Tue Feb 10, 2015 3:42 pm

Re: Can't Install phpBB on localhost!

Post by amir_rezas »

That's right thanks.

phpbb_ is default value of phpBB prefix !

And I set phpbb_1 and this error occured I think it's bug.
please solve it

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22358
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Can't Install phpBB on localhost!

Post by Mick »

I've never seen that before personally, I suspect you've made a mistake with the install. If it's a new board just delete it and try the install again. Why are you messing with the default prefix, there's no need to unless you already have a board on the same database with that prefix?
"The more connected we get the more alone we become" - Kyle Broflovski©

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69739
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Can't Install phpBB on localhost!

Post by KevC »

amir_rezas wrote:That's right thanks.

phpbb_ is default value of phpBB prefix !

And I set phpbb_1 and this error occured I think it's bug.
please solve it
It's not a bug.

Your hosts have a 30 character limit on field names.

This field name 'search_wordmatch_un_mtch' is 24 characters long.
That leaves you 6 characters for the prefix.
phpbb_ is 6 characters.

You added an extra digit to make it 7 characters long and your hosts gave you a message telling you that.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
Lumpy Burgertushie
Registered User
Posts: 67420
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Can't Install phpBB on localhost!

Post by Lumpy Burgertushie »

you could just remove a letter or change the phpbb_ to yoyo_ or no _ etc. it does not matter what the prefix is as long as it is different from any other prefixes used in that database and as long as it is under a total of 30 characters ( as per your host's requirements ). you don't even have to have a prefix at all if phpbb is all that is in that database.


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.0.x] Support Forum”