WordPress database error: [Unknown column 'rsvpdates.enddate' in 'field list']
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, ID as postID, rsvpdates.date as datetime, date_format(rsvpdates.date,'%M %e, %Y') as date, rsvpdates.enddate, rsvpdates.display_type, rsvpdates.ts_start, rsvpdates.ts_end, rsvpdates.timezone
FROM wp_posts JOIN wp_rsvpmaker_event rsvpdates ON rsvpdates.event = wp_posts.ID
WHERE 1=1 AND wp_posts.post_type = 'rsvpmaker' AND ((wp_posts.post_status = 'publish')) AND ( ( rsvpdates.date >= '2024-11-01' ) OR ( rsvpdates.enddate >= '2024-11-01' ))
GROUP BY wp_posts.ID
ORDER BY rsvpdates.date
LIMIT 0, 10
November 2024
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
---|---|---|---|---|---|---|
1
| 2
| |||||
3
| 4
| 5
| 6
| 7
| 8
| 9
|
10
| 11
| 12
| 13
| 14
| 15
| 16
|
17
| 18
| 19
| 20
| 21
| 22
| 23
|
24
| 25
| 26
| 27
| 28
| 29
| 30
|
WordPress database error: [Unknown column 'rsvpdates.enddate' in 'field list']
SELECT wp_posts.*, ID as postID, rsvpdates.date as datetime, date_format(rsvpdates.date,'%M %e, %Y') as date, rsvpdates.enddate, rsvpdates.display_type, rsvpdates.ts_start, rsvpdates.ts_end, rsvpdates.timezone
FROM wp_posts JOIN wp_rsvpmaker_event rsvpdates ON rsvpdates.event = wp_posts.ID
WHERE 1=1 AND wp_posts.post_type = 'rsvpmaker' AND ((wp_posts.post_status = 'publish')) AND enddate > '2024-11-01' AND enddate < DATE_ADD('2024-11-01', INTERVAL 5 WEEK)
ORDER BY rsvpdates.date