Hello,
I installed the lastest version of Mambo successfully in my hosting.
But when i install mambo in my PC. THEN ERROR
I think it's becuz my mySQL. But if you know, please let me know.
Below is my description
*** pre-installation check ***
PHP version >= 4.1.0 Yes
- zlib compression support Available
- XML support Available
- MySQL support Available
configuration.php Writeable
Session save path Not set, Unwriteable
Error log:
The error log is so long.... I just show some main error
SQL=Invalid default value for 'rating_sum':
- - - - - - - - - -
# Table structure for table `mos_content_rating`
CREATE TABLE `mos_content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) TYPE=MyISAM
= = = = = = =
Error when installing Mambo portal :: SQL=Specified key was too long; max key length is 1000 bytes:?
Hello,
Looks like you need to add a 0 to the end of the rating_sum row and the script will execute. So edit the mambo.sql file located in the SQL folder by adding a 0 at the end of the rating_sum row see below:
`rating_sum` int(11) unsigned NOT NULL default '',
to
`rating_sum` int(11) unsigned NOT NULL default '0',
I think your local MySQL install is being picky.
Try it out and let me know, if that works.
Thanks,
V
Error when installing Mambo portal :: SQL=Specified key was too long; max key length is 1000 bytes:?
i think u should provide a value for default
in rating sum
