newsflash stops adding new authors

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   newsflash stops adding new authors
kenspa
CZ Newbie
kenspa has been a member for over 19 year's 19 Year Member
spain.gif
Gender: Male
Status: Offline
Joined: Mar 24, 2005
0.00 posts per day
Posts: 7
Points: 118
   
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



Back to top Reply with quote
#2   
Telli
Site Admin
Telli has been a member for over 20 year's 20 Year Member
Occupation: Self Employed
Age: 45
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.06 posts per day
Posts: 8089
Points: 494,430
   
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.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: newsflash stops adding new authors
kenspa
CZ Newbie
kenspa has been a member for over 19 year's 19 Year Member
spain.gif
Gender: Male
Status: Offline
Joined: Mar 24, 2005
0.00 posts per day
Posts: 7
Points: 118
   
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.




Back to top Reply with quote
#4   re: newsflash stops adding new authors
kenspa
CZ Newbie
kenspa has been a member for over 19 year's 19 Year Member
spain.gif
Gender: Male
Status: Offline
Joined: Mar 24, 2005
0.00 posts per day
Posts: 7
Points: 118
   
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. icon_rolleyes.gif



Back to top Reply with quote
#5   
Telli
Site Admin
Telli has been a member for over 20 year's 20 Year Member
Occupation: Self Employed
Age: 45
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.06 posts per day
Posts: 8089
Points: 494,430
   
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.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#6   re: newsflash stops adding new authors
mejayne
CZ Newbie
mejayne has been a member for over 19 year's 19 Year Member
Status: Offline
Joined: Oct 27, 2004
0.00 posts per day
Posts: 1
Points: 785
   
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.



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum