August 8, 2011 at 8:17 am #5356
After updating WordPress to 3.2.1 and moving database to mysql 5.1 all menu items and slider images dissapeared. All data is still in the tables. Trying to add a new menu item or slider image fails without any error. Can you help me?August 8, 2011 at 11:50 am #49843
it’s really hard to say why the database/wp update broke the theme settings. I’d delete the display options table and reconfigure the theme settings. If you need to clear the menu(s) option table too you need to search for the “menu_order” table. More information can be found here: http://codex.wordpress.org/Database_Description#Table:_wp_posts , http://codex.wordpress.org/Database_Description and http://codex.wordpress.org/images/9/9e/WP3.0-ERD.pngAugust 8, 2011 at 1:15 pm #49844
Just FYI, I’m having the same problem. After we moved over to a Linux platform from windows and using mysql 5.1, the frontpage slider stopped working altogether. No error message, and when I try to configure it and save the results, I get back the normal “saved” message.August 8, 2011 at 1:19 pm #49845August 8, 2011 at 1:39 pm #49846
Ok so to add more detail Cu3er quit working months ago and have been using the jquery transitions. I have also tried to use the config.xml file without any luck. Its contents are also not showing up…
If I delete my display options table like you mentioned above, how could I get it back? Will the theme re-install it from scratch? I didn’t think so but I’m willing to try anything…August 8, 2011 at 3:19 pm #49847
Kriesi uses the inbuild wordpress option management – basically WordPress should recreate all necessary database entries. I’d backup the db first though.August 8, 2011 at 3:56 pm #49848August 8, 2011 at 4:14 pm #49849
That worked!!!!! Awesome job and for some reason, that also fixed cu3er. Just drop the table in mysql, and go back to display options and add the missing slides. Dude was right, the table was automatically recreated! Thanks for your help!!!!!!!!!!!!!August 8, 2011 at 5:07 pm #49850August 9, 2011 at 7:10 am #49851
I followed your instructions to drop the option tables and have the tables recreated when adding new items. Looked at the table names after they were recreated and found that the new table names are wp_Display_slider_menu and wp_Display_main_menu with upper case D in Display. The old tables had lower case d i display. So I dropped the new tables, altered the backupscript to create the tables with upper case D and now everything is back again.
Cause of error:
My new mysql server runs under linux but my old is under windows. The error was caused by the move of the database to a linux based mysql server where case matters, where as it doesn’t matter under windows. This error could have been avoided by the programmer simply by not using upper case D in the table names. None of the other tables in wp contains any upper case in its name and therefore work cross plattform.
Thank you for pointing me in the right directions and for a quick response.August 9, 2011 at 7:41 am #49852
Thanks for pointing this out. I’ll report it to Kriesi so that we can avoid this problem with upcoming themes :)August 15, 2011 at 8:16 pm #49853
Thanks for the notice! Since this only happens with legacy version of our themes (ones that dont use the wordpress menu manager) I dont think that a fix will be released, but its definitley good to know that we need to be carefull whenever we want to create additional database tables in the future :)
The topic ‘Menu items and Front page slider empty after update.’ is closed to new replies.