[TRFW_ORDER_DETAILS] doesn’t work, ‘order’ is protected query?
-
Using [TRFW_ORDER_DETAILS] didn’t work for me. The URL was https://example.com/register/confirmation/?order=4723
I did some debugging and I was able to get it to work by changing the GET variable on line 339 to be “order_id” instead of “order”:
$order_id = $_GET['order_id'];
…and then changing the URL to match:
https://example.com/register/confirmation/?order_id=4723.I think the issue is related to “order” being a variable WP uses as part of the loop, and maybe it’s protected?
I think line 204 and 228 would also need to be changed to used order_id:
$order_string = "&order_id=$order_id";
Can you verify?
-
Hi @fergbrain although the plugin works, but I would like to test the possibility. Can you share woocommerce log for more details.
Thanks in advance
Hi @fergbrain closing the issue because of non availability of WooCommerce Log. But I will be looking forward for the possibility you have mentioned.
Thanks in advance
sorry, I was on a work trip this week. Here’s the log if you’re still able to take a look:
### WordPress Environment ### WordPress address (URL): https://<redacted>.com Site address (URL): https://<redacted>.com WC Version: 6.3.1 REST API Version: ? 6.3.1 WC Blocks Version: ? 6.9.0 Action Scheduler Version: ? 3.4.0 WC Admin Version: ? 3.2.1 Log Directory Writable: ? WP Version: ? 5.9.2 - There is a newer version of WordPress available (5.9.3) WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.0.17 PHP Post Max Size: 100 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.79.1 OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 5.7.26-29-log Max Upload Size: 100 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.3.1 WC Database Prefix: wpa5_ Total Database Size: 105.48MB Database Data Size: 98.66MB Database Index Size: 6.82MB wpa5_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_woocommerce_order_itemmeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB wpa5_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_actionscheduler_actions: Data: 0.14MB + Index: 0.14MB + Engine InnoDB wpa5_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_actionscheduler_logs: Data: 0.11MB + Index: 0.09MB + Engine InnoDB wpa5_apto_sort_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpa5_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpa5_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB wpa5_ctf_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_ninja_table_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_options: Data: 5.02MB + Index: 0.16MB + Engine InnoDB wpa5_postmeta: Data: 7.44MB + Index: 1.84MB + Engine InnoDB wpa5_posts: Data: 76.48MB + Index: 0.72MB + Engine InnoDB wpa5_redirection_404: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wpa5_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpa5_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB wpa5_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_usermeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB wpa5_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpa5_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wfblockediplog: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wpa5_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_wfconfig: Data: 0.45MB + Index: 0.00MB + Engine InnoDB wpa5_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wffilemods: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wpa5_wfhits: Data: 1.02MB + Index: 0.09MB + Engine InnoDB wpa5_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_wfknownfilelist: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wpa5_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wflocs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpa5_wflogins: Data: 0.19MB + Index: 0.06MB + Engine InnoDB wpa5_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpa5_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpa5_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB wpa5_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wpdatatable_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_wpdatatable_2: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_yikes_easy_mc_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpa5_yoast_indexable: Data: 1.52MB + Index: 0.44MB + Engine InnoDB wpa5_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.08MB + Engine InnoDB wpa5_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpa5_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpa5_yoast_seo_links: Data: 0.17MB + Index: 0.11MB + Engine InnoDB wpa5_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_j3zbv9sf4g_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_j3zbv9sf4g_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_j3zbv9sf4g_options: Data: 0.11MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_j3zbv9sf4g_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_j3zbv9sf4g_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_j3zbv9sf4g_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_j3zbv9sf4g_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_j3zbv9sf4g_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### apto_sort: 14 attachment: 871 aw_workflow: 4 custom_css: 1 customize_changeset: 2 event_ticket: 51 nav_menu_item: 9 ninja-table: 1 oembed_cache: 1 page: 45 post: 73 product: 2 revision: 3323 shop_coupon: 1 shop_order: 24 speaker: 61 tablepress_table: 2 us_content_template: 1 us_grid_layout: 14 us_header: 1 us_page_block: 3 us_portfolio: 54 us_testimonial: 9 us_widget_area: 1 wptb-tables: 3 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (26) ### Gravity Forms: by rocketgenius – 2.4.16 Ultimate Addons for WPBakery Page Builder: by Brainstorm Force – 3.19.11 Advanced Post Types Order: by Nsp Code – 4.5.1 Akismet Anti-Spam: by Automattic – 4.2.2 AutomateWoo: by WooCommerce – 5.5.12 Custom Post Type UI: by WebDevStudios – 1.11.1 Custom Twitter Feeds: by Smash Balloon – 1.8.4 Decorator - WooCommerce Email Customizer: by WebToffee – 1.2.0 Duplicate Page: by mndpsingh287 – 4.4.8 Google Tag Manager for WordPress: by Thomas Geiger – 1.14.2 WPBakery Page Builder: by Michael M - WPBakery.com – 6.6.0 Manual Order for Woocommerce: by Coderstime – 1.1.0 Facebook for WordPress: by Facebook – 3.0.6 Redirection: by John Godley – 5.2.3 Slider Revolution: by ThemePunch – 6.5.0 Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.30 TablePress: by Tobias B?thge – 1.14 UpSolution Core: by UpSolution – 7.14.2 Thanks Redirect for WooCommerce (MOD): by Nitin Prakash – 3.1.1 Woo Discount Rules: by Flycart – 2.3.13 WooCommerce Box Office: by WooCommerce – 1.1.36 WooCommerce Stripe Gateway: by WooCommerce – 6.3.0 WooCommerce: by Automattic – 6.3.1 Yoast SEO: by Team Yoast – 18.5.1 WP Table Builder: by WP Table Builder – 1.3.16 Easy Forms for Mailchimp: by YIKES Inc. – 6.8.6 ### Inactive Plugins (4) ### Better Search Replace: by Delicious Brains – 1.4 Header Builder: by UpSolution – 2.4 Post Types Order: by Nsp Code – 1.9.8 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 ### Dropin Plugins (1) ### object-cache.php: APCu Object Cache ### Must Use Plugins (1) ### System Plugin: by – 4.22.2 ### 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) 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 ### Shop base: #4553 - /shop/ Cart: #4554 - /cart/ Checkout: #4555 - /checkout/ My account: #4556 - /my-account/ Terms and conditions: #2100 - /terms-conditions/ ### Theme ### Name: <redacted> Version: 2022.03.20 Author URL: Child Theme: ? Parent Theme Name: Impreza Parent Theme Version: 7.14.2 Parent Theme Author URL: https://us-themes.com/ WooCommerce Support: ? ### Templates ### Overrides: <redacted>/woocommerce/checkout/thankyou.php <redacted>/woocommerce/content-single-product.php <redacted>/woocommerce/emails/customer-completed-order.php <redacted>/woocommerce/emails/customer-invoice.php <redacted>/woocommerce/emails/customer-processing-order.php <redacted>/woocommerce/emails/email-order-details.php <redacted>/woocommerce/emails/plain/customer-completed-order.php <redacted>/woocommerce/emails/plain/customer-processing-order.php <redacted>/woocommerce/emails/plain/email-order-details.php ### Action Scheduler ### Complete: 476 Oldest: 2022-03-18 19:05:17 -0700 Newest: 2022-04-08 23:38:22 -0700 ### Status report information ### Generated at: 2022-04-10 15:33:40 -07:00
Let me know if you need more details, thanks!
Hi @fergbrain this issue is fixed.
Thanks!
- The topic ‘[TRFW_ORDER_DETAILS] doesn’t work, ‘order’ is protected query?’ is closed to new replies.