Warning : Error 500 on last update (database bug)
-
Be carreful don’t upgrade to 4.3.4, or you will have a 500 error :
Erreur de la base de données WordPress Table 'aal_request_cache' doesn't exist pour la requête SELECT cache,modified_time,expiration_time,charset,request_uri,name FROM aal_request_cacheI think the plugin is seeking for an old (and inexisting) table.
-
Hi,
I’m not sure why you get such an error. Sounds like a plugin database table does not exists. v4.3.4 does not include any changes regarding database tables.
Does downgrading the plugin solve the issue? To downgrade the plugin to an older version, you can find old versions of Amazon Auto Links at the bottom of this page.
Also, could you post what it says in the Database Tables field found via Dashboard -> Amazon Auto Links -> Help -> About?
Also, if you find any errors, let me know. To enable the site debug logging, you need to insert the following lines in the
wp-config.phpfile.define( 'WP_DEBUG', true ); define( 'WP_DEBUG_LOG', true );Then debug.log file will be created under the
wp-contentdirectory which reports errors and warnings.I erased the debug log I will provide another one tomorrow =)
Yeah the plugin is seeking for aal_request_cache… AND yes reverted to 4.3.2 solved the problem =)
Looking forward to it.
In addition, would be appreciated if you could check if v4.3.3 works for you or not.
Hi,
I have the same problem, return tu 4.3.3. It’ok.
A+
Hello 🙂
Here is the content of debug.log (I found it in the recycle bin) :
[18-Oct-2020 02:39:58 UTC] PHP Deprecated: automatic_feed_links est <strong>obsolète</strong> depuis la version 3.0.0 ! Utilisez add_theme_support( 'automatic-feed-links' ) à la place. in /suzukube.fr/wp-includes/functions.php on line 4773 [18-Oct-2020 02:39:58 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:58 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:59 UTC] PHP Deprecated: automatic_feed_links est <strong>obsolète</strong> depuis la version 3.0.0 ! Utilisez add_theme_support( 'automatic-feed-links' ) à la place. in /suzukube.fr/wp-includes/functions.php on line 4773 [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:59 UTC] Erreur de la base de données WordPress Table 'mydatabase.aal_request_cache' doesn't exist pour la requête SELECT cache,modified_time,expiration_time,charset,request_uri,name FROM aal_request_cache WHERE name = 'AAL_94ca3078b420a3bfc59ae4650d933913' faite par require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/featureon/archive.php'), get_template_part, locate_template, load_template, require('/themes/featureon/content-list.php'), the_excerpt, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hook->apply_filters, remove_dropcap_shortcode, apply_filters('the_content'), WP_Hook->apply_filters, do_blocks, render_block, WP_Block->render, AmazonAutoLinks_AALBSupport_GutenbergBlock->replyToBlockEditorCallback, apply_filters('aal_filter_shortcode_amazon_link'), WP_Hook->apply_filters, AmazonAutoLinks_AALBSupport_Shortcode_amazon_link->replyToFilterShortcodeContents, AmazonAutoLinks_AALBSupport_Shortcode_amazon_link->replyToGetOutput, AmazonAutoLinks, AmazonAutoLinks_Output->get, AmazonAutoLinks_Output->___getOutput, AmazonAutoLinks_Output->___getOutputByUnitType, apply_filters('aal_filter_unit_output_item_lookup'), WP_Hook->apply_filters, AmazonAutoLinks_UnitTypeLoader_Base->replyToGetUnitOutput, AmazonAutoLinks_UnitOutput_Base->get, AmazonAutoLinks_UnitOutput_search->fetch, AmazonAutoLinks_UnitOutput_search->_getResponses, AmazonAutoLinks_UnitOutput_item_lookup->getRequest, AmazonAutoLinks_PAAPI50->request, AmazonAutoLinks_PAAPI50___Cache->get, AmazonAutoLinks_PAAPI50___Cache->___getResponseBySignedRequest, AmazonAutoLinks_HTTPClient->getResponse, AmazonAutoLinks_HTTPClient->getRawResponse, AmazonAutoLinks_HTTPClient->___getHTTPResponseWithCache, AmazonAutoLinks_HTTPClient->getResponseFromCache, AmazonAutoLinks_HTTPClient->___getCacheFromDatabase, AmazonAutoLinks_DatabaseTable_aal_request_cache->getCache, AmazonAutoLinks_DatabaseTable_aal_request_cache->_getCacheEach, AmazonAutoLinks_DatabaseTable_Base->getRow [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type null in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/_common/utility/database/AmazonAutoLinks_DatabaseTable_aal_request_cache.php on line 227 [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type null in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/_common/utility/database/AmazonAutoLinks_DatabaseTable_aal_request_cache.php on line 228 [18-Oct-2020 02:39:59 UTC] Erreur de la base de données WordPress Table 'mydatabase.aal_request_cache' doesn't exist pour la requête SHOW FULL COLUMNS FROM <code>aal_request_cache</code> faite par require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/featureon/archive.php'), get_template_part, locate_template, load_template, require('/themes/featureon/content-list.php'), the_excerpt, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hook->apply_filters, remove_dropcap_shortcode, apply_filters('the_content'), WP_Hook->apply_filters, do_blocks, render_block, WP_Block->render, AmazonAutoLinks_AALBSupport_GutenbergBlock->replyToBlockEditorCallback, apply_filters('aal_filter_shortcode_amazon_link'), WP_Hook->apply_filters, AmazonAutoLinks_AALBSupport_Shortcode_amazon_link->replyToFilterShortcodeContents, AmazonAutoLinks_AALBSupport_Shortcode_amazon_link->replyToGetOutput, AmazonAutoLinks, AmazonAutoLinks_Output->get, AmazonAutoLinks_Output->___getOutput, AmazonAutoLinks_Output->___getOutputByUnitType, apply_filters('aal_filter_unit_output_item_lookup'), WP_Hook->apply_filters, AmazonAutoLinks_UnitTypeLoader_Base->replyToGetUnitOutput, AmazonAutoLinks_UnitOutput_Base->get, AmazonAutoLinks_UnitOutput_search->fetch, AmazonAutoLinks_UnitOutput_search->_getResponses, AmazonAutoLinks_UnitOutput_item_lookup->getRequest, AmazonAutoLinks_PAAPI50->request, AmazonAutoLinks_PAAPI50___Cache->get, AmazonAutoLinks_PAAPI50___Cache->___getResponseBySignedRequest, AmazonAutoLinks_HTTPClient->getResponse, AmazonAutoLinks_HTTPClient->getRawResponse, AmazonAutoLinks_HTTPClient->___getHTTPResponseWithCache, AmazonAutoLinks_HTTPClient->___setCacheInDatabase, AmazonAutoLinks_DatabaseTable_aal_request_cache->setCache, AmazonAutoLinks_DatabaseTable_aal_request_cache->setRow, AmazonAutoLinks_DatabaseTable_Base->setRow, AmazonAutoLinks_DatabaseTable_Base->setRows [18-Oct-2020 02:39:59 UTC] PHP Deprecated: automatic_feed_links est <strong>obsolète</strong> depuis la version 3.0.0 ! Utilisez add_theme_support( 'automatic-feed-links' ) à la place. in /suzukube.fr/wp-includes/functions.php on line 4773 [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:59 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:39:59 UTC] Erreur de la base de données WordPress Table 'mydatabase.bp_messages_recipients' doesn't exist pour la requête SELECT SUM(unread_count) FROM bp_messages_recipients WHERE user_id = 1 AND is_deleted = 0 AND sender_only = 0 faite par require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/otaku2020/single.php'), get_header, locate_template, load_template, require_once('/themes/otaku2020/header.php'), wp_body_open, do_action('wp_body_open'), WP_Hook->do_action, WP_Hook->apply_filters, wp_admin_bar_render, do_action_ref_array('admin_bar_menu'), WP_Hook->do_action, WP_Hook->apply_filters, bp_setup_admin_bar, do_action('bp_setup_admin_bar'), WP_Hook->do_action, WP_Hook->apply_filters, BP_Messages_Component->setup_admin_bar, messages_get_unread_count, BP_Messages_Thread::get_inbox_count [18-Oct-2020 02:40:02 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 8192 bytes) in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/unit/_common/option/_abstract/AmazonAutoLinks_UnitOption_Base.php on line 174 [18-Oct-2020 02:40:02 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 102400 bytes) in /suzukube.fr/wp-content/plugins/complianz-gdpr/class-cookie-blocker.php on line 452 [18-Oct-2020 02:40:02 UTC] PHP Fatal error: Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0 [18-Oct-2020 02:40:02 UTC] PHP Deprecated: automatic_feed_links est <strong>obsolète</strong> depuis la version 3.0.0 ! Utilisez add_theme_support( 'automatic-feed-links' ) à la place. in /suzukube.fr/wp-includes/functions.php on line 4773 [18-Oct-2020 02:40:02 UTC] PHP Deprecated: automatic_feed_links est <strong>obsolète</strong> depuis la version 3.0.0 ! Utilisez add_theme_support( 'automatic-feed-links' ) à la place. in /suzukube.fr/wp-includes/functions.php on line 4773 [18-Oct-2020 02:40:02 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:40:02 UTC] PHP Notice: Trying to access array offset on value of type bool in /suzukube.fr/wp-content/plugins/amazon-auto-links/include/core/component/template/option/AmazonAutoLinks_TemplateOption.php on line 176 [18-Oct-2020 02:40:02 UTC] Erreur de la base de données WordPress Table 'mydatabase.aal_request_cache' doesn't exist pour la requête SELECT cache,modified_time,expiration_time,charset,request_uri,name FROM aal_request_cache WHERE name = 'AAL_e50dad389eb5a8119b81200ecc28fb39' faite par do_action_ref_array('aal_action_check_tasks'), WP_Hook->do_action, WP_Hook->apply_filters, AmazonAutoLinks_Event___Action_Base->replyToDoAction, AmazonAutoLinks_Unit_Event_Action_CheckTasks->_doAction, AmazonAutoLinks_Unit_Event_Action_CheckTasks->___doTaskActions, do_action('aal_action_api_get_product_rating'), WP_Hook->do_action, WP_Hook->apply_filters, AmazonAutoLinks_Event___Action_Base->replyToDoAction, AmazonAutoLinks_Event___Action_HTTPRequestRating->_doAction, AmazonAutoLinks_Event___Action_HTTPRequestRating->___getWidgetPage, AmazonAutoLinks_Event___Action_HTTPRequestRating->___getWidgetPageResponse, AmazonAutoLinks_HTTPClient->getResponse, AmazonAutoLinks_HTTPClient->getRawResponse, AmazonAutoLinks_HTTPClient->___getHTTPResponseWithCache, AmazonAutoLinks_HTTPClient->getResponseFromCache, AmazonAutoLinks_HTTPClient->___getCacheFromDatabase, AmazonAutoLinks_DatabaseTable_aal_request_cache->getCache, AmazonAutoLinks_DatabaseTable_aal_request_cache->_getCacheEach, AmazonAutoLinks_DatabaseTable_Base->getRow4.3.3 is working well 🙂 !
The error is on anypage where there is the AAL module (on v3.3.4) ^^
@suzukube Can you post what it says in the Database Tables field found via Dashboard -> Amazon Auto Links -> Help -> About with v4.3.4?
@seug8520 Can you now update the plugin to 4.3.4 and see if you get the error? If you see it, please post what it says in in the Database Tables field found via Dashboard -> Amazon Auto Links -> Help -> About with v4.3.4.
The database table
aal_request_cachehasn’t changed since it was introduced, which is v3 (2015/6/29). v4.3.0 includes a change of addingaal_taskstable but it’s notaal_request_cache. It’s hard to think that theaal_request_cachetable disappeared. So I suspect somehow it became unable to access but it exists.If you are capable of checking tables with phpMyAdmin or other MySQL tools, please check if the
aal_request_cachetable exists or not.[deleted]
-
This reply was modified 3 years, 6 months ago by
SuzuKube. Reason: Was wrong
The datatable on v4.3.3 (I uninstalled the 4.3.4) says :
[aal_products] name: wpis_aal_products version: 1.4.0 size: 16.77 MB columns: { 0: { Field: object_id Type: bigint(20) unsigned Null: NO Key: PRI Default: Extra: auto_increment } 1: { Field: product_id Type: varchar(128) Null: YES Key: UNI Default: Extra: } 2: { Field: asin Type: varchar(10) Null: YES Key: Default: Extra: } 3: { Field: asin_locale Type: varchar(13) Null: NO Key: Default: Extra: } 4: { Field: locale Type: varchar(4) Null: YES Key: Default: Extra: } 5: { Field: language Type: varchar(10) Null: YES Key: Default: Extra: } 6: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 7: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 8: { Field: title Type: text Null: YES Key: Default: Extra: } 9: { Field: links Type: text Null: YES Key: Default: Extra: } 10: { Field: rating Type: tinyint(3) unsigned Null: YES Key: Default: Extra: } 11: { Field: rating_image_url Type: text Null: YES Key: Default: Extra: } 12: { Field: rating_html Type: blob Null: YES Key: Default: Extra: } 13: { Field: preferred_currency Type: varchar(10) Null: YES Key: Default: Extra: } 14: { Field: currency Type: varchar(10) Null: YES Key: Default: Extra: } 15: { Field: sales_rank Type: bigint(20) Null: YES Key: Default: Extra: } 16: { Field: price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 17: { Field: price_formatted Type: tinytext Null: YES Key: Default: Extra: } 18: { Field: lowest_new_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 19: { Field: lowest_new_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 20: { Field: lowest_used_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 21: { Field: lowest_used_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 22: { Field: discounted_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 23: { Field: discounted_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 24: { Field: count_new Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 25: { Field: count_used Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 26: { Field: description Type: mediumtext Null: YES Key: Default: Extra: } 27: { Field: images Type: mediumtext Null: YES Key: Default: Extra: } 28: { Field: similar_products Type: mediumtext Null: YES Key: Default: Extra: } 29: { Field: editorial_reviews Type: mediumblob Null: YES Key: Default: Extra: } 30: { Field: customer_review_url Type: text Null: YES Key: Default: Extra: } 31: { Field: customer_review_charset Type: varchar(20) Null: YES Key: Default: Extra: } 32: { Field: customer_reviews Type: mediumblob Null: YES Key: Default: Extra: } 33: { Field: number_of_reviews Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 34: { Field: categories Type: text Null: YES Key: Default: Extra: } 35: { Field: features Type: text Null: YES Key: Default: Extra: } 36: { Field: is_prime Type: tinyint(1) Null: YES Key: Default: Extra: } 37: { Field: is_adult Type: tinyint(1) Null: YES Key: Default: Extra: } 38: { Field: error Type: varchar(800) Null: YES Key: Default: Extra: } 39: { Field: delivery_free_shipping Type: tinyint(1) Null: YES Key: Default: Extra: } 40: { Field: delivery_fba Type: tinyint(1) Null: YES Key: Default: Extra: } } [aal_request_cache] name: wpis_aal_request_cache version: 1.0.0 size: 33.94 MB columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: request_uri Type: text Null: YES Key: Default: Extra: } 2: { Field: type Type: varchar(20) Null: YES Key: Default: Extra: } 3: { Field: charset Type: varchar(20) Null: YES Key: Default: Extra: } 4: { Field: cache Type: mediumblob Null: YES Key: Default: Extra: } 5: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 6: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } } [aal_tasks] name: wpis_aal_tasks version: 1.0.1 size: 7.03 MB columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: action Type: varchar(191) Null: YES Key: Default: Extra: } 2: { Field: arguments Type: text Null: YES Key: Default: Extra: } 3: { Field: creation_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 4: { Field: next_run_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } }The database on v4.3.4 :
[aal_products] name: wpis_aal_products version: 1.4.0 size: 16.77 MB columns: { 0: { Field: object_id Type: bigint(20) unsigned Null: NO Key: PRI Default: Extra: auto_increment } 1: { Field: product_id Type: varchar(128) Null: YES Key: UNI Default: Extra: } 2: { Field: asin Type: varchar(10) Null: YES Key: Default: Extra: } 3: { Field: asin_locale Type: varchar(13) Null: NO Key: Default: Extra: } 4: { Field: locale Type: varchar(4) Null: YES Key: Default: Extra: } 5: { Field: language Type: varchar(10) Null: YES Key: Default: Extra: } 6: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 7: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 8: { Field: title Type: text Null: YES Key: Default: Extra: } 9: { Field: links Type: text Null: YES Key: Default: Extra: } 10: { Field: rating Type: tinyint(3) unsigned Null: YES Key: Default: Extra: } 11: { Field: rating_image_url Type: text Null: YES Key: Default: Extra: } 12: { Field: rating_html Type: blob Null: YES Key: Default: Extra: } 13: { Field: preferred_currency Type: varchar(10) Null: YES Key: Default: Extra: } 14: { Field: currency Type: varchar(10) Null: YES Key: Default: Extra: } 15: { Field: sales_rank Type: bigint(20) Null: YES Key: Default: Extra: } 16: { Field: price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 17: { Field: price_formatted Type: tinytext Null: YES Key: Default: Extra: } 18: { Field: lowest_new_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 19: { Field: lowest_new_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 20: { Field: lowest_used_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 21: { Field: lowest_used_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 22: { Field: discounted_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 23: { Field: discounted_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 24: { Field: count_new Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 25: { Field: count_used Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 26: { Field: description Type: mediumtext Null: YES Key: Default: Extra: } 27: { Field: images Type: mediumtext Null: YES Key: Default: Extra: } 28: { Field: similar_products Type: mediumtext Null: YES Key: Default: Extra: } 29: { Field: editorial_reviews Type: mediumblob Null: YES Key: Default: Extra: } 30: { Field: customer_review_url Type: text Null: YES Key: Default: Extra: } 31: { Field: customer_review_charset Type: varchar(20) Null: YES Key: Default: Extra: } 32: { Field: customer_reviews Type: mediumblob Null: YES Key: Default: Extra: } 33: { Field: number_of_reviews Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 34: { Field: categories Type: text Null: YES Key: Default: Extra: } 35: { Field: features Type: text Null: YES Key: Default: Extra: } 36: { Field: is_prime Type: tinyint(1) Null: YES Key: Default: Extra: } 37: { Field: is_adult Type: tinyint(1) Null: YES Key: Default: Extra: } 38: { Field: error Type: varchar(800) Null: YES Key: Default: Extra: } 39: { Field: delivery_free_shipping Type: tinyint(1) Null: YES Key: Default: Extra: } 40: { Field: delivery_fba Type: tinyint(1) Null: YES Key: Default: Extra: } } [aal_request_cache] name: wpis_aal_request_cache version: 1.0.0 size: 33.94 MB columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: request_uri Type: text Null: YES Key: Default: Extra: } 2: { Field: type Type: varchar(20) Null: YES Key: Default: Extra: } 3: { Field: charset Type: varchar(20) Null: YES Key: Default: Extra: } 4: { Field: cache Type: mediumblob Null: YES Key: Default: Extra: } 5: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 6: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } } [aal_tasks] name: wpis_aal_tasks version: 1.0.1 size: 7.03 MB columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: action Type: varchar(191) Null: YES Key: Default: Extra: } 2: { Field: arguments Type: text Null: YES Key: Default: Extra: } 3: { Field: creation_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 4: { Field: next_run_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } }Thanks for providing those information.
So the
aal_request_cachetable surely exists. Otherwise, it won’t be able to know the table size. And you have a quite large task table. That’s another problem. I’m not sure what’s going on on your site.Can you empty the
aal_request_cachetable by going to Dashboard -> Amazon Auto Links -> Settings -> Cache -> Caches -> Clear Caches by checking the both Products and HTTP Requests? This might solve the issue.-
This reply was modified 3 years, 6 months ago by
miunosoft. Reason: A word missing
Yeah I have like 5.000 pages on my websites, with differents products on it :/ But I removed most of them since 2 days, replaced with a link to my amazon shop ^^’ !
I cleared the caches, updated to 4.3.4 and still error 500 :/ Reverted back to 4.3.3 working fine. Strange…
What is the Change Log ? I would do a Diff to see what are the changes 🙂 !
Added the Saudi Arabia locale.
Fixed a bug that descriptions in the category unit only appeared for the first product.
Fixed a bug that passing the unit_format direct arguments were not taking effects.
Fixed a bug that passing the item_format, image_format, title_format, unit_format direct arguments were not taking effects, started since v4.0.0.
Fixed a bug that country flags were not displayed in the Embed setting tab.
Tweaked the default Image Format unit option regarding widths.
Tweaked the style of Embed setting tab.
Optimized HTTP requests to Amazon sites.
Optimized PA-API requests.Hum. Perhaps it’s Optimized HTTP requests to Amazon sites & Optimized PA-API requests writing method ?
Hum. Perhaps it’s Optimized HTTP requests to Amazon sites & Optimized PA-API requests writing method ?
The latter is just not to use a lock with a transient stored in the options table. So it could be the former as HTTP requests use the
aal_request_cachetable.Another possibility is that your table
aal_request_cacheis corrupt. To check that please install the development version 4.3.5b01. And go to Dashboard -> Amazon Auto Links -> Help -> About and post the contents of the Database Tables field (same as the previous reply) This version includes additional information that hints whether the table is fine or not.Then, while enabling the site debug mode (
define( 'WP_DEBUG', true)), please try this. Go to Dashboard -> Amazon Auto Links -> Tests -> Scratches. Then check database/optimize and database/repair, then press Start. This will optimize/repair your plugin tables. If the issue is related to a corrupt table index, this might fix it.If this does not work, please try deleting the ‘aal_request_cache’ table by going to Dashboard -> Amazon Auto Links -> Tests -> Delete. Then, check database/aal_request_cache and press Start. This will delete the table and the table will be recreated automatically so don’t worry about it. This might fix the problem if it is due to a corrupt table.
-
This reply was modified 3 years, 6 months ago by
Hello my database in help content is :
[aal_products] set_name: wpis_aal_products set_version: 1.4.0 exists: Yes size: 15.69 MB rows: 2699 table_catalog: def table_schema: ewdo7169_wp266 table_name: wpis_aal_products table_type: BASE TABLE engine: InnoDB version: 10 row_format: Dynamic table_rows: 1956 avg_row_length: 8317 data_length: 16269312 max_data_length: 0 index_length: 180224 data_free: 4194304 auto_increment: 5658 create_time: 2020-10-13 18:33:57 update_time: check_time: table_collation: utf8mb4_unicode_ci checksum: create_options: table_comment: max_index_length: 0 temporary: N name: wpis_aal_products collation: utf8mb4_unicode_ci comment: checks: { Table: ewdo7169_wp266.wpis_aal_products Op: check Msg_type: status Msg_text: OK } columns: { 0: { Field: object_id Type: bigint(20) unsigned Null: NO Key: PRI Default: Extra: auto_increment } 1: { Field: product_id Type: varchar(128) Null: YES Key: UNI Default: Extra: } 2: { Field: asin Type: varchar(10) Null: YES Key: Default: Extra: } 3: { Field: asin_locale Type: varchar(13) Null: NO Key: Default: Extra: } 4: { Field: locale Type: varchar(4) Null: YES Key: Default: Extra: } 5: { Field: language Type: varchar(10) Null: YES Key: Default: Extra: } 6: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 7: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 8: { Field: title Type: text Null: YES Key: Default: Extra: } 9: { Field: links Type: text Null: YES Key: Default: Extra: } 10: { Field: rating Type: tinyint(3) unsigned Null: YES Key: Default: Extra: } 11: { Field: rating_image_url Type: text Null: YES Key: Default: Extra: } 12: { Field: rating_html Type: blob Null: YES Key: Default: Extra: } 13: { Field: preferred_currency Type: varchar(10) Null: YES Key: Default: Extra: } 14: { Field: currency Type: varchar(10) Null: YES Key: Default: Extra: } 15: { Field: sales_rank Type: bigint(20) Null: YES Key: Default: Extra: } 16: { Field: price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 17: { Field: price_formatted Type: tinytext Null: YES Key: Default: Extra: } 18: { Field: lowest_new_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 19: { Field: lowest_new_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 20: { Field: lowest_used_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 21: { Field: lowest_used_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 22: { Field: discounted_price Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 23: { Field: discounted_price_formatted Type: tinytext Null: YES Key: Default: Extra: } 24: { Field: count_new Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 25: { Field: count_used Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 26: { Field: description Type: mediumtext Null: YES Key: Default: Extra: } 27: { Field: images Type: mediumtext Null: YES Key: Default: Extra: } 28: { Field: similar_products Type: mediumtext Null: YES Key: Default: Extra: } 29: { Field: editorial_reviews Type: mediumblob Null: YES Key: Default: Extra: } 30: { Field: customer_review_url Type: text Null: YES Key: Default: Extra: } 31: { Field: customer_review_charset Type: varchar(20) Null: YES Key: Default: Extra: } 32: { Field: customer_reviews Type: mediumblob Null: YES Key: Default: Extra: } 33: { Field: number_of_reviews Type: bigint(20) unsigned Null: YES Key: Default: Extra: } 34: { Field: categories Type: text Null: YES Key: Default: Extra: } 35: { Field: features Type: text Null: YES Key: Default: Extra: } 36: { Field: is_prime Type: tinyint(1) Null: YES Key: Default: Extra: } 37: { Field: is_adult Type: tinyint(1) Null: YES Key: Default: Extra: } 38: { Field: error Type: varchar(800) Null: YES Key: Default: Extra: } 39: { Field: delivery_free_shipping Type: tinyint(1) Null: YES Key: Default: Extra: } 40: { Field: delivery_fba Type: tinyint(1) Null: YES Key: Default: Extra: } } [aal_request_cache] set_name: wpis_aal_request_cache set_version: 1.0.0 exists: Yes size: 84.84 MB rows: 4986 table_catalog: def table_schema: ewdo7169_wp266 table_name: wpis_aal_request_cache table_type: BASE TABLE engine: InnoDB version: 10 row_format: Dynamic table_rows: 3317 avg_row_length: 26732 data_length: 88670208 max_data_length: 0 index_length: 294912 data_free: 5242880 auto_increment: create_time: 2020-10-18 05:09:15 update_time: 2020-10-19 18:25:57 check_time: table_collation: utf8mb4_unicode_ci checksum: create_options: table_comment: max_index_length: 0 temporary: N name: wpis_aal_request_cache collation: utf8mb4_unicode_ci comment: checks: { Table: ewdo7169_wp266.wpis_aal_request_cache Op: check Msg_type: status Msg_text: OK } columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: request_uri Type: text Null: YES Key: Default: Extra: } 2: { Field: type Type: varchar(20) Null: YES Key: Default: Extra: } 3: { Field: charset Type: varchar(20) Null: YES Key: Default: Extra: } 4: { Field: cache Type: mediumblob Null: YES Key: Default: Extra: } 5: { Field: modified_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 6: { Field: expiration_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } } [aal_tasks] set_name: wpis_aal_tasks set_version: 1.0.1 exists: Yes size: 7.03 MB rows: 76 table_catalog: def table_schema: ewdo7169_wp266 table_name: wpis_aal_tasks table_type: BASE TABLE engine: InnoDB version: 10 row_format: Dynamic table_rows: 74 avg_row_length: 99411 data_length: 7356416 max_data_length: 0 index_length: 16384 data_free: 6291456 auto_increment: create_time: 2020-10-06 23:03:06 update_time: 2020-10-19 18:25:59 check_time: table_collation: utf8mb4_unicode_ci checksum: create_options: table_comment: max_index_length: 0 temporary: N name: wpis_aal_tasks collation: utf8mb4_unicode_ci comment: checks: { Table: ewdo7169_wp266.wpis_aal_tasks Op: check Msg_type: status Msg_text: OK } columns: { 0: { Field: name Type: varchar(191) Null: NO Key: PRI Default: Extra: } 1: { Field: action Type: varchar(191) Null: YES Key: Default: Extra: } 2: { Field: arguments Type: text Null: YES Key: Default: Extra: } 3: { Field: creation_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } 4: { Field: next_run_time Type: datetime Null: NO Key: Default: 0000-00-00 00:00:00 Extra: } }I will try the following steps….
-
This reply was modified 3 years, 6 months ago by
- The topic ‘Warning : Error 500 on last update (database bug)’ is closed to new replies.
