So sieht meine Gästebuch-Tabelle aus: (Export aus PHPMyAdmin)
CREATE TABLE `cwe_phpwcms_guestbook` (
`guestbook_id` int(11) NOT NULL auto_increment,
`guestbook_cid` int(11) NOT NULL default '0',
`guestbook_msg` text NOT NULL,
`guestbook_name` text NOT NULL,
`guestbook_email` text NOT NULL,
`guestbook_created` varchar(14) NOT NULL default '',
`guestbook_trashed` int(1) NOT NULL default '0',
`guestbook_url` text NOT NULL,
`guestbook_show` int(1) NOT NULL default '0',
`guestbook_ip` varchar(20) NOT NULL default '',
`guestbook_useragent` varchar(50) NOT NULL default '',
PRIMARY KEY (`guestbook_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Das ist das verfügbare Database Update:
#####################################################
#
# PHPWCMS SQL Update
#
# 13.08.2004
#
#####################################################
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_show` INT( 1 ) NOT NULL ;
ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_url` `guestbook_url` TEXT NOT NULL ;
ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_email` `guestbook_email` TEXT NOT NULL ;
ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_name` `guestbook_name` TEXT NOT NULL ;
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_ip` VARCHAR( 20 ) NOT NULL ;
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_useragent` VARCHAR( 50 ) NOT NULL ;
Wenn ich das über upgrade.php ausführe erhalte ich folgende Fehler:
-- ERROR --
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_show` INT( 1 ) NOT NULL;ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_url` `guestbook_url` TEXT NOT NULL;ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_email` `guestbook_email` TEXT NOT NULL;ALTER TABLE `cwe_phpwcms_guestbook` CHANGE `guestbook_name` `guestbook_name` TEXT NOT NULL;
-- ERROR --
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_ip` VARCHAR( 20 ) NOT NULL;
-- ERROR --
ALTER TABLE `cwe_phpwcms_guestbook` ADD `guestbook_useragent` VARCHAR( 50 ) NOT NULL;
Eintrag inder config.inc.php:
$phpwcms["db_prepend"] = "cwe";
Muß ich noch was am template ändern?
Bin fast am heulen.
Wie gesagt, es ist eine komplette Neuinstallation. Es gab an dieser Stelle zuvor kein PHPWCMS.
Christoph