The Events Calendar PHP Errors
-
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.1Errors :
TOTAL QUERIES:254 TOTAL DB ERRORS:4
Database Errors
- 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 JOINgKNzj_pmpro_memberships_pagesASpmpro_mp_4
ONpmpro_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’ - 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 JOINgKNzj_pmpro_memberships_pagesASpmpro_mp_5
ONpmpro_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’ - 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 JOINgKNzj_pmpro_memberships_pagesASpmpro_mp_8
ONpmpro_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’ - 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 JOINgKNzj_pmpro_memberships_pagesASpmpro_mp_9
ONpmpro_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]
- SELECT SQL_CALC_FOUND_ROWS gKNzj_posts.ID
Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
The topic ‘The Events Calendar PHP Errors’ is closed to new replies.