• Resolved bazmark

    (@bazmark)


    We are using The Events Calendar with Paid MemberShips Pro and the Paid Memberships Pro – Events Add On. When viewing the Events List, there are a number of PHP errors reported (see below). Can anyone assist in fixing this?

    Paid Memberships Pro – Events Add On Version 1.4
    Paid Memberships Pro Version 3.0.4
    The Events Calendar Version 6.5.1.1

    Errors :

    TOTAL QUERIES:254 TOTAL DB ERRORS:4

    Database Errors

    1. SELECT SQL_CALC_FOUND_ROWS gKNzj_posts.ID
      FROM gKNzj_posts INNER JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id

      LEFT JOIN gKNzj_pmpro_memberships_pages AS pmpro_mp_4
      ON pmpro_mp_4.page_id = gKNzj_posts.ID

      JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id 
      WHERE 1=1 AND ( 
      CAST(gKNzj_tec_occurrences.end_date_utc AS DATETIME) < ‘2024-06-14 01:49:37’
      ) AND gKNzj_posts.post_type = ‘tribe_events’ AND ((gKNzj_posts.post_status = ‘publish’ OR gKNzj_posts.post_status = ‘private’)) AND (pmpro_mp_4.membership_id IS NULL OR pmpro_mp_4.membership_id IN ( 4 )) 
      GROUP BY gKNzj_tec_occurrences.occurrence_id
      ORDER BY gKNzj_posts.post_date ASC
      LIMIT 0, 1
      Not unique table/alias: ‘gKNzj_tec_occurrences’
    2. SELECT SQL_CALC_FOUND_ROWS gKNzj_posts.ID
      FROM gKNzj_posts INNER JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id

      LEFT JOIN gKNzj_pmpro_memberships_pages AS pmpro_mp_5
      ON pmpro_mp_5.page_id = gKNzj_posts.ID

      JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id 
      WHERE 1=1 AND ( 
      CAST(gKNzj_tec_occurrences.end_date_utc AS DATETIME) < ‘2024-06-14 01:49:37’
      ) AND gKNzj_posts.post_type = ‘tribe_events’ AND ((gKNzj_posts.post_status = ‘publish’ OR gKNzj_posts.post_status = ‘private’)) AND (pmpro_mp_5.membership_id IS NULL OR pmpro_mp_5.membership_id IN ( 4 )) 
      GROUP BY gKNzj_tec_occurrences.occurrence_id
      ORDER BY gKNzj_posts.post_date ASC
      LIMIT 0, 1
      Not unique table/alias: ‘gKNzj_tec_occurrences’
    3. SELECT SQL_CALC_FOUND_ROWS gKNzj_posts.ID
      FROM gKNzj_posts INNER JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id

      LEFT JOIN gKNzj_pmpro_memberships_pages AS pmpro_mp_8
      ON pmpro_mp_8.page_id = gKNzj_posts.ID

      JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id 
      WHERE 1=1 AND ( 
      CAST(gKNzj_tec_occurrences.end_date_utc AS DATETIME) < ‘2024-06-14 01:49:37’
      ) AND gKNzj_posts.post_type = ‘tribe_events’ AND ((gKNzj_posts.post_status = ‘publish’ OR gKNzj_posts.post_status = ‘private’)) AND (pmpro_mp_8.membership_id IS NULL OR pmpro_mp_8.membership_id IN ( 4 )) 
      GROUP BY gKNzj_tec_occurrences.occurrence_id
      ORDER BY gKNzj_posts.post_date ASC
      LIMIT 0, 1
      Not unique table/alias: ‘gKNzj_tec_occurrences’
    4. SELECT SQL_CALC_FOUND_ROWS gKNzj_posts.ID
      FROM gKNzj_posts INNER JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id

      LEFT JOIN gKNzj_pmpro_memberships_pages AS pmpro_mp_9
      ON pmpro_mp_9.page_id = gKNzj_posts.ID

      JOIN gKNzj_tec_occurrences ON gKNzj_posts.ID = gKNzj_tec_occurrences.post_id 
      WHERE 1=1 AND ( 
      CAST(gKNzj_tec_occurrences.end_date_utc AS DATETIME) < ‘2024-06-14 01:49:37’
      ) AND gKNzj_posts.post_type = ‘tribe_events’ AND ((gKNzj_posts.post_status = ‘publish’ OR gKNzj_posts.post_status = ‘private’)) AND (pmpro_mp_9.membership_id IS NULL OR pmpro_mp_9.membership_id IN ( 4 )) 
      GROUP BY gKNzj_tec_occurrences.occurrence_id
      ORDER BY gKNzj_posts.post_date ASC
      LIMIT 0, 1
      Not unique table/alias: ‘gKNzj_tec_occurrences’

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Jes

    (@jescandoit)

    Hi @bazmark,

    To further investigate on this issue, would you mind sharing the following information?

    • PHP version
    • Database version
    • WordPress version

    Also, does this happen on The Events Calendar Version 6.5.1.1 or the issue exists on the previous versions?

    Please do not share any credentials, this is for us to follow the WordPress Forum Guidelines.

    Thread Starter bazmark

    (@bazmark)

    Hi Jes,

    Thank you for your reply. In answer to your questions

    The issue also exists on our Dev (staging site) and production site.

    – Dev PHP version: 7.4.33. 

    – Production PHP version: 8.2.20

    – Dev Database version: 
    Server version 10.6.18
    Client version mysqlnd 7.4.33

    – Production Database version: 
    Server version 8.0.37
    Client version mysqlnd 8.2.20

    – WordPress version: 6.5.4

    Does this happen on The Events Calendar Version 6.5.1.1 or the issue exists on the previous versions?

    Yes, it happens with 6.5.1.1. I have upgraded to 6.5.1.3, and the problem still exists.

    Plugin Support tristan083

    (@tristan083)

    Hi @bazmark ,

    Thank you for your message and the information.

    Just to have a clear understanding of the issue and to isolate the issue here, does deactivating Paid Memberships Pro – Events Add On plugin continue to throw out the database error?

    • This reply was modified 1 year, 11 months ago by tristan083.
    Thread Starter bazmark

    (@bazmark)

    Hi @tristan083 ,

    Deactivating the Paid Memberships Pro – Events Add On plugin removes the error.

    Plugin Support tristan083

    (@tristan083)

    Hi @bazmark ,

    Thank you for your message and the information.

    In that case, I’m afraid we’re looking at a conflict with the Paid Memberships Pro – Events Add On plugin here. Unfortunately, we do not have in-house knowledge of this plugin’s programming. Have you tried reaching out to the plugin’s support to see if they could find what’s causing the error from their code-base?

    Plugin Support Darian

    (@d0153)

    Hi there,

    It appears that there hasn’t been any recent activity on this thread, so we’ll consider it resolved. However, if you have any additional questions or concerns, feel free to start a new thread.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘The Events Calendar PHP Errors’ is closed to new replies.