Cart Price adjustments not working – php/db errors since update 10th Dec

  • Resolved clickingclients

    (@clickingclients)


    3 years, 11 months ago

    If 3+ items are added to the cart, then some FREE bonus (similar) products are added into the store:
    Buy 3 Get 4
    Buy 5 Get 7… etc
    But now the bonuses are simply NOT getting added.

    Since update on 10th December we are getting errors in php errorlog (but no error on the front end – just):

    [10-Dec-2020 11:13:54 UTC] WordPress database error Table 'XXXXXXXXXXX.wp_term_relationships' doesn't exist for query SELECT wat_term_relationships .....

    It seems to want to reference “wp_term_relationships” however there is no table for that – only there is wat_term_relationships

    How to isolate the problem or roll-back so the dynamic rules work again?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter clickingclients

    (@clickingclients)

    I’ve found the error.
    There is a hard coded section on line 88 of
    advanced-dynamic-pricing-for-woocommerce/BaseVersion/Includes/Cart/FreeCartItemChoicesSuitability.php:

    SELECT object_id
FROM wp_term_relationships

    it should be 

    SELECT object_id
FROM wat_term_relationships

    When I manually update it in phpmyadmin it works again.

    1) How do I ensure this is not overwritten in future updates?
    2) How can I be sure this is actually THE problem and I’ve not masked it?

    Hi, clickingclients,

    Please, send us a ticket in the helpdesk and we’ll send you the fixed version.

    Thread Starter clickingclients

    (@clickingclients)

    Thank you

    You’re welcome.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Cart Price adjustments not working – php/db errors since update 10th Dec’ is closed to new replies.

Tags