WPIntell

Source evidence

Database Error

Affiliate Super Assistent · support · 2024-02-12T21:37:00+00:00

complaintsentiment
mediumseverity
0.92relevance
2replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

5 / 31 rows with source links

16.1% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

26 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
woorooo unresolved
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. 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/ 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 .

Comments

2 shown
Timo 2024-02-12T22:47:00+00:00

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/

woorooo 2024-02-12T22:56:00+00:00

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 .