Forums / Setting Up Categories, Products, Attributes / moving categories glitch??

moving categories glitch??

Locked

Views: 1,053

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
5 Jul 2010, 11:17 PM
#1
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

moving categories glitch??

Hello all,

I've used the 'Move' function in Zen Cart admin to move a category.
My question... Why are both categories still viewable via a web browser?:huh:

Old Category
http://www.kcbgraphics.com/index.php?main_page=index&cPath=11_5_34

New Category
http://www.kcbgraphics.com/index.php?main_page=index&cPath=11_34

In my admin the old category isn't there.
Any ideas would be appreciated. Thank you.

6 Jul 2010, 12:53 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: moving categories glitch??

It looks like you have:

1 Categories and Products mixed in the same Category

2 Missing master_categories_id from the Products

3 Combination of both

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Jul 2010, 1:43 AM
#3
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

Re: moving categories glitch??

Thank you for the reply Linda,

Ajeh:

It looks like you have:
1 Categories and Products mixed in the same Category

There is only products in this category as far as I can see.

Ajeh:

It looks like you have:
2 Missing master_categories_id from the Products

All of the products have an ID# in the left column.

I moved this category from:

Signs and Banners
_Outdoor Signs
__Vinyl Banners

to

Signs and Banners
_Vinyl Banners

Could it be caused by moving it across two sub categories?

6 Jul 2010, 2:41 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: moving categories glitch??

It shouldn't ...

You need to check the master_categories_id on the products ...

Also check the products_to_categories table and see what products_id are in the two categories_id ...

Again, you should not have Products and Categories inside of a Category ... a Category holds 1 or the other ...

What version of Zen Cart are you using?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Jul 2010, 2:46 AM
#5
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

Re: moving categories glitch??

Thanks for the reply,

When I check the tables you mention what exactly am I looking for and how would I correct the issue?

I moved the category back to its original location and the reverse happens. The path to the new location is still accessible via browser but in the admin it doesn't exist.

A week ago I upgraded to 139d.
I notice in the bugfix list for 139a it mentions....

-Fix category look up to use master_categories_id
-Fix categories name lookup based on product master_categories_id vs random categories_id from products_to_categories

Could it be connected to this?

6 Jul 2010, 3:01 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: moving categories glitch??

It could be, but that means you would have missed the corrected file(s) in both upgrading to v1.3.9a and v1.3.9d ...

Do you use Linked Products?

What categories_id are the Products in right now? It appears that they are in categories_id 34 ...

If you look in categories_id 34 of your Zen Cart Admin ...

Signs and Banners :: Vinyl Banners

To you see Categories and Products?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Jul 2010, 12:35 PM
#7
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

Re: moving categories glitch??

Thanks for the help on this!

Ajeh:

It could be, but that means you would have missed the corrected file(s) in both upgrading to v1.3.9a and v1.3.9d ...

The upgrade wasn't done by me. I do notice not all of the files have changed. Do you know which file would be related to this issue?

Ajeh:

Do you use Linked Products?

I do.

Ajeh:

What categories_id are the Products in right now? It appears that they are in categories_id 34 ...

If you look in categories_id 34 of your Zen Cart Admin ...

Signs and Banners :: Vinyl Banners

To you see Categories and Products?

In Zen Admin they're all in Category_id 34. I also confirmed that's the case in phpMyadmin.

6 Jul 2010, 1:39 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: moving categories glitch??

While I can manually type the wrong path by changing the cPath in the URL, I do not see where there is a link produced to generate both links ...

Are you only able to get to the incorrect link by manually changing the URL or is this link being generated somewhere on your site?

Example: I can manually make any URL manually for any Category and get results, providing the ending categories_id on the cPath is valid:
/index.php?main_page=index&cPath=8_34

I still get the products in categories_id 34

Even something like this would work:
index.php?main_page=index&cPath=9999_34

It is not correct, but it will produce the results of categories_id 34 Products ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 Jul 2010, 1:49 PM
#9
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

Re: moving categories glitch??

Hi Ajeh,

The category for vinyl banners does not contain linked products.

I can type cPath=anynumber_34 and get to that category. I can do that to any category and it works. That being said can I just ignore this issue and move my categories and do my 301 redirects??

I discovered this when I moved the category went to Google found the old link and clicked on it. It took me to the old page location without any error.

6 Jul 2010, 4:48 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: moving categories glitch??

Correct ... there is nothing "forcing" the cPath to be correct when manually changing the URL or coming in on an old URL ...

So if you have redirects for this you can apply them ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Jul 2010, 10:57 PM
#11
kcb410 avatar

kcb410

Zen Follower

Join Date:
Dec 2008
Location:
Toronto
Posts:
348
Plugin Contributions:
0

Re: moving categories glitch??

Ajeh:

Correct ... there is nothing "forcing" the cPath to be correct when manually changing the URL or coming in on an old URL ...

So if you have redirects for this you can apply them ...

Thank you for your help on this Linda.