trying to integrate PPClassifieds with PostNuke .075 user registration.

jim6763nva · March 17th, 2005, 11:40 PM

Please help...

I have PPClassifieds 2.11 installed however when I login I can't get it to recognize me as an administrator. What do I need to do or how can fix this?
I'm attempting to integrate it with the PostNuke .750 user registration.

Jim

Chuck S · March 18th, 2005, 08:25 AM

Hello

I dont see anything out of line as in the admin user must be usergroup 2 from the postnuke membergroup table for the userid

However I did update the postnuke.php file to use the postnuke cookie instead of writing a photopost cookie as the old postnuke file in classifieds requires you to login to classifieds to be recognized as it doesnt read that your logged in at the forum. Something I rewrote for Photopost 4.8.2 or 4.8.6

Try this file and you should be logged in when logging in through your forum. Rename the file attached here from a txt file to php extention and upload to your forums subdirectory under classifieds overwriting the one present there

jim6763nva · March 18th, 2005, 10:55 AM

Ok I uploaded that file and tried it however I'm still getting the same results,
"You are not a valid administrator or moderator!", when logging in or switching from postnuke to pp classifieds adm-index.php. It's like the $User["UserEdit"] or $User["Moderator"] array indexes are not getting updated or something.

jim6763nva · March 18th, 2005, 11:07 AM

is there anything I should look at that would help to diagnose what is causing the problem? My config files? List of tables? Sample data?

I'm flexible

Chuck S · March 18th, 2005, 11:17 AM

well the build has been updated to reflect my changes with reading the postnuke cookie

I think you might have a php problem that came into existance with 4.3.10

Find this

$gologin = 1; $usergroup = 0; $checkpass = 0;
$ueditpho = 0; $ueditposts = 0; $useruploads = 0; $usercomment = 0;
$diskspace = 0; $uploadsize = 0;
$md5cookpass="";
$sessionid = "";

add below this

$ubbgroups = array();

jim6763nva · March 18th, 2005, 12:13 PM

What kind of php problem? It's not just my remote web hosting service where I'm having the problem. It's happening locally too and I have PHP v4.3.9.

Anyway, That didn't work either. I put this

Code:

Content visible to verified customers only.

right below this:

Code:

Content visible to verified customers only.

in the postnuke.php file... or is it supposed to go in another file? or multiple files?

jim6763nva · March 18th, 2005, 03:09 PM

I did a little digging and it appears to me that my Admin account in PostNuke is not being authenticated correctly in the authenticate function in postnuke.php. It looks like it's querying against the pp_usergroups table. I checked that table, and there's nothing in there. Also if you look at the following code in postnuke.php:

Code:

Content visible to verified customers only.

Shouldn't the part that reads:

Code:

Content visible to verified customers only.

and...

Code:

Content visible to verified customers only.

be:

Code:

Content visible to verified customers only.

and...

Code:

Content visible to verified customers only.

instead?

Ideas?

Chuck S · March 18th, 2005, 03:20 PM

Yes the file should be updated in the build and yes $ubbgroups is correct

jim6763nva · March 18th, 2005, 03:24 PM

Ok I must have an old build or where these updates made in the file you attached? If I need a new build, where do I go to download the new files?

Thanks,

Chuck S · March 18th, 2005, 03:31 PM

I stated in my second post in the thread we updated the build to reflect changes. You would download classifieds again and upload the postnuke.php file there

jim6763nva · March 18th, 2005, 03:37 PM

Ok Thank you. I'll give that a shot.

jim6763nva · March 18th, 2005, 04:04 PM

I downloaded the new build of 3/10/2005 according to the timestamp. Installed everything from scratch just to make sure. Still can't access the admin screens.
Not recognized as an administrator.

Chuck S · March 18th, 2005, 04:20 PM

Michael did not update the build it looks like

try this one

jim6763nva · March 18th, 2005, 04:27 PM

Ok Thanks. Will try that. Before I do though I wanted to mention that I'm in the process of doing another clean install. I've dropped all pp tables and rerunning the install script. I am in the Step 5 screen and in the upper left corner of the screen I am getting 2 errors that read:

