{"id":10002411,"date":"2018-02-22T10:43:03","date_gmt":"2018-02-22T10:43:03","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-122\/"},"modified":"2018-02-22T10:43:03","modified_gmt":"2018-02-22T10:43:03","slug":"wordpress-database-error-122","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wordpress-database-error-122\/","title":{"rendered":"WordPress database error"},"content":{"rendered":"<p>Hello,<\/p>\n<p>i am using the plugin with a custom argument.<br \/>\nMy SQL code is:<br \/>\n<strong>SELECT date,value FROM wp_userperf WHERE <code>user<\/code>={arg1}<\/strong><\/p>\n<p>and my shortcode is:<br \/>\n<strong>[gvn_schart_2 id=&#8221;679&#8243; arg1=&#8221;username&#8221;]<\/strong><\/p>\n<p>If enter this query in the MySQL console i get the correct table, but displaying the shortcode in wordpress gives me:<br \/>\n<strong>WordPress database error: [Unknown column &#8216;username&#8217; in &#8216;where clause&#8217;]<br \/>\nSELECT date,value FROM wp_userperf WHERE <code>user<\/code>=username<\/strong><\/p>\n<p>I tried different combinations, but i dont get any chart. What&#8217;s the problem here?<\/p>\n<p>Best regards<\/p>\n","protected":false},"template":"","class_list":["post-10002411","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10002411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10002411\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=10002411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}