Could not insert post into the database – Problem with payments plugins (paypal and stripe) for woocomerce – subscription + membership plugins

  • Unknown's avatar
    insightadviser · Member ·

    I have a serious problem with payments plugins (paypal and stripe) for woocomerce. They don’t work properly with your plugins – subscription and membership. Every time, when we can try to make payment for a subscription, the system shows warning:
    ‘Could not insert post into the database’ we tried to find different set up to avoid this problem – but finally when we did simple product – payments plugins start to work properly so seems to be problem with your plugins. Could you help me to avoid this issue?

  • Unknown's avatar
    insightadviser · Member · 
    
### WordPress Environment ###

WordPress address (URL): https://dental.ia-interactive.pl
Site address (URL): https://dental.ia-interactive.pl
WC Version: 4.6.0
REST API Version: ✔ 4.6.0
WC Blocks Version: ✔ 3.4.0
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.6.1
Log Directory Writable: ✔
WP Version: 5.5.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache/2
PHP Version: 7.3.20
PHP Post Max Size: 512 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.47.0
GnuTLS/3.4.10

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.43-MariaDB
Max Upload Size: 512 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.6.0
WC Database Prefix: dental_
Total Database Size: 111,00MB
Database Data Size: 94,00MB
Database Index Size: 17,00MB
dental_woocommerce_sessions: Data: 0,03MB + Index: 0,02MB + Engine InnoDB
dental_woocommerce_api_keys: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_woocommerce_attribute_taxonomies: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_woocommerce_downloadable_product_permissions: Data: 0,02MB + Index: 0,06MB + Engine InnoDB
dental_woocommerce_order_items: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_woocommerce_order_itemmeta: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_woocommerce_tax_rates: Data: 0,02MB + Index: 0,06MB + Engine InnoDB
dental_woocommerce_tax_rate_locations: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_woocommerce_shipping_zones: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_woocommerce_shipping_zone_locations: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_woocommerce_shipping_zone_methods: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_woocommerce_payment_tokens: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_woocommerce_payment_tokenmeta: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_woocommerce_log: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_actionscheduler_actions: Data: 1,52MB + Index: 0,66MB + Engine InnoDB
dental_actionscheduler_claims: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_actionscheduler_groups: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_actionscheduler_logs: Data: 0,45MB + Index: 0,31MB + Engine InnoDB
dental_aiowps_events: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_aiowps_failed_logins: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_aiowps_global_meta: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_aiowps_login_activity: Data: 0,05MB + Index: 0,00MB + Engine InnoDB
dental_aiowps_login_lockdown: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_aiowps_permanent_block: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_akeeba_common: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_ak_params: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_ak_profiles: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_ak_stats: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_ak_storage: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_ak_users: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_cf_forms: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_cf_form_entries: Data: 0,02MB + Index: 0,06MB + Engine InnoDB
dental_cf_form_entry_meta: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_cf_form_entry_values: Data: 0,02MB + Index: 0,05MB + Engine InnoDB
dental_cf_pro_messages: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_cf_queue_failures: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_cf_queue_jobs: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_commentmeta: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_comments: Data: 0,05MB + Index: 0,09MB + Engine InnoDB
dental_comment_likes: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_countries: Data: 0,02MB + Index: 0,01MB + Engine MyISAM
dental_coupones: Data: 0,08MB + Index: 0,05MB + Engine InnoDB
dental_courses_history: Data: 2,52MB + Index: 0,00MB + Engine InnoDB
dental_courses_lessons: Data: 0,05MB + Index: 0,02MB + Engine InnoDB
dental_et_social_stats: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_favorite_equipments: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_favorite_lessons: Data: 0,08MB + Index: 0,00MB + Engine InnoDB
dental_fca_eoi_activity: Data: 0,28MB + Index: 0,38MB + Engine InnoDB
dental_fca_eoi_subscribers: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_gr_configuration: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_gr_orders_map: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_gr_products_map: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_gr_schedule_jobs_queue: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_gr_variants_map: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_invoice_numbers: Data: 0,05MB + Index: 0,00MB + Engine InnoDB
dental_links: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_options: Data: 2,36MB + Index: 0,20MB + Engine InnoDB
dental_popularpostsdata: Data: 0,05MB + Index: 0,00MB + Engine InnoDB
dental_popularpostssummary: Data: 0,27MB + Index: 0,34MB + Engine InnoDB
dental_postmeta: Data: 17,52MB + Index: 3,03MB + Engine InnoDB
dental_posts: Data: 21,52MB + Index: 0,69MB + Engine InnoDB
dental_posts_: Data: 2,52MB + Index: 0,36MB + Engine InnoDB
dental_product_access: Data: 0,00MB + Index: 0,00MB + Engine MyISAM
dental_pts_tables: Data: 0,33MB + Index: 0,00MB + Engine InnoDB
dental_redirection_404: Data: 0,06MB + Index: 0,06MB + Engine InnoDB
dental_redirection_groups: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_redirection_items: Data: 0,02MB + Index: 0,09MB + Engine InnoDB
dental_redirection_logs: Data: 0,02MB + Index: 0,08MB + Engine InnoDB
dental_smush_dir_images: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_subscribers: Data: 0,06MB + Index: 0,00MB + Engine InnoDB
dental_termmeta: Data: 0,05MB + Index: 0,03MB + Engine InnoDB
dental_terms: Data: 0,41MB + Index: 0,38MB + Engine InnoDB
dental_term_relationships: Data: 0,08MB + Index: 0,06MB + Engine InnoDB
dental_term_taxonomy: Data: 0,50MB + Index: 0,48MB + Engine InnoDB
dental_usermeta: Data: 36,56MB + Index: 7,03MB + Engine InnoDB
dental_users: Data: 1,52MB + Index: 0,77MB + Engine InnoDB
dental_user_access: Data: 0,01MB + Index: 0,02MB + Engine MyISAM
dental_user_payment: Data: 2,13MB + Index: 0,01MB + Engine MyISAM
dental_user_transaction: Data: 0,15MB + Index: 0,03MB + Engine MyISAM
dental_watched_courses: Data: 0,22MB + Index: 0,00MB + Engine InnoDB
dental_wc_admin_notes: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wc_admin_note_actions: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wc_category_lookup: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wc_customer_lookup: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_wc_download_log: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_wc_order_coupon_lookup: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_wc_order_product_lookup: Data: 0,02MB + Index: 0,06MB + Engine InnoDB
dental_wc_order_stats: Data: 0,02MB + Index: 0,05MB + Engine InnoDB
dental_wc_order_tax_lookup: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_wc_product_meta_lookup: Data: 0,02MB + Index: 0,09MB + Engine InnoDB
dental_wc_reserved_stock: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wc_tax_rate_classes: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wc_webhooks: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wire_transfer_numbers: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_csv_uploads: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_logging: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_media: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_menus: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_project: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wpda_project_page: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wpda_project_table: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_publisher: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_wpda_table_design: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpda_table_settings: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpdb_errors: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpmailsmtp_tasks_meta: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_wpml_mails: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_xyz_ips_short_code: Data: 0,02MB + Index: 0,00MB + Engine InnoDB
dental_yoast_indexable: Data: 1,52MB + Index: 0,47MB + Engine InnoDB
dental_yoast_indexable_hierarchy: Data: 0,06MB + Index: 0,05MB + Engine InnoDB
dental_yoast_migrations: Data: 0,02MB + Index: 0,02MB + Engine InnoDB
dental_yoast_primary_term: Data: 0,02MB + Index: 0,03MB + Engine InnoDB
dental_yoast_seo_links: Data: 0,14MB + Index: 0,09MB + Engine InnoDB
dental_yoast_seo_meta: Data: 0,06MB + Index: 0,00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 161
acf-field-group: 17
attachment: 1324
certificate: 1
certificate_template: 1
course: 47
customize_changeset: 10
custom_css: 2
easy-opt-ins: 4
easy-pricing-table: 1
et_body_layout: 8
et_footer_layout: 1
et_pb_layout: 26
et_template: 45
et_theme_builder: 3
lesson: 239
logocarousel: 5
nav_menu_item: 139
oembed_cache: 9
online-training: 2
page: 40
post: 151
product: 7
quiz: 229
revision: 2588
rpt_pricing_table: 1
shop_order: 11
shop_subscription: 2
spt_testimonial: 5
sp_tfree_shortcodes: 1
testimonial_rotator: 1
wc_membership_plan: 5
wc_user_membership: 9
wpl_lcp_shortcodes: 1
wpl_logo_carousel: 2

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (42) ###

