Title: Database Error
Last modified: February 12, 2024

---

# Database Error

 *  [woorooo](https://wordpress.org/support/users/woorooo/)
 * (@woorooo)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-error-402/)
 * Hi, I keep getting this error in the logs, is there a way to fix?
 * _WordPress database error Table ‘wp\_asa\_collection’ doesn’t exist for query
   
   SELECT *FROM `wp\_asa\_collection`ORDER by collection\_labelmade by do\_action(‘
   customize\_controls\_enqueue\_scripts’), WP\_Hook->do\_action, WP\_Hook->apply\
   _filters, WP\_Customize\_Widgets->enqueue\_scripts, WP\_Customize\_Widgets->get\
   _available\_widgets, WP\_Customize\_Widgets->get\_widget\_control, wp\_widget\
   _control, WP\_Widget->form\_callback, WP\_Widget\_AmazonSimpleAdmin->form, AsaCollection-
   >getAll
 * Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Timo](https://wordpress.org/support/users/worschtebrot/)
 * (@worschtebrot)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-error-402/#post-17419919)
 * Thank you for your request. Have you activated the collections feature in the“
   Collections” tab in the admin section? Then this table should be created initially.
 * If so, perhaps the table could not be created or it was renamed, e.g. during 
   a site migration. There can be many reasons.
 * If you want to create the tables manually in the database, here is the SQL. Please
   replace wp_ in the table name with your database prefix.
 *     ```wp-block-code
       CREATE TABLE wp_asa_collection (
       collection_id int(11) NOT NULL auto_increment,
       collection_label varchar(190) NOT NULL,
       PRIMARY KEY  (collection_id),
       UNIQUE KEY collection_label (collection_label)
       );
   
       CREATE TABLE wp_asa_collection_item (
       collection_item_id int(11) NOT NULL auto_increment,
       collection_id int(11) NOT NULL,
       collection_item_asin varchar(20) NOT NULL,
       collection_item_timestamp datetime NOT NULL,
       PRIMARY KEY  (collection_item_id),
       UNIQUE KEY collection_item_asin (collection_id,collection_item_asin)
       );
       ```
   
 * If that doesn’t help, please create a ticket at [https://www.ifeelweb.de/support/](https://www.ifeelweb.de/support/)
 *  Thread Starter [woorooo](https://wordpress.org/support/users/woorooo/)
 * (@woorooo)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/database-error-402/#post-17419938)
 * Thank you for your reply Timo, however the problem is that I did not activate
   Collection feature. So it’s not activated. Should I create a support ticket at
   the website you mentioned for that?
    -  This reply was modified 2 years, 3 months ago by [woorooo](https://wordpress.org/support/users/woorooo/).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database Error’ is closed to new replies.

 * ![](https://ps.w.org/amazonsimpleadmin/assets/icon-256x256.png?rev=1788380)
 * [Affiliate Super Assistent](https://wordpress.org/plugins/amazonsimpleadmin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/amazonsimpleadmin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/amazonsimpleadmin/)
 * [Active Topics](https://wordpress.org/support/plugin/amazonsimpleadmin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/amazonsimpleadmin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/amazonsimpleadmin/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [woorooo](https://wordpress.org/support/users/woorooo/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/database-error-402/#post-17419938)
 * Status: not resolved