EasySocial 1.2.17 upgrade crashed site

I just upgraded from 1.2.16 to 1.2.17 across all Joomla 3.3.1 sites.

In all cases the upgrade failed at "Initializing Database Stored Functions" which was listed as failed and the upgrade did not complete.

In one case the site crashed completely on the frontend showing:

1558

COLUMN COUNT OF MYSQL.PROC IS WRONG. EXPECTED 20, FOUND 16. CREATED WITH MYSQL 50532, NOW RUNNING 50537. PLEASE USE MYSQL_UPGRADE TO FIX THIS ERROR. SQL=SELECT A.* , L.ID AS LOC_ID, L.UID AS LOC_UID, L.TYPE AS LOC_TYPE, L.USER_ID AS LOC_USER_ID, L.CREATED AS LOC_CREATED, L.SHORT_ADDRESS AS LOC_SHORT_ADDRESS ,L.ADDRESS AS LOC_ADDRESS, L.LONGITUDE AS LOC_LONGITUDE, L.LATITUDE AS LOC_LATITUDE, L.PARAMS AS LOC_PARAMS ,MD.ID AS MD_ID, MD.NAMESPACE AS MD_NAMESPACE,MD.NAMESPACE_UID AS MD_NAMESPACE_UID, MD.ICON AS MD_ICON, MD.VERB AS MD_VERB, MD.SUBJECT AS MD_SUBJECT, MD.CUSTOM AS MD_CUSTOM ,MD.TEXT AS MD_TEXT, MD.USER_ID AS MD_USER_ID, MD.CREATED AS MD_CREATED ,FLOOR( ( UNIX_TIMESTAMP( NOW() ) - UNIX_TIMESTAMP( A.`MODIFIED`) ) / 60 ) AS `MIN` ,FLOOR( ( UNIX_TIMESTAMP( NOW() ) - UNIX_TIMESTAMP( A.`MODIFIED`) ) / 60 / 60 ) AS `HOUR` ,FLOOR( ( UNIX_TIMESTAMP( NOW() ) - UNIX_TIMESTAMP( A.`MODIFIED`) ) / 60 / 60 / 24 ) AS `DAY` FROM (SELECT A1.* FROM `M4GLB_SOCIAL_STREAM` AS A1 WHERE `ACTOR_TYPE` = 'USER' AND `ACTOR_ID` = '632' UNION SELECT A2.* FROM `M4GLB_SOCIAL_STREAM` AS A2 INNER JOIN `M4GLB_SOCIAL_STREAM_ITEM` AS AI2 ON A2.`ID` = AI2.`UID` WHERE A2.`ACTOR_TYPE` = 'USER' AND A2.`TARGET_ID` = '632' AND A2.`CONTEXT_TYPE` IN ('FRIENDS','STORY', 'PHOTOS','LINKS') AND (	 ( AI2.`CONTEXT_TYPE` = 'FRIENDS' AND AI2.`VERB` = 'ADD' ) OR ( AI2.`CONTEXT_TYPE` = 'STORY' AND AI2.`VERB` = 'CREATE' ) OR ( AI2.`CONTEXT_TYPE` = 'PHOTOS' AND AI2.`VERB` = 'SHARE' ) OR ( AI2.`CONTEXT_TYPE` = 'LINKS' AND AI2.`VERB` = 'CREATE' ) ) UNION SELECT A4.* FROM `M4GLB_SOCIAL_STREAM` AS A4 INNER JOIN `M4GLB_SOCIAL_FRIENDS` AS F1 ON A4.`ACTOR_ID` = F1.`TARGET_ID` AND F1.`ACTOR_ID` = '632' AND F1.`STATE` = '1' UNION SELECT A5.* FROM `M4GLB_SOCIAL_STREAM` AS A5 INNER JOIN `M4GLB_SOCIAL_FRIENDS` AS F2 ON A5.`ACTOR_ID` = F2.`ACTOR_ID` AND F2.`TARGET_ID` = '632' AND F2.`STATE` = '1' UNION SELECT A6.* FROM `M4GLB_SOCIAL_STREAM` AS A6 INNER JOIN `M4GLB_SOCIAL_STREAM_TAGS` AS ST ON A6.`ID` = ST.`STREAM_ID` WHERE ST.`UID` = '632' AND ST.`UTYPE` = 'USER') AS A LEFT JOIN `M4GLB_SOCIAL_LOCATIONS` AS L ON A.`LOCATION_ID` = L.`ID` LEFT JOIN `M4GLB_SOCIAL_MOODS` AS MD ON A.`MOOD_ID` = MD.`ID` INNER JOIN `M4GLB_USERS` AS UU ON A.`ACTOR_ID` = UU.`ID` AND UU.`BLOCK` = 0 WHERE ( (A.`CLUSTER_ID`= 0) OR (A.`CLUSTER_ID` > 0 AND A.`CLUSTER_ACCESS` = 1) OR (A.`CLUSTER_ID` > 0 AND A.`CLUSTER_ACCESS` > 1 AND 632 IN (SELECT SCN.`UID` FROM `M4GLB_SOCIAL_CLUSTERS_NODES` AS SCN WHERE SCN.`CLUSTER_ID` = A.`CLUSTER_ID` AND SCN.`TYPE` = 'USER' AND SCN.`STATE` = 1) ) ) AND A.`ACTOR_TYPE`='USER' AND ( (A.`ACCESS` = '0') OR ( (A.`ACCESS` = '10') AND (632 > 0 ) ) OR ( (A.`ACCESS` = '20') AND ( ES_HASMUTUALFRIEND( A.`ACTOR_ID`, 632) > 0 OR ES_ISFRIEND( A.`ACTOR_ID`, 632) > 0 ) ) OR ( (A.`ACCESS` = '20') AND ( ES_ISFRIEND( A.`ACTOR_ID`, 632) > 0 ) ) OR ( (A.`ACCESS` = '30') AND ( ES_ISFRIEND( A.`ACTOR_ID`, 632) > 0 ) ) OR ( (A.`ACCESS` = '40') AND ( A.`ACTOR_ID` = 632 ) ) OR ( (A.`ACCESS` = '100') AND ( A.`CUSTOM_ACCESS` LIKE '%,632,%' ) ) OR (A.`ACTOR_ID` = 632) ) AND NOT EXISTS ( SELECT H.`UID` FROM `M4GLB_SOCIAL_STREAM_HIDE` AS H WHERE A.`ID`= H.`UID` AND H.`USER_ID`='632' AND H.`TYPE`='STREAM' ) AND NOT EXISTS ( SELECT H1.`CONTEXT` FROM `M4GLB_SOCIAL_STREAM_HIDE` AS H1 WHERE A.`CONTEXT_TYPE` = H1.`CONTEXT` AND H1.`USER_ID`='632' AND H1.`UID` = '0' AND H1.`ACTOR_ID` = '0' ) AND NOT EXISTS ( SELECT H2.`ACTOR_ID` FROM `M4GLB_SOCIAL_STREAM_HIDE` AS H2 WHERE A.`ACTOR_ID`= H2.`ACTOR_ID` AND H2.`USER_ID`='632' AND H2.`UID` = '0' AND H2.`CONTEXT` IS NULL ) ORDER BY A.`MODIFIED` DESC LIMIT 0,10

OH MY GOSH! YOU FOUND IT!!!

Looks like the page you're trying to visit doesn't exist.

Please check the URL and try your luck again.

I tried uninstalling and reinstalling, repairing all databases using phpMyAdmin but this did not help.

Any suggestions here?

Jordan