Divi Blog Extras: by Elicus – 2.5.3
Advanced Custom Fields PRO: by Elliot Condon – 5.8.11
AJAX Login and Registration modal popup - PRO: by Maxim K – 1.96
Ajax Search Lite: by Ernest Marcinko – 4.8.4
Akeeba Backup for WordPress: by Akeeba Ltd – 7.3.2
Caldera Forms: by Caldera Forms – 1.9.2
Caldera Forms Anti Spam: by Yoohoo Plugins – 0.3
Classic Editor: by WordPress Contributors – 1.6
Clear Cache For Me: by Webhead LLC – 1.5
Collapsible Content for Sensei LMS: by Donna Peplinskie – 1.0.1
Cookie Notice: by dFactory – 1.3.2
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 3.2.6
GetResponse for WordPress: by GetResponse – 5.5.9
GetResponse Forms by Optin Cat: by Fatcat Apps – 2.5.1
iframe: by webvitaly – 4.5
Insert PHP Code Snippet: by xyzscripts.com – 1.3.1
Kadence WooCommerce Email Designer: by Kadence WP – 1.4.3 – Installed version not tested with active version of WooCommerce 4.6.0
Loco Translate: by Tim Whitlock – 2.4.3
Monarch Plugin: by Elegant Themes – 1.4.13
Popups for Divi: by divimode.com – 2.2.4
Really Simple SSL: by Really Simple Plugins – 3.3.5
Recent Posts Widget With Thumbnails: by Martin Stehle – 7.0.0
Redirection: by John Godley – 4.8
Sensei LMS Certificates: by Automattic – 2.0.6
Sensei LMS Course Progress: by Automattic – 2.0.3
Sensei LMS: by Automattic – 3.5.2
Sensei LMS Media Attachments: by Automattic – 2.0.2
Surbma | Yoast SEO Breadcrumb Shortcode: by Surbma – 1.1
Testimonial: by ShapedPlugin – 2.2.7
Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.5.1
Video PopUp: by Alobaidi – 1.1.2
Widget Context: by Kaspars Dambis – 1.3.2
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.0 – Installed version not tested with active version of WooCommerce 4.6.0
WooCommerce Stripe Gateway: by WooCommerce – 4.5.3 – Installed version not tested with active version of WooCommerce 4.6.0
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.9.6

