Hi Christian,

Do you smiliar with phpmyadmin and mysql query? since you was using old jomsocial version you need follow this DB patch step by step www.dropbox.com/sh/zln48nosnc25l1l/AAAUw...XUBwmenUeDspnIa?dl=0

thank you

Honestly said am I not particularly firm with mysql queries.

You told me in your post from 15th of july: [...You can do the upgrading directly, just skip step by step upgrading.. do to the latest version from now, and if you found some issue regarding database error, just let me know, I will update the database manually then...].

That's what I did. And I could fix some db errors by myself (e.g. with: "ALTER TABLE `jos_community_files` ADD `groupid` INT(11) NOT NULL;).

The new (migrated) site is now online and working almost fine - except a couple of missing db entries (e.g. discuss stream). Can you eventually fix this for me as mentioned? That would be fine...

Thanks in advance
and regards

Hi Christian,

I just created new discussion and seems working fine, please check it www.wahl-verwandtschaft.de/joomla_3_3/in...iscussion?groupid=10

thank you!

Hi, we still have to fight with some troubles concerning data base table entries. Now old users didn't get notifications for new posts, group entries, e.g. - and we should fix this problem asap, because the site is online! This problem only occurs at old user. With new ones, everything is fine. So I had a look at the tables, e.g. "jos_community_users" column "params":

example of an "old" (migrated) user: {"notifyEmailSystem":"0","privacyProfileView":"20","privacyPhotoView":"20","privacyFriendsView":"20","privacyVideoView":"20","notifyEmailMessage":1,"notifyEmailApps":0,"notifyWallComment":0,"daylightsavingoffset":"0","postFacebookStatus":1,"group_activity_5":"747","group_activity_7":"745","lastnotificationlist":"2014-09-15 21:31:01","group_activity_1":"747"}

example of a new user (registered after our migration):
{"notifyEmailSystem":1,"privacyProfileView":20,"privacyPhotoView":20,"privacyFriendsView":20,"privacyGroupsView":20,"privacyVideoView":20,"notifyEmailMessage":1,"notifyEmailApps":0,"notifyWallComment":0,"notif_groups_notify_admin":1,"etype_groups_notify_admin":1,"notif_user_profile_delete":1,"etype_user_profile_delete":1,"notif_system_reports_threshold":1,"etype_system_reports_threshold":1,"notif_profile_activity_add_comment":1,"etype_profile_activity_add_comment":1,"notif_profile_activity_reply_comment":1,"etype_profile_activity_reply_comment":1,"notif_profile_status_update":1,"etype_profile_status_update":1,"notif_profile_like":1,"etype_profile_like":1,"notif_profile_stream_like":1,"etype_profile_stream_like":1,"notif_friends_request_connection":1,"etype_friends_request_connection":1,"notif_friends_create_connection":1,"etype_friends_create_connection":1,"notif_inbox_create_message":1,"etype_inbox_create_message":1,"notif_groups_invite":1,"etype_groups_invite":1,"notif_groups_discussion_reply":1,"etype_groups_discussion_reply":1,"notif_groups_wall_create":1,"etype_groups_wall_create":1,"notif_groups_create_discussion":1,"etype_groups_create_discussion":1,"notif_groups_create_news":1,"etype_groups_create_news":1,"notif_groups_create_album":1,"etype_groups_create_album":1,"notif_groups_create_video":1,"etype_groups_create_video":1,"notif_groups_create_event":1,"etype_groups_create_event":1,"notif_groups_sendmail":1,"etype_groups_sendmail":1,"notif_groups_member_approved":1,"etype_groups_member_approved":1,"notif_groups_member_join":1,"etype_groups_member_join":1,"notif_groups_notify_creator":1,"etype_groups_notify_creator":1,"notif_groups_discussion_newfile":1,"etype_groups_discussion_newfile":1,"notif_groups_activity_add_comment":0,"etype_groups_activity_add_comment":0,"notif_events_notify_admin":1,"etype_events_notify_admin":1,"notif_events_invite":1,"etype_events_invite":1,"notif_events_invitation_approved":1,"etype_events_invitation_approved":1,"notif_events_sendmail":1,"etype_events_sendmail":1,"notif_event_notify_creator":0,"etype_event_notify_creator":0,"notif_event_join_request":1,"etype_event_join_request":1,"notif_events_activity_add_comment":0,"etype_events_activity_add_comment":0,"notif_photos_submit_wall":1,"etype_photos_submit_wall":1,"notif_photos_reply_wall":1,"etype_photos_reply_wall":1,"notif_photos_tagging":1,"etype_photos_tagging":1,"notif_photos_like":1,"etype_photos_like":1,"notif_system_messaging":1,"etype_system_messaging":1,"postFacebookStatus":1,"coverPosition":"0%","group_activity_2":"739","lastnotificationlist":"2014-09-15 05:29:20"}

How can I reproduce or add all this values to all the old (migrated) users? Thanks for your quick answer/help

Hi Cristian,

Please you look at this patch files www.dropbox.com/sh/zln48nosnc25l1l/AAAUw...XUBwmenUeDspnIa?dl=0 , what you need is you apply the sql one by one for each version.. it will solve your database issue stucture in newest version.

thank you