{"id":3185517,"date":"2012-11-12T17:46:54","date_gmt":"2012-11-12T17:46:54","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-error-11\/"},"modified":"2016-08-20T17:31:43","modified_gmt":"2016-08-20T17:31:43","slug":"sql-error-11","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-error-11\/","title":{"rendered":"SQL error"},"content":{"rendered":"

I’ve just noticed in my PHP error log a table insert command error that occurred, I think either on installation or shortly afterwards:<\/p>\n

WordPress database error Table '[redacted].wp_wpaa_template' doesn't exist for query INSERT INTO<\/code>wp_wpaa_template(<\/code>NAME,<\/code>TYPE_ID,<\/code>CONTENT,<\/code>DESCRIPTION,<\/code>CSS,<\/code>ACTIVE) VALUES ('Product Summary', 0, '<div class="wpaa_product"><\/code><\/p>\n

… followed by what looks like should have been some html template.<\/p>\n

The table “wpaa_cache” has data, but the table “wpaa_template” has no records.<\/p>\n

Any help AVAILABLE on this?<\/p>\n

https:\/\/wordpress.org\/extend\/plugins\/wordpress-amazon-associate\/<\/p>\n","protected":false},"template":"","class_list":["post-3185517","topic","type-topic","status-closed","hentry","topic-tag-sql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3185517","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\/3185517\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=3185517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}