Loaded Commerce Community

Hi,

When a guest user clicks on add to basket on a product, the resulting page says: THe page you are trying to view is restricted.

Not sure where this is coming from, all the products are set to allow guest, retail and wholesale users.

anyone have any ideas?

Thanks

So you're using 6.2 B2B right (which patch - hopefully the latest) and both the category and product Access Group boxes are ticked for Guest? If you're using the cre seo url mod switch it off and try it again. Do all groups mentioned show in Admin >> Customers/Orders >> Customer Groups.

If it is old code then have a look at /catalog/index.php for this:

and change it to this:


Simon

actually my mistake, I'm actually using 6.4.1 b2b and the cre seo is turned off.

Right, so checked in /debug and on server error logs for reoccurring errors related to customer groups?
The logic for the 'restricted' page showing basically involves checking if the product has the 'G' customer group in the products_group_access column of the products table or not. In your case, it appears not to - ie the category itself hasn't got guest group access pushed to it and its subcategories.

#1 - check admin >> catalog/product >> categories concerned - do they have ticks in the Guest access boxes and have these been pushed through the subs as well?

#2 - check dbase - if there's are missing entries in the products table for products_group_access (in particular the letter G in this column) and products_nav_access column; customer groups table (ie no G mentioned anywhere)

Simon

Hi,

No both fields are correct in the database, and just to be sure I ran
UPDATE categories SET products_group_access = "G,0"
and
UPDATE categories SET products_nav_access = "G,0"

to no avail

Right, but that's just the categories table ... checked the products table? Customer groups table?
Several tie in on this customer groups access thing, not just the categories.

Simon

your right, that should be products....

I'm bailing on this - cart version change, change of actual table. Not sure if you're up on what you're doing there. This issue could be solved by someone with experience in probably 10 minutes looking at your database - not solvable when info keeps changing in posts.

Good luck!
Simon

When info keeps changing.... seriously....

I'll admit I made a mistake with the original version of cre I was dealing with, but I'm just trying to say both the products and categories tables are both set to G,0 on all items on those fields.

I resent your post and I'm sure a cre loaded expert could fix it in seconds.... why do you think I'm posting here! I'm a more then capable php developer, but I'm being forced to integrate a CRE system that the client decided on and basically just trying to get in and out with as little damage as possible.

Resent all you like - it's all free. Makes it difficult to assist with little info or background - who knows if the cart has other mods to it? Perhaps the dbase has been corrupted? There are many bugs in Cre, but this isn't generally one of them - if you check the /catalog/product_info.php file you'll see the conditional.

If you're a developer then you've probably tried adding a new category and seen if you can reproduce the error as a guest. There's not a lot in your posts that indicates any results of steps you've taken yourself.

Good luck!

Simon

In restricted area on add to cart ONLY (ie, product is correctly visible before adding to cart, but not visible afterwards) look for something changing the customers group access or session data during execution of the add.

This would generally be located in application_top.php. A check of the code against stock code may turn this up pretty quickly.

Generally, this type of problem affects more than just add to cart, and can be fixed by getting the data lined up correctly, as Simon mentioned. In doing this, make sure the group the customer belongs to exists, and has valid entries in the product table, and in each relevant category table entry as well.

David