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

[Boomer]

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?

Hello Nick.

First of all, thank you for your great mod.

I have a problem similar to the one experienced by the opening poster but my error says that "the maximum is 42 characters".

My gallery is at version 1.0.6 (I updated from 1.0.0 last month) and I was trying to update to version 1.1.0 (only when I came here did I realize that I could update directly to version 1.1.1 and then to 1.1.5 ). When I ran the update script, I received the "index name" "too long" "general error" (same table: gallery_rates).
You wrote that the problem has been fixed in version 1.1.1.
Is this also the case when the index name is 48 characters long?

[nickvergessen]

Just use the 1.1.5 file to update the database. That should work.

[Boomer]

Thank you for your reply Nick.

Since I was using such an old Gallery version, I decide to proceed in steps.
Anyway, the problem I described before did not occur when I upgraded from 1.0.6 to 1.1.1.

I then upgraded to version 1.1.5 when I saw that everything was working fine.

Thanks again.