Hello Wendell,

I am really sorry for the delay of this reply as it is a weekend for us here. Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?

Yes how do you want me to send it?

Hello Wendell,

I am really sorry for the delay of this reply as it is a weekend for us here. You can include the site's access and ftp access under the "Site Details" tab in the form below.

I had my hosting company issue the command:
mysql_upgrade -u root -p

And I tried to do the install again and it still failed.

I am also still getting the error on the following page:

http://littlepeepersohio.org/index.php/community

if you need to contact my hoster, his name is jeff and his email is jeffkoch@wpcomp.com

Please help.
Thanks,
Wendell

hello Wendell Payne,

Sorry for late reply to this,
If your webhosting run this sql query getting the empty result

mysql_upgrade -u root -p

then run the copy below sql statement and execute.

DELIMITER $$

CREATE FUNCTION `es_isfriend` (p_source int, p_target int)

	RETURNS INT DETERMINISTIC

BEGIN

	DECLARE cnt INT;

	select count(1) into cnt from `jos_social_friends` where ( actor_id = p_source and target_id = p_target) OR (target_id = p_source and actor_id = p_target) and state = 1;

	RETURN cnt;

END

$$

DELIMITER ;

If you get 'You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)',
this mean the db user do not have privilege to create stored function.

So you have to request with your Webhosting provider to grant the create function privilege and execute function privilege for the database user.
Reference link : http://dev.mysql.com/doc/refman/5.0/en/stored-routines-privileges.html

ok we upgraded MYSQL to latest and greatest and issued the commands and got passed the initial error.

now I am getting the message in attached image and copied below

Executing maintenance scripts Success
◦2 scripts to execute.
◦Executed script: Sync cluster access in stream table.
◦execute command denied to user 'sbnlpo'@'%' for routine 'lpojmdb.es_itemcustomaccess' SQL=update `oq5ec_social_stream` as a inner join `oq5ec_social_stream_item` as b on a.`id` = b.`uid` inner join `oq5ec_social_privacy_items` as c on c.`uid` = b.`uid` and c.`type` = 'story' set a.`access` = c.`value`, a.`privacy_id` = c.`privacy_id`, a.`custom_access` = es_itemcustomaccess(c.`privacy_id`, b.`actor_id`, b.`uid`, b.`context_type`, c.`value`) where a.`privacy_id` = 0
◦Updated maintenance version.

looks like its working. I had to download the 1.19 launcher and now things are fine.
Thanks

Hello Wendell,

I am really sorry for the delay of this reply as it is a weekend for us here. Thanks for updating and glad that your issues are resolved now