Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Staff v0.3 Problem.

Hi guys,

I have been reading the posts on the errors with the staff script. I also get the access denied message when running the Install_MySQL_Staff-v0.3 file along with this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kelly/public_html/homev2/includes/sql_layer.php on line 286

I read in another post that the solution maybe to use the sql file and isert the code straight into phpmyadmin. So. I did this but now have a different error. This is what i get when I try to run the tables:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 8

Any help will be gratefully received. Thanks guys, and keep up the great work !!

Regards

Jon

The sql reads

TYPE=MyISAM;

make sure you copied and pasted correctly. There should be no ' after MyISAM

Thanks for your reply. I have rechecked the copy and paste and placed in exactly what is in the sql file:

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',
'[color="#999999" size="1"]Staff v0.3 by [url="http://www.caffeine-junkies.com"]Caffeine Junkies[/url]. © 2004[/colour]');

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;

But im still getting the same error. Any ideas?

Thanks for your help.

Regards

Jon