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
le="color: #000000"><?php 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:
le="color: #000000"><?php [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;
