Title: SQL error
Last modified: August 20, 2016

---

# SQL error

 *  [sadhaka](https://wordpress.org/support/users/sadhaka/)
 * (@sadhaka)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/sql-error-11/)
 * I’ve just noticed in my PHP error log a table insert command error that occurred,
   I think either on installation or shortly afterwards:
 * `WordPress database error Table '[redacted].wp_wpaa_template' doesn't exist for
   query INSERT INTO`wp_wpaa_template`(`NAME`,`TYPE_ID`,`CONTENT`,`DESCRIPTION`,`
   CSS`,`ACTIVE`) VALUES ('Product Summary', 0, '<div class="wpaa_product">`
 * … followed by what looks like should have been some html template.
 * The table “wpaa_cache” has data, but the table “wpaa_template” has no records.
 * Any help AVAILABLE on this?
 * [http://wordpress.org/extend/plugins/wordpress-amazon-associate/](http://wordpress.org/extend/plugins/wordpress-amazon-associate/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Matthew Denton](https://wordpress.org/support/users/mdbitz/)
 * (@mdbitz)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/sql-error-11/#post-3185681)
 * Hi, it looks like an installation error. I’ll have to review in detail however
   it looks like the installation script for setting up default templates isn’t 
   picking up the correct prefix. Hope to have an update soon.
 * > Matthew

Viewing 1 replies (of 1 total)

The topic ‘SQL error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-amazon-associate.svg)
 * [WordPress-Amazon-Associate](https://wordpress.org/plugins/wordpress-amazon-associate/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-amazon-associate/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-amazon-associate/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-amazon-associate/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-amazon-associate/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-amazon-associate/reviews/)

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 1 reply
 * 2 participants
 * Last reply from: [Matthew Denton](https://wordpress.org/support/users/mdbitz/)
 * Last activity: [13 years, 6 months ago](https://wordpress.org/support/topic/sql-error-11/#post-3185681)
 * Status: not resolved