Codezwiz >> Forums >> General PHP Nuke Help >> newsflash stops adding new authors

I've been through this problem and cheked almost all messages on this issue. I tried to go round the problem changing my authors.php adding the new feature manually there, but no solution. the only possible thing to add new authors is to remove this line from Nuke_authors table:

radminNewsflashAdmin

and if so, the mod will return

access denied, go away.

I really appreciate any help on this.
thanks

You have to open the admin/authors.php and find the insert into nuke_authors query. Its missing a field thats why it won't work. Add a , '' on the end of it. I'm sure the NewsFlash came with instructions to do something similar.

Thank u for your quick reply.

i really went dizzy about trying to fix the newsflash. I added a code provided in some other forum in admin.php which was:

$result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_pwd', '0','0', '$add_radminsuper', '$add_admlanguage')");

but i didn't work for me, and still receive a blank page when adding new authors..

Now i deleted it and started to add the entry "radminNewsflash" manually in authors.php, and no fix is possible. Obviously there's something missing here.
The responsible for this mess is this line:

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

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

It comes in the original install.sql, AND FOR SURE not any instructions on that

I believe that it is possible to do something about it.

I appreciate any help on that.

The instructions on the readme file:

NEWSFLASH BLOCK v0.2
This is basically a scroller block that displays news flashes on your phpNuke site.
It can be programmed to release the newsflash on a certain date and time, with the
option of expiring the news flash after a certain period of time.

HTML can be included in the news flash content itself, but remember that this is a
block so you don't have very much space to work with if you're thinking of putting
fancy graphics and such. Each time you add a newsflash you will have to preview it
first, so this will be a good test to make sure any HTML code you put in works.

The newsflash database is administered via the standard Nuke admin interface.

Remember this is free software and is provided to you without any warranties or
guarantees. So PLEASE make sure you backup your database and code before you do
anything with it.

INSTALLATION PROCEDURES -- UPDATE FROM v0.1
1. Make a BACKUP of your database.
2. Make a BACKUP of your database. Done it yet?
3. Unzip all files into a directory on your hard drive.
4. Upload everything to your server, making sure that the files go into the correct
respective directories.

INSTALLATION PROCEDURES -- CLEAN INSTALL
1. Make a BACKUP of your database.
2. Make a BACKUP of your database. Done it yet?
3. Unzip all files into a directory on your hard drive.
4. Upload everything to your server, making sure that the files go into the correct
respective directories.
5. Edit the newsflash.sql file:
- If your database uses a different prefix that the default "nuke", you will need
to replace nuke_ with your own prefix (eg. nuke_newsflash becomes myprefix_newsflash)
- Replace the word "admin" with whatever your super user is called in the sql line
that begins with "update nuke_authors...."
6. Run the newsflash.sql file via command line or phpMyAdmin or whatever else you use.
7. Copy the contents of admin/language/lang-english.txt into your
admin/language/lang-english.php file

RUNNING IT
1. Enter some content using the Newsflash admin interface
2. Create a new block via the admin interface, selecting 'Newsflash' as the Filename
3. Set where you want the block to appear
4. Load up your phpNuke main page and see it working.

I could trace the Newsflash problem, and come out with:

The very moment you create the table needed in sql it alters the author table, adding a new entry as follows:
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
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`;

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

and since that moment you can't add any new author, but a blank page is returned instead.

I think there might be some go around this in the author table, since the instructions don't state any reference to this issue.
At the same time, nor in admin/authors.php i could see the add that must correspond to this mod:

"radminNewsflash"
I tried the to add a comma on the end of line, and still the same prob.

I really would appreciate any help on this.

If your adding a field to your nuke_authors table then you will also need to add it to the admin/modules/authors.php file. Attach that file and I will see whats going on.

I got mine working by changing the "radminency" to "radminsuper" in the sql file, then by going into my sql database to the nuke_authors and browsing to the list of authors. Picking the ones that are supposed to have access to your php control panel, edit them and put a "1" in the "radminNewsflashAdmin" field.