Hey Geekwright, since I last tried the XOOPS 2.6 install on my ubuntu desktop box which is what the code install examples and video should be in, IT WORKED!! so I will play with it later today when the sun goes down, this is only sun up threading... so what I think needs to be changed is the prefix_modules folder to the following as
you still haven't yet addressed the planning documents in the
XOOPS Forum - XOOPS Documenting Team which was released before you where even in the show Richard!!
Currently this is the prefix_modules table
CREATE TABLE `xxx__modules` (
`mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL DEFAULT '',
`version` smallint(5) unsigned NOT NULL DEFAULT '100',
`last_update` int(10) unsigned NOT NULL DEFAULT '0',
`weight` smallint(3) unsigned NOT NULL DEFAULT '0',
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dirname` varchar(25) NOT NULL DEFAULT '',
`hasmain` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasadmin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hassearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasconfig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hascomments` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasnotification` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `hasmain` (`hasmain`),
KEY `hasadmin` (`hasadmin`),
KEY `hassearch` (`hassearch`),
KEY `hasnotification` (`hasnotification`),
KEY `dirname` (`dirname`),
KEY `name` (`name`(15)),
KEY `isactive` (`isactive`),
KEY `weight` (`weight`),
KEY `hascomments` (`hascomments`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
I think we need to update it too the followng at least:
[code]
CREATE TABLE `xxx__modules` (
`mid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`typal` enum('api','apps','modules','themes') NOT NULL DEFAULT 'modules',
`name` varchar(150) NOT NULL DEFAULT '',
`version` smallint(5) unsigned NOT NULL DEFAULT '100',
`last_update` int(10) unsigned NOT NULL DEFAULT '0',
`weight` smallint(3) unsigned NOT NULL DEFAULT '0',
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dirname` varchar(25) NOT NULL DEFAULT '',
`hasmain` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasadmin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hassearch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasconfig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hascomments` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasnotification` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasfeed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hasrewrite` tinyint(1) unsigned NOT NULL DEFAULT '0',
`categories` int(22) unsigned NOT NULL DEFAULT '0',
`topics` int(22) unsigned NOT NULL DEFAULT '0',
`items` int(22) unsigned NOT NULL DEFAULT '0',
`deleted` int(22) unsigned NOT NULL DEFAULT '0',
`edits` int(22) unsigned NOT NULL DEFAULT '0',
`comments` int(22) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `hasmain` (`hasmain`),
KEY `hasadmin` (`hasadmin`),
KEY `hassearch` (`hassearch`),
KEY `hasnotification` (`hasnotification`),
KEY `dirname` (`dirname`),
KEY `name` (`name`(15)),
KEY `isactive` (`isactive`),
KEY `weight` (`weight`),
KEY `hascomments` (`hascomments`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
