Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Newsflash 2.o sql always returns errors

DROP TABLE IF EXISTS nuke_newsflash;

CREATE TABLE nuke_newsflash (
nid int(11) NOT NULL auto_increment,
title varchar(150) NOT NULL,
data blob,
launch_time datetime NOT NULL,
expires datetime default NULL,
active int(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (nid)
);

ALTER TABLE `nuke_authors` ADD `radminNewsFlashAdmin` TINYINT(2) NOT NULL AFTER `radminency`;

Can you tell me waht has to be edited to access it?
If you could change the fields that need to be edited with red text.
Would be greatly appreciated.

I have included the original sql file here the block appears on my page but I cannot access the admin part. [ Register or login to view links on this board. ]

Now I see why everyone is having a problem with this block, it's missing a very important ingredient. This line is missing from the SQL file:

update nuke_authors set radminNewsflashAdmin = 1 where aid = 'admin';

ty very much for the quick response I will try that and see what i get I will repost to let you know how it is

#1054 - Unknown column 'radminency' in 'nuke_authors'

any ideas?

Back up your nuke_authors table, then open up your nuke_authors table and remove the line:

radminNewsflashAdmin tinyint(2) DEFAULT '0' NOT NULL,

I do not see that name there in the nuke_authors table.

I see you have it working. The reason you don't see the text is because of the black, if you click and hightlight inside the block you will see what I mean. If you look at my site you will see I have it set to my themes bg color. Look in the block and find this code:

bgcolor=\"#FFFFFF