Shape 5

Wordpress Club Themes => Hexicon Gamer - Club => : kpd10435 May 26, 2013, 11:40:07 PM



: Database error message after trying to import posts from joomla
: kpd10435 May 26, 2013, 11:40:07 PM
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.


: Re: Database error message after trying to import posts from joomla
: Tristan Rineer May 27, 2013, 06:37:58 AM
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 (http://teck.in/how-to-repair-optimize-wordpress-database.html)), 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.


: Re: Database error message after trying to import posts from joomla
: kpd10435 May 28, 2013, 01:42:39 PM
Yeah I fixed it, thanks!