I'm using SMF 2.0.17.

My SMF is using ISO-8859-1 (Latin1), so my default collation in the database is latin1_swedish_ci (in case it matters); but the SMF Arcade tables created has automatically been set to utf8_mb4_0900_ai_ci.

I have tested using the arcade database purge tool, and then trying to install the arcade again, but still the same error message.

The two created tables smf_arcade_pdl1 and smf_arcade_pdl2 show as MyISAM, and both have the collation utf8_mb4_0900_ai_ci. Neither have any indexes apart from PRIMARY KEY.


Is there any way of finding out which table and index the error message is referring to? "Specified key was too long" obviously imply that some index key was too long, but I have no idea which one. But I can only assume it must be a more complicated one than just a primary key.

Sorry, with that file I get almost the same error, but a different line number:

Specified key was too long; max key length is 1000 bytes
File: /var/www/html/forum/Packages/temp/arcadeinstall/Subs-Install.php
Line: 52

The same error both with existing e-Arcade tables and with no arcade related tables. Any ideas?

SMF Arcade seems excellent, but unfortunately I can't manage to install it. The test in the Package Manager shows no warnings or errors, but when I click on Install Modification I keep getting the following error:

QuoteSpecified key was too long; max key length is 1000 bytes
File: /var/www/html/forum/Packages/temp/arcadeinstall/Subs-Install.php
Line: 34

I first thought it had something to do with switching from e-Arcade, but I have now deleted all old tables from e-Arcade and still gets the same error. So no matter what I do, I can't get past that error message, and nothing gets installed

When I look at the database after getting that error, only smf_arcade_pdl1 and smf_arcade_pdl2 has been created and no other tables.

Any idea why that is, or how to resolve the issue? I'm running PHP 7.4.11 and MySQL 8.0.22 under Ubuntu 20.04.

I have executed the E-Arcade to SMF Arcade conversion tool with no problems, but now when I try to install SMF Arcade I get the following error:

"Specified key was too long; max key length is 1000 bytes
File: /var/www/html/forum/Packages/temp/arcadeinstall/Subs-Install.php
Line: 34

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php."

What does that mean, and how do I resolve this?

Quote from: Chen Zhen on November 03, 2020, 06:41:17 PMGamepacks are in the download section.
Click on "Downloads" from the navigation bar and you will find many gamepacks.
Some of the latter ones contain HTML5 games and should state what type they are in the download details/description.

Thank you. I can see it now, although I could have sworn that category wasn't there when I checked yesterday...

Quote from: Chen Zhen on November 02, 2020, 11:59:59 AMThe older games you have are swf flash which will no longer be supported in mainstream browsers starting. Dec.31 2020.

HTML5/JavaScript games are the new norm.

I'm well aware of that, and it's very unfortunate. It's of course positive from a security point of view, but the problem is that the vast majority of Flash games most likely will never be ported to HTML5.

Are there any gamepacks available with HTML5 games compatible with SMF Arcade? The only thing I can find is to download individual games, which normally would be preferable - but if it's not possible to transfer everything from e-Arcade so I have to start all over, then it would be useful with a reasonably sized pack of decent games, in order for the arcade not to be completely empty at the beginning.

I can see old posts on this forum referring to gamepacks downloadable here, but I can't seem to find any such - nor can I find any gamepacks on the other web sites linked to either.

Thank you. I see that the new version of SMF Arcade has been released now, so I will make a backup of the database and try out the tool - hopefully it still works, so that the games and scores can be kept from e-Arcade.

Does this converter tool still work for the current version of SMF Arcade, or is there a newer one somewhere?

I have been using E-Arcade Beta4-SMF2 (with SMF 2.0.17) up until now, but would very much like to switch to the latest version of SMF Arcade - of course retaining all current games and high scores. So can I do that with the tool in this thread, or have tables used by SMF Arcade changed since then (so that the tool doesn't work these days)?

Considering the thread is from 2013, I thought I'd better ask before doing anything...