[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
-
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
-
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.');
-
If you use default theme, open "themes/default/page.css", replace "#appleft" with "#appside".
- 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 ) ; |