Database Error

  • 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_label
    made 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

    (@worschtebrot)

    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.

    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/

    Thread Starter woorooo

    (@woorooo)

    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 9 months, 2 weeks ago by woorooo.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Error’ is closed to new replies.