[Resolved] Data too long for column 'option_name'
We keep getting a bunch of these in our error log every time I load the network plugins page, network themes page, but NOT for the sites page. Which, I assume, is because caching wasn’t implemented for that page.
The plugin appears to be working just fine, it’s just cluttering our error logs.
I googled the general error and it was suggested to check the table collation type, but it was already utf8_general_ci like it should be.
I also found that the option_name field is varchar(64) and all of the values being inserted are longer than that. So that seems the be the problem, but I’m not sure how you’d want to handle that. Hope this is helpful.
Is anyone else seeing this in their logs?
[04-Jan-2013 21:08:49] WordPress database error Data too long for column 'option_name' at row 1 for query INSERT INTO 'wp_options' ('option_name', 'option_value', 'autoload') VALUES ('_transient_timeout_networkauditor_plugin_email-alerts/email-alerts.php', '1357337329', 'no') ON DUPLICATE KEY UPDATE 'option_name' = VALUES('option_name'), 'option_value' = VALUES('option_value'), 'autoload' = VALUES('autoload') made by require('C:\htdocs\webminis.tyndale.com\wp-admin\plugins.php'), WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Plugins_List_Table->display_rows, WP_Plugins_List_Table->single_row, do_action('manage_plugins_custom_column'), call_user_func_array, NetworkPluginAuditor->manage_plugins_custom_column, NetworkPluginAuditor->is_plugin_active_on_blogs, set_transient, add_option</p>
There is NOT an error for every plugin on our network, but I’d say most of them seem to be generating values that are too big.
Another thing to note is that we only get one error logged for the themes page. If it’s helpful, the value being inserted is:
- The topic ‘[Resolved] Data too long for column 'option_name'’ is closed to new replies.