Database upgrade
Posted: Thu 27. May 2004, 22:01
I installed release 1.1-RC4 22-05-2004 (from 01-05-2004 version) by overwriting all standard files. Do I also need to update the database? I tried the mysite/setup/upgrade.php file, but when run, the following message appears:
What is it I need to do? I don't know anything about sql....ERROR:
#
ALTER TABLE `phpwcms_articlecat` ADD `acat_redirect` VARCHAR( 255 ) NOT NULL;
ERROR:
CREATE TABLE `phpwcms_bid` (
`bid_id` int(11) NOT NULL auto_increment,
`bid_cid` int(11) NOT NULL default '0',
`bid_email` text NOT NULL,
`bid_hash` varchar(255) NOT NULL default '',
`bid_amount` float NOT NULL default '0',
`bid_created` timestamp(14) NOT NULL,
`bid_verified` int(1) NOT NULL default '0',
`bid_trashed` int(1) NOT NULL default '0',
`bid_vars` mediumblob NOT NULL,
PRIMARY KEY (`bid_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;