This article is targeted at advanced JomSocial users who wish to know modified database tables for each major upgrade of JomSocial. You are expected to be familiar with MySQL, PHPMyAdmin and a bit of PHP.

All queries below assumes you are using jos_# database prefix.

JomSocial 2.6

/*Add events allday fields in events table*/
ALTER TABLE `jos_community_events` ADD `allday` TINYINT( 11 ) NOT NULL DEFAULT '0';

CREATE TABLE `jos_community_notifications` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`actor` INT( 11 ) NOT NULL ,
`target` INT( 11 ) NOT NULL ,
`content` TEXT NOT NULL ,
`type` VARCHAR( 200 ) NOT NULL,
`cmd_type` TEXT NOT NULL,
`status` TINYINT NOT NULL,
`created` DATETIME NOT NULL ,
`params` TEXT NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

/*FIle sharing */
CREATE TABLE IF NOT EXISTS `jos_community_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `groupid` int(11) NOT NULL,
  `discussionid` int(11) NOT NULL,
  `eventid` int(11) NOT NULL,
  `profileid` int(11) NOT NULL,
  `filepath` varchar(255) NOT NULL,
  `filesize` int(11) NOT NULL,
  `hits` int(11) NOT NULL,
  `storage` varchar(64) NOT NULL,
  `creator` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `jos_community_videos_tag` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`videoid` INT( 11 ) NOT NULL ,
`userid` INT( 11 ) NOT NULL ,
`position` TEXT NOT NULL ,
`created_by` INT( 11 ) NOT NULL ,
`created` datetime NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

/* event recurring */
ALTER TABLE `jos_community_events` ADD `repeat` VARCHAR( 50 ) DEFAULT NULL COMMENT 'null,daily,weekly,monthly';
ALTER TABLE `jos_community_events` ADD `repeatend` DATE NOT NULL;
ALTER TABLE `jos_community_events` ADD `parent` INT( 11 ) NOT NULL COMMENT 'parent for recurring event' AFTER `id`;

/* File bulletin id support */
ALTER TABLE `jos_community_files` ADD `bulletinid` INT NOT NULL AFTER `discussionid`;

/* lock profile in each profile */
ALTER TABLE  `jos_community_profiles` ADD  `profile_lock` TINYINT( 1 ) NULL DEFAULT  '0' AFTER  `create_events`;

/* Store the type of file uploaded */
ALTER TABLE `jos_community_files` ADD  `type` VARCHAR( 255 );


/* Add params field for group-discussion */
ALTER TABLE `jos_community_groups_discuss` ADD `params` TEXT NOT NULL;

/* Add params field for group-bulletin */
ALTER TABLE `jos_community_groups_bulletins` ADD `params` TEXT NOT NUL;

ALTER TABLE `jos_community_events`
ADD KEY `idx_catid` (`catid`),
ADD KEY `idx_published` (`published`);

ALTER TABLE `jos_community_notifications`
ADD KEY `created` (`created`),
ADD KEY `status` (`status`),
ADD KEY `type` (`type`),
ADD KEY `target` (`target`),
ADD KEY `actor` (`actor`);

Aw... Why would you uninstall JomSocial? :'(

Anyway, you can uninstall JomSocial via Joomla Extensions Manager area. 

Joomla! 1.5

Please go to Extensions > Install / Uninstall > Components. 

JomSocial is listed as 'jomSocial' or 'community'. Select the radio button located next to the entry and press Uninstall button.

Joomla! 1.6

Please go to Extensions > Extensions Manager > Manage > Select 'Components' in the dropdown.

JomSocial is listed as 'jomSocial' or 'community'. Select the radio button located next to the entry and press Uninstall button.

Complete Removal of JomSocial Database

All JomSocial database information are stored in jos_community_# tables. To completely delete this information, please use phpmyadmin > your.joomla.database > and mark all tables that start with jos_community_

After making sure that you have selected only jos_community_# tables, go to the end of the table listing, and Select 'DROP'. This will remove all JomSocial database information from your site.

Upgrading to JomSocial 2.6.x

Preparation

1. Before doing anything major to your site, always create a full site backup (files + database).
I personally recommend you to use this extension: Akeeba backup. You can learn more on creating a Joomla backup by reading this documentation.
2. If you find it a hassle to do a complete backup of all files, please at the very least have backups of:

• Database
  {root}/components/com_community
  {root}/administrator/components/com_community
  {root}/templates/mycurrentdirectory/html/com_community
  {root}/plugins/community

3. Make sure you are running at least PHP 5.2.6, Joomla 1.5.23, max_upload in php.ini is above 4Mb, and most importantly Joomla is running well (meaning regular installation of other extensions do work flawlessly). Read our system requirement here.
4. Go to Administration -> Help > System Info -> Directory Permission; make sure everything is Green.

Be assured that

1. Upgrading JomSocial will never delete community information that are stored in the database.
2. It will not interfere with non-JomSocial database tables
 

Be wary that

1. All template customizations that do not adhere to our template override instruction will be deleted. Automagically, no doubt about that.

2. All template overrides need to be updated. Otherwise you will have a crippled JomSocial with limited JomSocial 2.6 functionalities. We have provided Team Rockettheme, Team Joomlart, and Team Gavick with up-to-date versions of their popular JomSocial templates. Please consult your template developers for an update.

3. All modifications to any file in /components/com_community and /administrator/components/com_community will get deleted.

4. Third party extensions that rely on hacking JomSocial template/core code to work, would likely to fail after the upgrade. You will have to re-do the hacks (documenting your hacks for personal reference would always help you greatly in the future).

5. Always consult third-party developers for updated version of their plugins.

IMPORTANT

If you have participated in any Alpha/Beta/RC Beta version for 2.6, please run this query before proceeding with the installation / upgrade. You will only have to run this once.

ALTER TABLE jos_community_events
ADD KEY `idx_catid` (`catid`),
ADD KEY `idx_published` (`published`);


ALTER TABLE jos_community_notifications
ADD KEY `created` (`created`),
ADD KEY `status` (`status`),
ADD KEY `type` (`type`),
ADD KEY `target` (`target`),
ADD KEY `actor` (`actor`);

This is assuming your database prefix starts with jos_#. You might also want to view a list of all modified database table in JomSocial 2.6.

Starting the Upgrade

1. Uninstall older JomSocial version. To do so, please go to Extensions > Install/Uninstall, and select JomSocial/Community.
2. Install the latest JomSocial 2.6.
3. It is that simple. ;)
 

Official Modules & Applications

1. Install the latest version of modules/apps on top of the older version.
 

Third Party Modules & Applications

1. Please consult the developer for an updated version, if needed.

Translations

1. There are a lot of new and modified language strings. View the list here.

What to do if...

The installation fails at Zend Library stage. Manual installation of the library
 

Known upgrade errors...

There was an error uploading this file to the server.
Some shared servers limit the size of uploaded files at a mere 2Mb. JomSocial component exceeds this limit. You will have to increase two php.ini settings to be at least 4Mb. If you are not sure on how to do this, please consult your webhost for assistance.

upload_max_filesize = 4M  ; Maximum allowed size for uploaded files.
post_max_size = 4M ; Maximum size of POST data that PHP will accept.

"ERROR: Could not find an XML setup file in the package"
Make sure you have unpacked com_community_pro_unzip_first_2.6.0.zip before installing the package. You will see four files:
1. apps_unzip_first_version.zip
2. com_community_pro_version.zip (Use this file to install JomSocial)
3. modules_unzip_first_version.zip
4. ReadMe.txt.