WooCommerce Subscriptions: by WooCommerce – 3.0.9 – Installed version not tested with active version of WooCommerce 4.6.0
WooCommerce: by Automattic – 4.6.0
Sensei with WooCommerce Paid Courses: by Automattic – 3.5.2.2.1.1 – Installed version not tested with active version of WooCommerce 4.6.0
WordPress Popular Posts: by Hector Cabrera – 5.2.4
Yoast SEO: by Team Yoast – 15.1.1
WP Data Access: by Passionate Programmers – 3.6.5
Smush: by WPMU DEV – 3.7.1

### Inactive Plugins (14) ###

Advanced Database Cleaner: by Younes JFR. – 3.0.3
All In One WP Security: by Tips and Tricks HQ
Peter Petreski
Ruhul
Ivy – 4.4.4

Autoptimize: by Frank Goossens (futtta) – 2.7.8
Autoptimize CriticalCSS.com Power-Up: by Deny Dias & Optimizing Matters – 1.18.0
Coming Soon Page, Maintenance Mode & Landing Pages by SeedProd: by SeedProd – 6.0.7
Duplicator: by Snap Creek – 1.3.38
Flexible Checkout Fields: by WP Desk – 2.6.0
Login for WordPress: by Damian Logghe – 1.2.3.5
Post List With Featured Image: by Dharmesh Patel – 1.2
Query Monitor: by John Blackbourn – 3.6.4
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
WooCommerce Memberships: by SkyVerge – 1.19.1 – Installed version not tested with active version of WooCommerce 4.6.0
WP Mail SMTP: by WPForms – 2.4.0
Yoast Test Helper: by Team Yoast – 1.9

### Must Use Plugins (1) ###

akeeba-backup-coreupdate.php: by  –

### Settings ###

API Enabled: –
Force SSL: ✔
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

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 ###

Shop base: #9807 - /shop/
Cart: #9808 - /cart/
Checkout: #9809 - /checkout/
My account: #9810 - /my-account/
Terms and conditions: #139 - /terms-of-use/

### Theme ###

Name: dental
Version: 1.0.0
Author URL: 
Child Theme: ✔
Parent Theme Name: Divi
Parent Theme Version: 4.6.6
Parent Theme Author URL: http://www.elegantthemes.com
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Subscriptions ###

WCS_DEBUG: ✔ No
Subscriptions Mode: ✔ Live
Subscriptions Live URL: https://dental.ia-interactive.pl
Subscription Statuses: auto-draft: 2
WooCommerce Account Connected: ❌ No
Report Cache Enabled: ✔ Yes
Cache Update Failures: ✔ 0 failure

### Store Setup ###

Country / State: Poland

### Payment Gateway Support ###

PayPal Checkout: products
refunds
subscriptions
subscription_cancellation
subscription_reactivation
subscription_suspension
multiple_subscriptions
subscription_payment_method_change_customer
subscription_payment_method_change_admin
subscription_amount_changes
subscription_date_changes

Stripe: products
refunds
tokenization
add_payment_method
subscriptions
subscription_cancellation
subscription_suspension
subscription_reactivation
subscription_amount_changes
subscription_date_changes
subscription_payment_method_change
subscription_payment_method_change_customer
subscription_payment_method_change_admin
multiple_subscriptions
pre-orders

### Action Scheduler ###

Canceled: 1
Oldest: 2020-10-08 15:02:32 +0200
Newest: 2020-10-08 15:02:32 +0200

Complete: 1,999
Oldest: 2020-09-23 21:47:26 +0200
Newest: 2020-10-20 20:42:17 +0200

Failed: 1
Oldest: 2020-06-07 19:43:24 +0200
Newest: 2020-06-07 19:43:24 +0200
  • staff-totoro · Staff ·

    Hi there,

    It sounds like you are needing help with the WooCommerce plugin, but have landed on the support forum for WordPress.com sites instead. Can you please report this issue to WooCommerce support by asking here?

    https://wordpress.org/support/plugin/woocommerce

    Thanks!

  • Unknown's avatar
    insightadviser · Member ·

    Thanks!

  • The topic ‘Could not insert post into the database – Problem with payments plugins (paypal and stripe) for woocomerce – subscription + membership plugins’ is closed to new replies.