wpForo 1.x.x [Closed] Database error: specified key was too long

How-to and Troubleshooting

Last Post by Glowball 7 years ago

6 Posts

3 Users

2 Reactions

2,979 Views

RSS

Posts: 56

Glowball

Topic starter

Jan 17, 2018 12:27 am

(@glowball)

Trusted Member

Joined: 7 years ago

I received this error. Is there something I need to do to the subscribes table? This happened when I was not working on the site or doing upgrades -- can you confirm that this is an upgrade and not malicious? Thanks!

WordPress database error Specified key was too long; max key length is 1000 bytes for query ALTER TABLE `td_wpforo_subscribes` ADD UNIQUE KEY `fld_group_unq`( `itemid`, `type`, `userid`, `user_email` ) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wpforo_update, wpforo_activation

5 Replies

1 Reply

Anonymous20

(@anonymous20)

Joined: 9 years ago

Noble Member

Posts: 1602

Jan 17, 2018 1:08 am

Reply to

Glowball

Welcome to my nightmare (just kidding), as Alice Cooper sing:

https://wpforo.com/community/how-to-and-troubleshooting-2/db-errors/

Posts: 10591

Robert

Admin

Jan 17, 2018 6:59 am

(@robert)

Support Team

Joined: 9 years ago

As I've already mentioned you can ignore this error. This is a one time error. This says one index in subscription table is not created. It's just an extra key for more convenient data storing, and it doesn't affect any function so you can forget about that without any worry.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.