Of Cookies And Admins.....

Hangin' Around Joined: Jan 11, 2007 Posts: 32

I am having two minor issues..

Seems that the people on the site can't get the cookies to "work right"... We had an issue where everytime some of us logged in, we got some message about Needing to activate cookies in big bold red letters. I don't recall the exact wording, but I googled it, found a solution and implemented it. It appeared to fix the problem.

NOW, people are getting logged out after just a few minutes of inactivity and they have to go thru the full login..

Unfortuanatly, I don't recall what I did to fix the RedLetter Cookie problem..

Can anyone deduce the problem from the above??

Secondly, I am trying to create some Senior Admins. I put in some info for two of our users in the EDIT ADMINS block, but the logins didn't work. So I deleted those to redo them. NOW when I try and create an ADMIN, I click on SUBMIT and it goes to a blank white page with no ADMIN created..

Any help??

Michale

Posted: Mon Jan 15, 2007 11:11 am

1. People need to have their browser setting to allow cookies. Plain and simple.

2. With Sentinel you may need to go thru its process to scan for new admins. That's documented on the Sentinel admin screen and your God admin has to go in and do that.

If you post back please give us the version you are running; of Nuke and Sentinel if you have that running.

Posted: Tue Jan 16, 2007 7:45 am

Many thanx for the response...

fkelly wrote:

If you post back please give us the version you are running; of Nuke and Sentinel if you have that running.

PHP Nuke 7.6/Update Patch 3.3/ NukeSentinel 2504_70-80

fkelly wrote:

1. People need to have their browser setting to allow cookies. Plain and simple.

I believe they do.. I know I do and I still can't get the cookie set....

fkelly wrote:

2. With Sentinel you may need to go thru its process to scan for new admins. That's documented on the Sentinel admin screen and your God admin has to go in and do that.

OK, I have done the New Scan Admin.. Still no luck.. Screen goes BLANK WHITE when I try to edit/add new admins in the PHP Nuke Administration screen...

Michale

Posted: Tue Jan 16, 2007 11:34 am

This sounds like you have a table structure issue ... probably a field extra or minus in your authors table from what the admin application is expecting when it goes to add the admin. One way to find out would be to patch mysql.php in the db directory to echo out any mysql errors as well as the sql that's generating those errors. Or look in the admin application for where it inserts records into the authors table and see how many fields it's expecting; then look at your table in phpmyadmin and see how many fields are in it.

As to cookies, you can look at them in Firefox and see if they are set correctly. There should be a user cookie for whatever your nuke domain is.

Posted: Wed Jan 17, 2007 6:23 am

fkelly wrote:

This sounds like you have a table structure issue ... probably a field extra or minus in your authors table from what the admin application is expecting when it goes to add the admin. One way to find out would be to patch mysql.php in the db directory to echo out any mysql errors as well as the sql that's generating those errors. Or look in the admin application for where it inserts records into the authors table and see how many fields it's expecting; then look at your table in phpmyadmin and see how many fields are in it.

While I have admin'ed a PHP Nuke server for a couple years, this is my first foray into actively setting one up and accessing/fixing DBs.

I have tried setting up phpMyAdmin but cannot seem to access it. I get a YOU DON'T HAVE PERMISSION error.. Sad

Would you mind pointing me to info on how to patch things to get the error info you mention??

fkelly wrote:

As to cookies, you can look at them in Firefox and see if they are set correctly. There should be a user cookie for whatever your nuke domain is.

Yea, there was a cookie for the domain in question, but there still was the issue. Is there a place in PHPNuke Admin that deals with cookies?? The only place I found was in the Forums/PHPBB Admin section.

Thanx for your time..

Michale

Posted: Wed Jan 17, 2007 12:33 pm

See this thread about capturing errors:

Only registered users can see links on this board! Get registered or login!

Are you on a shared host? If so, they need to provide you with the information to access PHPmyadmin. And regardless, you need to get your access problem to it resolved before you will be able to administer your site adequately. It is really site and server dependent and we may not be able to help that much with it here.

