an
groups-icon

Recurring database error

Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    Arthur Mayer
    0 points
    Beginner

    Hi. The website is https://agro-anunt.ro
    Had the the old 6.6.x versions on it, then upgraded to 8.x (made more than 3 upgrades as I remember)
    Since upgrading to the 8.x (8.1, 8.2) versions I get this error:

    [18-Jun-2015 08:36:29 Europe/Bucharest] Eroare bază de date WordPress Unknown column ‘t1.meta_key’ in ‘where clause’ pentru interogarea SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%%’) OR (wp_posts.post_content LIKE ‘% %’))) AND (wp_posts.post_password = ”) AND wp_posts.post_type = ‘listing_type’ AND (wp_posts.post_status = ‘publish’) AND t1.meta_key = ‘map-lat’ AND t1.meta_value != ” AND t2.meta_key = ‘map-log’ AND t2.meta_value != ” ORDER BY distance desc LIMIT 0, 8 efectuată de require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    (Let me translate the first few lines for you, it’s in romanian I don’t think you understand it:

    Database error WordPress Unknown column ‘t1.meta_key’ in ‘where clause’ for the interogation SELECT SQL_CALC_FOUND_ROWS an_posts.ID FROM an_posts WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%%’) OR …… LIMIT 0, 8 made by require(‘wp-blog-header.php’), …
    )

    So, I’ve looked at wp_posts and there is no t1.meta_key. Should I instantiate it (and if so what’s the parameters) or is there something to be changed in the code?

    Note: now I have version 8.2 on this website, version 8.3 hadn’t appeared in upgrades yet on the site (but installed it on another and it works great)
    Also wp_posts has another start, not wp_, but I think that shouldn’t be a problem….

    Also on a side note, I observed a change in the database composition, some MyISAM tables are now created as INNODB on a fresh install. Should have I had that changed also after upgrade, providing that I have a comparison chart looking at those tables with PHPMyAdmin?

    Thank you

    June 18, 2015 at 6:32 am
  • Arthur Mayer
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    June 18, 2015 at 7:45 am
  • Mark Fail
    11,848 points
    Platinum User
    Bronze User Silver User Gold User Platinum User Helpful Award Fast Responder Thank You Coffee Villian Award Video Testimonial
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    June 18, 2015 at 11:40 am
  • Arthur Mayer
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    June 19, 2015 at 6:19 am
  • Graham Clipson
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    August 15, 2016 at 7:10 pm
  • -2 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    August 16, 2016 at 10:57 am
  • Graham Clipson
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    August 16, 2016 at 12:12 pm
  • -2 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    August 16, 2016 at 12:16 pm
  • Graham Clipson
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    August 16, 2016 at 12:38 pm
  • Arthur Mayer
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    December 16, 2016 at 8:34 am

521

Views

9

Replies