CMS Mambo: Problemer med installation
Hej EksperterJeg er ved at installere Mambo på localhost.
Når jeg når til trin 2 får jeg en kilometer SQL-fejl.
SQL=BLOB/TEXT column 'comments' can't have a default value:
- - - - - - - - - -
# Table structure for table `mos_comment`
CREATE TABLE `mos_comment` (
`id` int(11) NOT NULL auto_increment,
`articleid` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`name` varchar(30) NOT NULL default '',
`comments` text NOT NULL default '',
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
= = = = = = = = = =
SQL=BLOB/TEXT column 'text' can't have a default value:
- - - - - - - - - -
# Table structure for table `mos_poll_data`
CREATE TABLE `mos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL default '',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
# Dumping data for table `mos_poll_data`
INSERT INTO `mos_poll_data` VALUES (20, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (19, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (18, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (17, 15, 'Scott Adams', 1)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (16, 15, 'Tim Berners-Lee', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (15, 15, 'Linus Torvalds', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (14, 15, 'Bill Gates', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (13, 15, 'Steve Jobs', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (21, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (22, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (23, 15, '', 0)
= = = = = = = = = =
SQL=Table 'mambo.mos_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mos_poll_data` VALUES (24, 15, '', 0)
= = = = = = = = = =
Mon insert-fejl er afledt af de 2 første?
SQL=BLOB/TEXT column 'comments' can't have a default value:
SQL=BLOB/TEXT column 'text' can't have a default value:
Alle de tabeller som får fejlen:
SQL=Table 'mambo.mos_xxx' doesn't exist
Eksisterer faktisk.
Har nogen et forslag til hvordan problemet løses?
Mvh Christian