As to cookies, no, there is no place in PHPnuke where you administer them. You are right that Forums has it's own settings but for Nuke I believe that they just are automatically associated with your domain.

Posted: Wed Jan 17, 2007 1:54 pm

fkelly wrote:

See this thread about capturing errors:

Only registered users can see links on this board! Get registered or login!

Are you on a shared host? If so, they need to provide you with the information to access PHPmyadmin. And regardless, you need to get your access problem to it resolved before you will be able to administer your site adequately. It is really site and server dependent and we may not be able to help that much with it here.

I have my own Fedora Core 6 box on a dedicated DSL. (Scary, ain't it?? Very Happy

)

I'll check that site and see what I can come up with..

fkelly wrote:

As to cookies, no, there is no place in PHPnuke where you administer them. You are right that Forums has it's own settings but for Nuke I believe that they just are automatically associated with your domain.

Cookie problem's been fixed. Seems that a tweak I had to do to make PMs and Emoticons work farbled up the Cookies..

Got that fixed..

Thanx

Michale

Posted: Wed Jan 17, 2007 2:06 pm

Here is what I got when I added the lines from that link...

sql failed .
query was insert into nuke_authors values ('<name1>', '<name2>', '', '<email@email.com>', '<long_set_of_numbers_and_letters>', '0', '1', '')
1136
Column count doesn't match value count at row 1

EDIT: Using WebMin, I was able to get a look at the table in question:

Let me know if the pic is not clear enough.

Michale

registered · Posted: Wed Jan 17, 2007 3:32 pm

Alright need to see the structure of the nuke_authors table. You can export the structure from phpMyAdmin and post it here

Posted: Wed Jan 17, 2007 3:37 pm

evaders99 wrote:

Alright need to see the structure of the nuke_authors table. You can export the structure from phpMyAdmin and post it here

^^^^^^ Is that what ya need???

Michale

Posted: Thu Jan 18, 2007 12:54 am

Did you install some kind of mod? I see the fields 'radminapprove' and 'radminorapprove' (I believe that's what it says?)
I don't think they are used in phpNuke 7.6

Posted: Thu Jan 18, 2007 5:55 am

evaders99 wrote:

Did you install some kind of mod? I see the fields 'radminapprove' and 'radminorapprove' (I believe that's what it says?)
I don't think they are used in phpNuke 7.6

Yes, that's the CNB_YOUR_ACCOUNT that was discussed in this thread:

http://www.ravenphpscripts.com/postp92388.html#92388

Michale

Posted: Thu Jan 18, 2007 7:25 pm

Unfortunately, the number of fields in the update statement has to equal the number in the table. You will need to either modify the update statement or the table. However, if you've installed CNB whatever you will need to look further because it may have it's own update statements that rely on those fields being there. I haven't looked at the thread you listed since I have my hands full with other things than CNBYA but I hope there is a solution there for you. And some day we should rewrite Nuke to NOT use that form of an insert statement, not ONCE not ever. It just causes problems and is very difficult to debug (not so much with Authors table but look at users).

Good luck.

Posted: Fri Jan 19, 2007 6:09 am

I was thinking that I could simply replace the STOCK/DEFAULT php files that were changed by installing the CNBYA stuff..

But, then it just occurred to me that doing so will not change the Database itself.

So, I am still trying to work thru this.

Thanx for all the replies. At least I have a basis to figure this out.

Michale

Posted: Fri Jan 19, 2007 7:30 am

Well, I got it!! Very Happy

Basically, I uninstalled CNB YA and then deleted the 2 extra tables from the DB... Created my admins and then re-installed CNB YA...

Worked perfectly..

And, I guess whatever I did fixed the glitch, because now I can create new admins w/o having to uninstall CNB YA..

Thanx to all for all the replies and assistance..

Michale

registered · Posted: Sun Jan 21, 2007 8:00 am

Tell your friends... lol