When I try to install this module I get this Error Message


Installing xRoster

// // ----------------------------------------------------------------------// This program is free software is not a valid SQL!

Unable to install xroster. Error(s):


I found this line in the data.sql file

// This program is free software;

Any Ideas?

I got the same error and have the same question. No idea whats wrong w/ it. and i know i uploaded it correctly.

Illuminus

if your sql files end by // -------------------------------

just delete the last line and retry intall procedure.
I've seen work in some other modules.

Good luck.

Ok I figured it out thanks for the clue

edit data.sql to look like this code below it worked for me

#
#
# Table structure for table `xRoster`
#

CREATE TABLE `xRoster` (
`id` int(11) NOT NULL auto_increment,
`member` tinyint(1) NOT NULL default '0',
`membername` varchar(50) NOT NULL default '',
`realname` varchar(50) NOT NULL default '',
`tid` int(11) NOT NULL default 9,
`gid` int(11) NOT NULL default 1,
`picture` varchar(255) NOT NULL default 'images/blank.jpg',
`location` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`age` char(3) NOT NULL default '',
`sitename` varchar(100) NOT NULL default '',
`siteurl` varchar(120) NOT NULL default '',
`games` varchar(100) NOT NULL default '',
`impref` varchar(4) NOT NULL default 'ICQ',
`imid` varchar(100) NOT NULL default '',
`connection` varchar(15) NOT NULL default '',
`note1` text NOT NULL,
`ahours` varchar(100) NOT NULL default '',
`pweapon` varchar(100) NOT NULL default '',
`sweapon` varchar(100) NOT NULL default '',
`note2` text NOT NULL,
`note3` text NOT NULL,
`note4` text NOT NULL,
`note5` text NOT NULL,
`tag` varchar(100) NOT NULL default '',
`since` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Table structure for table `xRoster_titles`
#

CREATE TABLE `xRoster_titles` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`weight` int(11) NOT NULL default 999,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

#
# Dumping data for table `xRoster_titles`
#

INSERT INTO `xRoster_titles` VALUES (1, 'Clan Leader',100);
INSERT INTO `xRoster_titles` VALUES (3, 'Deputy Clan Leader',200);
INSERT INTO `xRoster_titles` VALUES (4, 'Drill Instructor',300);
INSERT INTO `xRoster_titles` VALUES (5, 'First Communications Officer',400);
INSERT INTO `xRoster_titles` VALUES (6, 'Recruiting Officer',500);
INSERT INTO `xRoster_titles` VALUES (7, 'Second Communications Officer',600);
INSERT INTO `xRoster_titles` VALUES (8, 'XOA Member',700);
INSERT INTO `xRoster_titles` VALUES (9, 'XOA Recruit',800);
INSERT INTO `xRoster_titles` VALUES (10, 'Sandwich Maker',900);

CREATE TABLE `xRoster_groups` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`weight` int(11) NOT NULL default 999,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `xRoster_groups`
#

INSERT INTO `xRoster_groups` VALUES (1, 'Active',100);
INSERT INTO `xRoster_groups` VALUES (3, 'Honorary',200);

actully - it was a lot more simpler than all the above solutions...

Quote:

you see the problem bit? it is the < ? php right at the begining of the document. hmmmmph...possibly a bit more care should be exercised... and i am not a coder person - i do appreciate all and everything you guys/girls do. seriously - cudos to everyone.

I would reccommend using Profiles Module for XOOPS 2.0.
This is an alternative for xRoster.

Download Here

Cheers,

That is because you have a OLD version that was hacked and passed around. Try getting the new version 2.0

soegamers.com