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-10-21' OR rsvpdates.enddate > '2024-10-21' ) )
GROUP BY wp_posts.ID
ORDER BY rsvpdates.date
LIMIT 0, 10
October 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
| 31
|
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-10-01' AND enddate < DATE_ADD('2024-10-01', INTERVAL 5 WEEK)
ORDER BY rsvpdates.date