Index name ... on table ... is too long. The maximum is 24 c

[JirkaX]

Gallery Version: 1.1.0
phpBB Version: 3.0.9
Gallery-Link: http://www.belariepark.cz/gallery/index.php


Error description and message
Hi, when I tried to update my gallery from 1.0.6 to 1.1.0, I got this error: Index name 'phpbb_gallery_rates_rate_image_user' on table 'phpbb_gallery_rates' is too long. The maximum is 24 characters.
Could you help me with that?

[mixis]

Gallery Version: 1.1.0
phpBB Version: 3.0.9
Forum-Link: http://www.germes.ws/forum

The same problem...
when I tried to install my gallery I got this error:
Index name 'phpbb_gallery_users_pg_palbum_id' on table 'phpbb_gallery_users' is too long. The maximum is 24 characters.

[jsbean]

Had exact same problem on a quickinstall board when i tested this, until the mod is validated at phpbb.com, im gonna hold off from updating.

[nickvergessen]

I'm looking into it.

[nickvergessen]

Okay, so the problem is, I only installed the new version on phpbb 3.0.8 and seems like all the 50 beta downloads did only do that or an update aswell...

So here is a current work around solution, until I found a proper fix for this:

1. Do the normal file edits
2. Upload edited and new files
3. Upload includes/db/db_tools.php from 3.0.8:
   

   3.0.8_includes_db_db_tools.php.zip

   (10.66 KiB) Downloaded 91 times

4. Run the install/
5. Upload includes/db/db_tools.php from 3.0.9:
   

   3.0.9_includes_db_db_tools.php.zip

   (11.75 KiB) Downloaded 90 times

6. Do the rest of the DYI-Instructions from the manual

1. Die normalen Dateiänderungen machen
2. geänderte und neue Dateien hochladen
3. includes/db/db_tools.php aus 3.0.8 hochladen:
   

   3.0.8_includes_db_db_tools.php.zip

   (10.66 KiB) Downloaded 91 times

4. Das install/ Verzeichnis aufrufen.
5. includes/db/db_tools.php aus 3.0.9 hochladen:
   

   3.0.9_includes_db_db_tools.php.zip

   (11.75 KiB) Downloaded 90 times

6. Den Rest der Manuellen Vorgänge durchführen

[JirkaX]

Thanks, workaround works fine. But I have another issue - instead of all pictures I have "=>X" - see here: http://www.belariepark.cz/gallery/index.php
Do you know where the problem is?

[nickvergessen]

Please open a new topic, as I want to keep this for the install/update issue, thanks.

[preilly1205]

I am still getting the following error even after replacing the db_tools file.

General Error

Index name 'phpbb_gallery_users_pg_palbum_id' on table 'phpbb_gallery_users' is too long. The maximum is 24 characters.

[nickvergessen]

This is impossible, but please try 1.1.1

[nickvergessen]

Unstickied as it is fixed in 1.1.1