Login     Sign up
How to upgrade to 2.3?
dfcppnfounder (@dfcppnfounder)
Join date: May 8th 2010
Community posts: 50
View Profile
Send Message

How do I upgrade from 2.2 to 2.3? do I have to re-install?

179 months ago
foshechka (@foshechka)
Join date: May 6th 2010
Community posts: 18
View Profile
Send Message

[quote=dfcppnfounder]How do I upgrade from 2.2 to 2.3? do I have to re-install? [/quote]
Read this:
upgrade from 2.x

  1. copy/replace the following folders&files with the newest:
    includes/
    applications/
    files/applications/
    files/icons/rss.gif
    my/welcome_page.php
    my/welcome_page.jpg

  2. add this line to the end of your "/my/config.php":
    $optionalapps['events'] = array('uri'=>'events','manageuri'=>'','profileuri'=>'events/liststories/user','flag'=>'Events','des'=>'Allow your members to start events.');

  3. If you use default theme, open "themes/default/page.css", replace "#appleft" with "#appside".

  4. execute the following SQL query to the database where Jcow was installed:

CREATE TABLE IF NOT EXISTS jcow_reports (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
url varchar(255) NOT NULL,
message text NOT NULL,
hasread tinyint(1) NOT NULL,
created int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS jcow_messages_sent (
id int(11) NOT NULL auto_increment,
subject varchar(100) NOT NULL default '',
message text NOT NULL,
from_id int(11) NOT NULL default '0',
to_id int(11) NOT NULL default '0',
created int(11) NOT NULL default '0',
hasread tinyint(4) NOT NULL default '0',
PRIMARY KEY (id),
KEY from_id (from_id,to_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS jcow_liked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid),
KEY stream_id (stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

ALTER TABLE jcow_streams ADD hide TINYINT( 1 ) NOT NULL ,
ADD likes INT NOT NULL ;

ALTER TABLE jcow_profile_comments ADD stream_id INT NOT NULL ;

ALTER TABLE jcow_profile_comments ADD INDEX ( stream_id ) ;

ALTER TABLE jcow_comments ADD stream_id INT NOT NULL ;

ALTER TABLE jcow_comments ADD INDEX ( stream_id ) ;

179 months ago