Brizy WooCommerce Integration issue

Lloyd Pearson

• November 03, 2024 23:15

I can't view the checkout page in Brizy editor, it just hangs forever when trying to view it. I checked the error logs and this is what I am getting:

miamirecoveryhaven.com [Sun Nov 03 23:04:35 2024] [error] [client 2600:1009:a021:7cb1:e0e5:70ec:4e9c:1d26:0] AH01071: Got error 'PHP message: WordPress database error Table 'SCWORDPRESS-3530363775b0.wp_postmeta' doesn't exist for query UPDATE wp_postmeta pm\n\t\t\t\t\t   JOIN wp_postmeta m ON m.post_id=pm.post_id and m.meta_key="brizy_enabled" and m.meta_value=1\n\t\t\t\t\t   LEFT JOIN wp_postmeta mm ON mm.post_id=pm.post_id and mm.meta_key="brizy-post-compiler-version"\n\t\t\t\t\t   SET pm.meta_value=1\n\t\t\t\t\t   WHERE pm.meta_key="brizy-need-compile" and pm.meta_value=0 and CONVERT(REPLACE(IF(STRCMP(mm.meta_value,"dev") = 0,  0, mm.meta_value), " - wp", "") ,UNSIGNED )<294 made by do_action('wp_ajax_brizy-update-global-blocks'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Blocks_Api->actionUpdateGlobalBlocks, do_action('brizy_global_data_updated'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Main->global_data_updated, Brizy_Editor_Post::mark_all_for_compilation'

I recently sent you all login details for that site due to another issue, What can be causing the problem and how does it get fixed?

0

• 

  Ariel H.

  • November 04, 2024 12:57

  Hi Lloyd,

  Thank you for reaching out to us.

  I have reviewed your site, but I couldn't replicate the issue.

  
  Could you please clear your browser cache or try accessing it with a different browser?

  Best regards,  
  Ariel H.

  0
• 

  Lloyd Pearson

  • November 04, 2024 13:35

  I have 2 checkout pages, the one that woocommerce uses will not let me edit it. I have made a screen recording of it. 
  
  https://share.cleanshot.com/kCKD62Dt

  0
• 

  Ariel H.

  • November 04, 2024 14:01

  Hi Lloyd,

  Thank you for the update. I'm editing the same page without encountering the issue—here’s a quick video showing my experience: https://youtu.be/Kxg479setaQ.

  I’m currently using Firefox, and it also works in Chrome. Please try a different browser and see if this helps resolve the issue.

  Best regards,  
  Ariel H.

  0
• 

  Lloyd Pearson

  • November 04, 2024 14:46

  It still doesn't explain what's going on in the error logs:
  
  miamirecoveryhaven.com [Sun Nov 03 22:49:58 2024] [error] [client 2600:1009:a021:7cb1:e0e5:70ec:4e9c:1d26:0] AH01071: Got error 'PHP message: WordPress database error Table 'SCWORDPRESS-3530363775b0.wp_postmeta' doesn't exist for query UPDATE wp_postmeta pm\n\t\t\t\t\t   JOIN wp_postmeta m ON m.post_id=pm.post_id and m.meta_key="brizy_enabled" and m.meta_value=1\n\t\t\t\t\t   LEFT JOIN wp_postmeta mm ON mm.post_id=pm.post_id and mm.meta_key="brizy-post-compiler-version"\n\t\t\t\t\t   SET pm.meta_value=1\n\t\t\t\t\t   WHERE pm.meta_key="brizy-need-compile" and pm.meta_value=0 and CONVERT(REPLACE(IF(STRCMP(mm.meta_value,"dev") = 0,  0, mm.meta_value), " - wp", "") ,UNSIGNED )<294 made by do_action('wp_ajax_brizy-update-global-blocks'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Blocks_Api->actionUpdateGlobalBlocks, do_action('brizy_global_data_updated'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Main->global_data_updated, Brizy_Editor_Post::mark_all_for_compilation'
  miamirecoveryhaven.com [Sun Nov 03 23:04:35 2024] [error] [client 2600:1009:a021:7cb1:e0e5:70ec:4e9c:1d26:0] AH01071: Got error 'PHP message: WordPress database error Table 'SCWORDPRESS-3530363775b0.wp_postmeta' doesn't exist for query UPDATE wp_postmeta pm\n\t\t\t\t\t   JOIN wp_postmeta m ON m.post_id=pm.post_id and m.meta_key="brizy_enabled" and m.meta_value=1\n\t\t\t\t\t   LEFT JOIN wp_postmeta mm ON mm.post_id=pm.post_id and mm.meta_key="brizy-post-compiler-version"\n\t\t\t\t\t   SET pm.meta_value=1\n\t\t\t\t\t   WHERE pm.meta_key="brizy-need-compile" and pm.meta_value=0 and CONVERT(REPLACE(IF(STRCMP(mm.meta_value,"dev") = 0,  0, mm.meta_value), " - wp", "") ,UNSIGNED )<294 made by do_action('wp_ajax_brizy-update-global-blocks'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Blocks_Api->actionUpdateGlobalBlocks, do_action('brizy_global_data_updated'), WP_Hook->do_action, WP_Hook->apply_filters, Brizy_Admin_Main->global_data_updated, Brizy_Editor_Post::mark_all_for_compilation'

  0
• 

  Lloyd Pearson

  • November 04, 2024 14:49

  And the real issue is that the checkout page isnt loading
  
  https://share.cleanshot.com/RvZFcTLR

  0
• 

  Ariel H.

  • November 04, 2024 15:02

  Hi Lloyd,

  It looks like the wp_postmeta table may be corrupted, or there might be an issue with the database prefix configuration, which is preventing the table (SCWORDPRESS-3530363775b0.wp_postmeta) from being found. Please verify that the database prefix in wp-config.php matches the actual prefix used in your database tables.

  If the prefix is correct, try repairing or optimizing your database by following the steps in this guide: https://verpex.com/blog/wordpress-hosting/how-to-repair-the-wordpress-database.

  Best regards,  
  Ariel H.

  0
• 

  Lloyd Pearson

  • November 04, 2024 15:32

  Prefix is matching. 
  Checked for errors, said everything is ok
  
  did you check this out?
  
  And the real issue is that the checkout page isnt loading
  
  https://share.cleanshot.com/RvZFcTLR

  0
• 

  Ariel H.

  • November 04, 2024 15:43

  Hi Lloyd,

  Upon checking the issue doesn't occur on Windows - https://youtu.be/FiLXbF3WWZk
  However, on iOS the issue occurs - https://youtu.be/PSYbXN-Fp2A

  I assume that this issue is only specific to Apple devices. Could you confirm if you're on a Mac?
  I currently don't have access to a Mac but I will check with a colleague if the issue can be replicated.

  Best regards,
  Ariel H.

  0
• 

  Lloyd Pearson

  • November 04, 2024 15:54

  I am definitely on Mac

  0
• 

  Lloyd Pearson

  • November 04, 2024 16:51

  Brizy editor not loading could also be a Mac Specific issue too

  0
• 

  Ariel H.

  • November 05, 2024 08:32

  Hi Lloyd,

  Thank you for the update.

  Upon checking, we didn’t encounter any issues editing the page on a Mac, as shown in this screencast: https://youtu.be/siBjwVmyvtk.

  However, it appears the shopping cart is not functioning properly. Please try rebuilding the cart by deleting and recreating it to see if this resolves the issue. For reference, we have an example here: https://jumpshare.com/v/7HFhDvI6CwvMWG0zqEbE.

  Please give this a try and let me know how it goes.

  Best regards,  
  Ariel H.

  0

Please sign in to leave a comment.