Not logged in, can't view categories.

damon18 · February 9th, 2007, 07:39 PM

I'm making progress, but ran into a snag. After adding a few categories and a couple of test ads noticed that if you try to click on a category while not logged in, I get an error

Code:

Content visible to verified customers only.

It's the same for any category, but oddly, if you click on one of the "recent ads" at the bottom, you can view full ads without being logged in.

Test at http://www.cheapsailing.com/pp_classifieds
to login as a user
testing
testing

Chuck S · February 10th, 2007, 11:09 AM

You should get that error logged in or out I would think but the issue here is why are you getting it and what is the error

What do you get if you view the category while logged in as admin?

damon18 · February 10th, 2007, 05:26 PM

Quote:

Originally Posted by Chuck S

What do you get if you view the category while logged in as admin?

Everything works when logged in as Admin or as a regular user. No errors that I can find. When not logged in, I get the error when clicking on any category that is set to contain ads.

The two top cateogries are set to "Contains Ads - No" and display correctly the list of subcats, but when any of the subcats are clicked the error is displayed instead of the category contents.

Chuck S · February 10th, 2007, 06:23 PM

Is this an upgrade you did or new install cause I can not say where the error is.

You can try making an edit and lets see what your error is

In admin global options turn on debug to DISPLAY ERRORS

Then edit your pp-inc.php file and delete the part in bold for line 408

Code:

Content visible to verified customers only.

change it to this

Code:

Content visible to verified customers only.

damon18 · February 10th, 2007, 07:26 PM

Ok, that's done. I didn't see anything in bold in your message, but I think I know the change you wanted, to be able to see error messages when not logged in. I had already set the global option to display errors, but of course their wasn't an error when logged in.

If it helps, I'm running MySQL 4.1.18 and PHP Version 4.4.2

damon18 · February 10th, 2007, 07:35 PM

Also, forgot to say it's a fresh new install. The only file change was the change to postnuke.php you had me make.

Chuck S · February 10th, 2007, 07:39 PM

Quote:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT c.id,c.catname,c.template,n.userid FROM cp_categories c LEFT JOIN cp_notify n ON (n.userid= AND n.product=c.id AND n.type=1) WHERE c.id=9

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND n.product=c.id AND n.type=1) WHERE c.id=9' at line 3

Database handle: Resource id #7

Well I can not say what your userid variable is empty but you can get rid of that error by editing showcat.php and line 248 can be this

Code:

Content visible to verified customers only.

damon18 · February 11th, 2007, 11:12 PM

That worked, do I still have a usergroups problem? Or was this a bug? What user ID were "not logged in" visitors supposed to have?

Chuck S · February 12th, 2007, 10:31 AM

They are suppose to be userid 0 if not logged in which is why I said what I said. Anyway the edit I provided would solve the mysql issue if it is not passed.

damon18 · April 13th, 2007, 10:18 AM

I just installed a fresh copy of 2.61 using the Postnuke integration. After installation I checked the cp_usergroups table and see my three Postnuke groups, plus a Guest group with a userid of 100.

Should I change this to 0? Or is this a change with the new version?

Thanks for the update,

Damon

Chuck S · April 13th, 2007, 04:26 PM

http://www.cheapsailing.com/pp_classifieds/index.php

Your site does not exist at least this is what I see

No guests should be 100 and is a placeholder account since Nuke doesnt really have a guests account