Error: Column count doesn't match value count at row 1
Error: Column count doesn't match value count at row 1

jim6763nva · March 18th, 2005, 04:55 PM

After downloading your last attachment and copying it over to the pp forums folder, I again reran the install script. When Step 5 screen comes up I get 2 errors that read:

Error: Table 'ncdb.usergroups' doesn't exist
Error: Table 'ncdb.usergroups' doesn't exist

In Step 4, I selected:

Forum Integration: PostNuke
Email Address: admin@nova-classifieds.com
URL to forum directory: http://localhost/html (where I have postnuke installed)
Forum database prefix: nuke_
Forum Cookie prefix: I've tried pnPHPBB2mysql, pnPHPBB2mysql_data, POSTNUKE, and POSTNUKESID
WebSite Name: NOVA-Classifieds.com
WebSite URL to homepage: http://localhost/html
URL to Photopost main script directory: http://localhost/pp

Step 5 I set:
Server Path to Forum: ./forum
Server Path to PP Directory: .

URL to your forums http://localhost/html
URL to PhotoPost http://localhost/pp
URL to your PhotoPost DATA directory: http://localhost/pp/data
PhotoPost Database Table Prefixes: pp_

VB3, VB2 and VB2PORTAL integration I left "Off"

Still comes up with : "You are not a valid administrator or moderator!" when attempting to access the adm-index.php

Chuck S · March 18th, 2005, 04:56 PM

Using phpmyadmnin what usergroup inserts are under the classifieds usergroup table?

jim6763nva · March 18th, 2005, 05:08 PM

Quote:

Originally Posted by omegatron

Using phpmyadmnin what usergroup inserts are under the classifieds usergroup table?

I noticed that there were two tables created when PP Classifieds was installed:
1. pp_usergroups
2. usergroups

Both tables have no records.

jim6763nva · March 19th, 2005, 10:41 AM

Quote:

Originally Posted by omegatron

Using phpmyadmnin what usergroup inserts are under the classifieds usergroup table?

I still haven't solved the problem, but I wanted to point out some additional testing and discoveries I've found in the postnuke.php file, particularly in the authenticate function:

I'm not sure what is causing this but I found that in the pn_session_info table
pn_uid field was empty which was causing the following query on or around line 242 to return nothing of value:

Code:

Content visible to verified customers only.

After I filled in the necessary value in the pn_uid field, the above query ran fine however the code on or around line 250 did not seem to work in assigning the record values to the variables:

Code:

Content visible to verified customers only.

when I assigned the result from mysql_fetch_row() to a variable, then assigned the variable content to the list function, both values where parsed out.

Code:

Content visible to verified customers only.

On or around like 282, look for the following code:

Code:

Content visible to verified customers only.

I'm not sure where you are getting $usergroups from. It does not appear to be a global variable. When I commented this line out, everything else in this code seemed to work ok, and although I stopped getting the "... not a valid adminstrator..." message, all I get now is a blank screen.

Hopefully something that I've mentioned here will help. If there is anything else I can do or look up, please let me know.

Thank you for your assistance in this!
Jim

Chuck S · March 19th, 2005, 10:49 AM

Jim

Delete the install and try again with this file

You have no usergroup inserts so of course your not gonna have admin access or noone have any access

jim6763nva · March 19th, 2005, 12:59 PM

Nope, still not importing the usergroup data. I'm still getting a partial error message during the transition from step 4 into step 5 as I've indicated in the attached file. I believe the reason (or at least part of the issue) that data is not getting imported is due to lines 376 - 377 in the postnuke file that look like this:

Code:

Content visible to verified customers only.

1. There are single quotes around the data in column 1 which is a numeric id field (both queries)
2. There also appears to be a field missing. There are 12 field values in this query and 13 fields in the table.

On lines 421 - 422 the same occurs as above however this query appears to have the correct number of field values.

Code:

Content visible to verified customers only.

I suspect that the error during the install is originating between lines 1017 - 1036 in install.php.

Hth,
Jim