uberm0nkeyI was having a problem with all of my themes, that whenever I selected a different theme, I would get the following error message:
WordPress database error: [Data truncated for column 'autoload' at row 1]
INSERT INTO wp3_options (option_name, option_value, option_description, autoload) VALUES ('k2installed', 'r167', 'This options simply tells me if K2 has been installed before', '')I have several themes in my directory, but the only ones that would not produce this message are the default ones that come with WP.
I tried changing the database instance, to no effect. I deleted all of my non-default themes, re-extraced the compressed packages, also with no effect.
The strange thing is that it appears not only when I view the test site, but also in my WordPress dashboard.
I'm pretty sure I know what caused this: I went to FTP some files from my local test server to my host server, and accidentally synchronized both sites, even though at the time, the databases were totally different.
I thought upgrading from my WP 2.0.5 to 2.1.2 would repair the damage, but apparently not -- the problem persists.
Do I need to strip out WP, MySQL and everything and start from scratch?
Thanks.
