Login     Sign up
Upgrading from 4.2 - 5.0? You need this!
Shawn Lyte (@bmfsports)
Join date: Mar 5th 2011
Community posts: 61
View Profile
Send Message

This was not in the download of 5.0, but I received it today from an admin.

[quote]** upgrade from 4.2.x to 5.0 ***
Step.1
Excute the following SQL queries:
ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

CREATE TABLE IF NOT EXISTS jcow_footer_pages (
id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL,
link_name varchar(255) NOT NULL,
content text NOT NULL,
weight int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;[/quote]

I can't get my phpMyAdmin to accept this update, so any help would be appreciated. GREATLY appreciated!

161 months ago
Jcow Master (@falcone)
Join date: Sep 2nd 2010
Community posts: 917
View Profile
Send Message

what error do you have ?

161 months ago
Shawn Lyte (@bmfsports)
Join date: Mar 5th 2011
Community posts: 61
View Profile
Send Message

I got a slew of different errors at different times. I got tired of it all, so I just alerted my members that I would just tear down and build anew instead of updating. The fresh install took about 10 seconds and is flawless.

161 months ago