1
skara
WF-Channel wrong type of field
  • 2005/4/9 11:13

  • skara

  • Friend of XOOPS

  • Posts: 84

  • Since: 2004/9/24


Using WF-channel and trying to post the 128th story you will mention that is impossible to do this!

The reason is that the CID field is a "tinyint" and not a "int" type!

Take a look after i was made an export of the database:

CREATE TABLE `xoops_wfschannel` (
   `
CID` tinyint(4) NOT NULL auto_increment,
   `
pagetitle` varchar(255) NOT NULL default '0',
   `
pageheadline` varchar(255) NOT NULL default '0',
   `
page` text NOT NULL,
   `
weight` int(11) NOT NULL default '1',
   `
html` int(11) NOT NULL default '0',
   `
smiley` int(11) NOT NULL default '1',
   `
xcodes` int(11) NOT NULL default '1',
   `
breaks` int(10) NOT NULL default '1',
   `
defaultpage` int(10) NOT NULL default '0',
   `
indeximage` varchar(255) default 'blank.png',
   `
htmlfile` varchar(255) default NULL,
   `
mainpage` int(11) NOT NULL default '0',
   `
submenu` int(11) NOT NULL default '0',
   `
created` int(10) unsigned NOT NULL default '0',
   `
comments` tinyint(11) NOT NULL default '0',
   `
allowcomments` tinyint(11) NOT NULL default '0',
   `
usedoctitle` tinyint(1) NOT NULL default '0',
   `
publishdate` int(10) unsigned NOT NULL default '0',
   `
expiredate` int(10) unsigned NOT NULL default '0',
   `
counter` int(11) NOT NULL default '0',
   
PRIMARY KEY  (`CID`),
   
UNIQUE KEY `topicID` (`CID`),
   
FULLTEXT KEY `answer` (`page`)
) 
ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='WF-Channel by Catzwolf';

The solution to transform the CID field to "int" type.

I hope to WF-guys to correct this problem in a next release.

I'm wondering also if this problem exist also to other WF modules...

2
Marco
Re: WF-Channel wrong type of field
  • 2005/4/9 13:33

  • Marco

  • Home away from home

  • Posts: 1256

  • Since: 2004/3/15


if you add this in wf-projects bugtracker, I hope so !
marco