Bill

For anyone running onto this, I also had duplicate meta entries in the database. I was getting the error "Could not update the meta value of footnotes in database" 

This is what fixed it for me.

Go to MyPHPAdmin:
Run the SQL command first to check for duplicates.  Change the "YOUR_KEY_HERE" to the error being reported, such as "footnotes" ,  After I fixed footnotes, I had another similar error, but this time it was "_kad_blocks_custom_css".  Here is an example for the fix I used for both:

"YOUR_KEY_HERE" should be replaced with the exact name of the error you are getting  (see examples below).

THIS SQL COMMAND IDENTIFIES IF YOU HAVE DUPLICATES AND HOW MANY ENTRIES ARE AFFECTED:

SELECT post_id, COUNT(*) AS c
FROM wp_postmeta
WHERE meta_key = 'YOUR_KEY_HERE'
GROUP BY post_id
HAVING c > 1;

THIS SQL COMMAND GIVES YOU A PREVIEW OF YOUR DUPLICATES (no changes made to database):

SELECT pm1.*
FROM wp_postmeta pm1
JOIN wp_postmeta pm2
ON pm1.post_id = pm2.post_id
AND pm1.meta_key = 'YOUR_KEY_HERE'
AND pm2.meta_key = 'YOUR_KEY_HERE'
AND pm1.meta_id > pm2.meta_id;

THIS IS THE ACTUAL FIX AND DELETES THE DUPLICATES  
(Backup before you do this, it will change your database):

DELETE pm1
FROM wp_postmeta pm1
JOIN wp_postmeta pm2
  ON pm1.post_id = pm2.post_id
 AND pm1.meta_key = 'YOUR_KEY_HERE'
 AND pm2.meta_key = 'YOUR_KEY_HERE'
 AND pm1.meta_id > pm2.meta_id;


For me, I had to do this whole process twice.  The first time, it was to fix the "footnotes" error, so my DELETE entry for the footnotes meta duplicates was:

DELETE pm1
FROM wp_postmeta pm1
JOIN wp_postmeta pm2
  ON pm1.post_id = pm2.post_id
 AND pm1.meta_key = 'footnotes'
 AND pm2.meta_key = 'footnotes'
 AND pm1.meta_id > pm2.meta_id;

After doing this, the footnotes error was eliminated, but I had a new error which was exactly the same except instead of footnotes, it was "_kad_blocks_custom_css", which is was from my theme.   I did the same process again:

DELETE pm1
FROM wp_postmeta pm1
JOIN wp_postmeta pm2
  ON pm1.post_id = pm2.post_id
 AND pm1.meta_key = '_kad_blocks_custom_css'
 AND pm2.meta_key = '_kad_blocks_custom_css'
 AND pm1.meta_id > pm2.meta_id;

I actually had to do this for about 6 different errors, as soon as I fixed one, a new one would occur.  AFter 6 fixes, I was good to go. FOr me, I couldn't use ACV custom fields until these DB errors were fixed.

Again, hope this helps someone

• This reply was modified 5 months, 4 weeks ago by Bill.

David, you don’t happened to have soliloquy plugin for slideshows installed, do you?
In my site, the genesis simple sidebars setting in the page editor screen (when changing the page to use a different sidebar) do not save if soliloquy is installed and activated. As soon as I deactivate soliloquy, the sidebar assignment setting will save and work as intended. (so, I just deactivate soliloquy, assign the sidebar, then activate soliloquy again, and the settings still are saved).

Hi Ron,
I=thanks for the reply. See thats just it. I did deactivate all plugins,a nd even switched tot he genesis framework as the theme (not even using a child theme) and it still doesn’t work. It worked up to the point I updated to WP 3.5

Same thing here…. I narrowed it downt to his plugin when the quote changes (using ajax)