Help Desk

Uncaught TypeError: Cannot read property 'max_lat' of null

  • Posts: 79 Topics: 22
    | Permalink

    Hello,

    I am getting the following errors when visiting the calendar page:

    Uncaught TypeError: Cannot read property 'max_lat' of null
        tribe-events-ajax-maps.min.js?ver=4.4.19:1 
        at tribe-events-ajax-maps.min.js?ver=4.4.19:1
        at tribe-events-ajax-maps.min.js?ver=4.4.19:1
    (anonymous) @ tribe-events-ajax-maps.min.js?ver=4.4.19:1
    (anonymous) @ tribe-events-ajax-maps.min.js?ver=4.4.19:1
    

    And also:

    [Wed Nov 08 15:14:24.411677 2017] [:error] [pid 12223] [client 207.46.13.9:52543] KILLED QUERY (19985 characters long generated in /nas/content/live/wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php:907): \n\t\t\tSELECT\n\t\t\t\tMAX( [code]coords

    .

    lat

    ) AS

    max_lat

    ,\n\t\t\t\tMAX(

    coords

    .

    lng

    ) AS

    max_lng

    ,\n\t\t\t\tMIN(

    coords

    .

    lat

    ) AS

    min_lat

    ,\n\t\t\t\tMIN(

    coords

    .

    lng

    ) AS

    min_lng

    \n\t\t\tFROM (\n\t\t\t\tSELECT

    post_id

    AS

    venue_id

    ,\n\t\t\t\tCASE\n\t\t\t\t\tWHEN

    meta_key

    = '_VenueLat'\n\t\t\t\t\tTHEN CAST(

    meta_value

    AS DECIMAL( 10, 6 ) )\n\t\t\t\tEND AS

    lat

    ,\n\t\t\t\tCASE\n\t\t\t\t\tWHEN

    meta_key

    = '_VenueLng'\n\t\t\t\t\tTHEN CAST(

    meta_value

    AS DECIMAL( 10, 6 ) )\n\t\t\t\tEND AS

    lng

    \n\t\t\tFROM

    wp_postmeta

    \n\t\t\tWHERE\n\t\t\t\t(\n\t\t\t\t\t

    meta_key

    = '_VenueLat'\n\t\t\t\t\tOR

    meta_key

    = '_VenueLng'\n\t\t\t\t)\n\t\t\t\tAND

    post_id

    IN (\n\t\t\t\t\tSELECT

    meta_value

    \n\t\t\t\t\tFROM

    wp_postmeta

    \n\t\t\t\t\tWHERE\n\t\t\t\t\t\t

    meta_key

    = '_EventVenueID'\n\t\t\t\t\t\tAND

    post_id

    IN ( 50, 75, 78, 81, 82, 86, 88, 94, 95, 101, 105, 108, 111, 112, 117, 118, 129, 132, 133, 134, 137, 140, 141, 142, 145, 148, 150, 154, 155, 161, 162, 164, 169, 1185, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1276, 1315, 1322, 1323, 1324, 1325, 1326, 1327, 1477, 1481, 1486, 1487, 1541, 1553, 1561, 1569, 1577, 1586, 1611, 1616, 1730, 1732, 1738, 1741, 1745, 1842, 1863, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1891, 1893, 1894, 1895, 1898, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1913, 1914, 1917, 1921, 1922, 1923, 1926, 1928, 1929, 1930, 1939, 1941, 1942, 1943, 1944, 1946, 1948, 1951, 1952, 1953, 1968, 1969, 1970, 1982, 1983, 1984, 1985, 1987, 2004, 2005, 2008, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2078, 2079, 2144, 2535, 2536, 2560, 2776, 3691, 3700, 3710, 3712, 3715, 3717, 3802, 3857, 3974, 4023, 4093, 4097, 4099, 4106, 4109, 4162, 4164, 4166, 4168, 4173, 4176, 4181, 4182, 4204, 4205, 4213, 4223, 4256, 4307, 4331, 4334, 4417, 4420, 4443, 4534, 4553, 4560, 4584, 4623, 4624, 4640, 4656, 4685, 4690, 4765, 4825, 4835, 4865, 4868, 4886, 4952, 4972, 4978, 4981, 4984, 4986, 4987, 4988, 4989, 5033, 5037, 5038, 5039, 5040, 5057, 5063, 5071, 5103, 5114, 5185, 5186, 5187, 5266, 5275, 5277, 5281, 5295, 5404, 5417, 5440, 5470, 5475, 5480, 5492, 5558, 5609, 5613, 5615, 5631, 5645, 5650, 5733, 5771, 5868, 6143, 6149, 6155, 6180, 6183, 6185, 6192, 6195, 6196, 6200, 6237, 6241, 6378, 6385, 6388, 6637, 6639, 6764, 6767, 6769, 6770, 6771, 6772, 6773, 6872, 6880, 7013, 7017, 7028, 7033, 7034, 7035, 7036, 7037, 7038, 7039, 7040, 7042, 7051, 7058, 7060, 7063, 7065, 7067, 7081, 7088, 7104, 7131, 7184, 7197, 7200, 7203, 7211, 7221, 7239, 7241, 7344, 7362, 7379, 7387, 7417, 7421, 7426, 7474, 7522, 7523, 7587, 7594, 7605, 7636, 7639, 7643, 7707, 7736, 7751, 7776, 7843, 7845, 7853, 7854, 7855, 7856, 7857, 7858, 7861, 7886, 7926, 7966, 8049, 8051, 8056, 8057, 8233, 8242, 8244, 8251, 8253, 8254, 8255, 8256, 8275, 8280, 8295, 8298, 8337, 8341, 8350, 8361, 8362, 8446, 8447, 8449, 8450, 8474, 8483, 8510, 8512, 8513, 8514, 8518, 8570, 8578, 8619, 8778, 8789, 8792, 8794, 8802, 8803, 8807, 8808, 8810, 8811, 8812, 8813, 8814, 8815, 8817, 8818, 8819, 8820, 8821, 8822, 8823, 8824, 8825, 8826, 8827, 8828, 8829, 8830, 8831, 8873, 8904, 8907, 8908, 8909, 8912, 8913, 8914, 8982, 9027, 9134, 9148, 9174, 9177, 9212, 9232, 9239, 9242, 9257, 9294, 9340, 9342, 9700, 9703, 9704, 9707, 9733, 9791, 9796, 9798, 9805, 9849, 9876, 9898, 9901, 9902, 9906, 9908, 9916, 9917, 9923, 9979, 10167, 10168, 10286, 10292, 10293, 10294, 10295, 10296, 10297, 10298, 10299, 10300, 10301, 10302, 10463, 10465, 10472, 10474, 10513, 10585, 10588, 10754, 10834, 10837, 10870, 11121, 11123, 11240, 11248, 11286, 11297, 11317, 11318, 11352, 11360, 11407, 11436, 11466, 11519, 11522, 11550, 11556, 11557, 11558, 11559, 11560, 11561, 11562, 11563, 11565, 11686, 11876, 11917, 12013, 12019, 12020, 12022, 12056, 12069, 12073, 12092, 12094, 12095, 12113, 12114, 12121, 12123, 12124, 12125, 12126, 12127, 12128, 12129, 12130, 12131, 12132, 12133, 12134, 12135, 12136, 12137, 12138, 12139, 12140, 12141, 12142, 12143, 12144, 12145, 12146, 12147, 12148, 12149, 12150, 12151, 12152, 12153, 12154, 12155, 12156, 12157, 12158, 12159, 12160, 12161, 12162, 12163, 12164, 12165, 12166, 12167, 12168, 12169, 12170, 12171, 12172, 12173, 12175, 12179, 12187, 12188, 12195, 12215, 12216, 12218, 12235, 12284, 12310, 12312, 12323, 12324, 12342, 12453, 12503, 12520, 12536, 12543, 12557, 12561, 12630, 12634, 12640, 12842, 12848, 12849, 12850, 12851, 12852, 12853, 12854, 12855, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863, 12864, 12865, 12866, 12867, 12868, 12869, 12870, 12871, 12872, 12873, 12874, 12875, 12876, 12877, 12878, 12879, 12880, 12881, 12882, 12883, 12884, 12885, 12886, 12887, 12888, 12889, 12890, 12891, 12892, 12893, 12894, 12895, 12896, 12897, 12898, 12899, 12900, 12901, 12902, 12903, 12904, 12905, 12906, 12907, 12908, 12909, 12910, 12911, 12912, 12913, 12914, 12915, 12916, 12917, 12918, 12919, 12920, 12921, 12922, 12923, 12924, 12925, 12926, 12927, 12928, 12929, 12930, 12931, 12932, 12933, 12934, 12935, 12936, 12937, 12938, 12939, 12940, 12941, 12942, 12943, 12944, 12945, 12946, 12947, 12948, 12949, 12950, 12951, 12952, 12953, 12954, 12955, 12956, 12957, 12958, 12959, 12960, 12961, 12962, 12963, 12964, 12967, 12970, 12980, 12981, 12982, 12988, 12989, 12990, 12999, 13001, 13061, 13104, 13140, 13188, 13208, 13262, 13267, 13280, 13291, 13295, 13318, 13418, 13478, 13508, 13512, 13515, 13520, 13524, 13527, 13528, 13530, 13531, 13532, 13533, 13534, 13535, 13536, 13546, 13548, 13571, 13585, 13628, 13639, 13668, 13671, 13673, 13674, 13675, 13676, 13677, 13678, 13691, 13729, 13730, 13742, 13769, 13770, 13773, 13778, 13800, 13812, 13826, 13830, 13833, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13851, 13852, 13853, 13855, 13860, 13863, 13871, 13875, 14000, 14001, 14070, 14071, 14112, 14117, 14149, 14167, 14172, 14204, 14253, 14255, 14257, 14260, 14262, 14361, 14364, 14365, 14400, 14404, 14440, 14441, 14442, 14443, 14464, 14524, 14525, 14535, 14554, 14614, 14639, 14660, 14662, 14663, 14664, 14667, 14735, 14736, 14750, 14751, 14754, 14756, 14813, 14814, 14815, 14816, 14820, 14829, 14873, 14885, 14886, 14890, 14891, 14892, 14893, 14894, 14895, 14896, 14897, 14899, 14900, 14901, 14904, 14905, 14906, 14907, 14909, 14914, 14915, 14938, 14962, 14964, 14969, 15005, 15021, 16041, 16064, 16068, 16118, 16163, 16186, 16187, 16190, 16194, 16207, 16210, 16216, 16254, 16257, 16258, 16259, 16260, 16261, 16262, 16263, 16264, 16265, 16266, 16267, 16268, 16269, 16270, 16271, 16272, 16273, 16274, 16275, 16276, 16277, 16278, 16279, 16280, 16281, 16282, 16283, 16284, 16285, 16286, 16287, 16288, 16289, 16290, 16291, 16292, 16293, 16294, 16295, 16297, 16309, 16317, 16330, 16332, 16333, 16397, 16399, 16424, 16432, 16469, 16471, 16472, 16475, 16476, 16477, 16496, 16507, 18261, 18265, 18308, 18310, 18311, 18312, 18313, 18314, 18315, 18317, 18318, 18319, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18329, 18330, 18331, 18402, 18407, 18410, 18411, 18413, 18420, 18435, 18806, 18824, 18827, 18894, 18896, 18897, 18900, 18902, 18906, 18957, 18960, 18961, 18962, 18963, 18964, 18965, 18966, 19014, 19019, 19030, 19081, 19188, 19247, 19282, 19284, 19299, 19311, 19326, 19356, 19360, 19361, 19362, 19403, 19407, 19413, 19415, 19416, 19477, 19518, 19540, 19619, 19621, 19644, 19650, 19664, 19670, 19679, 19681, 19683, 19684, 19685, 19708, 19754, 19756, 19781, 19782, 19784, 19805, 19807, 19808, 19809, 19810, 19811, 19827, 19829, 19832, 19833, 19841, 19852, 19855, 19857, 19858, 19860, 19861, 19862, 19863, 19865, 19866, 19868, 19871, 19872, 19874, 19876, 19973, 20006, 20054, 20056, 20057, 20072, 20124, 20125, 20159, 20203, 20248, 20251, 20265, 20308, 20331, 20332, 20376, 20391, 20408, 20464, 20466, 20467, 20495, 20524, 20525, 20527, 20604, 20671, 20675, 20678, 20679, 20684, 20687, 20762, 20763, 20767, 20838, 20843, 20845, 20875, 20876, 20877, 20878, 20879, 2
    DashboardInstallsUsersSettingsSupport Garage
    Privacy PolicyCommunityConsultantsSystem Status
    [/code]

    Any idea what’s going on? It started happening after the latest update I just ran.

    Posts: 5926
    | Permalink

    Hi Daniel,

    Thanks for reaching out!  I’m sorry to hear that you are experiencing this issue!

    Are you seeing any issues with functionality on this site when the error is there?

    As a first step, let’s try to rule out if there is some type of conflict at play.
    This is usually because of:

    1.    A conflict with another plugin

    2.    A conflict with your WordPress theme

    3.    A template customization for the Events Calendar that requires updating

    When it comes to that type of issue, it is preferable to troubleshoot in a staging environment if you have one.

    A first quick test is to simply temporarily revert back to a default WordPress theme such as twenty-sixteen to see if the issue persists.

    The next step would be to go through our testing for conflicts procedure and let us know what you find out.

    Basically the goal here is to revert back to a bare WordPress installation to see if the problem persists. It also allows us to pinpoint what the cause of the issue is.

    But, before you do that, there are 2 things I would advise:

    1.    Make a backup of your database

    2.    Consider activating a “Maintenance Page” plugin if you are doing this on your live site (to minimize impact on your visitors)

    Let me know how that goes!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Hi Jaime,

    I did all the troubleshooting and the issue still persists. Now with the latest version there also another issue mentioned on the following link: https://wordpress.org/support/topic/last-update-causes-issues/#post-9670962

    Your plugin is causing conflicts with Advanced Custom Fields.

    Please advise. For now I have rolled back to 4.6.3 and I still have the issue mentioned on this thread.

    Thank you!

    Posts: 79 Topics: 22
    Posts: 5926
    | Permalink

    Hi Daniel,

    Thanks for providing me with all of this information.  I’m sorry that you are seeing additional issues with your site since updating, however I’m glad to see that you have a workaround for now.

    Let’s start off by working on your initial issue.  Would you mind sharing a screenshot of your map settings with me?  Also, if you could tell me what triggers that error to appear, I could try to replicate things on my end.

    In the meantime, you may also want to ensure that you have everything set up properly with Google Maps:

    https://theeventscalendar.com/knowledgebase/setting-up-your-google-maps-api-key/

    Please let me know if there is anything else I need to know in order to replicate this issue!

     

    Thanks,

    Jaime

    Posts: 5926
    | Permalink

    Hi Daniel,

    I just wanted to follow up with you and let you know that I got some more information on your issue.  It seems that there is a bug related to our geolocation code.  A workaround for this issue at this time would be for you to roll back to Events Calendar version 4.4.18.

    We apologize for the inconvenience caused by this glitch and we are actively working on a solution for this.  I cannot guarantee when it will be fixed, as it’s in the development team’s hands now.  They need to assign it, code it, test it, and schedule it for release.  The good news is that you will be contacted as soon as a fix is available.

    As for your other issues, if you are still experiencing them, I’d recommend opening a new thread for that issue, so that we can deal with each issue separately.

    Please let me know if you have any questions in the meantime.  Thank you for your patience as we see this through.

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Hi Jaime,

    Just to follow up, I’m running the latest version of The Events Calendar (4.6.5) and Events Calendar PRO (4.4.19) and I’m still having the issue.

    Thank you!

    Posts: 79 Topics: 22
    | Permalink

    I rolled back Events Calendar PRO to 4.4.18 and now I’m getting the following:

    [Fri Nov 17 22:16:15.876131 2017] [:error] [pid 16989] [client 207.46.13.114:14549] PHP Fatal error: Uncaught Error: Class 'Tribe__Events__Pro__Venue_Widget' not found in /wp-includes/class-wp-widget-factory.php:100\nStack trace:\n#0 /wp-includes/widgets.php(115): WP_Widget_Factory->register('Tribe__Events__...')\n#1 /wp-content/plugins/events-calendar-pro/src/Tribe/Main.php(1521): register_widget('Tribe__Events__...')\n#2 [internal function]: Tribe__Events__Pro__Main->pro_widgets_init('')\n#3 /wp-includes/class-wp-hook.php(286): call_user_func_array(Array, Array)\n#4 /wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(NULL, Array)\n#5 /wp-includes/plugin.php(453): WP_Hook->do_action(Array)\n#6 /wp-includes/widgets.php(1645): do_action('widgets_init')\n#7 [internal function]: wp_widgets_init('')\n#8 /wp-includes/class-wp-hook.php(286): call_user_func_array('w in /wp-includes/class-wp-widget-factory.php on line 100

    :/

    Posts: 5926
    | Permalink

    Hi Daniel,

    I apologize for the delayed response.  As you’ve discovered, rolling back to 4.4.18 isn’t a workable solution anymore, and we are actively working on creating a fix for this issue.  I apologize for any inconvenience this may cause you and we appreciate your patience throughout this process.

    Please let me know if you have any other questions in the meantime!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Hello,

    Any update on this? My server logs are getting filled with this. 🙂

    Thank you!

    Posts: 5926
    | Permalink

    Hi Daniel,

    I wish I had some more concrete news for you, but unfortunately this bug is still being worked on and I don’t have a definitely timeline of when it will be resolved.  It has been bumped up to a high priority bug and you will be notified as soon as a fix is available.

    Thank you for your patience!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Ok Jaime,

    This is filling up my error log making it hard to catch other bugs. 🙂

    Also I don’t think the option “Notify me of follow-up replies via email” on this ticket is working. I never got your replies via email.

    Thank you.

    Posts: 5926
    | Permalink

    Hi Daniel,

    I’m sorry that you are not getting notifications via email.  Just as an update, this bug has been upgraded to high priority and we are actively working on a solution for our users.

    You will be notified as soon as a fix is available.  Please let me know if you have any other questions in the meantime!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Ok, I believe this is causing my server to timeout not only this requests but others. Please fix this ASAP.

    Thank you!

    Posts: 5926
    | Permalink

    Hi Daniel,

    We are actively working on a fix for this bug and progress has been made since my last response to you.

    This will be released soon, and we really appreciate your patience and understanding throughout this process.

     

    Thanks,

    Jaime

    Posts: 6521 Topics: 11
    | Permalink

    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

    Posts: 79 Topics: 22
    | Permalink
    This reply has been marked as private.
    Posts: 5926
    | Permalink

    Hi Daniel,

    I’m sorry to hear that the most recent update did not resolve your issue.  You had previously mentioned that our plugin conflicts with Advanced Custom Fields on your site.  If you turn off ACF, do you see the errors resolved?

    In any case, let’s try running through our testing for conflicts procedure again and troubleshoot from there.

    Thanks for your patience in this process.  Let me know how it goes and if any other questions come up along the way!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Hi Jaime,

    That conflict was related to another issue (https://wordpress.org/support/topic/last-update-causes-issues/#post-9670962). That issue has been resolved already.

    The error now is related to /wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php on line 948 where it makes a query on the database that needs to be killed by the server, probably because it was not properly coded and it is generating a query that is too long/big.

    I have already tested for conflict and the issue still remains.

    Thanks!

    Posts: 5926
    | Permalink

    Hi Daniel,

    As a first troubleshooting step, could you please provide us with your complete updated system information in a private reply using the instructions found in the following link?

    https://theeventscalendar.com/knowledgebase/sharing-sys-info/

    Let me know if anything else comes up in the meantime!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink
    This reply has been marked as private.
    Posts: 5926
    | Permalink

    Hi Daniel,

    Thanks for providing me with that information.

    Please try the following:

    • Please clear your cache and disable your caching plugin (if you have one)
    • Go to Settings > Permalinks and re-save the permalink settings
    • clear your browser cache (here‘s how to do that)

    Let me know how that goes!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink
    This reply has been marked as private.
    Posts: 5926
    | Permalink

    Hi Daniel,

    Do you know when you see this error?  In other words, is this error triggered with recurring events, map view, etc.?

    Does rolling back to 4.4.18 resolve this issue?

    Also, can you try updating to the latest release of our plugin to see if that helps?

    Let me know!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink
    This reply has been marked as private.
    Posts: 5926
    | Permalink

    Hi Daniel,

    The issue with events not showing up was resolved with a hotfix on Friday, can you try updating and let me know if that issue was resolved for you?

    Let me know how that goes!

     

    Thanks,

    Jaime

    Posts: 79 Topics: 22
    | Permalink

    Hi Jaime,

    I have updated to 4.6.11.1 and the events are now showing up.

    However, the initial issue: KILLED QUERY (18431 characters long generated in ../wp-content/plugins/events-calendar-pro/src/Tribe/Geo_Loc.php:948) is still happening.

    I have created a staging environment and the same happens on the staging environment. The log shows the error upon users visiting the events pages.

    Any idea when this can be resolved? Thank you!

    Posts: 5926
    | Permalink

    Hi Daniel,

    It looks like we are still looking into the issue that you are describing, as we still have other users reporting similar issues.

    I will mark this thread as Pending Fix again, and you will be notified when a fix has been released for this issue.

    Please let me know if you have any other questions in the meantime!

     

    Thanks,

    Jaime

    Posts: 6093 Topics: 16
    | Permalink
    Correct Answer

    Hi There!

    Just wanted to share with you that a new maintenance release (for the Week of 5 March 2018) is out, including a fix for this issue 🙂

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

    Please update the plugins and let us know if the fix works for your site.

    Best,
    Victor

    Posts: 7
    | Permalink

    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

The topic ‘Uncaught TypeError: Cannot read property 'max_lat' of null’ is closed to new replies.