1
Hello!
I'm trying out XOOPS and it looks very promising, although I've got a problem when trying to install the news module.
It gives an SQL error. Here's what the MySQL-debugger gives:
Queries
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '537af355c1369223c99a40283cdea016'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT COUNT(*) FROM xoops_modules WHERE dirname = 'news'
CREATE TABLE xoops_stories ( storyid int(8) unsigned NOT NULL auto_increment, uid int(5) unsigned NOT NULL default '0', title varchar(255) NOT NULL default '', created int(10) unsigned NOT NULL default '0', published int(10) unsigned NOT NULL default '0', expired int(10) UNSIGNED NOT NULL default '0', hostname varchar(20) NOT NULL default '', nohtml tinyint(1) NOT NULL default '0', nosmiley tinyint(1) NOT NULL default '0', hometext text NOT NULL, bodytext text NOT NULL, counter int(8) unsigned NOT NULL default '0', topicid smallint(4) unsigned NOT NULL default '1', ihome tinyint(1) NOT NULL default '0', notifypub tinyint(1) NOT NULL default '0', story_type varchar(5) NOT NULL default '', topicdisplay tinyint(1) NOT NULL default '0', topicalign char(1) NOT NULL default 'R', comments smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (storyid), KEY idxstoriestopic (topicid), KEY ihome (ihome), KEY uid (uid), KEY published_ihome (published,ihome), KEY title (title(40)), KEY created (created), FULLTEXT KEY search (title,hometext,bodytext) ) TYPE=MyISAM
Error number: 1064
Error message: You have an error in your SQL syntax near 'KEY search (title,hometext,bodytext) ) TYPE=MyISAM' at line 28
SELECT * FROM xoops_modules WHERE (hasadmin = 1 AND isactive = 1) ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
Total: 9 queries
And then it aborts installation. Can anyone help me?
Thanks!
Birdy