By Athanasios Zisopoulos on Friday, 13 July 2018
Posted in Technical Issues
Likes 0
Views 711
Votes 0
hi My easysocial site is a migration of joomla 1.5 and all imported users have timezone to utc 100% from Greece is there a way to change their time to Europe/Athens as default option via mysql? If i leave it Utc will i have any problems with this users when they post in activity streams or easydiscuss posts?
Hey,

Hm, Joomla actually stores their timezone in the #__users.`params` column. I am not sure if this could work but please please please do test it on a staging or replica of your database,



UPDATE #__users SET `params` = REPLACE(`params`, '"UTC"', '"YOURTIMEZONEVALUE"');
·
Friday, 13 July 2018 20:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Only new users affected all my old users dont have the parameter in jos_users !!! is there a synchronization tool to do it? I had this option as required and i thing some users could not connect i dont know if this was the issue but i know that when i disabled age and timezone users could connect again at list 2 off them who emailed me that they could not log in i just want to know if this is necessary or not if not we must not bother then ...i just mention it because i found it strange.
·
Saturday, 14 July 2018 00:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

I think i still not understand your current issue, do you mean when the new user register in your site under Easysocial registration form, it doesn't store this timezone value from this table (jos_users) as what their selected from the Timezone field during registration?
·
Saturday, 14 July 2018 10:46
·
0 Likes
·
0 Votes
·
0 Comments
·
new users have the parameters but near 10000 are imported from joomla 1.5 and i all of them dont have the timezone parameters in ...and i want to know if this will cause any issues my version is a migrate from kunena 1.7 upgradet to 5.
·
Saturday, 14 July 2018 11:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks!
·
Saturday, 14 July 2018 11:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Athanasios,

I am really sorry for the delay of this reply as it is a weekend for us here. I don't think it would be a problem if the users doesn't have those values because it will then fallback to what the site uses for it's timezone.
·
Saturday, 14 July 2018 13:47
·
0 Likes
·
0 Votes
·
0 Comments
·
ok thanks!
·
Saturday, 14 July 2018 18:47
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding
·
Saturday, 14 July 2018 22:56
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post