Package: mambo
Version: 4.5.1.3-2
Severity: important
Please, excuse my horrible english.
An Invalid default value in Table structure for table
`mos_content_rating`, prevents mambo.mos_content_rating creation
table.
The complete SQL Query is
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 ;
MySQL report this error messagen when try execute query
#1067 - Invalid default value for 'rating_sum'
To solve this problem, you need change line
`rating_sum` int( 11 ) unsigned NOT NULL default '',
for
`rating_sum` int( 11 ) unsigned NOT NULL default '0',
I include an attached file with diff patch
Regards,
Esteban
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (990, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14.5
Locale: LANG=es_AR, LC_CTYPE=es_AR (charmap=ISO-8859-1)
Versions of packages mambo depends on:
ii apache2-mpm-prefork [httpd] 2.0.55-4 traditional model for Apache2
ii debconf [debconf-2.0] 1.4.70 Debian configuration management sy
ii php4 4:4.4.2-1 server-side, HTML-embedded scripti
ii php4-mysql 4:4.4.2-1 MySQL module for php4
ii wget 1.10.2-1 retrieves files from the web
ii wwwconfig-common 0.0.44 Debian web auto configuration
mambo recommends no packages.
-- debconf information excluded
--
Social Engineer > Because there is no patch for human stupidity...
276c276
< `rating_sum` int(11) unsigned NOT NULL default '',
---
> `rating_sum` int(11) unsigned NOT NULL default '0',
