Notifications
Clear all

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

6 Posts
3 Users
2 Likes
2,679 Views
Posts: 56
Topic starter
(@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)
Joined: 8 years ago

Noble Member
Posts: 1602

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

 

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

 

 

Robert
Posts: 10478
Admin
(@robert)
Support Team
Joined: 8 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.

Posts: 56
Topic starter
(@glowball)
Trusted Member
Joined: 7 years ago

Thanks for the link, Anonymous20, a search didn't turn anything up.  Very helpful.  Good luck to you!

Posts: 1602
(@anonymous20)
Noble Member
Joined: 8 years ago
Posted by: Glowball

Thanks for the link, Anonymous20, a search didn't turn anything up.  Very helpful.  Good luck to you!

Can you do me a favor ? Does Subscribe to a Topic works for you (in your site i mean) ?

Posts: 56
Topic starter
(@glowball)
Trusted Member
Joined: 7 years ago

Yes, it does.  I haven't had any issues with that functionality.