ATTENTION, PLEASE READ: New topic creation is disabled, as we have moved to a new support system. Your existing topics will remain, but for all new requests you will need to use the new system. Click here to go to the new support request form.

• Back to forum

  Posted in: Cardinal
• August 22, 2014 at 7:01 pm #103437
  torb

  Member

  Post count: 317

  When using orderby=popularity, this error occurs:

  WordPress database error: [Unknown column ‘rnp_postmeta.meta_value’ in ‘order clause’]

  Any idea why?

  August 22, 2014 at 7:10 pm #103438
  torb

  Member

  Post count: 317

  When changing to another theme, the error disappears. When changing back to Cardinal, the error is back again.

  August 24, 2014 at 11:19 pm #103619
  Swift Ideas – Ed

  Keymaster

  Post count: 15264

  Hi @torb,

  Looks like you’ve got a different theme active? I’ve personally not seen this issue before, and nothing in the theme would cause it as far as I’m aware. If you can re-enable Cardinal I’ll happily take a look.

  – Ed

  August 24, 2014 at 11:24 pm #103620
  torb

  Member

  Post count: 317

  Re-enabled. But as you can see, I have another issue: The first half of the page is not shown (including the shop)….

  August 24, 2014 at 11:54 pm #103632
  Swift Ideas – Ed

  Keymaster

  Post count: 15264

  Can you please enable WP_DEBUG in wp-config.php? Looks like either you have corrupted files (did you make any template changes?) else plugins have caused issues here – this isn’t an issue with the theme.

  – Ed

  August 25, 2014 at 7:47 am #103707
  torb

  Member

  Post count: 317

  This reply has been marked as private.
  August 25, 2014 at 9:03 pm #103883
  Rui Guerreiro – SUPPORT

  Keymaster

  Post count: 25779

  Hi,

  I checked your site and it really seems that some file is corrupted.
  Guess it’s better to refresh the Theme files with the latest version.

  -Rui

  August 31, 2014 at 10:17 am #105568
  torb

  Member

  Post count: 317

  Hi,

  I am still getting this error. I have reinstalled the Cardinal theme.

  When I switch to another theme the error disappears, to reappear when going back to Cardinal. It seems Cardinal is the only theme with this problem.

  WordPress database error: [Unknown column ‘rnp_postmeta.meta_value’ in ‘order clause’]
  SELECT rnp_posts.* FROM rnp_posts WHERE 1=1 AND rnp_posts.post_type = ‘galleries’ AND (rnp_posts.post_status = ‘publish’ OR rnp_posts.post_status = ‘private’) AND rnp_posts.post_password = ” ORDER BY rnp_postmeta.meta_value+0 DESC, rnp_posts.post_date DESC

  Any ideas?

  September 1, 2014 at 9:58 pm #105982
  Rui Guerreiro – SUPPORT

  Keymaster

  Post count: 25779

  Hi,

  I’m not seeing the error at the moment? Did you turned of anything?

  -Rui

  September 2, 2014 at 6:34 am #106100
  torb

  Member

  Post count: 317

  No, I can see someone has deactivated WooCommerce, but the error i still there when I reactivate it.

  September 2, 2014 at 9:45 am #106198
  torb

  Member

  Post count: 317

  And with the latest update of the theme, I get this:

  WordPress database error: [Unknown column ‘rnp_postmeta.meta_value’ in ‘order clause’]
  SELECT rnp_posts.* FROM rnp_posts WHERE 1=1 AND rnp_posts.post_type = ‘galleries’ AND (rnp_posts.post_status = ‘publish’ OR rnp_posts.post_status = ‘private’) AND rnp_posts.post_password = ” ORDER BY rnp_postmeta.meta_value+0 DESC, rnp_posts.post_date DESC
  WordPress database error: [Unknown column ‘rnp_postmeta.meta_value’ in ‘order clause’]
  SELECT rnp_posts.* FROM rnp_posts WHERE 1=1 AND rnp_posts.post_type = ‘spb-section’ AND (rnp_posts.post_status = ‘publish’ OR rnp_posts.post_status = ‘private’) AND rnp_posts.post_password = ” ORDER BY rnp_postmeta.meta_value+0 DESC, rnp_posts.post_date DESC

  September 2, 2014 at 11:12 am #106283
  Rui Guerreiro – SUPPORT

  Keymaster

  Post count: 25779

  Hi Torb,

  I already managed to replicate this situation in my WordPress Instalation.
  Will update this as soon has we found the issue.

  -Rui

  September 13, 2014 at 7:47 am #110301
  torb

  Member

  Post count: 317

  Any solution to this? Still having the error.

  September 13, 2014 at 7:53 am #110302
  torb

  Member

  Post count: 317

  This reply has been marked as private.
  September 13, 2014 at 7:55 am #110303
  torb

  Member

  Post count: 317

  This reply has been marked as private.
• Back to forum

  Posted in: Cardinal