Apparent database problem in 4.4.19

[Fred McNaughton]

Hi there, my host said to send these details after discovering that Events Calendar PRO 4.4.19 was causing my events pages to bog down everything on my server:

The geolocation code in src/Tribe/Geo_Loc.php in get_min_max_coords() seems to be generating database queries that pretty much never finish. Here’s an example of one:

SELECT
MAX( coords.lat ) AS max_lat,
MAX( coords.lng ) AS max_lng,
MIN( coords.lat ) AS min_lat,
MIN( coords.lng ) AS min_lng
FROM (
SELECT post_id AS venue_id,
CASE
WHEN meta_key = ‘_VenueLat’
THEN CAST( meta_value AS DECIMAL( 10, 6 ) )
END AS lat,
CASE
WHEN meta_key = ‘_VenueLng’
THEN CAST( meta_value AS DECIMAL( 10, 6 ) )
END AS lng
FROM wp_postmeta
WHERE
(
meta_key = ‘_VenueLat’
OR meta_key = ‘_VenueLng’
)
AND post_id IN (
SELECT meta_value
FROM wp_postmeta
WHERE
meta_key = ‘_EventVenueID’
AND post_id IN ( 50734, 50867, 51116, 51122, 51142, 53408, 53596, 53698, 53699, 53700, 53701, 53702, 53829, 53831, 53835, 53928, 53963, 53966, 53968, 53973, 53974, 53978, 53980, 53985, 53986, 53995, 53996, 53997, 54004, 54008, 54011, 54012, 54014, 54015, 54016, 54017, 54018, 54026, 54028, 54033, 54036, 54037, 54040, 54042, 54044, 54048, 54055, 54057, 54059, 54066, 54071, 54074, 54079, 54093, 54096, 54104, 54106, 54124, 54127, 54128, 54131, 54143, 54154, 54158, 54170, 54172, 54177, 54178, 54179, 54180, 54181, 54182, 54195, 54197, 54200, 54201, 54204, 54220, 54225, 54228, 54237, 54238, 54240, 54242, 54244, 54246, 54251, 54255, 54258, 54267, 54269, 54272, 54275, 54279, 54282, 54292, 54294, 54295, 54305, 54308, 54311, 54325, 54327, 54328, 54329, 54330, 54331, 54333, 54334, 54348, 54365, 54366, 54368, 54369, 54374, 54412, 54419, 54422, 54424, 54426, 54428, 54430, 54438, 54440, 54443, 54451, 54454, 54460, 54465, 54471, 54473, 54476, 54480, 54482, 54484, 54486, 54488, 54490, 54493, 54505, 54507, 54512, 54518, 54519, 54523, 54528, 54530, 54534, 54539, 54540, 54553, 54554, 54555, 54556, 54558, 54560, 54562, 54569, 54578, 54581, 54583, 54586, 54597, 54605, 54610, 54660, 54662, 54682, 54722, 54731, 54740, 54747, 54753, 54757, 54764, 54767, 54769, 54771, 54775, 54777, 54784, 54788, 54790, 54791, 54793, 54795, 54796, 54798, 54801, 54804, 54806, 54808, 54810, 54813, 54815, 54817, 54824, 54835, 54837, 54839, 54841, 54844, 54849, 54868, 54871, 54885, 54892, 54915, 54918, 54921, 54924, 54927, 54929, 54931, 54933, 54937, 54940, 54941, 54942, 54943, 54951, 54952, 54956, 54959, 54967, 54969, 54976, 54980, 55004, 55006, 55011, 55030, 55034, 55040, 55044, 55050, 55058, 55060, 55063, 55072, 55073, 55074, 55075, 55076, 55077, 55078, 55081, 55084, 55085, 55086, 55087, 55088, 55089, 55090, 55092, 55094, 55095, 55096, 55097, 55098, 55099, 55100, 55101, 55102, 55103, 55107, 55109, 55124, 55130, 55131, 55132, 55148, 55151, 55165, 55166, 55170, 55172, 55175, 55184, 55188, 55189, 55195, 55197, 55199, 55201, 55215, 55233, 55245, 55251, 55256, 55260, 55262, 55265, 55268, 55276, 55282, 55283, 55286, 55287, 55288, 55289, 55291, 55292, 55293, 55294, 55295, 55304, 55307, 55312, 55315, 55317, 55320, 55334, 55337, 55435, 55436, 55437, 55438, 55452, 55468, 55469, 55470, 55471, 55482, 55494, 55500, 55502, 55505, 55510, 55513, 55521, 55534, 55544, 55552, 55566, 55575, 55576, 55577, 55578, 55579, 55580, 55587, 55591, 55601, 55604, 55606, 55609, 55610, 55611, 55612, 55613, 55614, 55618, 55622, 55623, 55624, 55625, 55626, 55629, 55652, 55661, 55677, 55682, 55685, 55696, 55702, 55706, 55708, 55710, 55711, 55712, 55713, 55714, 55715, 55716, 55717, 55718, 55719, 55720, 55721, 55733, 55736, 55751, 55753, 55755, 55757, 55759, 55763, 55766, 55777, 55781, 55784, 55791, 55795, 55796, 55797, 55801, 55819, 55824, 55826, 55832, 55834, 55838, 55840, 55847, 55848, 55849, 55858, 55864, 55874, 55880, 55885, 55887, 55901, 55904, 55911, 55917, 55922, 55924, 55928, 55939, 55950, 55961, 55970, 55972, 55974, 55983, 55985, 55987, 55991, 55992, 55993, 55994, 56001, 56003, 56006, 56012, 56020, 56025, 56029, 56031, 56033, 56047, 56048, 56064, 56066, 56072, 56076, 56078, 56089, 56092, 56094, 56100, 56105, 56111, 56114, 56122, 56126, 56129, 56134, 56140, 56148, 56163, 56170, 56171, 56173, 56174, 56176, 56183, 56196, 56198, 56206, 56216, 56218, 56221, 56225, 56229, 56233, 56237, 56238, 56241, 56244, 56248, 56254, 56255, 56257, 56260, 56261, 56265, 56271, 56275, 56278, 56290, 56293, 56296, 56298, 56299, 56301, 56305, 56314, 56392, 56398, 56401, 56403, 56405, 56408, 56411, 56421, 56430, 56433, 56435, 56437, 56441, 56449, 56457, 56463, 56466, 56471, 56472, 56474, 56479, 56493, 56516, 56519, 56529, 56535, 56542, 56545, 56547, 56553, 56557, 56562, 56564, 56566, 56568, 56578, 56583, 56591, 56596, 56599, 56602, 56605, 56608, 56627, 56641, 56646, 56653, 56666, 56671, 56675, 56676, 56689, 56717, 56718, 56723, 56728, 56730, 56741, 56748, 56751, 56752, 56754, 56758, 56760, 56762, 56765, 56770, 56779, 56788, 56793, 56797, 56803, 56804, 56805, 56809, 56816, 56830, 56835, 56847, 56850, 56864, 56869, 56873, 56879, 56890, 56908, 56915, 56917, 56930, 56932, 56933, 56939, 56940, 56946, 56948, 56958, 56963, 56964, 56970, 56973, 56981, 57018, 57024, 57028, 57035, 57039, 57041, 57053, 57057, 57060, 57064, 57068, 57070, 57074, 57075, 57079, 57087, 57096, 57099, 57105, 57107, 57108, 57109, 57110, 57111, 57117, 57121, 57122, 57126, 57133, 57139, 57146, 57152, 57155, 57161, 57164, 57168, 57172, 57175, 57180, 57192, 57196, 57199, 57207, 57217, 57243, 57256, 57267, 57268, 57274, 57280, 57282, 57302, 57308, 57311, 57312, 57318, 57320, 57321, 57322, 57323, 57330, 57335, 57338, 57342, 57346, 57349, 57357, 57361, 57369, 57393, 57399, 57402, 57407, 57408, 57410, 57411, 57412, 57413, 57414, 57417, 57421, 57425, 57429, 57431, 57434, 57436, 57444, 57447, 57456, 57466, 57468, 57471, 57474, 57479, 57484, 57486, 57494, 57498, 57502, 57507, 57509, 57511, 57515, 57520, 57523, 57524, 57532, 57535, 57538, 57542, 57550, 57551, 57559, 57561, 57570, 57573, 57588, 57593, 57595, 57597, 57609, 57616, 57631, 57637, 57639, 57644, 57647, 57650, 57662, 57672, 57674, 57676, 57679, 57683, 57687, 57690, 57696, 57698, 57707, 57712, 57714, 57715, 57720, 57730, 57751, 57754, 57757, 57764, 57767, 57769, 57773, 57777, 57778, 57780, 57785, 57786, 57792, 57795, 57797, 57801, 57802, 57805, 57806, 57808, 57811, 57813, 57817, 57819, 57821, 57823, 57825, 57827, 57832, 57834, 57839, 57848, 57851, 57860, 57866, 57871, 57879, 57882, 57884, 57886, 57903, 57906, 57908, 57910, 57913, 57929, 57931, 57935, 57945, 57948, 57952, 57955, 57957, 57973, 57983, 57984, 57987, 57995, 57997, 58000, 58003, 58014, 58020, 58023, 58024, 58028, 58034, 58040, 58051, 58056, 58063, 58070, 58077, 58081, 58084, 58096, 58100, 58103, 58105, 58108, 58114, 58122, 58138, 58140, 58161, 58165, 58172, 58174, 58180, 58186, 58190, 58205, 58207, 58216, 58218, 58219, 58220, 58228, 58233, 58237, 58256, 58265, 58270, 58271, 58286, 58289, 58296, 58297, 58300, 58308, 58316, 58327, 58332, 58338, 58344, 58360, 58364, 58366, 58377, 58378, 58385, 58392, 58393, 58400, 58412, 58414, 58415, 58416, 58417, 58422, 58423, 58424, 58425, 58432, 58443, 58445, 58453, 58459, 58460, 58462, 58463, 58465, 58467, 58468, 58469, 58470, 58472, 58475, 58478, 58487, 58494, 58496, 58499, 58502, 58504, 58510, 58515, 58516, 58526, 58528, 58532, 58535, 58536, 58537, 58538, 58539, 58540, 58551, 58557, 58559, 58563, 58574, 58578, 58583, 58584, 58585, 58589, 58597, 58599, 58601, 58603, 58605, 58607, 58609, 58611, 58613, 58634, 58665, 58666, 58672, 58674, 58687, 58690, 58695, 58700, 58706, 58720, 58725, 58726, 58823, 58825, 58828, 58832, 58839, 58854, 58858, 58860, 58862, 58863, 58864, 58865, 58866, 58939, 58942, 58959, 58960, 58964, 58968, 58989, 58992, 58996, 59014, 59016, 59019, 59022, 59030, 59033, 59036, 59040, 59047, 59048, 59050, 59051, 59054, 59057, 59061, 59063, 59065, 59067, 59070, 59071, 59072, 59074, 59075, 59076, 59077, 59078, 59079, 59082, 59083, 59084, 59090, 59093, 59096, 59098, 59113, 59116, 59119, 59145, 59149, 59156, 59173, 59175, 59180, 59182, 59184, 59186, 59189, 59192, 59199, 59202, 59204, 59209, 59211, 59212, 59218, 59219, 59221, 59235, 59237, 59239, 59241, 59242, 59243, 59244, 59245, 59246, 59247, 59254, 59255, 59256, 59257, 59261, 59262, 59263, 59264, 59268, 59269, 59270, 59271, 59272, 59273, 59274, 59275, 59280, 59282, 59286, 59291, 59292, 59293, 59299, 59302, 59304, 59316, 59319, 59322, 59323, 59325, 59332, 59333, 59334, 59345, 59352, 59354, 59356, 59358, 59363, 59365, 59366, 59367, 59368, 59371, 59376, 59378, 59381, 59390, 59392, 59402, 59426, 59430, 59432, 59439, 59454, 59459, 59462, 59474, 59481, 59484, 59491, 59493, 59495, 59496, 59497, 59498, 59502, 59506, 59513, 59525, 59526, 59528, 59531, 59535, 59536, 59641, 59698, 59707, 59718, 59724, 59727, 59731, 59734, 59736, 59742, 59752, 59753, 59755, 59759, 59761, 59766, 59771, 59781, 59785, 59788, 59790, 59798, 59801, 59804, 59810, 59813, 59830, 59835, 59836, 59837, 59838, 59839, 59840, 59841, 59842, 59843, 59846, 59847, 59848, 59849, 59850, 59852, 59854, 59856, 59858, 59861, 59867, 59877, 59887, 59892, 59895, 59898, 59899, 59900, 59901, 59903, 59905, 59906, 59910, 59911, 59912, 59913, 59915, 59917, 59918, 59920, 59926, 59928, 59929, 59931, 59933, 59935, 59953, 59957, 59960, 59980, 59982, 59999, 60001, 60002, 60003, 60004, 60005, 60006, 60007, 60009, 60028, 60051, 60052, 60053, 60054, 60056, 60058, 60062, 60067, 60077, 60098, 60101, 60108, 60111, 60114, 60121, 60124, 60128, 60134, 60137, 60147, 60149, 60155, 60159, 60163, 60171, 60180, 60181, 60184, 60188, 60191, 60194, 60195, 60200, 60201, 60202, 60212, 60215, 60218, 60223, 60230, 60235, 60236, 60238, 60244, 60251, 60254, 60259, 60264, 60275, 60280, 60281, 60284, 60286, 60288, 60291, 60294, 60298, 60300, 60303, 60304, 60312, 60321, 60328, 60333, 60344, 60349, 60352, 60358, 60364, 60365, 60384, 60386, 60396, 60402, 60411, 60414, 60417, 60428, 60431, 60434, 60438, 60441, 60442, 60458, 60459, 60467, 60471, 60473, 60479, 60480, 60496, 60498, 60510, 60515, 60525, 60532, 60536, 60545, 60548, 60568, 60570, 60573, 60587, 60588, 60590, 60592, 60597, 60600, 60601, 60604, 60612, 60614, 60617, 60620, 60628, 60632, 60640, 60645, 60646, 60648, 60651, 60653, 60660, 60663, 60667, 60668, 60676, 60677, 60678, 60683, 60687, 60693, 60698, 60700, 60701, 60702, 60704, 60705, 60706, 60711, 60721, 60723, 60726, 60728, 60730, 60732, 60736, 60740, 60741, 60743, 60754, 60755, 60757, 60758, 60761, 60763, 60765, 60769, 60773, 60786, 60792, 60798, 60800, 60803, 60809, 60812, 60817, 60819, 60821, 60831, 60833, 60835, 60846, 60854, 60857, 60861, 60863, 60871, 60875, 60881, 60892, 60912, 60918, 60922, 60925, 60926, 60943, 60944, 60948, 60960, 60961, 60962, 60963, 60964, 60967, 60972, 60973, 60982, 60983, 60984, 60985, 60986, 60987, 60988, 60990, 60991, 60993, 60997, 61000, 61005, 61016, 61017, 61019, 61023, 61037, 61040, 61042, 61048, 61052, 61053, 61055, 61058, 61064, 61068, 61070, 61079, 61087, 61088, 61089, 61090, 61091, 61093, 61094, 61095, 61101, 61103, 61113, 61117, 61120, 61131, 61145, 61150, 61157, 61160, 61165, 61167, 61171, 61175, 61179, 61181, 61185, 61187, 61192, 61204, 61210, 61214, 61221, 61227, 61229, 61234, 61235, 61241, 61267, 61268, 61270, 61273, 61275, 61278, 61282, 61284, 61290, 61292, 61295, 61307, 61310, 61311, 61312, 61313, 61319, 61321, 61323, 61325, 61327, 61332, 61344, 61345, 61346, 61348, 61350, 61356, 61365, 61369, 61379, 61383, 61384, 61386, 61389, 61396, 61400, 61401, 61403, 61405, 61407, 61409, 61411, 61420, 61422, 61432, 61439, 61445, 61448, 61453, 61454, 61457, 61464, 61465, 61468, 61470, 61475, 61478, 61481, 61488, 61490, 61492, 61496, 61500, 61507, 61514, 61518, 61521, 61524, 61536, 61538, 61541, 61546, 61550, 61552, 61556, 61561, 61563, 61567, 61569, 61572, 61578, 61581, 61585, 61596, 61600, 61604, 61606, 61613, 61614, 61621, 61625, 61628, 61632, 61638, 61641, 61655, 61658, 61660, 61662, 61665, 61672, 61679, 61697, 61706, 61710, 61712, 61717, 61720, 61722, 61729, 61732, 61734, 61741, 61761, 61765, 61779, 61794, 61795, 61798, 61800, 61804, 61812, 61813, 61816, 61823, 61830, 61837, 61840, 61841, 61845, 61847, 61861, 61862, 61863, 61864, 61865, 61866, 61868, 61869, 61873, 61876, 61877, 61880, 61882, 61894, 61897, 61899, 61911, 61926, 61930, 61932, 61941, 62015, 62017, 62019, 62023, 62025, 62029, 62032, 62044, 62047, 62054, 62058, 62061, 62063, 62066, 62068, 62074, 62078, 62080, 62082, 62084, 62085, 62110, 62118, 62122, 62125, 62126, 62132, 62138, 62140, 62142, 62148, 62156, 62158, 62163, 62165, 62167, 62178, 62203, 62204, 62206, 62208, 62210, 62214, 62223, 62226, 62228, 62230, 62238, 62240, 62243, 62249, 62252, 62254, 62255, 62262, 62264, 62268, 62272, 62285, 62287, 62288, 62289, 62290, 62294, 62296, 62299, 62301, 62309, 62320, 62321, 62322, 62326, 62327, 62331, 62332, 62337, 62351, 62354, 62356, 62358, 62362, 62364, 62367, 62369, 62371, 62373, 62376, 62384, 62389, 62401, 62405, 62406, 62407, 62409, 62413, 62417, 62420, 62427, 62440, 62443, 62445, 62452, 62476, 62479, 62510, 62546, 62554, 62566, 62573, 62578, 62585, 62587, 62590, 62591, 62592, 62593, 62595, 62596, 62598, 62603, 62606, 62641, 62659, 62666, 62673, 62684, 62688, 62690, 62693, 62695, 62701, 62709, 62712, 62714, 62743, 62744, 62745, 62746, 62747, 62748, 62749, 62750, 62751, 62752, 62753, 62754, 62755, 62756, 62757, 62758, 62763, 62764, 62765, 62766, 62767, 62768, 62769, 62770, 62771, 62795, 62798, 62806, 62808, 62809, 62813, 62817, 62833, 62838, 62846, 62847, 62850, 62852, 62864, 62866, 62879, 62888, 62894, 62898, 62910, 62916, 62924, 62929, 62931, 62934, 62937, 62938, 62955, 62959, 62986, 62993, 62994, 62997, 63011, 63013, 63033, 63040, 63047, 63055, 63059, 63063, 63067, 63080, 63082, 63084, 63087, 63088, 63089, 63090, 63095, 63097, 63099, 63105, 63107, 63108, 63109, 63110, 63111, 63112, 63114, 63115, 63116, 63117, 63118, 63126, 63130, 63141, 63142, 63144, 63164, 63185, 63187, 63189, 63197, 63200, 63218, 63232, 63234, 63238, 63243, 63247, 63249, 63260, 63264, 63267, 63273, 63277, 63279, 63280, 63290, 63295, 63449, 63472, 63476, 63489, 63491, 63498, 63510, 63515, 63517, 63519, 63522, 63526, 63545, 63550, 63557, 63561, 63563, 63566, 63581, 63622, 63630, 63632, 63636, 63643, 63645, 63647, 63648, 63652, 63654, 63656, 63657, 63660, 63662, 63668, 63692, 63695, 63696, 63705, 63706, 63708, 63712, 63713, 63716, 63721, 63749, 63756, 63762, 63765, 63766, 63778, 63779, 63791, 63793, 63796, 63798, 63800, 63804, 63806, 63816, 63822, 63831, 63834, 63839, 63841, 63854, 63857, 63859, 63864, 63866, 63868, 63876, 63880, 63881, 63882, 63883, 63905, 63907, 63909, 63914, 63958, 63960, 63963, 63973, 63976, 63979, 64000, 64004, 64005, 64006, 64007, 64012, 64016, 64026, 64028, 64033, 64036, 64038, 64046, 64049, 64051, 64054, 64066, 64068, 64070, 64073, 64075, 64078, 64083, 64085, 64090, 64093, 64096, 64101, 64104, 64106, 64126, 64148, 64150, 64153, 64156, 64158, 64160, 64163, 64177, 64185, 64194, 64196, 64199, 64200, 64201, 64202, 64203, 64204, 64205, 64206, 64207, 64209, 64216, 64233, 64251, 64254, 64258, 64272, 64275, 64276, 64277, 64284, 64300, 64302, 64315, 64319, 64324, 64329, 64334, 64335, 64340, 64348, 64351, 64353, 64354, 64355, 64363, 64371, 64373, 64379, 64384, 64392, 64397, 64406, 64408, 64410, 64414, 64415, 64416, 64449, 64460, 64462, 64474, 64537, 64538, 64539, 64540, 64542, 64547, 64551, 64554, 64556, 64559, 64560, 64567, 64569, 64572, 64577, 64578, 64579, 64580, 64581, 64582, 64583, 64594, 64595, 64596, 64597, 64598, 64599, 64600, 64608, 64609, 64610, 64611, 64615, 64617, 64619, 64621, 64623, 64696, 64699, 64703, 64708, 64718, 64737, 64738, 64740, 64747, 64750, 64753, 64755, 64758, 64771, 64775, 64779, 64783, 64786, 64789, 64790, 64793, 64796, 64804, 64807, 64819, 64840, 64844, 64848, 64849, 64852, 64860, 64869, 64878, 64883, 64897, 64952, 64978, 64982, 64985, 64990, 65001, 65003, 65005, 65010, 65017, 65023, 65027, 65032, 65035, 65039, 65048, 65051, 65055, 65057, 65061, 65062, 65064, 65069, 65077, 65084, 65086, 65088, 65093, 65096, 65100, 65110, 65112, 65114, 65128, 65131, 65133, 65139, 65141, 65160, 65168, 65169, 65170, 65171, 65185, 65186, 65187, 65196, 65202, 65222, 65226, 65236, 65239, 65242, 65250, 65251, 65259, 65276, 65278, 65291, 65307, 65310, 65326, 65339, 65341, 65344, 65351, 65354, 65355, 65358, 65360, 65363, 65365, 65393, 65396, 65399, 65406, 65422, 65425, 65428, 65429, 65430, 65431, 65448, 65458, 65466, 65469, 65477, 65479, 65483, 65488, 65489, 65490, 65491, 65492, 65494, 65517, 65531, 65542, 65544, 65545, 65550, 65571, 65575, 65578, 65587, 65591, 65596, 65598, 65600, 65625, 65627, 65628, 65630, 65669, 65675, 65681, 65683, 65724, 65727, 65737, 65739, 65741, 65743, 65745, 65747, 65752, 65754, 65758, 65762, 65763, 65784, 65785, 65791, 65793, 65796, 65799, 65809, 65813, 65816, 65834, 65837, 65847, 65849, 65854, 65865, 65868, 65882, 65894, 65898, 65900, 65904, 65922, 65933, 65935, 65945, 65947, 65956, 65963, 65966, 66001, 66002, 66003, 66004, 66005, 66006, 66007, 66008, 66009, 66010, 66031, 66039, 66040, 66041, 66050, 66060, 66063, 66066, 66068, 66080, 66085, 66089, 66094, 66097, 66101, 66102, 66103, 66139, 66143, 66145, 66160, 66177, 66181, 66183, 66184, 66185, 66186, 66194, 66211, 66215, 66223, 66225, 66231, 66240, 66243, 66247, 66249, 66256, 66258, 66260, 66262, 66264, 66295, 66302, 66304, 66305, 66306, 66308, 66310, 66319, 66332, 66337, 66350, 66353, 66355, 66357, 66366, 66368, 66372, 66397, 66401, 66404, 66408, 66410, 66417, 66437, 66439, 66441, 66442, 66452, 66456, 66466, 66472, 66473, 66478, 66481, 66493, 66496, 66499, 66510, 66513, 66520, 66524, 66526, 66527, 66531, 66539, 66541, 66543, 66546, 66548, 66550, 66586, 66588, 66589, 66590, 66594, 66595, 66596, 66597, 66598, 66599, 66600, 66601, 66610, 66613, 66615, 66617, 66619, 66623, 66624, 66626, 66628, 66630, 66632, 66639, 66645, 66647, 66648, 66658, 66662, 66877, 66882, 66886, 66935, 66937, 66938, 66939, 66940, 66948, 66950, 66969, 66977, 66979, 66989, 66990, 66991, 66992, 66993, 66994, 66995, 66996, 66997, 66998, 67004, 67032, 67034, 67036, 67038, 67041, 67044, 67048, 67051, 67055, 67083, 67084, 67094, 67097, 67101, 67102, 67109, 67121, 67125, 67127, 67128, 67129, 67130, 67252, 67254, 67256, 67258, 67265, 67274, 67279, 67282, 67284, 67287, 67290, 67293, 67296, 67298, 67300, 67320, 67332, 67338, 67340, 67341, 67348, 67350, 67366, 67372, 67376, 67393, 67406, 67409, 67412, 67414, 67416, 67419, 67433, 67435, 67440, 67445, 67450, 67451, 67454, 67459, 67460, 67467, 67469, 67471, 67474, 67475, 67476, 67477, 67485, 67487, 67490, 67491, 67493, 67495, 67527, 67541, 67542, 67543, 67559, 67563, 67567, 67568, 67569, 67570, 67571, 67572, 67573, 67574, 67575, 67576, 67577, 67583, 67586, 67589, 67592, 67593, 67594, 67597, 67606, 67607, 67609, 67610, 67611, 67625, 67626, 67629, 67631, 67633, 67635, 67637, 67674, 67705, 67712, 67726, 67727, 67731, 67744, 67750, 67758, 67760, 67766, 67768, 67775, 67777, 67781, 67782, 67792, 67794, 67797, 67822, 67823, 67826, 67827, 67845, 67847, 67851, 67857, 67861, 67862, 67864, 67865, 67867, 67868, 67870, 67873, 67874, 67919, 67936, 67938, 67950, 67954, 67957, 67959, 67963, 67980, 68039, 68041, 68046, 68047, 68048, 68049, 68053, 68067, 68073, 68090, 68112, 68119, 68120, 68123, 68125, 68127, 68139, 68146, 68148, 68152, 68157, 68165, 68167, 68169, 68185, 68194, 68196, 68198, 68200, 68225, 68245, 68247, 68251, 68266, 68272, 68274, 68276, 68277, 68286, 68289, 68298, 68302, 68306, 68307, 68330, 68331, 68332, 68333, 68334, 68335, 68342, 68349, 68352, 68364, 68366, 68367, 68370, 68380, 68392, 68394, 68396, 68397, 68399, 68400, 68401, 68402, 68403, 68404, 68405, 68409, 68411, 68424, 68438, 68439, 68440, 68450, 68457, 68468, 68469, 68471, 68473, 68475, 68499, 68500, 68501, 68503, 68505, 68516, 68522, 68523, 68524, 68525, 68537, 68538, 68539, 68540, 68542, 68544, 68550, 68554, 68556, 68558, 68562, 68582, 68583, 68585, 68595, 68626, 68628, 68636, 68637, 68643, 68646, 68648, 68649, 68651, 68653, 68656, 68658, 68664, 68694, 68702, 68704, 68706, 68709, 68712, 68739, 68743, 68745, 68756, 68758, 68760, 68764, 68774, 68776, 68784, 68788, 68791, 68797, 68799, 68801, 68804, 68809, 68815, 68816, 68817, 68826, 68847, 68849, 68850, 68854, 68857, 68860, 68870, 68889, 68895, 68897, 68900, 68902, 68905, 68912, 68926, 68928, 68930, 68932, 68933, 68935, 68937, 68939, 68942, 68948, 68952, 68954, 68958, 68960, 68962, 68967, 68970, 68971, 68973, 68975, 68977, 68980, 68984, 69021, 69022, 69024, 69028, 69038, 69040, 69041, 69042, 69043, 69044, 69045, 69047, 69071, 69076, 69078, 69080, 69081, 69082, 69084, 69096, 69113, 69120, 69122, 69124, 69131, 69133, 69134, 69139, 69141, 69143, 69147, 69148, 69150, 69155, 69181, 69184, 69189, 69192, 69195, 69198, 69202, 69203, 69215, 69220, 69224, 69226, 69245, 69246, 69248, 69251, 69255, 69257, 69259, 69264, 69277, 69282, 69284, 69290, 69293, 69296, 69297, 69308, 69311, 69317, 69320, 69322, 69325, 69328, 69338, 69340, 69344, 69346, 69348, 69350, 69352, 69386, 69390, 69392, 69397, 69404, 69406, 69409, 69411, 69417, 69430, 69442, 69448, 69450, 69453, 69457, 69468, 69470, 69472, 69476, 69479, 69480, 69492, 69501, 69505, 69513, 69514, 69519, 69521, 69525, 69530, 69533, 69536, 69539, 69542, 69563, 69565, 69568, 69580, 69584, 69587, 69589, 69590, 69599, 69610, 69615, 69616, 69618, 69631, 69633, 69634, 69638, 69642, 69644, 69646, 69652, 69662, 69663, 69670, 69681, 69683, 69684, 69685, 69686, 69687, 69688, 69691, 69693, 69712, 69717, 69725, 69726, 69727, 69729, 69730, 69738, 69740, 69755, 69765, 69766, 69767, 69768, 69771, 69774, 69777, 69786, 69803, 69806, 69810, 69812, 69814, 69827, 69831, 69836, 69848, 69851, 69855, 69857, 69859, 69861, 69863, 69865, 69867, 69879, 69885, 69887, 69891, 69894, 69898, 69904, 69906, 69909, 69925, 69931, 69933, 69936, 69937, 69938, 69941, 69944, 69945, 69949, 69957, 69958, 69962, 69987, 69989, 69998, 70000, 70002, 70004, 70014, 70016, 70019, 70040, 70042, 70059, 70061, 70073, 70075, 70080, 70090, 70098, 70101, 70102, 70108, 70111, 70117, 70130, 70131, 70133, 70135, 70137, 70149, 70177, 70180, 70181, 70182, 70183, 70184, 70185, 70186, 70187, 70188, 70189, 70194, 70197, 70198, 70202, 70210, 70211, 70213, 70219, 70221, 70223, 70225, 70227, 70231, 70233, 70304, 70319, 70326, 70328, 70329, 70331, 70337, 70341, 70355, 70357, 70358, 70384, 70389, 70390, 70391, 70392, 70393, 70394, 70395, 70396, 70406, 70408, 70414, 70416, 70434, 70436, 70437, 70442, 70445, 70491, 70493, 70498, 70503, 70506, 70508, 70509, 70595, 70606, 70607, 70609, 70621, 70623, 70625, 70629, 70640, 70646, 70650, 70656, 70657, 70663, 70664, 70665, 70669, 70670, 70676, 70677, 70679, 70682, 70684, 70686, 70687, 70689, 70690, 70691, 70694, 70696, 70697, 70698, 70699, 70713, 70715, 70717, 70757, 70759, 70765, 70767, 70768, 70770, 70771, 70772, 70773, 70775, 70776, 70778, 70779, 70783, 70788, 70789, 70791, 70798, 70801, 70812, 70816, 70832, 70845, 70846, 70854, 70857, 70860, 70866, 70876, 70879, 70883, 70884, 70921, 70923, 70928, 70931, 70954, 70957, 70959, 70967, 70970, 70985, 70988, 70990, 70998, 71004, 71006, 71008, 71023, 71025, 71028, 71031, 71043, 71064, 71066, 71067, 71068, 71069, 71071, 71081, 71083, 71086, 71095, 71097, 71107, 71138, 71141, 71149, 71182, 71184, 71190, 71193, 71194, 71197, 71198, 71200, 71201, 71203, 71207, 71209, 71225, 71226, 71233, 71239, 71251, 71265, 71266, 71275, 71276, 71279, 71282, 71284, 71287, 71288, 71301, 71310, 71315, 71317, 71323, 71335, 71343, 71347, 71349, 71359, 71365, 71400, 71403, 71407, 71412, 71422, 71424, 71426, 71433, 71434, 71437, 71444, 71445, 71448, 71450, 71471, 71475, 71479, 71482, 71484, 71486, 71488, 71490, 71492, 71494, 71507, 71509, 71513, 71515, 71517, 71519, 71520, 71522, 71528, 71532, 71536, 71556, 71582, 71584, 71586, 71588, 71591, 71593, 71594, 71595, 71596, 71610, 71611, 71612, 71637, 71642, 71645, 71656, 71662, 71663, 71664, 71665, 71666, 71675, 71677, 71678, 71679, 71680, 71681, 71682, 71699, 71706, 71708, 71742, 71747, 71750, 71759, 71761, 71771, 71778, 71780, 71820, 71825, 71827, 71830, 71833, 71835, 71848, 71855, 71859, 71861, 71863, 71871, 71873, 71874, 71877, 71888, 71895, 71904, 71911, 71913, 71921, 71928, 71937, 71938, 71940, 71942, 71943, 71967, 71969, 71970, 71971, 71972, 71973, 71976, 71979, 71980, 71982, 71983, 71986, 71988, 71989, 71991, 71995, 72020, 72024, 72026, 72030, 72031, 72034, 72036, 72049, 72051, 72069, 72080, 72088, 72090, 72093, 72096, 72098, 72099, 72100, 72101, 72117, 72118, 72123, 72125, 72127, 72136, 72138, 72140, 72148, 72186, 72200, 72201, 72210, 72211, 72213, 72217, 72222, 72233, 72239, 72252, 72256, 72270, 72272, 72282, 72297, 72300, 72307, 72310, 72312, 72315, 72319, 72321, 72323, 72349, 72350, 72357, 72358, 72359, 72361, 72364, 72368, 72393, 72404, 72412, 72415, 72423, 72427, 72433, 72826, 72902, 72936, 72938, 72983, 73173, 73175, 73178, 73180, 73186, 73187, 73189, 73190, 73219, 73253, 73258, 73259, 73262, 73263, 73264, 73265, 73266, 73268, 73269, 73270, 73274, 73275, 73277, 73279, 73280, 73281, 73288, 73290, 73310, 73312, 73314, 73316, 73327, 73344, 73351, 73356, 73360, 73364, 73366, 73382, 73384, 73386, 73426, 73441, 73443, 73449, 73451, 73465, 73471, 73473, 73474, 73478, 73479, 73482, 73514, 73515, 73525, 73526, 73527, 73539, 73545, 73547, 73548, 73550, 73552, 73554, 73556, 73558, 73600, 73604, 73608, 73611, 73615, 73624, 73626, 73634, 73636, 73645, 73648, 73663, 73670, 73671, 73672, 73685, 73687, 73689, 73728, 73736, 73757, 73771, 73796, 73801, 73804, 73838, 73841, 73849, 73854, 73859, 73861, 73863, 73865, 73867, 73869, 73871, 73876, 73878, 73904, 73905, 73915, 73920, 73922, 73925, 73927, 73931, 73941, 73943, 73947, 73949, 73951, 73953, 73960, 74002, 74003, 74005, 74018, 74020, 74021, 74023, 74031, 74033, 74036, 74055, 74056, 74062, 74065, 74075, 74083, 74085, 74087, 74090, 74111, 74115, 74117, 74122, 74128, 74132, 74136, 74138, 74141, 74143, 74145, 74157, 74160, 74165, 74182, 74190, 74192, 74194, 74196, 74198, 74294, 74307, 74312, 74316, 74318, 74320, 74325, 74326, 74327, 74328, 74350, 74353, 74359, 74372, 74381, 74392, 74402, 74403, 74407, 74412, 74415, 74417, 74419, 74427, 74436, 74438, 74447, 74449, 74451, 74460, 74467, 74489, 74497, 74499, 74507, 74521, 74523, 74525, 74527, 74528, 74546, 74548, 74598, 74601, 74606, 74612, 74616, 74619, 74621, 74639, 74642, 74644, 74646, 74662, 74665, 74669, 74676, 74679, 74681, 74685, 74688, 74689, 74690, 74699, 74702, 74703, 74704, 74705, 74706, 74707, 74708, 74709, 74710, 74712, 74714, 74771, 74792, 74836, 74837, 74842, 74845, 74847, 74848, 74849, 74850, 74852, 74864, 74868, 74876, 74878, 74880, 74882, 74884, 74886, 74887, 74908, 74910, 74911, 74912, 74916, 74928, 74929, 74930, 74938, 74942, 74944, 74948, 74951, 74990, 75009, 75011, 75013, 75014, 75017, 75021, 75024, 75026, 75029, 75030, 75031, 75032, 75040, 75064, 75073, 75075, 75077, 75078, 75079, 75081, 75083, 75085, 75089, 75091, 75093, 75095, 75097, 75099, 75101, 75103, 75105, 75107, 75200, 75203, 75207, 75222, 75226, 75227, 75441, 75442, 75451, 75452, 75593, 75596, 75599, 75616, 75619, 75631, 75632, 75634, 75638, 75653, 75656, 75661, 75663, 75666, 75667, 75671, 75673, 75675, 75676, 75704, 75705, 75713, 75714, 75718, 75719, 75721, 75722, 75753, 75760, 75762, 75765, 75767, 75769, 75775, 75776, 75778, 75782, 75785, 75786, 75788, 75791, 75793, 75796, 75797, 75798, 75814, 75835, 75841, 75858, 75859, 75861, 75869, 75874, 75888, 75890, 75892, 75901, 75903, 75904, 75906, 75917, 75920, 75922, 75924, 75926, 75931, 75933, 75944, 75946, 75948, 75949, 75950, 75960, 75983, 75984, 75985, 75988, 75990, 75992, 75994, 75997, 76006, 76008, 76010, 76017, 76043, 76044, 76046, 76052, 76055, 76078, 76079, 76080, 76081, 76082, 76190, 76192, 76194, 76196, 76352, 76353, 76356, 76362, 76363, 76369, 76371, 76373, 76383, 76385, 76388, 76389, 76390, 76403, 76405, 76408, 76414, 76423, 76425, 76427, 76430, 76431, 76433, 76435, 76438, 76440, 76442, 76444, 76446, 76448, 76450, 76452, 76454, 76456, 76460, 76462, 76476, 76477, 76478, 76501, 76510, 76512, 76524, 76528, 76532, 76534, 76536, 76560, 76565, 76578, 76580, 76588, 76590, 76599, 76604, 76616, 76619, 76621, 76625, 76643, 76646, 76650, 76653, 76660, 76665, 76667, 76669, 76679, 76682, 76684, 76686, 76691, 76694, 76699, 76700, 76702, 76704, 76721, 76723, 76727, 76737, 76738, 76739, 76740, 76741, 76742, 76745, 76761, 76763, 76764, 76765, 76774, 76779, 76781, 76782, 76783, 76786, 76797, 76799, 76801, 76803, 76804, 76823, 76824, 76826, 76833, 76838, 76843, 76845, 76854, 76859, 76860, 76875, 76877, 76889, 76893, 76896, 76904, 76911, 76917, 76918, 76920, 76929, 76932, 76935, 76946, 76948, 76949, 76956, 76984, 76991, 76993, 76998, 77000, 77002, 77010, 77012, 77014, 77017, 77018, 77031, 77041, 77047, 77053, 77069, 77070, 77071, 77072, 77073, 77074, 77084, 77088, 77092, 77094, 77096, 77097, 77098, 77099, 77100, 77101, 77103, 77125, 77127, 77129, 77131, 77132, 77138, 77142, 77151, 77154, 77155, 77156, 77157, 77158, 77159, 77161, 77165, 77169, 77170, 77176, 77178, 77211, 77217, 77228, 77230, 77232, 77240, 77244 )
)
) AS coords

