Warning with Nuke install

Ilse · April 9th, 2005, 12:42 PM

Hi,

I have tried to find a solution to this problem in the forum, but I can't seem to find it.

I have done a fresh install of Photopost 5.03. I have PHP Nuke 7.6 patch 2.9 (that's not the platinum version as far as I know it) running on my site.

I have ran the entire install without any problems (besides the message "error:" without an error message. See other post) and now I'm at adm-index.php and I get the following error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/scrappi/public_html/gallery/forums/nuke.php on line 330

I haven't got a clue as to what seems to be the problem. Anyone who knows what I should do?

Other info:
Server operatingversion: Linux
PHP Version: 4.3.9
MySQL: 4.0.22-Standard
Shared Hosting on My own account

What do I have to do with this?

Regards,
Ilse

Chuck S · April 9th, 2005, 05:18 PM

Looks to me like your usergroups did not insert. If you have phpmyadmin tell me whats in your photopost usergroups table

Ilse · April 10th, 2005, 04:30 AM

This is the only table that doesn't have pp as a prefix. All the rest does have this prefix. Is this the cause of the problem?

I have included a picture of the table.

EDIT APRIL 10:
I have renamed the table usergroups to pp_usergroups and that seemed to fix the problem. Only thing left: How do I become an administrator?

I can't login with the Admin as I have set it up in PHP Nuke and my personal account has no administration rights. So..... how to solve this problem?

Regards,
Ilse

Chuck S · April 10th, 2005, 11:06 AM

Yes that would be the issue.

If in usergroups table usergroup entry 2 which is admin access has cpaccess set to 1 you should have admin access. I would make sure to see your logged in.

Chuck S · April 10th, 2005, 11:09 AM

I do see the issue here

In nuke.php this line

function init_user_groups() {
global $link, $pp_db_prefix;

should be this

function init_user_groups() {
global $Globals, $db_link, $link;

You can try a reinstall after making this change and see the issue or making sure there is a usergroup entry of 2 as noted above with cpaccess set to 1 should do it as well

Ilse · April 10th, 2005, 11:51 AM

Quote:

Originally Posted by omegatron

Yes that would be the issue.

If in usergroups table usergroup entry 2 which is admin access has cpaccess set to 1 you should have admin access. I would make sure to see your logged in.

This doesn't help. I am logged in as the admin of the site in PHP Nuke, but I can't get into the gallery admin. I'll try to reinstall.

Regards,
Ilse

Ilse · April 10th, 2005, 11:58 AM

Quote:

Originally Posted by omegatron

I do see the issue here

In nuke.php this line

function init_user_groups() {
global $link, $pp_db_prefix;

should be this

function init_user_groups() {
global $Globals, $db_link, $link;

You can try a reinstall after making this change and see the issue or making sure there is a usergroup entry of 2 as noted above with cpaccess set to 1 should do it as well

Done this, but it ain't working either...... ????? I keep getting the error:
Invalid Login. Check username and password or register.

I have cleared my cache and deleted all my cookies, but this didn't help either. Do you happen to have another solution?

Regards,
Ilse

organizedhome · April 10th, 2005, 12:04 PM

Just to let you all know that I'm another one who needs to integrate her new PP with a PHP-Nuke site, and I'm having the same database errors that Ilse's experiencing.

I can get an integrated install to succeed ONLY if I permit PP to place tables in the nuke database. I get the same database installation error (usergroups not being named pp_usergroups). Even when I correct the table name manually, I still can't log in as admin.

As I'm hoping to use both PP and ReviewPost on three or four large production sites (Ilse, I run organizedscrapbooks.com, among others!), I'm pretty discouraged at the difficulty of achieving what you folks swore to me was possible: an integrated Nuke install.

I'll try all the fixes noted here, but any help you can give the both of us would be very welcome. So far, the only way I've managed to make this software work is to bypass Nuke entirely and use the PP authentication, which doesn't meet my needs. Thank goodness I'm just kicking the tires on a trial site: http://townleyfamily.com/photo

Ilse · April 10th, 2005, 12:10 PM

Quote:

Originally Posted by organizedhome

Just to let you all know that I'm another one who needs to integrate her new PP with a PHP-Nuke site, and I'm having the same database errors that Ilse's experiencing.

I can get an integrated install to succeed ONLY if I permit PP to place tables in the nuke database. I get the same database installation error (usergroups not being named pp_usergroups). Even when I correct the table name manually, I still can't log in as admin.

As I'm hoping to use both PP and ReviewPost on three or four large production sites (Ilse, I run organizedscrapbooks.com, among others!), I'm pretty discouraged at the difficulty of achieving what you folks swore to me was possible: an integrated Nuke install.

I'll try all the fixes noted here, but any help you can give the both of us would be very welcome. So far, the only way I've managed to make this software work is to bypass Nuke entirely and use the PP authentication, which doesn't meet my needs. Thank goodness I'm just kicking the tires on a trial site: http://townleyfamily.com/photo

Same here. I really need to have only one registration option. Luckily I have a running gallery, but it doesn't meet my needs. The previous version of Photopost (PP486) I had installed (before I had to entirely reinstall my site) was giving no problems at all, so I don't see why I have these problems now with the improved version of PP. I do know I have another version of PHP Nuke running (7.6 patched 2.9 instead of 7.2). Maybe there's a clue?

By the way. I really like Organized scrapbooks.com!! I still need to setup links on my site, but as soon as I'm starting there, I'll be sure to include your site

Any help would be truly appreciated!

Regards,
Ilse

organizedhome · April 10th, 2005, 04:04 PM

Okay, an update.

I have done a re-install using the above edit. The software installed correctly, the database tables are properly in place, and I can log in as a user--but still no admin access.

The pp_usergroups shows a cpaccess of 1 for admin users, I specified the correct cookie, and there are no error messages. I am logged in as the Nuke admin but have no admin access for PP. Error message is "You are not a valid administrator or moderator! "

Any ideas, guys? I'm running PHP-Nuke version 7.5, with security patches in place from Chatserv. Love the software, but I can't use it on production sites without Nuke integration.

Chuck S · April 10th, 2005, 05:36 PM

Is your cookie settings in place? Note in Nuke we integrate with the nuke login and the usergroups come from the forum usergroups so if your an admin of the forum your an admin of photopost

You can PM me site urls and admin access as well as link to phpmyadmin and I can ponder what your specific issue is. If usergroups are set right I would think your cookies are not set right and your not truly logged in but we shall see

Ilse · April 11th, 2005, 01:38 PM

Quote:

Originally Posted by omegatron

Is your cookie settings in place? Note in Nuke we integrate with the nuke login and the usergroups come from the forum usergroups so if your an admin of the forum your an admin of photopost

You can PM me site urls and admin access as well as link to phpmyadmin and I can ponder what your specific issue is. If usergroups are set right I would think your cookies are not set right and your not truly logged in but we shall see

Okay, I think I may have a point:
Here's the thing with Nuke. The Admin/moderator of the Forums is NOT the admin/moderator of the site: in Nuke I'm the administrator with username Admin. I can access the forums administration via the administration panel in Nuke, but I can't moderate the forums. I need to be logged in as Ilse (my personal account on the site), to be able to do that. Maybe that's why I can't login in Photopost as an admin and I don't have the admin rights as a normal user?

Also, I have changed the path of the forum to the real path of the forums (instead of the mainpart of the site, seen that Nuke is more then just a forum) but it doesn't help one bit. I keep getting the same error. I just really don't know what to do anymore.......

I've PM-ed all my details to you Omegatron.

Thanks for all the help!

Regards,
Ilse

Chuck S · April 11th, 2005, 01:52 PM

Correct this is your issue. Ilse exists in the mysql table

When you installed nuke you did not select for the Admin user to be an admin of the forum hense there is not even a mysql entry in your nuke user table for use to authenticate. Admin simply does not exist. If you login with Ilse I am sure you will see a admin link.

Ilse · April 11th, 2005, 01:59 PM

At first I didn't, but I figured out I had to login at the Nukepart as Ilse (and not also as the admin....) and then I can go to the gallery and access the admin. The fact I can be logged in as both admin and Ilse on the Nuke part, seemed to be the problem.

Thanks for all the help! Now I can finally start to adjust everything to my needs.

Regards,
Ilse