Error when upgrading to new version of Social Groups

lesliedow

Member
Hi
We got this error when upgrading to the new version of Social Groups (from 1.0.6 to 2.1.0)
I'm running XF v2.10

XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_tl_group.avatar_attachment_id' in 'on clause' in src/XF/Db/AbstractStatement.php at line 217
 

lesliedow

Member
Well now I have done it. It turns out the issue was the PHP version was too low. When PHP is upgraded to 7.2 the upgrade is mostly OK, the issue now is that the upgrade mode apparently overwrote all the group information.

The groups are there, I can see them and the users, and I suspect the rest is as well but the content is not viewable. And yes, I did ignore the warning that said it would overwrite files, I expected that meant the addon data, not user data!

Is this data retrievable?
 

lesliedow

Member
The upgrade overwrote all the content. Where we had cover images and posts now is blank. So my users lost all their content, unless it still exists in the database and there is a way to connect it with the social group
 

lesliedow

Member
It looks like all the content is in the database, but when I run the upgrade the addon does not find it. Does that help?
 

Truonglv

Staff member
Tech Support
What is previous version before you are upgrade to latest? I version from (XF 1.5) so that still in your database with other prefix xf_team* tables. And files also existing.
 

lesliedow

Member
So are you saying that the Team prefix is from the v1.x version? I do have those tables in the db but some of the content looks like it is after I upgraded to 2.x
 

Truonglv

Staff member
Tech Support
In XF2 version are prefixed by: xf_tl_group
Also did you do import after upgrade?
 
View previous replies…
Top