Forum Support

Shape 5
March 28, 2024, 03:15:55 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Database error message after trying to import posts from joomla  (Read 725 times)
kpd10435
Jr. Member
**
Offline Offline

Posts: 3



« on: 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.
Logged
Tristan Rineer
Global Moderator
*****
Offline Offline

Posts: 3858

Gravatar


« Reply #1 on: 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), 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

Tristan Rineer
------------
Shape 5 Team



- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
kpd10435
Jr. Member
**
Offline Offline

Posts: 3



« Reply #2 on: May 28, 2013, 01:42:39 PM »

Yeah I fixed it, thanks!
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
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.