Bonjour,

J'essaye d'installer le module RSS Center mais je reçois cette erreur

Impossible d'installer rssc. Erreur(s) :
Installation RSS Center

BLOB 'link' ne peut avoir de valeur par d�faut

Je suis sur Xoops 2.3.3

même lorsque j'essaye d'installer le module XHLD0, je reçois la même erreur.

J'ai activé le mode debug et on me signale o erreur.
d'où peut provenir le problème??

Merci

Ça vient du versions plus récentes MySQL.
Éditez /sql/mysql.sql et enlever les clauses default xxx avec les définitions blob.

Merci Ghia pour ta réponse,

Je ne vois pas comment changer cette configuration de MySQL, j'ai EasyPHP 3 avec MySQL 5.1.30 et PHP 5.2.8

Merci

Il ne faut pas éditer la configuration mySQL, mais /sql/mysql.sql qui ce trouve dans le dossier du module .

Salut Ghia

voici la Base de données de RSS Center

# $Id: rssc.sql,v 1.15 2009/03/13 20:12:42 ohwada Exp $

# 2009-03-14 K.OHWADA
# change INSERT

# 2009-02-20 K.OHWADA
# gicon_id in link table
# geo_lat in feed table

# 2008-02-24 K.OHWADA
# change varchar to text (64KB)
# link in feed

# 2008-01-20 K.OHWADA
# add field post_plugin in link
# change attribute censor plugin in link

# 2007-11-26 K.OHWADA
# BLOB and TEXT columns cannot have DEFAULT values.

# 2007-11-01 K.OHWADA
# add field enclosure censor plugin in link
# add field cache ctime in black, white

# 2007-06-01 K.OHWADA
# add table xml, word
# add field act in feed
# add field act reg count in black, white

# 2006-09-01 K.OHWADA
# add conf_valuetype

# 2006-07-08 K.OHWADA
# corresponding to podcast

# =========================================================
# RSS Center Module
# 2006-01-01 K.OHWADA
# =========================================================

#
# Table structure for table `rssc_config`
# modify from system `config`
#

CREATE TABLE rssc_config (
id smallint(5) unsigned NOT NULL auto_increment,
conf_id smallint(5) unsigned NOT NULL default 0,
conf_name varchar(255) NOT NULL default '',
conf_valuetype varchar(255) NOT NULL default '',
conf_value text NOT NULL,
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
PRIMARY KEY (id),
KEY conf_id (conf_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_link`
#

CREATE TABLE rssc_link (
lid int(11) unsigned NOT NULL auto_increment,
uid int(11) unsigned default '0',
mid int(11) unsigned default '0',
p1 int(11) unsigned default '0',
p2 int(11) unsigned default '0',
p3 int(11) unsigned default '0',
title varchar(255) default '',
url varchar(255) NOT NULL default '',
ltype tinyint(2) unsigned default '0',
refresh mediumint(8) unsigned default '3600',
headline mediumint(8) unsigned default '0',
mode tinyint(3) default '0',
rdf_url varchar(255) default '',
rss_url varchar(255) default '',
atom_url varchar(255) default '',
encoding varchar(15) default '',
updated_unix int(10) default'0',
channel text NOT NULL,
xml mediumtext NOT NULL,
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
enclosure tinyint(2) default '1',
censor text NOT NULL,
plugin text NOT NULL,
post_plugin text NOT NULL,
icon varchar(255) default '',
gicon_id int(10) default'0',
PRIMARY KEY (lid),
KEY mid (mid),
KEY p (p1, p2, p3)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_xml`
#

CREATE TABLE rssc_xml (
xid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned default '0',
xml mediumtext NOT NULL,
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
PRIMARY KEY (xid),
KEY lid (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_feed`
#

CREATE TABLE rssc_feed (
fid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned NOT NULL default '0',
uid int(11) unsigned default '0',
mid int(11) unsigned default '0',
p1 int(11) unsigned default '0',
p2 int(11) unsigned default '0',
p3 int(11) unsigned default '0',
site_title varchar(255) default '',
site_link varchar(255) default '',
title varchar(255) NOT NULL default '',
link text default '',
entry_id varchar(255) default '',
guid varchar(255) default '',
updated_unix int(10) default '0',
published_unix int(10) default '0',
category varchar(255) default '',
author_name varchar(255) default '',
author_uri varchar(255) default '',
author_email varchar(255) default '',
type_cont varchar(255) default '',
raws text NOT NULL,
content text NOT NULL,
search text NOT NULL,
enclosure_url varchar(255) default '',
enclosure_type varchar(255) default '',
enclosure_length int(5) default '0',
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
act tinyint(1) default '1',
geo_lat double(10,8) NOT NULL default '0',
geo_long double(11,8) NOT NULL default '0',
media_content_url varchar(255) default '',
media_content_type varchar(255) default '',
media_content_medium varchar(255) default '',
media_content_filesize int(10) default '0',
media_content_width int(10) default '0',
media_content_height int(10) default '0',
media_thumbnail_url varchar(255) default '',
media_thumbnail_width int(10) default '0',
media_thumbnail_height int(10) default '0',
PRIMARY KEY (fid),
KEY lid (lid),
KEY mid (mid),
KEY p (p1, p2, p3),
KEY link (link(10)),
KEY updated (updated_unix),
KEY published (published_unix)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_black`
#

CREATE TABLE rssc_black (
bid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned default '0',
uid int(11) unsigned default '0',
mid int(11) unsigned default '0',
p1 int(11) unsigned default '0',
p2 int(11) unsigned default '0',
p3 int(11) unsigned default '0',
title varchar(255) default '',
url varchar(255) NOT NULL default '',
memo text NOT NULL,
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
act tinyint(1) default '1',
reg tinyint(1) default '0',
count int(11) unsigned default '0',
cache int(11) unsigned default '0',
ctime int(11) unsigned default '0',
PRIMARY KEY (bid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_white`
#

CREATE TABLE rssc_white (
wid int(11) unsigned NOT NULL auto_increment,
lid int(11) unsigned default '0',
uid int(11) unsigned default '0',
mid int(11) unsigned default '0',
p1 int(11) unsigned default '0',
p2 int(11) unsigned default '0',
p3 int(11) unsigned default '0',
title varchar(255) default '',
url varchar(255) NOT NULL default '',
memo text NOT NULL,
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
act tinyint(1) default '1',
reg tinyint(1) default '0',
count int(11) unsigned default '0',
cache int(11) unsigned default '0',
ctime int(11) unsigned default '0',
PRIMARY KEY (wid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `rssc_word`
#

CREATE TABLE rssc_word (
sid int(11) unsigned NOT NULL auto_increment,
word varchar(255) default '',
reg tinyint(1) default '0',
point int(11) unsigned default '0',
count int(11) unsigned default '0',
aux_int_1 int(5) default '0',
aux_int_2 int(5) default '0',
aux_text_1 varchar(255) default '',
aux_text_2 varchar(255) default '',
PRIMARY KEY (sid),
KEY point (point, count)
) TYPE=MyISAM;
# --------------------------------------------------------

INSERT INTO rssc_link VALUES (1, 1, 0, 0, 0, 0, 'XOOPS.org', 'http://www.xoops.org/', 2, 3600, 1, 2, '', 'http://www.xoops.org/backend.php', '', 'utf-8', 0, '', '', 0, 0, '', '', 1, '', '', '', '', 0 );
INSERT INTO rssc_xml VALUES (1, 1, '', 0, 0, '', '');

je ne vois pas ce qu'il y'a à enlever.

et voici ce que me donne le fichier mysql.sql de XHLD0

CREATE TABLE xhld0 (
headline_id smallint(5) unsigned NOT NULL auto_increment,
headline_name text NOT NULL default '',
headline_url text NOT NULL default '',
headline_rssurl text NOT NULL default '',
headline_titlepattern text NOT NULL default '',
headline_titleexclude text NOT NULL default '',
headline_linkpattern text NOT NULL default '',
headline_linkexclude text NOT NULL default '',
headline_encoding varchar(15) NOT NULL default '',
headline_cachetime mediumint(8) unsigned NOT NULL default '3600',
headline_asblock tinyint(1) unsigned NOT NULL default '0',
headline_display tinyint(1) unsigned NOT NULL default '0',
headline_weight smallint(3) unsigned NOT NULL default '0',
headline_mainfull tinyint(1) unsigned NOT NULL default '1',
headline_mainimg tinyint(1) unsigned NOT NULL default '1',
headline_mainmax tinyint(2) unsigned NOT NULL default '10',
headline_blockimg tinyint(1) unsigned NOT NULL default '0',
headline_blockmax tinyint(2) unsigned NOT NULL default '10',
headline_xml mediumtext NOT NULL default '',
headline_updated int(10) NOT NULL default'0',
headline_syndication varchar(255) NOT NULL default '',
headline_timeout smallint(3) NOT NULL default '99',
headline_allowhtml tinyint(1) NOT NULL default '0',
PRIMARY KEY (headline_id)
) TYPE=MyISAM;

Citation :Oops, il y en a oublier une:
=>

et
=>
Probablement aussi:
=>

Re salut Ghia

Toujours rien, j'ai remplacé comme tu as dit, mais rien ne change parfois j'ai d'autres erreurs.

as tu installé le module "happy linux framework" avant? Il est nécessaire pour faire fonctionner rss center