Staff module (SOLVED)

Worker Joined: Jun 16, 2004 Posts: 159 Location: Sweden

Hi i wounder if some can help me to fix this staff module so it works with
raven nuke

registered · Posted: Tue Nov 08, 2011 1:48 pm

What errors are you getting when you try to install it? It doesn't use the old dbi layer so it should work.

Posted: Tue Nov 08, 2011 3:08 pm

Thanks for fast reply...It dont show anything when i setup a staff

SQL-fråga:

CREATETABLE nuke_staff(

id int( 3)NOTNULL default'',
sid int( 3)NOTNULLAUTO_INCREMENT ,
name varchar( 255)NOTNULL default'',
des mediumtext NOTNULL ,
rank varchar( 255)NOTNULL ,
alias varchar( 255)NOTNULL default'',
photo varchar( 255)NOTNULL default'',
PRIMARYKEY ( sid ) ,
UNIQUEKEY sid( sid )
) TYPE=MYISAM ;

MySQL sa:
#1067 - Invalid default value for 'id'

here is all

CREATE TABLE nuke_staff (
id int(3) NOT NULL default '',
sid int(3) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
des mediumtext NOT NULL,
rank varchar(255) NOT NULL,
alias varchar(255) NOT NULL default '',
photo varchar(255) NOT NULL default '',
PRIMARY KEY (sid),
UNIQUE KEY sid (sid)
) TYPE=MyISAM;

CREATE TABLE nuke_staff_config (
latest int(3) NOT NULL default '',
img_url mediumtext NOT NULL,
staff_join_page mediumtext NOT NULL,
ranks int(3) NOT NULL default '',
index_bl int(3) NOT NULL default '',
copyright_txt mediumtext NOT NULL,
) TYPE=MyISAM;

INSERT INTO nuke_staff_config (
latest,
img_url,
staff_join_page,
ranks,
index_bl,
copyright_txt)
VALUES (
'1',
'images/staff/',
'',
'1',
'1',
'[center][color="#999999" size="1"]Staff v0.3 by [url="http://www.caffeine-junkies.com"]Caffeine Junkies[/url]. © 2004[/colour][/center]');

CREATE TABLE nuke_staff_cat (
id int(3) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;

nuke_staff_cat Seems just to add nothing else!!

Posted: Tue Nov 08, 2011 4:24 pm

Hi i have solve it

##
## Table structure for table `nuke_staff`
##

CREATE TABLE `nuke_staff` (
`id` int(3) NOT NULL default '0',
`sid` int(3) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`des` mediumtext NOT NULL,
`rank` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`photo` varchar(255) NOT NULL default '',
PRIMARY KEY (`sid`),
UNIQUE KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

##
## Dumping data for table `nuke_staff`
##

## ########################################################

##
## Table structure for table `nuke_staff_cat`
##

CREATE TABLE `nuke_staff_cat` (
`id` int(3) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

##
## Dumping data for table `nuke_staff_cat`
##

## ########################################################

##
## Table structure for table `nuke_staff_config`
##

CREATE TABLE `nuke_staff_config` (
`latest` int(3) NOT NULL default '0',
`img_url` mediumtext NOT NULL,
`staff_join_page` mediumtext NOT NULL,
`ranks` int(3) NOT NULL default '0',
`index_bl` int(3) NOT NULL default '0',
`copyright_txt` mediumtext NOT NULL
) TYPE=MyISAM ;

##
## Dumping data for table `nuke_staff_config`
##

INSERT INTO `nuke_staff_config` VALUES (1, 'images/staff/', '', 1, 1, '[center][color="#999999" size="1"]Staff v0.2 by [url="http://www.caffeine-junkies.com"]Caffeine Junkies[/url]. © 2004[/colour][/center]');

New Member Joined: Jul 02, 2012 Posts: 1 Location: Concord

Yeah it has been quite supportive,But by executing it, Displaying error called" Data not found". What does it indicates?

Posted: Mon Jul 02, 2012 11:55 pm

Turn on error reporting and see what error is generated.