Downloadable product error
-
Good morning,
I bought a theme with Woocommerce for a bookshop, with both downloadable and physical products. After setting everything, it seems to work fine, except for the downloads. When the client buy a downloadable product, it appears an error message (“the download log entry could not be inserted into the database”) (in spanish, the language that its set it said “no ha sido posible insertar la entrada del registro de descarga en la base de datos”) After checking with my hosting, they said that everything in the database is fine, and the error may be in Woocomerce. I’ve checked everything and seems to be correct, but the error keeps appearing, and I cannot find any piece of information. I really need to solve that.
I look forward to your response.
Thank you!
-
Hi there ??
That’s strange! As a first step, please share the following WooCommerce logs:
- System Status: found under WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
- Error log: found under WooCommerce > System Status > Logs
Thank you!
Hello! Thanks for your response, I don’t have the error log option, but here is the system status info:
### WordPress Environment ### WordPress address (URL): https://metodooye.es Site address (URL): https://metodooye.es WC Version: 5.4.2 REST API Version: ? 5.4.2 WC Blocks Version: ? 5.1.0 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 2.3.1 Log Directory Writable: ? WP Version: 5.7.2 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ? Language: es_ES External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.3.29 PHP Post Max Size: 1 GB PHP Time Limit: 800 PHP Max Input Vars: 10000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.3.30-MariaDB Max Upload Size: 1 GB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.4.2 WC Database Prefix: wp_metodooye Tama?o total de la base de datos: 21.04MB Tama?o de los datos de la base de datos: 18.95MB Tama?o del índice de la base de datos: 2.09MB wp_metodooyewoocommerce_sessions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewoocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewoocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewoocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_metodooyewoocommerce_order_items: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewoocommerce_order_itemmeta: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB wp_metodooyewoocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_metodooyewoocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewoocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyewoocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewoocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyewoocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewoocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewoocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeactionscheduler_actions: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB wp_metodooyeactionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeactionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeactionscheduler_logs: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyecommentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyecomments: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB wp_metodooyelayerslider: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyelayerslider_revisions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyelinks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyems_snippets: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyeoptions: Datos: 4.52MB + índice: 0.11MB + Motor InnoDB wp_metodooyepostmeta: Datos: 9.52MB + índice: 0.41MB + Motor InnoDB wp_metodooyeposts: Datos: 3.52MB + índice: 0.13MB + Motor InnoDB wp_metodooyerevslider_css: Datos: 0.13MB + índice: 0.02MB + Motor InnoDB wp_metodooyerevslider_css_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_layer_animations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_layer_animations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_navigations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_navigations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_sliders: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyerevslider_sliders_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_slides: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyerevslider_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyerevslider_static_slides: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyerevslider_static_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyesnippets: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyetermmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyeterms: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyeterm_relationships: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeterm_taxonomy: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyetm_taskmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyetm_tasks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeusermeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyeusers: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_metodooyewc_admin_notes: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB wp_metodooyewc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyewc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewc_order_product_lookup: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB wp_metodooyewc_order_stats: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB wp_metodooyewc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB wp_metodooyewc_product_meta_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB wp_metodooyewc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyewc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyewpfm_backup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB wp_metodooyeyith_wcwl: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB wp_metodooyeyith_wcwl_lists: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB ### Post Type Counts ### attachment: 187 custom_css: 1 customize_changeset: 14 elementor_library: 10 jet-theme-core: 2 nav_menu_item: 11 oembed_cache: 1 page: 13 post: 12 product: 21 revision: 320 shop_coupon: 1 shop_order: 16 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (25) ### LayerSlider WP: por Kreatura Media – 6.11.8 Code Snippets: por Code Snippets Pro – 2.14.1 Contact Form 7: por Takayuki Miyoshi – 5.4.1 DesignThemes Flickr: por DesignThemes – 1.0 DesignThemes Framework: por the DesignThemes team – 1.0 DesignThemes Portfolio: por the DesignThemes team – 1.0 DesignThemes Shop: por DesignThemes – 1.0 DesignThemes Theme: por the DesignThemes team – 1.0 DesignThemes Twitter: por DesignThemes – 1.0 Duplicate Page: por mndpsingh287 – 4.4 Elementor: por Elementor.com – 3.2.5 Envato Market: por Envato – 2.0.6 Hello Dolly: por Matt Mullenweg – 1.7.2 JetBlocks For Elementor: por Crocoblock – 1.2.8 JetElements For Elementor: por Crocoblock – 2.5.7 JetMenu: por Crocoblock – 2.0.9 JetPopup: por Crocoblock – 1.5.2 JetTabs For Elementor: por Crocoblock – 2.1.12 JetThemeCore: por Crocoblock – 1.2.1 JetTricks: por Crocoblock – 1.3.7 Maintenance: por WebFactory Ltd – 4.02 Slider Revolution: por ThemePunch – 6.5.0 Unyson: por ThemeFuse – 2.7.24 WooCommerce Redsys Gateway Light: por José Conti – 3.0.4 WooCommerce: por Automattic – 5.4.2 (la actualización a la versión 5.5.1 está disponible) ### Inactive Plugins (1) ### Akismet Anti-Spam: por Automattic – 4.1.9 ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – ### WC Pages ### Base de la tienda: #20353 - /libros/ Carrito: #14 - /carrito/ Finalizar compra: #15 - /checkout/ Mi cuenta: #16 - /mi-cuenta/ Términos y condiciones: ? Página sin definir ### Theme ### Name: Bomo Version: 1.1.1 Author URL: https://wedesignthemes.com/ Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Completo: 54 Oldest: 2021-07-01 07:15:53 +0000 Newest: 2021-07-19 11:31:36 +0000 ### Status report information ### Generated at: 2021-07-19 11:32:46 +00:00
Thank you for sharing the system status, Raquel ??
Upon checking, I can see that the database table
wc_download_log
exists on your site, so that’s good!Now, this kind of problem is usually caused by a conflict with your theme or with another plugin.
?
The best way to determine this is to:- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
Before you start
First, please make sure you have a good backup in place of your full site and database.
Second, I would suggest installing a plugin called?Health Check & Troubleshooting. This is a plugin developed by the WordPress community and it allows you to disable plugins without affecting your current site visitors.
Let me know how it goes!
Hi there,
Since we haven’t heard back from you, and this thread has been inactive for a bit, I’m going to mark it as
Resolved
now for the overall health of the forums. Please feel free to open a new one if you have any further questions.Cheers!
- The topic ‘Downloadable product error’ is closed to new replies.