Forum Support

 
Advanced Search


New Posts
FAQs for Wordpress
If you have a question about Wordpress products please read through a list of our most commonly asked questions here.
[1]

Offline kpd10435
Free Member
Posts: 3

I am now getting the following errors from the main menu/flexmenu after importing some pages/content from Joomla:

WORDPRESS DATABASE ERROR: [UNKNOWN COLUMN 'TH.METAVALUE' IN 'WHERE CLAUSE']
SELECT C.META_VALUE FROM WP_POSTMETA AS C, WP_POSTMETA AS TH WHERE C.META_KEY = '_MENU_ITEM_OBJECT_ID' AND C.POST_ID = TH.METAVALUE AND TH.META_KEY= '_MENU_ITEM_MENU_ITEM_PARENT' AND TH.POST_ID = 15
NOTICE: UNDEFINED OFFSET: 0 IN /VAR/WWW/M4DTEST.M4DGAMING.COM-80/HTDOCS/WP-CONTENT/THEMES/S5_HEXICON_GAMER/VERTEX/FLEX_MENU/FLEXMENU.WALKER.PHP ON LINE 18 NOTICE: UNDEFINED OFFSET: 0 IN /VAR/WWW/M4DTEST.M4DGAMING.COM-80/HTDOCS/WP-CONTENT/THEMES/S5_HEXICON_GAMER/VERTEX/FLEX_MENU/FLEXMENU.WALKER.PHP ON LINE 26
WORDPRESS DATABASE ERROR: [UNKNOWN COLUMN 'TH.METAVALUE' IN 'WHERE CLAUSE']
SELECT C.META_VALUE FROM WP_POSTMETA AS C, WP_POSTMETA AS TH WHERE C.META_KEY = '_MENU_ITEM_OBJECT_ID' AND C.POST_ID = TH.METAVALUE AND TH.META_KEY= '_MENU_ITEM_MENU_ITEM_PARENT' AND TH.POST_ID = 16
NOTICE: UNDEFINED OFFSET: 0 IN /VAR/WWW/M4DTEST.M4DGAMING.COM-80/HTDOCS/WP-CONTENT/THEMES/S5_HEXICON_GAMER/VERTEX/FLEX_MENU/FLEXMENU.WALKER.PHP ON LINE 18 NOTICE: UNDEFINED OFFSET: 0 IN /VAR/WWW/M4DTEST.M4DGAMING.COM-80/HTDOCS/WP-CONTENT/THEMES/S5_HEXICON_GAMER/VERTEX/FLEX_MENU/FLEXMENU.WALKER.PHP ON LINE 26

I have tried removing / reinstalling the theme, modifying my menu etc...  I cannot figure out what is causing that error. Any help would be appreciated.
Logged

Offline Tristan Rineer
Free Member
Posts: 3858

It is very possible that whatever tool you used to do the import ended up causing some corruption in the database.

The first thing I would suggest doing is creating a new custom menu and assigning that as your site menu.  If that works, you can just recreate your menu structure.

You can also force WP to run the built in database repair process (Tutorial), and if that doesn't work, there are a handful of database repair and optimization plugins you can try (just search for database repair on the plugin install screen).

Unfortunately, there is a possibility that the Joomla import caused permanent damage to the database, but your best option is probably assigning a new site menu.
Logged

Offline kpd10435
Free Member
Posts: 3

Yeah I fixed it, thanks!
Logged
[1]

Jump to:  


Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Page created in 0.023 seconds with 22 queries.
Need some help getting your site up and running? Be sure to check out our tutorials area, post on the forum or hire us
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.