Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Database error

10 years 11 months ago
Licenses:
JomSocial Expired

Attachment error.JPG not found


we were using jomsocial for our joomla 1.5 site and we upgrade our site to joomla 2.5, jomsocial was not compatible for our joomla 2.5 site so, we had bought jomsocial professional and tryed installing through iJoomla installer as guided in installation document after installation we are getting the following error
" 500 - An error has occurred.
DB function failed with error number 1054 <br /><span style="color: red;">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.`cover` as _cover , 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 `j25_community_users` as a LEFT JOIN `j25_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `j25_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='367'</span>"

Attachments:
10 years 11 months ago
Licenses:
JomSocial Expired GURU Expired Publisher Expired AdAgency Expired iSEO Expired Socialize Expired

Hi Rajasekar,
I am clue less here and need more explanation.
btw have you followed these steps for upgrading? documentation.jomsocial.com/wiki/Updatin...d_JomSocial_Versions
Thanks

10 years 11 months ago
Licenses:
JomSocial Expired

We were having jomsocial 2.2.2 in our joomla site 1.5 and we have upgraded our test site to 2.5.20 version. After the test site upgradation to joomla 2.5.20 we had bought jomsocial professional current version is 3.2.05 and we tryed to install this version of jomsocial and we are facing this database error. If we need to go step by step upgradation means from we will get the previous version of your component or how should we proceed further.

We have planned to move to production onece its working in test site

10 years 11 months ago
Licenses:
JomSocial Expired

Hi, we have fixed this issue. We have found solution in your forum and able to fix the same from below URLs.

www.jomsocial.com/forum/installation/15516-database-error
www.jomsocial.com/forum/installation/165...rading-need-solution

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW