1
Hi! When I install in modules Xcenter I got an error from MySQL:
SELECT center_id, title, homepage, submenu FROM xcenter WHERE homepage='0' AND submenu='1' order by `weight`
Error number: 1146
Error message: Table 'uad.xoops_xcenter' doesn't exist
CREATE TABLE xcenter ( center_id int(16) NOT NULL auto_increment, parent_id int(16) NOT NULL default '0', weight int(8) unsigned NOT NULL default '0', title varchar(255) NOT NULL default '', summary varchar(560) NOT NULL default '', keywords varchar(2000) NOT NULL default '', text text default NULL, visible tinyint(1) NOT NULL default '0', homepage tinyint(1) NOT NULL default '0', nohtml tinyint(1) NOT NULL default '0', nosmiley tinyint(1) NOT NULL default '0', nobreaks tinyint(1) NOT NULL default '0', nocomments tinyint(1) NOT NULL default '0', anonymous tinyint(1) NOT NULL default '1', link tinyint(1) NOT NULL default '0', address varchar(255) default NULL, submenu tinyint(1) NOT NULL default '0', PRIMARY KEY (center_id, weight, title(20)) ) TYPE=MyISAM
Error number: 1074
Error message: Column length too big for column 'summary' (max = 255); use BLOB or TEXT instead
Please help me to solve the problem.
p.s. Xoops-2.3.3
Xcenter -1.09
MySQL - 4.1.22
