Musicity : Error 500 after installing Jomsocial

Ciao,

I'm trying to have the Musicity Demo template working on my laptop.

I have followed the steps:

- Installation of gk_musicity_quickstart_J!25
- Installation of JomSocial 2.8.1
- folder gk_style moved
- MGK JomSocial Members & GK JomSocial Stats published

Now I'm experiencing the error 500. It seems that something is missing in the quickstart package.

The details of the error are:
500
DB function failed with error number 1054
Unknown column 'a.events' in 'field list' SQL=SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `qzprs_community_users` as a LEFT JOIN `qzprs_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `qzprs_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='372'

Any help?

Thanks in advance
Giuseppe

Hi, error 500 --> It looks like JomSocial problem ! Ask JS Support
... also read here: http://forum.joomla.org/viewtopic.php?p=178862


Try:
Delete Joomla installation, all files.
And install gavick quickstart again (new prefix) - check website.
Download JomSocial 2.8.4(!) - install component - check website.
Now copy our template for JomSocial - check website.
Install plugins for JomSocial - check website.

I am having the same problem as described below.

The problem is not from Jomsocial, (I have installed JS 2.8.4).

On the front page if the GK_JS modules are disabled it doesn't have any problem. Once they are enabled I get the same error.

I have used the quickstart files for musicity installation. And once it is installed I see that you have inserted already the jomsocial tables. The tables from which JS version are they?

This has to do with the installation that you have made for quickstart.

well for an unknown reason the jomsocial installation didn't create the tables as it should do.
As a result there were missing entries on the community_users table and community_activities table.

I have manually fixed it and it's working.

Unfortunately, sometimes Jomsocial have a strange, unpredictable behavior. That's why they hire new person to check quality of code.

Hi vasite, can you please explain how you fixed it, i am not good with phpmyadmin and could use some guidance on exactly what you did step by step. (i can follow along well)
I am having the same issue.
thank you!

well for an unknown reason the jomsocial installation didn't create the tables as it should do.
As a result there were missing entries on the community_users table and community_activities table.

I have manually fixed it and it's working.

Ok so i figured out how to fix this error:

I'll explain:
1. log into your cPanel (hosting side)
2. Run phpmyadmin
3. Select your database (Left Side) See video below if you feel lost...
4. At the top, click SQL
and run this command line

Code: Select all

UPDATE `xxx_assets` SET `parent_id` =  '1' WHERE `parent_id` =  '0' AND `id` != 1;

NOTE: replace the xxx with your databases prefix of course.
For the noobs like me, here is a short video on how to run the command line: http://www.youtube.com/watch?v=3oHdwkGfyL4

So all assets with no parent (except the aset with id=1) are fixed.
Also, the extension "ACL Manager" should also be executed after an upgrade (in case you own it), so many fixes to be done !

Hi,

that didn`t work... any ideas?

PHP Version 5.3.23
Joomla! 2.5.11
JS 2.8.4.1