Hi Loic,

I am sorry for the delay of this reply.

Regarding your issue, when I attempt to upgrade your EasySocial to 2.0.2, i keep getting error connecting to your MySQL server. In fact, most of the operations that involved database will failed

Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.

I also getting this error sometime. http://screen.stackideas.com/Installation_-_Step_4_2016-11-03_13-29-09.png

It seems like your server is kinda unstable.

Anyway, can you provide me your phpMyAdmin access so that I can manually run the require sql statement for your EasySocial 2.0.2?

Please advise.

Hello sam,
thanks for your help
find phpmyadmin access in site details

Loïc

Hi Loic,

I am sorry for the delay of this reply and thanks for the phpmyadmin access. It seems like even when working on phpmyadmin, i still encounter connection timeout issue

Anyway, after many times trying, I've successfully install EasySocial 2.0.2 on your site by manually executing all the sql statement.

http://take.ms/jZXki

If you login to EasySocial backend, you will notice a notice error on EasyBlog blog app. You will need to update your blog app

By the way, I cant seem to be able to access to your site frontend. I keep getting connection error:

Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.

Please advise.

Hello
Thanks for your help
In frontend (Dashboard page) sometime i have this error :
ERREUR: 0

SQL=SELECT COUNT(1) FROM (select * from ( select a.* , (select pri.value as `access` from `#__social_privacy_items` as pri left join `#__social_privacy_customize` as prc on pri.id = prc.uid and prc.utype = 'item' where pri.uid = a.id and pri.`type` = 'videos' UNION ALL select prm.value as `access` from `#__social_privacy_map` as prm inner join `#__social_privacy` as pp on prm.privacy_id = pp.id left join `#__social_privacy_customize` as prc on prm.id = prc.uid and prc.utype = 'user' where prm.uid = a.user_id and prm.utype = 'user' and pp.type = 'videos' and pp.rule = 'view' union all select prm.value as `access` from `#__social_privacy_map` as prm inner join `#__social_privacy` as pp on prm.privacy_id = pp.id inner join `#__social_profiles_maps` pmp on prm.uid = pmp.profile_id where prm.utype = 'profiles' and pmp.user_id = a.user_id and pp.type = 'videos' and pp.rule = 'view' limit 1) as access, (select concat(',', group_concat(prc.user_id SEPARATOR ','), ',') as `custom_access` from `#__social_privacy_items` as pri left join `#__social_privacy_customize` as prc on pri.id = prc.uid and prc.utype = 'item' where pri.uid = a.id and pri.`type` = 'videos' UNION ALL select concat(',', group_concat(prc.user_id SEPARATOR ','), ',') as `custom_access` from `#__social_privacy_map` as prm inner join `#__social_privacy` as pp on prm.privacy_id = pp.id left join `#__social_privacy_customize` as prc on prm.id = prc.uid and prc.utype = 'user' where prm.uid = a.user_id and prm.utype = 'user' and pp.type = 'videos' and pp.rule = 'view' limit 1) as custom_access from `#__social_videos` as a where a.`state` = '1' and a.`type` = 'user' order by a.hits desc ) as x WHERE ( (x.`access` = '0') OR ( (x.`access` = '10') AND (0 > 0 ) ) OR ( (x.`access` = '30') AND ( (select count(1) from `#__social_friends` where ( `actor_id` = x.`user_id` and `target_id` = 0) OR (`target_id` = x.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (x.`access` = '40') AND ( x.`user_id` = 0 ) ) OR ( (x.`access` = '100') AND ( x.`custom_access` LIKE '%,0,%' ) ) OR (x.`user_id` = 0) )) AS zcount


Loic

Maybe i have to clear CDN also. I will.

Loic, I believe there is something really wrong with your hosting provider's end, http://take.ms/3PhZk

Sam also did mentioned that the entire site is extremely slow and to be honest, I really think you should consider switching to a proper web host.

hello,

i am afraid to move hosting because of the big sql queries i will need to run and the possible trouble i'll have to solve

can you recommend me one ?

the problem appear when i have tried to upgrade :
http://screencast.com/t/SWTpEqsPZhaY

Loïc

Hi Loic,

I am sorry for the delay of this reply.

Regarding your issue, after further investigate on your site, look like the sql for privacy checking on the video listing causing the error from your database server.

I've added a temporary fix to disable the video privacy during video listing. Below is the file I've modified.

JOOMLA/easysocial/administrator/components/com_easysocial/models/videos.php

Now your EasySocial 2.0 should work correctly.

i am afraid to move hosting because of the big sql queries i will need to run and the possible trouble i'll have to solve
can you recommend me one ?

You can try this web hosting company Inmotion as they are specialist in hosting Joomla web applications.
https://stackideas.com/inmotion-webhosting


Hope this help and have a nice day!

Thanks you sam,

it is working much better

Backend is ok and i don't have troubles with any components except ES users page (others ES pages seems ok)
http://www.rando-trekking.com/administrator/index.php?option=com_easysocial&view=users

also in frontend it's working as long as i am not connected !!
when connected i have long sql queries...

maybe something is still wrong with users database or privacy something ??

Loïc

I am investigating further on to move my hosting
I am also looking for an hosting with a datacenter in EU (my users are from france)

Hi Loic,

I am sorry for the delay of this reply.

Regarding your issue, I login to your phpmyadmin and run the optimize command on the users table and privacy tables. When i attempt to login to your site, i now getting this error: http://take.ms/zs1Xvx

Is your site now under maintenance? Please advise.

Hello sam,
thanks again for trying

site is not under maintenance ; is "alive" in EU
it could be a problem of CDN ; Datacenter is in Paris and i have cleaned CDN... maybe one in asia is not so clean...

anyway, i'll change my hosting tomorrow
As it is week-end for you, i'll put my site down and do the change...
I'll contact you again on monday morning

i am afraid there is something still wrong with SQL Queries and when i'll move from one hosting to the other, i'll also move the problem (something went wrong during ES 1.4 -> 2 -> 1.4 -> 2 again...)

Loïc

Hello loic,

Great, perhaps it would be advisable that you also start a new thread since I am leaning to believe that with your new hosting provider, everything should be great again

By the way, which hosting are you moving to and which hosting are you currently using (so that we can keep an eye about this hoster in case another customer is using their services) ?

Hello

I'll move from OVH to InMotion Hosting

Loic

Hello;

hosting change is done ; still have issues
I have created a new topic :
https://stackideas.com/forums/errors-pages-sql-after-upgrade-to-es-2

Loïc

Thanks, we'll reply you on your other thread