PRZVL
Forum Replies Created
-
Thanks for your answer. I will try your solution
Hello, I have the same error ( WordPress database error Incorrect DATETIME value: ” ) which appears every day in my logs randomly and which does not necessarily concern the same event. Below is an excerpt from last night’s mistakes. Thank you for your help
[08-Mar-2024 02:30:25 UTC] WordPress database error Incorrect DATETIME value: ” for query
SELECT SQL_CALC_FOUND_ROWS (wptl04_tec_occurrences.occurrence_id + 10000000) as occurrence_id
FROM wptl04_posts LEFT JOIN wptl04_postmeta ON ( wptl04_posts.ID = wptl04_postmeta.post_id AND wptl04_postmeta.meta_key = ‘_EventHideFromUpcoming’ )
JOIN wptl04_tec_occurrences ON wptl04_posts.ID = wptl04_tec_occurrences.post_id
WHERE 1=1 AND (
CAST(wptl04_tec_occurrences.start_date AS DATETIME) < ” AND wptl04_postmeta.post_id IS NULL ) AND wptl04_posts.post_type = ‘tribe_events’ AND ((wptl04_posts.post_status = ‘publish’)) AND (wptl04_posts.ID NOT IN (70152)) GROUP BY wptl04_tec_occurrences.occurrence_id ORDER BY wptl04_tec_occurrences.start_date_utc DESC, wptl04_posts.post_date DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/the-events-calendar/src/views/v2/default-template.php’), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\Template_Bootstrap->get_v1_single_event_html, tribe_get_view, include(‘/themes/citadela/tribe-events/single-event.php’), tribe_the_prev_event_link, tribe_get_prev_event_link, Tribe__Events__Adjacent_Events->get_prev_event_link, Tribe__Events__Adjacent_Events->get_event_link, Tribe__Events__Adjacent_Events->get_closest_event, WP_Query->get_posts, apply_filters_ref_array(‘posts_pre_query’), WP_Hook->apply_filters, TEC\Events\Custom_Tables\V1\WP_Query\Modifiers\Events_Only_Modifier->filter_posts_pre_query, TEC\Events\Custom_Tables\V1\WP_Query\Custom_Tables_Query->get_posts, WP_Query->get_postsForum: Plugins
In reply to: [WooCommerce Stripe Payment Gateway] card number input fields inaccessibleI have just received information from DIVI which tells me that the problem is with them (☺) They are working on implementing a fix.
To be continued…
Thank you for your help.
Forum: Plugins
In reply to: [WooCommerce Stripe Payment Gateway] card number input fields inaccessibleI have contacted DIVI support and after numerous tests with them, it appears that the problem does not come from the theme but from the Stripe extension. They pointed out to me that there were errors in the console (see the attached screenshot)
Also I changed the CSS of the element wc-stripe-elements-field
{ border: 1px solid #ddd; margin: 5px; padding: 5px; background-color: #fff; outline: 0; min-height: 30px; }
We can clearly see that the height of the line is indeed modified but there is nothing in the value tag.
Forum: Plugins
In reply to: [WooCommerce Stripe Payment Gateway] card number input fields inaccessibleHi,
I have answer to you by mail but nothing has change so this is a copy of my mail. As you can see below it seems that I am not the only one who has the problem I describe. Thanks for your help.
Copy of My mail :
First of all, I must specify that my theme is DIVI and that I have a child theme.
I did the following tests :
– First : deactivation of all plugins except Woocommerce and Woocommerce Stripe gateway but keeping Divi Child. Result: entering the credit card is impossible.
– Second : deactivation of all plugins except Woocommerce and Woocommerce Stripe gateway keeping Divi but without Divi child I was not able to create an order in guest mode although I specified it in the Woocommerce settings For information, it is in my child theme that one of code created to authorize order creation in guest mode.
– Third : deactivation of all plugins except Woocommerce and Woocommerce Stripe gateway with Storefront theme. Impossible to create an order. The switch from Divi to Storefront does not create any pages and I cannot access the customer payment page.
So I came back to the following situation : Divi child Theme + woocommerce + woocommerce stripe gateway and I searched for the System Status Report that you will find below
WordPress Environment WordPress address (URL): https://aventure-trekking.com Site address (URL): https://aventure-trekking.com WC Version: 8.2.1 REST API Version: ✔ 8.2.1 WC Blocks Version: ✔ 11.1.2 Action Scheduler Version: ✔ 3.6.3 Log Directory Writable: ✔ WP Version: 6.3.2 WP Multisite: – WP Memory Limit: 1 Go WP Debug Mode: – WP Cron: ✔ Language: fr_FR External object cache: – Server Environment Server Info: Apache PHP Version: 7.4.27 PHP Post Max Size: 256 Mo PHP Time Limit: 1500 PHP Max Input Vars: 10000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.28-MariaDB Max Upload Size: 256 Mo Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Votre serveur n’a pas la classe SoapClient activée - certaines extensions de passerelle utilisant SOAP peuvent ne pas fonctionner correctement. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ Database WC Database Version: 8.2.1 WC Database Prefix: wpkk_ Taille totale de la base de données: 30.53MB Taille de la base de données: 27.05MB Taille de l’index: 3.48MB wpkk_woocommerce_sessions: Données : 0.06MB + Index : 0.02MB + Moteur InnoDB wpkk_woocommerce_api_keys: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_woocommerce_attribute_taxonomies: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_woocommerce_downloadable_product_permissions: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_woocommerce_order_items: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_woocommerce_order_itemmeta: Données : 0.06MB + Index : 0.03MB + Moteur InnoDB wpkk_woocommerce_tax_rates: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_woocommerce_tax_rate_locations: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_woocommerce_shipping_zones: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_woocommerce_shipping_zone_locations: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_woocommerce_shipping_zone_methods: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_woocommerce_payment_tokens: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_woocommerce_payment_tokenmeta: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_woocommerce_log: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_actionscheduler_actions: Données : 0.09MB + Index : 0.11MB + Moteur InnoDB wpkk_actionscheduler_claims: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_actionscheduler_groups: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_actionscheduler_logs: Données : 0.08MB + Index : 0.03MB + Moteur InnoDB wpkk_check_email_log: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_cky_banners: Données : 0.05MB + Index : 0.00MB + Moteur InnoDB wpkk_cky_cookies: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_cky_cookie_categories: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_commentmeta: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_comments: Données : 0.05MB + Index : 0.09MB + Moteur InnoDB wpkk_links: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_options: Données : 1.45MB + Index : 0.19MB + Moteur InnoDB wpkk_postmeta: Données : 1.52MB + Index : 0.33MB + Moteur InnoDB wpkk_posts: Données : 7.52MB + Index : 0.09MB + Moteur InnoDB wpkk_post_smtp_logmeta: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_post_smtp_logs: Données : 0.11MB + Index : 0.00MB + Moteur InnoDB wpkk_redirection_404: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_redirection_groups: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_redirection_items: Données : 0.02MB + Index : 0.09MB + Moteur InnoDB wpkk_redirection_logs: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_termmeta: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_terms: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_term_relationships: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_term_taxonomy: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_usermeta: Données : 0.06MB + Index : 0.03MB + Moteur InnoDB wpkk_users: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_wc_admin_notes: Données : 0.06MB + Index : 0.00MB + Moteur InnoDB wpkk_wc_admin_note_actions: Données : 0.05MB + Index : 0.02MB + Moteur InnoDB wpkk_wc_category_lookup: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wc_customer_lookup: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_download_log: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_orders: Données : 0.02MB + Index : 0.11MB + Moteur InnoDB wpkk_wc_orders_meta: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_order_addresses: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_wc_order_coupon_lookup: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_order_operational_data: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_order_product_lookup: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_wc_order_stats: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_wc_order_tax_lookup: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_wc_product_attributes_lookup: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wc_product_download_directories: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wc_product_meta_lookup: Données : 0.02MB + Index : 0.09MB + Moteur InnoDB wpkk_wc_rate_limits: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wc_reserved_stock: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wc_tax_rate_classes: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wc_webhooks: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wfblockediplog: Données : 0.06MB + Index : 0.00MB + Moteur InnoDB wpkk_wfblocks7: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_wfconfig: Données : 2.52MB + Index : 0.00MB + Moteur InnoDB wpkk_wfcrawlers: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wffilechanges: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wffilemods: Données : 7.52MB + Index : 0.00MB + Moteur InnoDB wpkk_wfhits: Données : 0.52MB + Index : 0.25MB + Moteur InnoDB wpkk_wfhoover: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wfissues: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_wfknownfilelist: Données : 3.52MB + Index : 0.00MB + Moteur InnoDB wpkk_wflivetraffichuman: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wflocs: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wflogins: Données : 0.06MB + Index : 0.03MB + Moteur InnoDB wpkk_wfls_2fa_secrets: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_wfls_role_counts: Données : 0.00MB + Index : 0.00MB + Moteur MEMORY wpkk_wfls_settings: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wfnotifications: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wfpendingissues: Données : 0.02MB + Index : 0.06MB + Moteur InnoDB wpkk_wfreversecache: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wfsecurityevents: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wfsnipcache: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_wfstatus: Données : 0.16MB + Index : 0.11MB + Moteur InnoDB wpkk_wftrafficrates: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wfwaffailures: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wpforms_payments: Données : 0.02MB + Index : 0.14MB + Moteur InnoDB wpkk_wpforms_payment_meta: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_wpforms_tasks_meta: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wpmailsmtp_debug_events: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_wpmailsmtp_tasks_meta: Données : 0.02MB + Index : 0.00MB + Moteur InnoDB wpkk_yoast_indexable: Données : 0.06MB + Index : 0.09MB + Moteur InnoDB wpkk_yoast_indexable_hierarchy: Données : 0.02MB + Index : 0.05MB + Moteur InnoDB wpkk_yoast_migrations: Données : 0.02MB + Index : 0.02MB + Moteur InnoDB wpkk_yoast_primary_term: Données : 0.02MB + Index : 0.03MB + Moteur InnoDB wpkk_yoast_seo_links: Données : 0.05MB + Index : 0.03MB + Moteur InnoDB Post Type Counts attachment: 59 awcdp_payment: 26 awcdp_payment_plan: 13 custom_css: 2 customize_changeset: 1 et_footer_layout: 1 et_pb_layout: 2 et_template: 1 nav_menu_item: 5 page: 27 post: 2 product: 13 revision: 282 seedprod: 1 shop_coupon: 1 shop_order: 21 ulpb_post: 1 wp_global_styles: 2 wp_navigation: 1 Security Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ Active Plugins (2) WooCommerce Stripe Gateway: par WooCommerce – 7.6.2 WooCommerce: par Automattic – 8.2.1 Inactive Plugins (8) CookieYes | GDPR Cookie Consent: par CookieYes – 3.1.6 Deposits & Partial Payments for WooCommerce - Pro: par Acowebs – 3.1.4 Redirection: par John Godley – 5.3.10 UpdraftPlus - Backup/Restore: par UpdraftPlus.Com DavidAnderson – 1.23.10 Wordfence Security: par Wordfence – 7.10.6 WP Crontrol: par John Blackbourn & crontributors – 1.16.0 WP Mail SMTP: par WP Mail SMTP – 3.9.0 Yoast SEO: par Team Yoast – 21.5 Settings API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right 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: – Enforce Approved Product Download Directories: ✔ HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – WC Pages Base de la boutique: #351 - /tous-les-sejours/ Panier: ❌ La page ne contient pas le code court [woocommerce_cart] ou le bloc woocommerce/cart. Commander: ❌ La page ne contient pas le code court [woocommerce_checkout] ou le bloc woocommerce/checkout. Mon compte: #13 - /mon-compte/ Conditions générales de vente et d’utilisation: #200 - /conditions-generales-de-vente/ Theme Name: Divi Enfant Version: 1.0 Author URL: https://aventure_trekking.com Child Theme: ✔ Parent Theme Name: Divi Parent Theme Version: 4.23.0 Parent Theme Author URL: http://www.elegantthemes.com WooCommerce Support: ✔ Templates Overrides: Divi-Child/woocommerce/emails/customer-completed-order.php Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: customize-store minified-js new-product-management-experience settings async-product-editor-category-field Daily Cron: ✔ Next scheduled: 2023-11-04 17:34:33 +01:00 Options: ✔ Notes: 77 Onboarding: skipped Action Scheduler Terminé: 143 Oldest: 2023-10-05 12:48:09 +0200 Newest: 2023-11-04 14:36:50 +0100 En attente: 6 Oldest: 2023-11-04 15:06:37 +0100 Newest: 2023-11-06 14:30:37 +0100 Échoué: 31 Oldest: 2023-09-15 09:37:29 +0200 Newest: 2023-11-03 19:16:05 +0100 Status report information Generated at: 2023-11-04 15:05:57 +01:00 `And there is no fatal error logs in the système.
Thank you in advance for your help.
Forum: Plugins
In reply to: [Redirection] RedirectionHi John,
Thanks for the info but I do not understand what you mean. Could you be more precise or maybe give me screen shot of what I have to do.
Excuse me for that.
Thanks
PhilippeForum: Fixing WordPress
In reply to: How to make global redirection?Hey Hudson,
Thanks for you help but as far as I understand, this can only work one URl by one URL and what I am searching is something that can take all URL’s.
Let see an example
The URL of all pages in Duth are like that http://www.toutle05.fr/nl/item/name_of_my_page-nl
Let take one for exemple : http://www.toutle05.fr/nl/item/latil02-nl/The URL of all pages in English are like that http://www.toutle05.fr/en/item/name_of_my_page-en
Let take the same in English than in Dutch : http://www.toutle05.fr/en/item/latil02-en/I have seen that I can say that I want redirect http://www.toutle05.fr/nl/item/latil02-nl/ to http://www.toutle05.fr/en/item/latil02-en/
But I have about 7 000 pages in Dutch. So I cannot managed all that pages like that.As I want to suppress Dutch pages I want to say to redirect http://www.toutle05.fr/nl/ to http://www.toutle05.fr/en/ and that is what I do not know how to do.
Thanks.
PhilippeForum: Plugins
In reply to: [Dave's WordPress Live Search] View more doesn’t workHi,
Thank you for your answers. I finally decided to build my own search.
Thank you for the links for WP Query.
Have a nice day.Forum: Plugins
In reply to: [Fast Secure Contact Form] fill form field with variables from another formHello Mbrsolution,
Many thanks you for your help, I have finally found how to do.
I have not understood how to use all your info, but now it works. I have just renamed form_name with 3name in the first form.
Thank you again. Have a nice day.
Philippe.Forum: Plugins
In reply to: [Fast Secure Contact Form] fill form field with variables from another formHello Mbrsolution,
I do not know how to send you a screen capture.
Could you help me?
Thanks
PhilippeHello again,
I have found how to give you screen capture.This is redirecting parameter of form 1 : http://www.webdesign05.fr/wp-content/uploads/param_form_test.jpg
This is URL after redirection http://www.webdesign05.fr/wp-content/uploads/redirect_url.jpg
This is how I have tried to put parameter in order to recover from_name in form 2 http://www.webdesign05.fr/wp-content/uploads/param_field_name_form_2.jpg
And it is not working, so this is what I have on form 2 (please don’t laugh) http://www.webdesign05.fr/wp-content/uploads/screen_form_2.jpg
Thank you telling me, where I am wrong and how I have to do.
Have a nice day.
Philippe.Forum: Plugins
In reply to: [Fast Secure Contact Form] fill form field with variables from another formHello Mbrsolution,
I have followed your instructions and this is the result of my tests.
I have a page called test with a form n°1 in it.
In that form only 2 fields : name1 and e-mail1
I have enable redirect after the message send and enable posted data.
My redirect URL is http://www.mywebsite.fr/receipt
I have rename form_name with xnamI have a page called receipt with a form n°2 in it.
In that form 2 fields : name2, e-mail2.After validation of the form n°1, I see that values of name and e-mail are in the URL and that’s good >> http://www.mywebsite.fr/receipt/?email_to=info%40mywebsite.fr&name_to=Webmaster&xnam=pipo4&from_email=bla%40mail.fr
But I do not see how to do in the form n°2 to have field name2 completed with the value of the name1 of the form n°1
Thank you for your help
PhilippeForum: Plugins
In reply to: [Fast Secure Contact Form] fill form field with variables from another formHello,
I am not in my office today. I seems to be the good things for me.
I will have a look this evening or tomorow morning and I will make a return to you as soon as possible.
Thank you for your help and your quick answer.
philippeForum: Themes and Templates
In reply to: [Pure & Simple] How to align left logoJust GREAT.
It works exactly like I want.
Thank you very much.
I wish you an happy new year.
Philippe.
