ERROR: Query failed; error='Table 'kmoser_kms.swing_users' doesn't exist' (1146), SQL='SELECT * FROM swing_users WHERE ( `id` IS NULL )' SQL error=Table 'kmoser_kms.swing_users' doesn't exist, error number=1146, SQL statement=SELECT * FROM swing_users WHERE ( `id` IS NULL )
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_users' doesn't exist' (1146), SQL='SELECT * FROM swing_users WHERE ( `id` IS NULL )' SQL error=Table 'kmoser_kms.swing_users' doesn't exist, error number=1146, SQL statement=SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_users' doesn't exist' (1146), SQL='SELECT * FROM swing_users WHERE ( `id` IS NULL )' SQL error=Table 'kmoser_kms.swing_users' doesn't exist, error number=1146, SQL statement=SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_users' doesn't exist' (1146), SQL='SELECT * FROM swing_users WHERE ( `id` IS NULL )'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingUser.inc.php(22): KRec->select_all_rows(<b style="color: green;">sql => SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>, <b style="color: green;">return_after_first => 1</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2278): SwingUser->select_all_rows(<b style="color: green;">sql => SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>, <b style="color: green;">return_after_first => 1</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingUser.inc.php(26): KRec->select_one_row(<b style="color: green;">sql => SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(727): SwingUser->select_one_row(<b style="color: green;">sql => SELECT * FROM swing_users WHERE ( `id` IS NULL )</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingUser.inc.php(8): KRec::from_db(<b style="color: green;">0 => NULL</b>, <b style="color: green;">1 => SwingUser</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(39): SwingUser::from_db(<b style="color: green;">0 => NULL</b>)<br/>
ERROR: Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-03-04"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-04-03"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-03-04"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-04-03"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(29): KRec->select_all_rows(<b style="color: green;">0 => swing_events.id</b>, <b style="color: green;">1 => swing_events.venue_id</b>, <b style="color: green;">2 => swing_bands.id AS band_id</b>, <b style="color: green;">3 => DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago</b>, <b style="color: green;">4 => swing_bands.name AS band_name</b>, <b style="color: green;">5 => swing_events.when_type</b>, <b style="color: green;">6 => swing_events.weekdays</b>, <b style="color: green;">7 => swing_events.start_when</b>, <b style="color: green;">8 => swing_events.end_when</b>, <b style="color: green;">9 => swing_events.time</b>, <b style="color: green;">10 => swing_events.time_start</b>, <b style="color: green;">11 => swing_events.time_end</b>, <b style="color: green;">12 => swing_events.repeats</b>, <b style="color: green;">13 => swing_venues.venue_type</b>, <b style="color: green;">14 => swing_venues.name AS venue_name</b>, <b style="color: green;">15 => swing_venues.name_short AS venue_name_short</b>, <b style="color: green;">16 => swing_venues.address AS address</b>, <b style="color: green;">17 => swing_venues.city AS city</b>, <b style="color: green;">18 => swing_venues.state AS state</b>, <b style="color: green;">19 => swing_venues.zip AS zip</b>, <b style="color: green;">20 => swing_venues.lat AS lat</b>, <b style="color: green;">21 => swing_venues.lon AS lon</b>, <b style="color: green;">22 => swing_venues.phone AS phone</b>, <b style="color: green;">23 => COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url</b>, <b style="color: green;">24 => swing_venues.map_url AS map_url</b>, <b style="color: green;">25 => COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost</b>, <b style="color: green;">26 => COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name</b>, <b style="color: green;">27 => COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short</b>, <b style="color: green;">28 => COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image</b>, <b style="color: green;">29 => COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description</b>, <b style="color: green;">30 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons</b>, <b style="color: green;">31 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social</b>, <b style="color: green;">32 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music</b>, <b style="color: green;">33 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs</b>, <b style="color: green;">34 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs</b>, <b style="color: green;">35 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy</b>, <b style="color: green;">36 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues</b>, <b style="color: green;">37 => NULL AS distance</b>, <b style="color: green;">38 => GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates</b>, <b style="color: green;">39 => GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(804): SwingEvent->select_all_rows(<b style="color: green;">0 => swing_events.id</b>, <b style="color: green;">1 => swing_events.venue_id</b>, <b style="color: green;">2 => swing_bands.id AS band_id</b>, <b style="color: green;">3 => DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago</b>, <b style="color: green;">4 => swing_bands.name AS band_name</b>, <b style="color: green;">5 => swing_events.when_type</b>, <b style="color: green;">6 => swing_events.weekdays</b>, <b style="color: green;">7 => swing_events.start_when</b>, <b style="color: green;">8 => swing_events.end_when</b>, <b style="color: green;">9 => swing_events.time</b>, <b style="color: green;">10 => swing_events.time_start</b>, <b style="color: green;">11 => swing_events.time_end</b>, <b style="color: green;">12 => swing_events.repeats</b>, <b style="color: green;">13 => swing_venues.venue_type</b>, <b style="color: green;">14 => swing_venues.name AS venue_name</b>, <b style="color: green;">15 => swing_venues.name_short AS venue_name_short</b>, <b style="color: green;">16 => swing_venues.address AS address</b>, <b style="color: green;">17 => swing_venues.city AS city</b>, <b style="color: green;">18 => swing_venues.state AS state</b>, <b style="color: green;">19 => swing_venues.zip AS zip</b>, <b style="color: green;">20 => swing_venues.lat AS lat</b>, <b style="color: green;">21 => swing_venues.lon AS lon</b>, <b style="color: green;">22 => swing_venues.phone AS phone</b>, <b style="color: green;">23 => COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url</b>, <b style="color: green;">24 => swing_venues.map_url AS map_url</b>, <b style="color: green;">25 => COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost</b>, <b style="color: green;">26 => COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name</b>, <b style="color: green;">27 => COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short</b>, <b style="color: green;">28 => COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image</b>, <b style="color: green;">29 => COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description</b>, <b style="color: green;">30 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons</b>, <b style="color: green;">31 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social</b>, <b style="color: green;">32 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music</b>, <b style="color: green;">33 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs</b>, <b style="color: green;">34 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs</b>, <b style="color: green;">35 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy</b>, <b style="color: green;">36 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues</b>, <b style="color: green;">37 => NULL AS distance</b>, <b style="color: green;">38 => GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates</b>, <b style="color: green;">39 => GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(930): SwingEvent::retrieve_matching_events(<b style="color: green;">dt_start => </b>, <b style="color: green;">dt_end => </b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(806): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(930): SwingEvent::retrieve_matching_events(<b style="color: green;">dt_start => </b>, <b style="color: green;">dt_end => </b>)<br/>
ERROR: Error retrieving matching events: SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-03-04"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-04-03"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(932): KError::log_error(<b style="color: green;">0 => Error retrieving matching events: SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-03-04"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-04-03"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->

		<base href="/events/">

		<title>South Florida Swing, Lindy Hop, and Blues: classes and social dancing</title>

		<meta property="og:url"           content="http://blueswing.kim/event/20210201-186-993" />
<!--
		<meta property="og:type"          content="website" />
		<meta property="og:title"         content="Your Website Title" />
		<meta property="og:description"   content="Your description" />
		<meta property="og:image"         content="https://www.your-domain.com/path/image.jpg" />
-->

		<link rel="icon" href="/images/favicon.ico">

		<script src="../js/jquery-1.12.4.min.js"></script>
		<!--script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script -->


		<!-- Bootstrap -->
		<link href="../bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
		<!--link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" -->

		<link href="kcalendar.css" rel="stylesheet">

		<link href="style.css" rel="stylesheet">

		<script src="../bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>

		<script type="text/javascript" src="//addevent.com/libs/atc/1.6.1/atc.min.js" async defer></script>

		<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
		<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
		<!--[if lt IE 9]>
			<script src="//oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
			<script src="//oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
		<![endif]-->
	</head>
	<body>
<!--
		<div id="fb-root"></div>
		<script>(function(d, s, id) {
		  var js, fjs = d.getElementsByTagName(s)[0];
		  if (d.getElementById(id)) return;
		  js = d.createElement(s); js.id = id;
		  js.src = '//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.11';
		  fjs.parentNode.insertBefore(js, fjs);
		}(document, 'script', 'facebook-jssdk'));</script>
-->

		<!-- Fixed navbar -->
		<nav class="navbar navbar-default navbar-fixed-top navbar-inverse">
			<div class="container">
				<div class="navbar-header">
					<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
						<span class="sr-only">Toggle navigation</span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
					</button>
					<a class="navbar-brand" title="Swing, Lindy Hop, and Blues in Martin County, Palm Beach County, Broward County, and Dade County" href="#home">South Florida Swing</a>
				</div>
				<div id="navbar" class="navbar-collapse collapse">
					<ul class="nav navbar-nav">
						<li><a href="#home">Home</a></li>
						<li><a href="#calendar">Calendar</a></li>
						<li><a href="#map">Map</a></li>
						<li><a href="#venues">Venues</a></li>
						<li><a href="#lessons">Lessons</a></li>
						<li><a href="#social">Social Dancing</a></li>
						<li><a href="#music">Live Music</a></li>
						<li><a href="#bands">Bands</a></li>
						<li><a href="#contact">Contact</a></li>
						<li><a href="#" onclick="$( '#search' ).modal( 'show' ); return false;">Search</a></li>
						<li class="dropdown">
							<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
								My Account
							<span class="caret"></span></a>
							<ul class="dropdown-menu">
								<li><a href="#" onclick="$( '#login' ).modal( 'show' ); $( '#login input[name=username]' ).focus(); return false;">Log In</a></li>
								<li><a href="#" onclick="$( '#register' ).modal( 'show' ); return false;">Register</a></li>
							</ul>
						</li>
	<!--
						<li class="dropdown">
							<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
							<ul class="dropdown-menu">
								<li><a href="#">East Coast Swing</a></li>
								<li><a href="#">West Coast Swing</a></li>
								<li><a href="#">Lindy Hop</a></li>
								<li><a href="#">Blues</a></li>
							</ul>
						</li>
	-->
					</ul>
				</div><!--/.nav-collapse -->
			</div>
		</nav>

		<div class="container">

			<div id="home">

				<!-- Carousel with static headline: https://bootsnipp.com/snippets/featured/carousel-static-headline-caption -->
				<div class="row">
					<div class="col-md-12">

						<div id="carousel-example-generic" class="carousel fade" data-ride="carousel" data-interval="5000">
							<ol class="carousel-indicators hidden-xs">
							</ol>
							<div class="carousel-inner">
								<div class="item active">
									<img src="../images/carousel/2016-FNB-at-La-Nacional.jpg" alt="2016-FNB-at-La-Nacional.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/2016-Steel-City-Blues-3.jpg" alt="2016-Steel-City-Blues-3.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/2016-Steel-City-Blues-with-Kim-and-Andria-5.jpg" alt="2016-Steel-City-Blues-with-Kim-and-Andria-5.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/2016-Winter-Blues-1.jpg" alt="2016-Winter-Blues-1.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/2017-Mo-Better-Blues---Jessica-Goethe-2-and-Kim.jpg" alt="2017-Mo-Better-Blues---Jessica-Goethe-2-and-Kim.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/2017-Steel-City-with-Pamela-Carney.jpg" alt="2017-Steel-City-with-Pamela-Carney.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-1.jpg" alt="Blues-n-Soul-2016-1.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-2.jpg" alt="Blues-n-Soul-2016-2.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-9.jpg" alt="Blues-n-Soul-2016-9.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-Kim-and-Heather-Haskett-2.jpg" alt="Blues-n-Soul-2016-Kim-and-Heather-Haskett-2.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-Kim-and-Sheri-1.jpg" alt="Blues-n-Soul-2016-Kim-and-Sheri-1.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-Kim-and-Sheri-2.jpg" alt="Blues-n-Soul-2016-Kim-and-Sheri-2.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/Blues-n-Soul-2016-Kim-and-Sheri-4.jpg" alt="Blues-n-Soul-2016-Kim-and-Sheri-4.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
								<div class="item">
									<img src="../images/carousel/swing-flier-cropped.jpg" alt="swing-flier-cropped.jpg" />
									<div class="carousel-caption">
										<!-- caption goes here -->
									</div>
								</div>
							</div><!-- carousel-inner -->
							<a class="left carousel-control" href="#carousel-example-generic" data-slide="prev">
								<span class="glyphicon glyphicon-chevron-left"></span>
							</a>
							<a class="right carousel-control" href="#carousel-example-generic" data-slide="next">
								<span class="glyphicon glyphicon-chevron-right"></span>
							</a>
						</div><!-- carousel-example-generic -->
						<div class="main-text">
							<div class="col-md-12 text-center">
								<h1>
									South Florida Swing
								</h1>
								<h2>
									East Coast Swing &bull; West Coast Swing &bull; Lindy Hop &bull; Blues<br />
									Lessons &bull; Social Dancing &bull; Live Music
								</h2>
								<h3>
									in Martin, Palm Beach, Broward, and Dade Counties
								</h3>

								<p class="easy-nav hidden-xs">
									<a class="btn btn-warning" role="button" href="#calendar">
										Calendar
									</a>
									<a class="btn btn-warning" role="button" href="#map">
										Map
									</a>
									<a class="btn btn-warning" role="button" href="#venues">
										Venues
									</a>
									<a class="btn btn-warning" role="button" href="#lessons">
										Lessons
									</a>
									<a class="btn btn-warning" role="button" href="#social">
										Social Dancing
									</a>
									<a class="btn btn-warning" role="button" href="#music">
										Live Music
									</a>
									<a class="btn btn-warning" role="button" href="#bands">
										Bands
									</a>
									<a class="btn btn-warning" role="button" href="#contact">
										Contact
									</a>
									<a class="btn btn-warning" role="button" href="#" onclick="$( '#search' ).modal( 'show' ); return false;">
										Search
									</a>
								</p>


							</div>
						</div><!-- main-text hidden-xs -->
					</div><!-- col-md-12 -->
				</div><!-- row -->

			</div><!-- home -->

			<p class="wide-button-nav text-center hidden-sm hidden-md hidden-lg">
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#calendar">
					Calendar
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#map">
					Map
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#venues">
					Venues
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#lessons">
					Lessons
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#social">
					Social Dancing
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#music">
					Live Music
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#bands">
					Bands
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#contact">
					Contact
				</a>
				<a class="btn btn-lg btn-block btn-warning" role="button" href="#" onclick="$( '#search' ).modal( 'show' ); return false;">
					Search
				</a>
			</p>

			<div class="calendar">
				<a class="anchor" id="calendar"></a>

				<h2>
					Calendar
				</h2>


ERROR: Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-02-01"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-03-31"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-02-01"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-03-31"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC' SQL error=Table 'kmoser_kms.swing_events' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_events' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(29): KRec->select_all_rows(<b style="color: green;">0 => swing_events.id</b>, <b style="color: green;">1 => swing_events.venue_id</b>, <b style="color: green;">2 => swing_bands.id AS band_id</b>, <b style="color: green;">3 => DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago</b>, <b style="color: green;">4 => swing_bands.name AS band_name</b>, <b style="color: green;">5 => swing_events.when_type</b>, <b style="color: green;">6 => swing_events.weekdays</b>, <b style="color: green;">7 => swing_events.start_when</b>, <b style="color: green;">8 => swing_events.end_when</b>, <b style="color: green;">9 => swing_events.time</b>, <b style="color: green;">10 => swing_events.time_start</b>, <b style="color: green;">11 => swing_events.time_end</b>, <b style="color: green;">12 => swing_events.repeats</b>, <b style="color: green;">13 => swing_venues.venue_type</b>, <b style="color: green;">14 => swing_venues.name AS venue_name</b>, <b style="color: green;">15 => swing_venues.name_short AS venue_name_short</b>, <b style="color: green;">16 => swing_venues.address AS address</b>, <b style="color: green;">17 => swing_venues.city AS city</b>, <b style="color: green;">18 => swing_venues.state AS state</b>, <b style="color: green;">19 => swing_venues.zip AS zip</b>, <b style="color: green;">20 => swing_venues.lat AS lat</b>, <b style="color: green;">21 => swing_venues.lon AS lon</b>, <b style="color: green;">22 => swing_venues.phone AS phone</b>, <b style="color: green;">23 => COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url</b>, <b style="color: green;">24 => swing_venues.map_url AS map_url</b>, <b style="color: green;">25 => COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost</b>, <b style="color: green;">26 => COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name</b>, <b style="color: green;">27 => COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short</b>, <b style="color: green;">28 => COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image</b>, <b style="color: green;">29 => COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description</b>, <b style="color: green;">30 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons</b>, <b style="color: green;">31 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social</b>, <b style="color: green;">32 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music</b>, <b style="color: green;">33 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs</b>, <b style="color: green;">34 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs</b>, <b style="color: green;">35 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy</b>, <b style="color: green;">36 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues</b>, <b style="color: green;">37 => NULL AS distance</b>, <b style="color: green;">38 => GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates</b>, <b style="color: green;">39 => GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(804): SwingEvent->select_all_rows(<b style="color: green;">0 => swing_events.id</b>, <b style="color: green;">1 => swing_events.venue_id</b>, <b style="color: green;">2 => swing_bands.id AS band_id</b>, <b style="color: green;">3 => DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago</b>, <b style="color: green;">4 => swing_bands.name AS band_name</b>, <b style="color: green;">5 => swing_events.when_type</b>, <b style="color: green;">6 => swing_events.weekdays</b>, <b style="color: green;">7 => swing_events.start_when</b>, <b style="color: green;">8 => swing_events.end_when</b>, <b style="color: green;">9 => swing_events.time</b>, <b style="color: green;">10 => swing_events.time_start</b>, <b style="color: green;">11 => swing_events.time_end</b>, <b style="color: green;">12 => swing_events.repeats</b>, <b style="color: green;">13 => swing_venues.venue_type</b>, <b style="color: green;">14 => swing_venues.name AS venue_name</b>, <b style="color: green;">15 => swing_venues.name_short AS venue_name_short</b>, <b style="color: green;">16 => swing_venues.address AS address</b>, <b style="color: green;">17 => swing_venues.city AS city</b>, <b style="color: green;">18 => swing_venues.state AS state</b>, <b style="color: green;">19 => swing_venues.zip AS zip</b>, <b style="color: green;">20 => swing_venues.lat AS lat</b>, <b style="color: green;">21 => swing_venues.lon AS lon</b>, <b style="color: green;">22 => swing_venues.phone AS phone</b>, <b style="color: green;">23 => COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url</b>, <b style="color: green;">24 => swing_venues.map_url AS map_url</b>, <b style="color: green;">25 => COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost</b>, <b style="color: green;">26 => COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name</b>, <b style="color: green;">27 => COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short</b>, <b style="color: green;">28 => COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image</b>, <b style="color: green;">29 => COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description</b>, <b style="color: green;">30 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons</b>, <b style="color: green;">31 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social</b>, <b style="color: green;">32 => IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music</b>, <b style="color: green;">33 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs</b>, <b style="color: green;">34 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs</b>, <b style="color: green;">35 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy</b>, <b style="color: green;">36 => IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues</b>, <b style="color: green;">37 => NULL AS distance</b>, <b style="color: green;">38 => GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates</b>, <b style="color: green;">39 => GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(1781): SwingEvent::retrieve_matching_events(<b style="color: green;">offers => NULL</b>, <b style="color: green;">venue_types => NULL</b>, <b style="color: green;">lat => NULL</b>, <b style="color: green;">lon => NULL</b>, <b style="color: green;">zip => NULL</b>, <b style="color: green;">city => NULL</b>, <b style="color: green;">radius => NULL</b>, <b style="color: green;">dt_start => </b>, <b style="color: green;">dt_end => </b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingEvent.inc.php(806): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(1781): SwingEvent::retrieve_matching_events(<b style="color: green;">offers => NULL</b>, <b style="color: green;">venue_types => NULL</b>, <b style="color: green;">lat => NULL</b>, <b style="color: green;">lon => NULL</b>, <b style="color: green;">zip => NULL</b>, <b style="color: green;">city => NULL</b>, <b style="color: green;">radius => NULL</b>, <b style="color: green;">dt_start => </b>, <b style="color: green;">dt_end => </b>)<br/>
ERROR: Error retrieving matching events: SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
<br />
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
<br />
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
<br />
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
<br />
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
<br />
						 WHERE ( (
<br />
									end_when = "0000-00-00"
<br />
										OR
<br />
									end_when >= "2021-02-01"
<br />
								) AND (
<br />
									start_when = "0000-00-00"
<br />
										OR
<br />
									start_when <= "2021-03-31"
<br />
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(1783): KError::log_error(<b style="color: green;">0 => Error retrieving matching events: SELECT SQL_CALC_FOUND_ROWS swing_events.id, swing_events.venue_id, swing_bands.id AS band_id, DATEDIFF( swing_events.when_added, NOW() ) AS when_added_days_ago, swing_bands.name AS band_name, swing_events.when_type, swing_events.weekdays, swing_events.start_when, swing_events.end_when, swing_events.time, swing_events.time_start, swing_events.time_end, swing_events.repeats, swing_venues.venue_type, swing_venues.name AS venue_name, swing_venues.name_short AS venue_name_short, swing_venues.address AS address, swing_venues.city AS city, swing_venues.state AS state, swing_venues.zip AS zip, swing_venues.lat AS lat, swing_venues.lon AS lon, swing_venues.phone AS phone, COALESCE( NULLIF( swing_events.url, "" ), swing_venues.url ) AS url, swing_venues.map_url AS map_url, COALESCE( NULLIF( swing_events.cost, "" ), swing_venues.cost ) AS cost, COALESCE( NULLIF( swing_events.name, "" ), NULLIF( swing_bands.name, "" ), swing_venues.name ) AS name, COALESCE( NULLIF( swing_events.name_short, "" ), NULLIF( swing_bands.name_short, "" ), swing_venues.name_short ) AS name_short, COALESCE( NULLIF( swing_events.image, "" ), swing_venues.image ) AS image, COALESCE( NULLIF( swing_events.description, "" ), swing_venues.description ) AS description, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_lessons, swing_events.offer_lessons ) AS offer_lessons, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_social, swing_events.offer_social ) AS offer_social, IF( swing_events.offer_lessons = "" AND swing_events.offer_social = "" AND swing_events.offer_music = "", swing_venues.offer_music, swing_events.offer_music ) AS offer_music, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_ecs, swing_events.lesson_ecs ) AS lesson_ecs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_wcs, swing_events.lesson_wcs ) AS lesson_wcs, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_lindy, swing_events.lesson_lindy ) AS lesson_lindy, IF ( swing_events.lesson_ecs = "" AND swing_events.lesson_wcs = "" AND swing_events.lesson_lindy = "" AND swing_events.lesson_blues = "", swing_venues.lesson_blues, swing_events.lesson_blues ) AS lesson_blues, NULL AS distance, GROUP_CONCAT( DISTINCT( swing_event_dates.`date` ) ) AS event_dates, GROUP_CONCAT( DISTINCT( swing_event_date_exceptions.`date` ) ) AS event_date_exceptions FROM swing_events
						LEFT JOIN swing_venues ON ( swing_events.venue_id = swing_venues.id )
						LEFT JOIN swing_bands ON ( swing_events.band_id = swing_bands.id )
						LEFT JOIN swing_event_dates ON ( swing_events.id = swing_event_dates.event_id )
						LEFT JOIN swing_event_date_exceptions ON ( swing_events.id = swing_event_date_exceptions.event_id )
						 WHERE ( (
									end_when = "0000-00-00"
										OR
									end_when >= "2021-02-01"
								) AND (
									start_when = "0000-00-00"
										OR
									start_when <= "2021-03-31"
								) ) GROUP BY swing_events.id ORDER BY swing_events.`start_when` ASC, swing_events.`time_start` ASC, swing_event_dates.`date` ASC, swing_event_date_exceptions.`date` ASC</b>)<br/>
			<link rel="stylesheet" href="kcalendar.css" type="text/css" media="screen" />
			<div class="kcalendar">
				<nav aria-label="Navigation">
					<ul class="pager">
						<li class="previous">
							<a href="/events/?zip_validated=0&city_validated=0&y=2021&m=1#calendar"><span aria-hidden="true">&larr;</span> January</a>
						</li>

						<li class="calendar-header">
							February 2021						</li>
						<li class="next">
							<a href="/events/?zip_validated=0&city_validated=0&y=2021&m=3#calendar">March <span aria-hidden="true">&rarr;</span></a>
						</li>
					</ul>
				</nav>

				<ul class="weekdays">
  					<li>
  						Sun  					</li>
  					<li>
  						Mon  					</li>
  					<li>
  						Tue  					</li>
  					<li>
  						Wed  					</li>
  					<li>
  						Thu  					</li>
  					<li>
  						Fri  					</li>
  					<li>
  						Sat  					</li>
				</ul>
				<ul class="days">
				    <li class="past blank">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Feb</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Feb</span>
									1
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Tue,</span> <span class="month">Feb</span>
									2
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Wed,</span> <span class="month">Feb</span>
									3
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Feb</span>
									4
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Fri,</span> <span class="month">Feb</span>
									5
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Sat,</span> <span class="month">Feb</span>
									6
						</div>

						<div class="events">
													</div>
					</li>
				</ul>
				<ul class="days">
				    <li class="past free">
						<div class="date">
							<span class="day">Sun,</span> <span class="month">Feb</span>
									7
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Feb</span>
									8
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Tue,</span> <span class="month">Feb</span>
									9
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Wed,</span> <span class="month">Feb</span>
									10
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Feb</span>
									11
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Fri,</span> <span class="month">Feb</span>
									12
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Sat,</span> <span class="month">Feb</span>
									13
						</div>

						<div class="events">
													</div>
					</li>
				</ul>
				<ul class="days">
				    <li class="past free">
						<div class="date">
							<span class="day">Sun,</span> <span class="month">Feb</span>
									14
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Feb</span>
									15
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Tue,</span> <span class="month">Feb</span>
									16
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Wed,</span> <span class="month">Feb</span>
									17
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Feb</span>
									18
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Fri,</span> <span class="month">Feb</span>
									19
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Sat,</span> <span class="month">Feb</span>
									20
						</div>

						<div class="events">
													</div>
					</li>
				</ul>
				<ul class="days">
				    <li class="past free">
						<div class="date">
							<span class="day">Sun,</span> <span class="month">Feb</span>
									21
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Feb</span>
									22
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Tue,</span> <span class="month">Feb</span>
									23
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Wed,</span> <span class="month">Feb</span>
									24
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Feb</span>
									25
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Fri,</span> <span class="month">Feb</span>
									26
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past free">
						<div class="date">
							<span class="day">Sat,</span> <span class="month">Feb</span>
									27
						</div>

						<div class="events">
													</div>
					</li>
				</ul>
				<ul class="days">
				    <li class="past free">
						<div class="date">
							<span class="day">Sun,</span> <span class="month">Feb</span>
									28
						</div>

						<div class="events">
													</div>
					</li>
				    <li class="past blank">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">Mar</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="future blank">
						<div class="date">
							<span class="day">Tue,</span> <span class="month">Mar</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="future blank">
						<div class="date">
							<span class="day">Wed,</span> <span class="month">Mar</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="future blank">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Apr</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="future blank">
						<div class="date">
							<span class="day">Mon,</span> <span class="month">May</span>

						</div>

						<div class="events">
													</div>
					</li>
				    <li class="future blank">
						<div class="date">
							<span class="day">Thu,</span> <span class="month">Jun</span>

						</div>

						<div class="events">
													</div>
					</li>
				</ul>
			</div><!--class="kcalendar"-->

				<nav aria-label="Navigation">
					<ul class="pager">
						<li class="previous">
							<a href="/events/?zip_validated=0&city_validated=0&y=2021&m=1#calendar"><span aria-hidden="true">&larr;</span> January</a>
						</li>
						<li class="next">
							<a href="/events/?zip_validated=0&city_validated=0&y=2021&m=3#calendar">March <span aria-hidden="true">&rarr;</span></a>
						</li>
					</ul>
				</nav>
			</div><!-- calendar -->


			<div>
				<a class="anchor" id="map"></a>
				
				<h2>
					Map
				</h2>

				<div class="map" id="themap">
					<!-- generated dynamically -->
					<h3 class="text-center">
						Please wait while the map loads...
					</h3>
				</div>
			</div>


				<a class="anchor" id="venues"></a>

				<h2>
					Venues				</h2>


				<div class="row">
ERROR: Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(386): SwingVenue->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">offers => NULL</b>, <b style="color: green;">search_lat => NULL</b>, <b style="color: green;">search_lon => NULL</b>, <b style="color: green;">search_zip => NULL</b>, <b style="color: green;">search_city => NULL</b>, <b style="color: green;">search_radius => NULL</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(1896): do_section(<b style="color: green;">0 => venues</b>, <b style="color: green;">1 => Venues</b>, <b style="color: green;">2 => NULL</b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(388): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">offers => NULL</b>, <b style="color: green;">search_lat => NULL</b>, <b style="color: green;">search_lon => NULL</b>, <b style="color: green;">search_zip => NULL</b>, <b style="color: green;">search_city => NULL</b>, <b style="color: green;">search_radius => NULL</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(1896): do_section(<b style="color: green;">0 => venues</b>, <b style="color: green;">1 => Venues</b>, <b style="color: green;">2 => NULL</b>)<br/>
ERROR: Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(866): KError::log_error(<b style="color: green;">0 => Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(1896): do_section(<b style="color: green;">0 => venues</b>, <b style="color: green;">1 => Venues</b>, <b style="color: green;">2 => NULL</b>)<br/>

				</div><!-- row -->

				<script>
					function create_markers( map, venues ) {
						// https://mapicons.mapsmarker.com/category/markers/culture-entertainment/culture/music/?custom_color=5cb85c&style=

						var iconBase = '/images/map/'; // 'https://maps.google.com/mapfiles/kml/shapes/';
						var icons = {
							lessons: {
								icon: iconBase + 'danceclass.png'
							},
							social: {
								icon: iconBase + 'dancinghall.png'
							},
							music: {
								icon: iconBase + 'jazzclub.png'
							}
						};


						// Create markers.
						venues.forEach( function( venue ) {
							var infowindow = new google.maps.InfoWindow({
								//content: venue.content
								maxWidth: 300,
								content: [
									'<div class="infowindow">',
									'<p>',
										Object.keys(venue.offers).map( function(key) { return {"lessons":"<span class=\"label label-danger\"> <img src=\"\/images\/offer_lessons.png\" \/>Lessons<\/span>","social":"<span class=\"label label-warning\"> <img src=\"\/images\/offer_social.png\" \/>Social Dancing<\/span>","music":"<span class=\"label label-success\"> <img src=\"\/images\/offer_music.png\" \/>Live Music<\/span>"}[key]; } ).join( ' ' ),
									'</p>',
									'<p><strong>',
										'<a target="_blank" href="' + venue.url + '">' + venue.name + '</a>',
									'</strong><br />',
									venue.address + '<br />',
									venue.city + ', ' + venue.state + ' ' + venue.zip + '<br />',
									( ( venue.phone && venue.phone.length ) ? ( venue.phone + '<br />' ) : '' ),
									'</p>',
									'<p class="description">' + venue.description + '</p>',

									(
										venue.lessons
											?
										(
											'<p>' + Object.keys(venue.lessons).map( function(key) { return '<p>' + {"ecs":"<span class=\"badge badge-ecs\" title=\"East Coast Swing\">ECS<\/span>","wcs":"<span class=\"badge badge-wcs\" title=\"West Coast Swing\">WCS<\/span>","lindy":"<span class=\"badge badge-lindy\" title=\"Lindy Hop\">Lindy Hop<\/span>","blues":"<span class=\"badge badge-blues\" title=\"Blues\">Blues<\/span>"}[key] + ' ' + this.lessons[key] + '</p>'; }, venue ).join( ' ' ) + '</p>'
										)
											:
										''
									),

									(
										venue.upcoming_events
											?
										(
											'<div class="upcoming-events">'
												+
												Object.keys( venue.upcoming_events ).map( function( key, index ) { return venue.upcoming_events[key]; } ).join( '' )
												+
											'</div>'
										)
											:
										''
									),

									'</div>'
								].join( '' ),
							});

if ( !Object.keys( venue.offers ).length ) {
	console.log( 'No offers for ' + venue.name + ' [' + venue.id + ']' );
}
							var icon_key = Object.keys( venue.offers ).length ? Object.keys(venue.offers)[0] : 'music';
							var marker = new google.maps.Marker({
								position: new google.maps.LatLng( venue.lat, venue.lon ),
								icon: icons[ icon_key ].icon,
								title: venue.name + ' (' + Object.keys(venue.offers).map( function(key) { return {"lessons":"lessons","social":"social dancing","music":"live music"}[key]; } ).join( ', ' ) + ')',
								map: map,
								optimized: false,
								// Lessons on top; social dancing below that; everything else below that:
								// From https://stackoverflow.com/a/28098302/378779
								zIndex: (
									venue.offers[ 'lessons' ]
										?
									1001
										:
									(
										venue.offers[ 'social' ]
											?
										1000
											:
										999
									)
								)
							});

							marker.addListener('click', function() {
								infowindow.open( map, marker );
							});

						});
					}

					function initMap() {
						if ( navigator.geolocation ) {
							navigator.geolocation.getCurrentPosition( initMapCallback, initMapCallbackNoCoords );
						} else {
							initMapCallbackNoCoords();
						}
					}
					
					function initMapCallback( position ) {
ERROR: Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) AS min_lat, MIN( lon ) AS min_lon, MAX( lat ) AS max_lat, MAX( lon ) AS max_lon FROM swing_zips'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => MIN( lat ) AS min_lat</b>, <b style="color: green;">1 => MIN( lon ) AS min_lon</b>, <b style="color: green;">2 => MAX( lat ) AS max_lat</b>, <b style="color: green;">3 => MAX( lon ) AS max_lon</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2278): SwingZip->select_all_rows(<b style="color: green;">0 => MIN( lat ) AS min_lat</b>, <b style="color: green;">1 => MIN( lon ) AS min_lon</b>, <b style="color: green;">2 => MAX( lat ) AS max_lat</b>, <b style="color: green;">3 => MAX( lon ) AS max_lon</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(27): KRec::select_one_row(<b style="color: green;">0 => MIN( lat ) AS min_lat</b>, <b style="color: green;">1 => MIN( lon ) AS min_lon</b>, <b style="color: green;">2 => MAX( lat ) AS max_lat</b>, <b style="color: green;">3 => MAX( lon ) AS max_lon</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2054): SwingZip::select_one_row(<b style="color: green;">0 => MIN( lat ) AS min_lat</b>, <b style="color: green;">1 => MIN( lon ) AS min_lon</b>, <b style="color: green;">2 => MAX( lat ) AS max_lat</b>, <b style="color: green;">3 => MAX( lon ) AS max_lon</b>)<br/>
ERROR: Error selecting min/max lat/lon.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(2073): KError::log_error(<b style="color: green;">0 => Error selecting min/max lat/lon.</b>)<br/>
							initMapCallbackNoCoords();
					}

					function initMapCallbackNoCoords() {
ERROR: Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat, AVG( lon ) AS lon FROM swing_zips'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat</b>, <b style="color: green;">1 => AVG( lon ) AS lon</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2278): SwingZip->select_all_rows(<b style="color: green;">0 => MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat</b>, <b style="color: green;">1 => AVG( lon ) AS lon</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(27): KRec::select_one_row(<b style="color: green;">0 => MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat</b>, <b style="color: green;">1 => AVG( lon ) AS lon</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2094): SwingZip::select_one_row(<b style="color: green;">0 => MIN( lat ) + ( ( MAX( lat ) - MIN( lat ) ) / 2 ) AS lat</b>, <b style="color: green;">1 => AVG( lon ) AS lon</b>)<br/>
ERROR: Error selecting avg lat and lon.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(2098): KError::log_error(<b style="color: green;">0 => Error selecting avg lat and lon.</b>)<br/>

						initMapAt( 26.81511111, -80.095 );
					}

					function initMapAt( lat, lon ) {
						var map = new google.maps.Map(document.getElementById('themap'), {
							zoom: 9,
							center: { lat: lat, lng: lon },
							mapTypeId: 'roadmap'
						});


						// http://www.latlong.net/convert-address-to-lat-long.html

						$.getJSON( '/events/index.php?action=xvenues', function( venues ) {
							if ( venues instanceof Object ) {
								create_markers( map, venues );
							} else {
								$( 'div#themap h3' ).text( 'Sorry, we\'re experiencing technical difficulties with this feature. Please try again later. (Error code 2119)' );
								console.log( 'Error on line 2120' );
							}
						}).fail( function( d, textStatus, error ) {
							$( 'div#themap h3' ).text( 'Sorry, we\'re experiencing technical difficulties with this feature. Please try again later. (Error code 2123)' );
							console.log( 'Error on line 2124' );
						});

					}
				</script>

				<script async defer
				src="//maps.googleapis.com/maps/api/js?key=AIzaSyDH81aalUs2FL4OK74UYPCoDy4Ogdl1mTU&callback=initMap">
				</script>


			<div>

				<a class="anchor" id="lessons"></a>

				<h2>
					Lessons				</h2>


				<div class="row">
ERROR: Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(386): SwingVenue->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => lessons</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2137): do_section(<b style="color: green;">0 => lessons</b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(388): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => lessons</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2137): do_section(<b style="color: green;">0 => lessons</b>)<br/>
ERROR: Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(866): KError::log_error(<b style="color: green;">0 => Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_lessons != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2137): do_section(<b style="color: green;">0 => lessons</b>)<br/>

				</div><!-- row -->
			</div><!-- lessons -->


			<div>

				<a class="anchor" id="social"></a>

				<h2>
					Social Dancing				</h2>


				<div class="row">
ERROR: Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(386): SwingVenue->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => social</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2144): do_section(<b style="color: green;">0 => social</b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(388): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => social</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2144): do_section(<b style="color: green;">0 => social</b>)<br/>
ERROR: Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(866): KError::log_error(<b style="color: green;">0 => Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_social != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2144): do_section(<b style="color: green;">0 => social</b>)<br/>

				</div><!-- row -->
			</div><!-- social -->


			<div>

				<a class="anchor" id="music"></a>

				<h2>
					Music				</h2>

				<p>
					Most of these venues don't have a dedicated dance floor so please be careful that your dancing doesn't interfere with staff, other patrons, or the band.
				</p>

				<div class="row">
ERROR: Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC' SQL error=Table 'kmoser_kms.swing_venues' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_venues' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(23): KRec->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(386): SwingVenue->select_all_rows(<b style="color: green;">0 => swing_venues.*</b>, <b style="color: green;">1 => AVG( swing_venue_ratings.stars ) AS stars</b>, <b style="color: green;">2 => COUNT( swing_venue_ratings.id ) AS num_reviews</b>, <b style="color: green;">3 => NULL AS distance</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => music</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2151): do_section(<b style="color: green;">0 => music</b>)<br/>
ERROR: Error selecting events.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/swing-inc/SwingVenue.inc.php(388): KError::log_error(<b style="color: green;">0 => Error selecting events.</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(864): SwingVenue::retrieve_matching_venues(<b style="color: green;">0 => music</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2151): do_section(<b style="color: green;">0 => music</b>)<br/>
ERROR: Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(866): KError::log_error(<b style="color: green;">0 => Error retrieving matching venues: SELECT SQL_CALC_FOUND_ROWS swing_venues.*, AVG( swing_venue_ratings.stars ) AS stars, COUNT( swing_venue_ratings.id ) AS num_reviews, NULL AS distance FROM swing_venues LEFT JOIN swing_venue_ratings ON ( swing_venue_ratings.venue_id = swing_venues.id ) WHERE ( swing_venues.offer_music != '' AND is_hidden = 0 ) GROUP BY swing_venues.id ORDER BY name ASC</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2151): do_section(<b style="color: green;">0 => music</b>)<br/>

				</div><!-- row -->
			</div><!-- music -->




			<div>
				<a class="anchor" id="bands"></a>

				<h2>
					Bands
				</h2>

				<p>
					These bands are either based in South Florida or play in South Florida on a regular basis.
				</p>


				<div class="row">
ERROR: Query failed; error='Table 'kmoser_kms.swing_bands' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name' SQL error=Table 'kmoser_kms.swing_bands' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_bands' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name' SQL error=Table 'kmoser_kms.swing_bands' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_bands' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name' SQL error=Table 'kmoser_kms.swing_bands' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_bands' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS * FROM swing_bands ORDER BY name'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingBand.inc.php(23): KRec::select_all_rows(<b style="color: green;">order => name</b>, <b style="color: green;">callback => </b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2213): SwingBand::select_all_rows(<b style="color: green;">order => name</b>, <b style="color: green;">callback => </b>)<br/>
ERROR: Error getting bands.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(2215): KError::log_error(<b style="color: green;">0 => Error getting bands.</b>)<br/>
				</div><!-- row -->

			</div><!-- bands -->



			<div class="contact">
				<a class="anchor" id="contact"></a>

				<h2>
					Contact
				</h2>

				<div class="row">
					<div class="col-sm-4 text-center">
						<h1>
						 	<span class="glyphicon glyphicon-envelope"></span>
						</h1>
						
						<p>
							Get weekly updates on upcoming swing events including lessons, social dancing, and live music.
						</p>

						<a class="btn btn-primary btn-large" href="mailto:E?subject=Please add me to your swing email list&body=I live in city or zip: _____%0A%0AI am interested in the following types of swing events (check all that apply):%0A[ ] Social dancing%0A[ ] Live music%0A[ ] Lessons (specify below)%0A%0AI am interested in taking lessons in (check all that apply):%0A[ ] East Coast swing%0A[ ] West Coast swing%0A[ ] Lindy Hop%0A[ ] Blues">
							Join Mailing List &raquo;
						</a>
					</div>
					<div class="col-sm-4 text-center">
						<h1>
							<span class="glyphicon glyphicon-map-marker"></span>
						</h1>

						<p>
							Add your swing event to this page. Events should involve swing dancing, lessons, or swing/blues music.
						</p>

						<a class="btn btn-primary btn-large" href="mailto:E?subject=Please list my swing event on your website">
							List Your Event &raquo;
						</a>
					</div>
					<div class="col-sm-4 text-center">
						<h1>
							<span class="glyphicon glyphicon-music"></span>
						</h1>
						
						<p>
							Contact me for more information on swing classes in the Jupiter / West Palm Beach area.
						</p>

						<a class="btn btn-primary btn-large" href="mailto:E?subject=Please send me more information on swing classes">
							Swing Lessons &raquo;
						</a>
					</div>
				</div><!-- row -->

			</div><!-- contact -->


			<footer>
				<hr />
				<div class="text-center">
					<p>
						Copyright &copy; 2021 by
						<a href="https://www.kmoser.com/">
							Kim Moser
						</a>
					</p>
				</div>
			</footer>

		</div><!-- container -->

		<!-- event modal -->
		<div id="event" class="modal fade" role="dialog">
			<div class="modal-dialog">
				<div class="modal-content">
					<!-- contents filled via JS -->
				</div>
			</div><!-- modal-dialog -->
		</div><!-- event -->


		<!-- jamp modal: -->
		<div id="jamp" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<div class="modal-body text-center">
						<h1>
							Please wait...
						</h1>
						&nbsp;
					</div><!-- modal-body -->
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- jamp -->


		<!-- thank you modal: -->
		<div id="thankyou" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal">&times;</button>
					</div>
					<div class="modal-body text-center">
						<h3>
							Your changes have been saved
						</h3>
						&nbsp;
					</div><!-- modal-body -->
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
					</div>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- thank you -->


		<!-- search modal: -->
		<div id="search" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
<!--
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal">&times;</button>
						<h4 class="modal-title">Search</h4>
					</div>
-->
					<div class="modal-body">

<script>
	function do_calendar_event_link( event_id, yyyymmdd ) {

		var loader_html = ' \
					<div class="modal-body text-center"> \
						<h3> \
							<div class="loader"></div> \
						</h3> \
					</div><!-- modal-body --> \
		';

		$( 'div#event div.modal-dialog div.modal-content' ).html( loader_html );

		$.ajax({
			url: '/events/?action=calendar&id=' + parseInt( event_id ) + '&dt=' + encodeURIComponent( yyyymmdd ),
		}).done(function( data ) {
			$( 'div#event div.modal-dialog div.modal-content' ).html( data );
		}).fail( function( d, textStatus, error ) {
			var fail_html = ' \
						<div class="modal-body text-center"> \
							<h3> \
								Sorry, we\'re experiencing technical difficulties with this feature. \
							</h3> \
							\
							<h4> \
								Please try again later. \
							</h4> \
						</div><!-- modal-body --> \
			';

			$( 'div#event div.modal-dialog div.modal-content' ).html( fail_html );
		});

		return false;
	}

	function do_search() {
		var r = true; // assume

		if ( r ) {
			$( '#search' ).modal( 'hide' );
			$( '#jamp' ).modal( 'show' );
		}

		return r;
	}
</script>

						<form action="/events/" class="search" method="get" onsubmit="do_search();">
						<p class="lead">
							<span class="label label-danger">
								No results found. Try expanding your search.
							</span>
						</p>


						<h3>
							I'm looking for
						</h3>

						<div class="offer">
							<label>
								<input type="checkbox" name="offers[]" value="lessons" checked="checked"> <span class="label label-danger"> <img src="/images/offer_lessons.png" />Lessons</span><!--Lessons-->
							</label><br />
							<label>
								<input type="checkbox" name="offers[]" value="social" checked="checked"> <span class="label label-warning"> <img src="/images/offer_social.png" />Social Dancing</span><!--Social dancing-->
							</label><br />
							<label>
								<input type="checkbox" name="offers[]" value="music" checked="checked"> <span class="label label-success"> <img src="/images/offer_music.png" />Live Music</span><!--Live music-->
							</label><br />
						</div>

<!--
						<h3 class="text-center">
							Where
						</h3>
-->

						<p>
							Within
								<select name="radius">
									<option value="5" >5</option>
									<option value="10" >10</option>
									<option value="20" selected="selected">20</option>
									<option value="35" >35</option>
									<option value="50" >50</option>
									<option value="75" >75</option>
								</select>
							miles of
						</p>

						<p>
								<select name="city" onchange="$( 'form.search input[name=zip]' ).val(''); return false;">
									<option value="">Any town</option>
ERROR: Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(23): KRec::select_all_rows(<b style="color: green;">0 => DISTINCT city AS city</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(2493): SwingZip::select_all_rows(<b style="color: green;">0 => DISTINCT city AS city</b>)<br/>
ERROR: Error getting cities.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(2495): KError::log_error(<b style="color: green;">0 => Error getting cities.</b>)<br/>
							</select>


								or

							<input type="text" name="zip" size="6" maxlength="6" placeholder="Zip" value="" oninput="if ( $( 'form.search input[name=zip]' ).val().length ) { $( 'form.search select[name=city] option' ).prop( 'selected', false ) } return false;" />

						</p>

						<p>
							<input type="checkbox" onclick="$('#advanced-search' ).toggle();" >
							Show advanced options...
						</p>

						<div class="offer" id="advanced-search" style="display: none" >
							In any of the following types of venues<br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="bar" checked="checked"> Bar<!--Bar-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="barrestaurant" checked="checked"> Bar/Restaurant<!--Bar/Restaurant-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="communitycenter" checked="checked"> Community Center<!--Community Center-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="theater" checked="checked"> Theater<!--Theater-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="cafe" checked="checked"> Cafe<!--Cafe-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="dancestudio" checked="checked"> Dance Studio<!--Dance Studio-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="foodcourt" checked="checked"> Food Court<!--Food Court-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="gallery" checked="checked"> Gallery<!--Gallery-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="mall" checked="checked"> Mall<!--Mall-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="multiuse" checked="checked"> Multi-Use<!--Multi-Use-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="nightclub" checked="checked"> Nightclub<!--Nightclub-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="park" checked="checked"> Park<!--Park-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="plaza" checked="checked"> Plaza<!--Plaza-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="restaurant" checked="checked"> Restaurant<!--Restaurant-->
							</label><br />
							<label>
								<input type="checkbox" class="venue-types" name="venue_types[]" value="winebar" checked="checked"> Wine Bar<!--Wine Bar-->
							</label><br />
						</div>
<!--
						<h3 class="text-center">
							When
						</h3>

						<p>
							Between
								<input type="date" name="dt1" value="" />
							and
								<input type="date" name="dt2" value="" />
						</p>
-->

						<br />

						<button type="submit" name="action" value="xsearch" class="btn btn-primary" onclick="if ( $( '#advanced-search' ).is( ':hidden' ) ) { $( 'input.venue-types' ).prop( 'checked', false ); }">
							Search
						</button>

						</form>


					</div><!-- modal-body -->
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
					</div>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- search -->

<script>
function do_populate_review_modal( id, name ) {
	$( 'div#review div#other_reviews' ).html( '<div class="loader"></div>' );

	$( 'div#review input[name="venue_id"]' ).val( id );
	$( '#review-name' ).html( name );

	// Populate login modal's hidden venue ID:
	$( 'div#login input[name="venue_id"]' ).val( id );

	// Populate register modal's hidden venue ID:
	$( 'div#register input[name="venue_id"]' ).val( id );

	// Remove star rating:
	$( 'div#review input[name="stars"]' ).val( '' );
	$( 'a.review-star' ).each(
		function() {
			$(this).children().each(
				function() {
					$(this).removeClass( 'off' );
				}
			)
		}
	);

	$.ajax({
		url: 'index.php?action=populate_review_modal&venue_id=' + parseInt( id ),
	}).done(function( data ) {
		$( 'div#review div#other_reviews' ).html( data );
	});

	return false;
}
</script>

		<!-- review modal: -->
		<div id="review" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<form action="/events/" method="post">
						<input type="hidden" name="venue_id" value="">
						<input type="hidden" name="stars" value="">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal">&times;</button>
							<h4 class="modal-title">
								<span id="review-name"></span>
							</h4>
						</div>
						<div class="modal-body">

	<p class="lead text-center">
		<a href="#" data-toggle="modal" data-target="#login">Login</a>	
			or
		<a href="#" data-toggle="modal" data-target="#register">register</a>
			to post a review
	</p>

						</div><!-- modal-body -->
						<div class="modal-body">
							<div id="other_reviews">
								<!-- filled via JS -->
							</div>
						</div><!-- modal-body -->

						<div class="modal-footer">
							<button type="button" class="btn btn-default pull-right" data-dismiss="modal">Cancel</button>
						</div>


					</form>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- review -->


		<!-- login modal: -->
		<div id="login" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<form action="/events/" method="post">
						<input type="hidden" name="venue_id" value="">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal">&times;</button>
							<h4 class="modal-title">
								Log In
							</h4>
						</div>
						<div class="modal-body">


							<div class="form-group">
								<label>Username</label>
								<input class="form-control" type="text" name="username" placeholder="username or e-mail" required>
							</div>
							<div class="form-group">
								<label>Password</label>
								<input class="form-control" type="password" name="pw" placeholder="password" required>
							</div>


						</div><!-- modal-body -->
						<div class="modal-body">
							<div id="other_reviews">
								<!-- filled via JS -->
							</div>
						</div><!-- modal-body -->

						<div class="modal-footer">
							<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
							<button type="submit" name="action" value="xlogin" class="btn btn-primary pull-right">Log In</button>
						</div>

					</form>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- login -->


		<!-- logout confirm modal: -->
		<div id="logout" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<form action="/events/" method="get">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal">&times;</button>
							<h4 class="modal-title">
								Log Out
							</h4>
						</div>
						<div class="modal-body">

							<h2>
								Are you sure you want to log out?
							</h2>

						</div><!-- modal-body -->
						<div class="modal-body">
							<div id="other_reviews">
								<!-- filled via JS -->
							</div>
						</div><!-- modal-body -->

						<div class="modal-footer">
							<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
							<button type="submit" name="action" value="xlogout" class="btn btn-primary pull-right">Log Out</button>
						</div>

					</form>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- logout -->

		<!-- logout confirm modal: -->
		<div id="loggedout" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal">&times;</button>
							<h4 class="modal-title">
								Log Out
							</h4>
						</div>
						<div class="modal-body">

							<h2>
								You have been logged out.
							</h2>

						</div><!-- modal-body -->
						<div class="modal-body">
							<div id="other_reviews">
								<!-- filled via JS -->
							</div>
						</div><!-- modal-body -->

						<div class="modal-footer">
							<button type="button" class="btn btn-default pull-right" data-dismiss="modal">Close</button>
						</div>

				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- logout -->

		<!-- register modal: -->
		<div id="register" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<form action="/events/" method="post">
						<input type="hidden" name="venue_id" value="">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal">&times;</button>
							<h4 class="modal-title">
								Register New Account
							</h4>
						</div>
						<div class="modal-body">

							<p class="lead text-muted">
								Registered users can write reviews of venues and join our mailing list to get updates on upcoming events.
							</p>

						
							<div class="form-group">
								<label>Username</label>
								<input class="form-control" type="text" name="username" value="" required placeholder="Username">
							</div>
							<div class="form-group">
								<label>E-Mail</label>
								<input class="form-control" type="email" name="email" value="" required placeholder="user@domain.com">
							</div>
							<div class="form-group">
								<label>Password</label>
								<input class="form-control" type="password" name="pw" required placeholder="password">
							</div>

						</div><!-- modal-body -->
						<div class="modal-footer">
							<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>
							<button type="submit" name="action" value="xregister" class="btn btn-primary pull-right">Register</button>
						</div>

					</form>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- register -->


		<!-- review success modal: -->
		<div id="review-success" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal">&times;</button>
						<h4 class="modal-title">
							Thank You!
						</h4>
					</div>
					<div class="modal-body">

					<p class="text-center">
						Thanks for reviewing <strong><span class="name"></span></strong>!
					</p>

					</div><!-- modal-body -->
					<div class="modal-footer">
						<button type="button" class="btn btn-default" data-dismiss="modal">Ok</button>
					</div>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- review success -->

<script>
	$( 'a.review-star' ).click( function() {
		var stars = parseInt( $(this).attr( 'data-id' ) );
		if ( isNaN( stars ) ) {
			stars = 0;
		}

		$( 'div#review input[name="stars"]' ).val( stars );

		$( 'a.review-star' ).each(
			function() {
				if (
					$(this).attr('data-id' )
						<=
					stars
				) {
					$(this).children().each(
						function() {
							$(this).removeClass( 'off' );
						}
					);
				} else {
					$(this).children().each(
						function() {
							$(this).addClass( 'off' );
						}
					);
				}
			}
		);
	});

	$( 'div#review form' ).submit( function( e ) {
		var stars = parseInt( $( 'div#review input[name="stars"]' ).val() );
		if ( isNaN( stars ) ) {
			stars = 0;
		}

		if ( stars <= 0 || stars > 5 ) {
			$( 'div#review p.stars' ).addClass( 'error' );
			alert( 'Please specify how dancer friendly this venue is' );
			e.preventDefault();
		}
		
	});
</script>




		<!-- account modal: -->
		<div id="account" class="modal" role="dialog">
			<div class="modal-dialog">

				<!-- Modal content-->
				<div class="modal-content">
					<form action="/events/" class="form-inline search" method="post">
					<input type="hidden" name="k" value="">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal">&times;</button>
						<h4 class="modal-title">My Account</h4>
					</div>
					<div class="modal-body">
						<h3>
							My Profile
						</h3>

						<div class="form-group w100" style="margin-top: 20px;">
							<label>
								Username
							</label>
							<br />
							<input class="form-control" type="text" name="username" value="" placeholder="Username" required="required" />
						</div>

						<div class="form-group w100" style="margin-top: 20px;">
							<label>
								E-Mail
							</label>
							<br />
							<input class="form-control" type="email" name="email" value="" placeholder="you@email.com" required="required" />
						</div>


						<div class="form-group w100" style="margin-top: 20px;">
							<label>
								Change Password (optional)
							</label>
							<br />
							<input class="form-control" type="password" name="pw" value="" placeholder="New password" />
						</div>


						<hr />

						<h3>
							My E-Mail Subscriptions
						</h3>


						<p class="lead">
							Please e-mail me once a week with updates on:
						</p>

						<div class="offer" style="display: block; width: 200px; margin: auto; ">
							<label>
								<input type="checkbox" name="offers[]" value="lessons"> <span class="label label-danger"> <img src="/images/offer_lessons.png" />Lessons</span><!--Lessons-->
								<div class="offer" style="padding-left: 20px;">
									<label>
										<input type="checkbox" name="lessons[]" value="ecs"> <span class="badge badge-ecs" title="East Coast Swing">East Coast Swing</span><!--East Coast Swing-->
									</label><br />
									<label>
										<input type="checkbox" name="lessons[]" value="wcs"> <span class="badge badge-wcs" title="West Coast Swing">West Coast Swing</span><!--West Coast Swing-->
									</label><br />
									<label>
										<input type="checkbox" name="lessons[]" value="lindy"> <span class="badge badge-lindy" title="Lindy Hop">Lindy Hop</span><!--Lindy Hop-->
									</label><br />
									<label>
										<input type="checkbox" name="lessons[]" value="blues"> <span class="badge badge-blues" title="Blues">Blues</span><!--Blues-->
									</label><br />
								</div>
							</label><br />
							<label>
								<input type="checkbox" name="offers[]" value="social"> <span class="label label-warning"> <img src="/images/offer_social.png" />Social Dancing</span><!--Social dancing-->
							</label><br />
							<label>
								<input type="checkbox" name="offers[]" value="music"> <span class="label label-success"> <img src="/images/offer_music.png" />Live Music</span><!--Live music-->
							</label><br />
						</div>


<!--
						<h3 class="text-center">
							Where
						</h3>
-->

						<div class="text-center" style="padding-top: 20px;">
							Within
								<select class="form-control" name="radius">
									<option value="5" >5</option>
									<option value="10" >10</option>
									<option value="20" selected="selected">20</option>
									<option value="35" >35</option>
									<option value="50" >50</option>
									<option value="75" >75</option>
								</select>
							miles of

							<select class="form-control" name="city" onchange="$( 'form.search input[name=zip]' ).val(''); return false;">
								<option value=""></option>
ERROR: Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(269): KError->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(2918): KObj->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips' SQL error=Table 'kmoser_kms.swing_zips' doesn't exist, error number=1146, SQL statement=SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips</b>)<br/>
/usr/www/users/kmoser/swing/inc/KLib/KObj.inc.php(1992): KRec->log_error(<b style="color: green;">0 => Query failed; error='Table 'kmoser_kms.swing_zips' doesn't exist' (1146), SQL='SELECT SQL_CALC_FOUND_ROWS DISTINCT city AS city FROM swing_zips'</b>)<br/>
/usr/www/users/kmoser/swing/swing-inc/SwingZip.inc.php(23): KRec::select_all_rows(<b style="color: green;">0 => DISTINCT city AS city</b>)<br/>
/usr/www/users/kmoser/swing/events/index.php(3133): SwingZip::select_all_rows(<b style="color: green;">0 => DISTINCT city AS city</b>)<br/>
ERROR: Error getting cities.
<br />
Stack trace follows:
<br />
/usr/www/users/kmoser/swing/events/index.php(3135): KError::log_error(<b style="color: green;">0 => Error getting cities.</b>)<br/>
							</select>


								or

							<input class="form-control" type="text" name="zip" size="5" maxlength="5" placeholder="Zip" value="" oninput="if ( $( this ).val().length ) { $( 'form.search select[name=city] option' ).prop( 'selected', false ); } return false;" />

						</div>


					</div><!-- modal-body -->
					<div class="modal-footer">
						<button type="button" class="btn btn-default pull-left" data-dismiss="modal">Cancel</button>

						<button type="submit" name="action" value="xaccountupdate" class="btn btn-primary pull-right">
							Save
						</button>
					</div>

					</form>
				</div><!-- modal-content -->
			</div><!-- modal-dialog -->
		</div><!-- account -->


		<script src="/js/e.js"><!-- de-munge email addresses --></script>

		<script>
			// Animate anchor links:
			// https://stackoverflow.com/a/26129950/378779

			// handle links with @href started with '#' only
			$(document).on('click', 'a[href^="#"]', function(e) {
				// target element id
				var id = $(this).attr('href');

				// target element
				var $id = $(id);
				if ($id.length === 0) {
					return;
				}

				// prevent standard hash navigation (avoid blinking in IE)
				e.preventDefault();

				// top position relative to the document
				var pos = $id.offset().top;

				// animated top scrolling
				$('body, html').animate({scrollTop: pos}, 500);
			});
		</script>

	<script>
		$( '#event' ).modal( 'show' );
		var a = '20210201-186-993'.split( '-' );
		var event_id = a[ 2 ];
		var yyyymmdd = a[ 0 ];
		do_calendar_event_link( event_id, yyyymmdd );
		// $( '#event-20210201-186-993' ).modal( 'show' );
	</script>

	<script>
		// Add hasScrollBar() function to jQuery:
		(function($) {
			$.fn.hasScrollBar = function() {
				return this.get(0).scrollHeight > this.innerHeight();
			}
		})(jQuery);

		// Add "More" div to calendar cells:
		$( '.kcalendar ul.days li' ).prepend( '<div class="more"><span class="glyphicon glyphicon-arrow-right"></span></div>' );

		// Add mouseover, mouseout, and scroll handling to calendar cells:
		$( '.kcalendar ul.days li' ).mouseover( function() {
			if ( $(this).hasScrollBar() ) {
				$(this).find( '.more' ).css('visibility', 'visible' );
			}
		}).mouseout( function() {
			$(this).find( '.more' ).css('visibility', 'hidden' );
		}).scroll( function() {
			var scrolled_val = $(this).scrollTop().valueOf();
			$(this).find( '.more' ).css('visibility',
				( scrolled_val > 20 ) // Disappear after they scroll 20 pixels
					?
				'hidden'
					:
				'visible'
			);
		});
	</script>

	</body>
</html>