By LAC Webadmin on Saturday, 28 October 2017
Posted in Technical Issues
Replies 10
Likes 0
Views 644
Votes 0
I am getting this error after update to v2.1.2:

404

The requested page can't be found.
An error has occurred while processing your request.
1054: Unknown column 'a.container' in 'where clause'

You can check in my Test site.

Thanks,

Jackson
Was this an upgrade from an RC / beta? Could you try running the following SQL query?

[gist]
ALTER TABLE `#__social_clusters_categories` ADD `container` tinyint(3) NOT NULL DEFAULT 0;
[/gist]
·
Saturday, 28 October 2017 01:43
·
0 Likes
·
0 Votes
·
0 Comments
·
By the way, if you see errors from the template override files, well it is not. I also tried it in my staging where I disabled my template override and I'm seeing the same error.
·
Saturday, 28 October 2017 01:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

Yes, my setup was upgraded from v.2.1.x RC/Beta.

The SQL patch worked.

Thanks!

Jackson
·
Saturday, 28 October 2017 01:56
·
0 Likes
·
0 Votes
·
0 Comments
·
Ah okay, got it. That explained why you hit these errors. Most users who don't update through the beta / rc, would be fine.
·
Saturday, 28 October 2017 02:17
·
0 Likes
·
0 Votes
·
0 Comments
·
What is the best course of upgrading Mark? Should I uninstall EasySocial first then install a fresh one so I won't have these issues? Since there are other issues as well for language and json file that were not deleted or updated by running the full installer or launcher.
·
Saturday, 28 October 2017 02:53
·
0 Likes
·
0 Votes
·
0 Comments
·
I updated from 2.1.1 and also got this error but before that the site was using the beta.

the SQL does resolve it but to clarify for others mark has an extra _ in there after the hashtag and you need to change your prefix to whatever you are using from the hashtag i.e. "prfx_social_clusters_categories"


ALTER TABLE `#_social_clusters_categories` ADD `container` tinyint(3) NOT NULL DEFAULT 0;
·
Saturday, 28 October 2017 04:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, remember to replace:

#__

with your table prefix

<prefix>_social_clusters_categories
·
Saturday, 28 October 2017 06:03
·
0 Likes
·
0 Votes
·
0 Comments
·
This problem only happens if you are upgrading from a beta release. If you are upgrading from a prior release, 2.0.x or 1.4.x, you will not face such problems.
·
Saturday, 28 October 2017 10:27
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post