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?
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
Members Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login Now