This query shows up in the MySQL monitor as running for minutes – it never seems to finish. This code (a rough approximation of which is in the same source file, but in a function called estimate_center_point(), doesn’t seem to exhibit the same behavior in 4.4.18, so I’ve downgraded to that (and 4.6.2 on The Events Calendar, just to be safe).

Is this enough to go on for a bug report? Is there anything else I can pass back to our host to try, perhaps in the configuration?

Thanks,
Fred

[Fred McNaughton]

Yikes, that paste job was terrible. You can see the SQL being generated here:

https://gist.github.com/anonymous/45f6f1305872cb7329ebd16eeaf68add

Hope that’s better!

[Andras]

Hi Fred,

WOW! Indeed, that query looks terrible. 🙂 Let’s try to get to the bottom of this.

Do you possibly know when that query gets generated? My hunch is when the map view is loaded, trying to center the map. And the issue likely comes from the number of events / venues.

Can you share with me a database dump so I can do some investigation?

Thanks,
Andras

 

[Fred McNaughton]

I have NO idea when the call is happening, but it’s happening for event pages. Nothing ever loads – the database call starts while my browser spinner is still going slow and nothing is showing on the screen – so I suppose it’s pretty early in the page load.

You can get a link to the database dump at https://1ty.me/hAEoK5Eo6 – that’s a one-time link that will show you where to download a dump of the wp_posts and wp_postmeta tables. (If you want/need other tables, please let me know. I didn’t dump the whole database because there are non-WP things in there that I’d prefer not to share. 🙂 Please let me know if that doesn’t work for you.

Thanks for the offer of assistance!

[Andras]

Thanks Fred, I’ll take a look at it and will let you know if I find something. Please hang in there.

Cheers,
Andras

[Andras]

Hi Fred,

It looks like this is a glitch in the plugin. I have submitted a bugticket on this so our developers can take a look at it.

Until the fix is released the workaround is to roll back to Events Calendar PRO 4.4.18.

I am going to set the status of this ticket to “pending fix” and we will update it once the fix is released. If you have any new questions or issues please create a new ticket and reference this one.

Thanks and cheers,
Andras

[Fred McNaughton]

Thanks Andras. I will have Peter from Agathon get in touch should we have any further issues (Agathon is where our servers are housed. They help us with issues above our ability.)

[Andras]

Sure thing Fred, we’re happy to help.

I would like to kindly ask, if you / they are getting in touch with us with a different issue, then please open a new thread in the forums so we can keep things clean.

Thanks and cheers,
Andras

[Nico]

Hi there,

Just wanted to share with you that a new maintenance release (for the Week of 7th January 2018) is out, including a fix for this issue :slightly_smiling_face:

Find out more about this release → https://theeventscalendar.com/maintenance-release-week-7-january-2018/

Please update the plugins and let us know if the fix works for your site,
Best,
Nico

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts