Loading...
 
Features / Usability

Features / Usability


Re: Re: Re: Re: Problem with Mods

posts: 1797 Catalan Countries

There seems to be a problem with mods.tw.o.
Try manually installing this version 1.6.2 attached at:
http://edu.tikiwiki.org/tiki-index.php?page=AulaWiki

For the database, get the sql script from the Packages/features-aulawiki.info.txt

To make it easier for you, this 1.6.2 needs this sql commands to be run (through phpmyadmin or similar):

DROP TABLE IF EXISTS `tiki_workspace_role_wstype`;
DROP TABLE IF EXISTS `tiki_workspace_roles`;
DROP TABLE IF EXISTS `tiki_workspaces`;
DROP TABLE IF EXISTS `tiki_workspace_modules`;
DROP TABLE IF EXISTS `tiki_workspace_types`;
DROP TABLE IF EXISTS `tiki_workspace_zones`;
DROP TABLE IF EXISTS `aulawiki_assignment`;
DROP TABLE IF EXISTS `aulawiki_gradebook`;
DROP TABLE IF EXISTS `aulawiki_period`;
DROP TABLE IF EXISTS `aulawiki_period_type`;
CREATE TABLE `tiki_workspace_role_wstype` (`roleName` varchar(250) NOT NULL default '0',`typeId` int(14) NOT NULL default '0',`wstypePermGroup` varchar(250) default NULL, PRIMARY KEY  (`typeId`,`roleName`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_roles` (`name` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`permgroup` varchar(250) default NULL,`description` varchar(250) NOT NULL default '', PRIMARY KEY  (`name`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspaces` (`workspaceId` int(14) NOT NULL auto_increment, `code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(250) default '',`created` int(14) default '0',`startDate` int(14) default '0',`endDate` int(14) default '0',`closed` char(1) NOT NULL default 'y',`type` int(14) NOT NULL default '0',`parentId` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`owner` varchar(100) default '',`isuserws` char(1) NOT NULL default '',`hide` char(1) NOT NULL default '',`categoryId` int(12) NOT NULL default '0', PRIMARY KEY  (`workspaceId`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_modules` (`moduleId` int(10) NOT NULL auto_increment,`name` varchar(200) NOT NULL default '',`position` char(1) default NULL,`ord` int(4) default NULL,`zoneId` int(11) NOT NULL default '0',`title` varchar(255) default NULL,`cache_time` int(14) default NULL,`rows` int(4) default NULL,`params` text,`groups` text,`style_data` varchar(150) default NULL,`style_title` varchar(150) default NULL, `uid` varchar(100) NOT NULL default '', PRIMARY KEY  (`moduleId`)) TYPE=MyISAM;
CREATE TABLE `tiki_workspace_types` (`wstypeId` int(14) NOT NULL auto_increment,`code` varchar(100) NOT NULL default '',`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`uid` varchar(100) NOT NULL default '',`menuid` int(8) NOT NULL default '0',`resources` text NOT NULL,`userwstype` int(14) NOT NULL default '0',`hide` char(1) NOT NULL default '',`active` char(1) NOT NULL default '', PRIMARY KEY (`wstypeId`)) TYPE=MyISAM; 
CREATE TABLE tiki_workspace_zones (`zoneId` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(100) NOT NULL default '',`workspaceId` int(14) NOT NULL,`type` varchar(100) NOT NULL default '',`ord` int(4) NOT NULL default '0',`uid` varchar(100) NOT NULL default '', PRIMARY KEY  (`zoneId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_assignment` (`assignmentId` int(14) NOT NULL auto_increment,`workspaceId` int(14) NOT NULL default '0',`periodId` int(14) NOT NULL default '0',`gradeWeight` int(5) NOT NULL default '0',`name` varchar(150) NOT NULL default '',`description` varchar(250) NOT NULL default '',`wikipage` varchar(100) NOT NULL default '',`createdby` varchar(100) NOT NULL default '',`creationDate` int(14) NOT NULL default '0',`startDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`type` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0', PRIMARY KEY  (`assignmentId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_gradebook` (`assignmentId` int(14) NOT NULL default '0',`userId` varchar(100) NOT NULL default '',`comment` varchar(250) NOT NULL default '',`grade` int(4) NOT NULL default '0') TYPE=MyISAM;
CREATE TABLE `aulawiki_period` (`periodId` int(5) NOT NULL auto_increment,`periodTypeId` int(5) default '0',`name` varchar(100) NOT NULL default '',`description` varchar(100) default '',`startDate` int(11) NOT NULL default '0',`endDate` int(14) NOT NULL default '0',`uid` varchar(100) NOT NULL default '',`gradeWeight` int(14) NOT NULL default '50', PRIMARY KEY  (`periodId`)) TYPE=MyISAM;
CREATE TABLE `aulawiki_period_type` (`periodTypeId` int(14) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`description` varchar(250) NOT NULL default '', PRIMARY KEY  (`periodTypeId`)) TYPE=MyISAM;
DELETE FROM tiki_menu_options WHERE url LIKE '%aulawiki%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%AulaWiki%';
DELETE FROM tiki_menu_options WHERE url LIKE '%workspaces%';
DELETE FROM tiki_menus WHERE menuid=100 AND description LIKE '%workspace%';
DELETE FROM `users_permissions` WHERE `permName` LIKE 'aulawiki_p_%';
DELETE FROM `users_permissions` WHERE `permName` LIKE '%workspace%';
DELETE FROM `tiki_preferences` WHERE name = 'feature_aulawiki';
DELETE FROM `tiki_preferences` WHERE name = 'feature_workspaces';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_user_assigned_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%aulawiki%';
DELETE FROM `tiki_modules` WHERE `name` LIKE '%workspaces%';
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Teacher', '2fd99c1c873d19ee003a5bde9b832607', 'RolePerms-Teacher', 'Teacher');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Student', '9d94a9b153bc6e7a162262b109ce3829', 'RolePerms-Student', 'Student');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Owner', 'cf658411eca2e230d90276c5a0235a1b', 'RolePerms-Owner', 'Portfolio owner');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Registered', 'a671a29eef794f7423ae567f7d964d42', 'Registered', 'Registered users');
INSERT INTO `tiki_workspace_roles` (`name`,`uid`,`permgroup`,`description`) VALUES ('Anonymous', '77f08d9b1ee1a29d11aabefbeca5d1e5', 'Anonymous', 'Anonymous users');
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Teacher';
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Student';
DELETE FROM `users_groups` WHERE `groupName`='RolePerms-Owner';
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Teacher', 'Teacher role permissions template');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Student', 'Student role permissions template');
INSERT INTO `users_groups` (groupName,groupDesc) VALUES ('RolePerms-Owner', 'Owner role permissions template');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_admin_assignments','Can admin assignments','admin','assignments','NULL');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_view_assignments','Can view assignments','basic','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_edit_assignments','Can edit existing assignments','editors','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_create_assignments','Can create new assignments','editors','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('aulawiki_p_remove_assignments','Can remove assignments','admin','assignments','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_view_workspace','Can view a workspace','basic','workspace','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_admin_workspace','Can admin workspaces','admin','workspace','');
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_create_workspace_resour','Can create new workspace resources','editors','workspace','');
INSERT INTO tiki_menus VALUES (100,'Workspace menu','Sample workspace menu','d', '');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'s','Workspaces','./tiki-workspaces_admin.php',1020,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Workspaces','./tiki-workspaces_admin.php',1022,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Workspace Types','./tiki-workspaces_types.php',1024,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Admin Roles','./tiki-workspaces_roles.php',1026,'','tiki_p_admin_workspace','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Users/Groups','./tiki-workspaces_view_module.php?module=workspaces_user_groups',10,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Resources','./tiki-workspaces_view_module.php?module=workspaces_resources',52,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Blogs list','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=blog',60,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Img galeries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=image gallery',70,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','File galleries','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=file gallery',71,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Wiki Pages','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=wiki page',72,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Forums','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=forum',73,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Calendars','tiki-workspaces_view_module.php?module=workspaces_list_resources&type=calendar',74,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','History','./tiki-workspaces_get_resource.php?name=History',80,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Gradebook','./aulawiki-view_gradebook.php',1,'','','');
INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (100,'o','Assignments','./aulawiki-assignments_admin.php',41,'','','');
INSERT INTO tiki_preferences (name,value) VALUES ( 'feature_workspaces', 'y');
INSERT INTO tiki_workspace_types VALUES ('1','PORTFOLIO','Portfolio','','f6dfa6643939c4887a68710a5b8c27b5','100','a:2:{i:0;a:3:{s:4:"name";s:6:"MyBlog";s:4:"desc";s:7:"My Blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:19:"Home portfolio page";s:4:"type";s:9:"wiki page";}}','0','n','y');
INSERT INTO tiki_workspace_types VALUES ('2','COURSE','Course','Sample course type','bcff9b0c6b65e3d060685650d3e6b6e1','100','a:5:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:16:"Home course page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:2;a:3:{s:4:"name";s:5:"Files";s:4:"desc";s:12:"Course files";s:4:"type";s:12:"file gallery";}i:3;a:3:{s:4:"name";s:6:"Images";s:4:"desc";s:13:"Course images";s:4:"type";s:13:"image gallery";}i:4;a:3:{s:4:"name";s:5:"Forum";s:4:"desc";s:12:"Course forum";s:4:"type";s:5:"forum";}}','3','n','y');
INSERT INTO tiki_workspace_types VALUES ('3','PERSONAL','Personal workspace type','Sample personal workspace','dcd9e72f70d04fa9399db80a3fa056d8','100','a:2:{i:0;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:12:"History blog";s:4:"type";s:4:"blog";}i:1;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:18:"Personal home page";s:4:"type";s:9:"wiki page";}}','0','y','y');
INSERT INTO tiki_workspace_types VALUES ('4','FOLDER','Folder','','9e39b5e9a566a61ce60417a9429ff0f0','0','a:1:{i:0;s:8:"wikipage";}','0','','y');
INSERT INTO tiki_workspace_types VALUES ('5','GROUP','Student group','','b4a6f4eef0d1e1111d568b50195b45e0','100','a:2:{i:0;a:3:{s:4:"name";s:4:"Home";s:4:"desc";s:15:"Group home page";s:4:"type";s:9:"wiki page";}i:1;a:3:{s:4:"name";s:7:"History";s:4:"desc";s:10:"Group blog";s:4:"type";s:4:"blog";}}','0','y','y');
INSERT INTO tiki_workspace_zones VALUES (1,'main','main zone',1,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c39');
INSERT INTO tiki_workspace_zones VALUES (2,'main','main zone',2,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c40');
INSERT INTO tiki_workspace_zones VALUES (3,'main','main zone',3,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c41');
INSERT INTO tiki_workspace_zones VALUES (5,'main','main zone',5,'workspace type',1,'ade0ff330c3ebb57865e34c2ce476c43');
INSERT INTO tiki_workspace_modules VALUES ('1','workspaces_last_blog_posts','2','3',1,'My Blog','0','0','name=%WSCODE%-MyBlog','','','','68809e75ced4d1f52bec9eb73bc32cdc');
INSERT INTO tiki_workspace_modules VALUES ('2','workspaces_viewpage','1','1',1,'Portfolio Home','0','0','name=%WSCODE%-Home','','','','6ac0bc2518a0c836de87662defbada90');
INSERT INTO tiki_workspace_modules VALUES ('3','workspaces_who_is_there','2','1',2,'Course users','0','0','','','','','cbbbb0122cb4aca6c83859cda85bdecd');
INSERT INTO tiki_workspace_modules VALUES ('5','workspaces_last_blog_posts','1','3',2,'Course History','0','0','name=%WSCODE%-History&maxPosts=3&showBar=n','','','','da1d338b0fb3d87256341b4154ba96c5');
INSERT INTO tiki_workspace_modules VALUES ('6','workspaces_viewpage','2','1',3,'Home page','0','0','name=%WSCODE%-Home','','','','1f1b76a1f4dff160d31ae36a11170ede');
INSERT INTO tiki_workspace_modules VALUES ('7','workspaces_last_blog_posts','2','5',3,'History','0','0','name=%WSCODE%-History','','','','ae744c4a52b38e5386c99ddc43edc8be');
INSERT INTO tiki_workspace_modules VALUES ('9','workspaces_last_files','3','11',2,'Course files','0','0','name=%WSCODE%-Files&maxFiles=3&showBar=y&','','','','ce32d51600a7f6b3f999be9ec467c5d7');
INSERT INTO tiki_workspace_modules VALUES ('10','workspaces_break','1','5',2,'','0','0','','','','','781330d16d490e7a88237e2aa1983ce1');
INSERT INTO tiki_workspace_modules VALUES ('19','workspaces_break','2','2',1,'','0','0','','','','','b0678bf202e5b4417bb6fdcae969626e');
INSERT INTO tiki_workspace_modules VALUES ('17','workspaces_last_image','3','15',2,'Images','0','0','name=%WSCODE%-Images&maxImages=3&showBar=y&','','','','f73d1e5f2a56721284d38eba1da56de0');
INSERT INTO tiki_workspace_modules VALUES ('15','workspaces_calendar','2','6',2,'Course calendar','0','0','','','','','7126d03da3815b92f80feef1e8598ddb');
INSERT INTO tiki_workspace_modules VALUES ('14','workspaces_childs','2','5',2,'Child workspaces','0','0','','','','','e4604c1cea8879a11425ebcae8aab4d1');
INSERT INTO tiki_workspace_modules VALUES ('16','workspaces_viewpage','1','10',2,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','a91e337ce2b81ce208523635e1471faa');
INSERT INTO tiki_workspace_modules VALUES ('22','workspaces_owner','1','1',3,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','017e28f378066a9c8c6d2a66f435f3cd');
INSERT INTO tiki_workspace_modules VALUES ('20','workspaces_owner','2','1',1,'Workspace owner','0','0','showName=y&showWorkspaces=y','','','','b162f68536c92a270150ae475bd8308f');
INSERT INTO tiki_workspace_modules VALUES ('28','workspaces_viewpage','1','1',5,'View page','0','0','name=%WSCODE%-Home&showBar=y','','','','40ca0c9474d974dba3e73ff3fc9db3a7');
INSERT INTO tiki_workspace_modules VALUES ('29','workspaces_last_blog_posts','1','2',5,'Blog','0','0','name=%WSCODE%-History&maxPosts=5&showBar=y&','','','','a8fa9590762ec2cceee9934378631b3b');
INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','1','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Student','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Owner','3','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','3','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Teacher','5','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Student','5','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Registered','2','');
INSERT INTO tiki_workspace_role_wstype VALUES ('Anonymous','2','');


HTH

P.S: I've already requested to have mods.tw.o updated with the latest code for AulaWiki mod

Upcoming Events

No records to display

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.