hideCategories

[scatzc]

The solution for this is posted TWICE in this thread..

Thanks are you referring to this?

http://www.zen-cart.com/forum/showpo...&postcount=224

[scatzc]

OK I think that I found it:
http://www.zen-cart.com/forum/showpo...2&postcount=94

It turns out that I was using the wrong keyword in the Thread Search: It should be "site map", not "sitemap".

[DivaVocals]

OK I think that I found it:
http://www.zen-cart.com/forum/showpo...2&postcount=94

It turns out that I was using the wrong keyword in the Thread Search: It should be "site map", not "sitemap".

Ummmm okay..

FYI.. Dunno if you noticed, but this thread is quoted in the post you just asked about earlier..

[lextechs]

I am using the css_horizontal_dynamic_menu mod, how do i make the hidden categories mod work with the css_horizontal_dynamic_menu mod. I have followed the instruction with the Hidden categories mod however the category that i want to hide still shows up. Any idea?

[DivaVocals]

I am using the css_horizontal_dynamic_menu mod, how do i make the hidden categories mod work with the css_horizontal_dynamic_menu mod. I have followed the instruction with the Hidden categories mod however the category that i want to hide still shows up. Any idea?

This is probably best asked in the support thread for the menu mod, but you would have to take a look at the query that drives the categories in the menu and adjust it so that it excludes the hidden categories..

[lextechs]

This is probably best asked in the support thread for the menu mod, but you would have to take a look at the query that drives the categories in the menu and adjust it so that it excludes the hidden categories..

I do not want to double post the question, is anyone using both these mod together.

[DivaVocals]

So if you go to these links you get the errors in the queries as shown:
http://www dot hairisle dot com/products_new
Quote:

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 ]

http://www dot hairisle dot com/products_all
Quote:

1054 Unknown column 'p.master_categories_id' in 'on clause'
in:
[select count(p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id), zen_products_description pd LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id) WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 ]

This did not occur on the dev site as you can see:
http://clients dot overthehillweb dot com/hairisle/products_new
http://clients dot overthehillweb dot com/hairisle/products_all


I've been doing a LOT of searching of this forum and Googling, and my research indicates that this might be an issue with the on clause of the left join.. This post was very helpful in nundging me inthe right direction. It reads in part:
http://www.zen-cart.com/forum/showpo...47&postcount=6
Quote:

The real culprit is Mysql data base queries. Once your host upgrade sql database to 5.x, you need to fix your sql queries...

So I took a look at both dev and the live site and yes indeed they are on different versions of mySQL. (thought my server was running 5.x.. it's not... I'll deal with that later this week)

DB Versions:
hairisle dot com - Database: MySQL 5.0.81-community-log
clients dot overthehillweb dot com/hairisle - Database: MySQL 4.1.22-max-log

So I think I have a grasp on WHAT the issue is, and if I can get some assistance to what the corrected syntax for these queries should be, I should be good to go in correcting the queries for these pages..

I am hoping a s_mack can pop in to help.. YES I read other threads on this error.. Unfortunately the queries are different, and I can't make the leap to figure out how to correct the syntax of this query based on some of the other threads.. Hope someone will take pity on me and help..

[DivaVocals]

Please see this post for the solution I am trying out to resolve the mySQL v5 issue: http://www.zen-cart.com/forum/showpo...8&postcount=14

If you want to read this full thread:
http://www.zen-cart.com/forum/showthread.php?t=139864

I'm still testing to make sure this doesn't break other aspects of the hideCategories add-on. So far so good.. Your mileage may vary.. I also plan to test if this "fix" will work with mySQL v4.x as well.. If I get a different result, I will share those findings as well.

So if you go to these links you get the errors in the queries as shown:
http://www dot hairisle dot com/products_new
Quote:
http://www dot hairisle dot com/products_all
Quote:
This did not occur on the dev site as you can see:
http://clients dot overthehillweb dot com/hairisle/products_new
http://clients dot overthehillweb dot com/hairisle/products_all


I've been doing a LOT of searching of this forum and Googling, and my research indicates that this might be an issue with the on clause of the left join.. This post was very helpful in nundging me inthe right direction. It reads in part:
http://www.zen-cart.com/forum/showpo...47&postcount=6
Quote:
So I took a look at both dev and the live site and yes indeed they are on different versions of mySQL. (thought my server was running 5.x.. it's not... I'll deal with that later this week)

DB Versions:
hairisle dot com - Database: MySQL 5.0.81-community-log
clients dot overthehillweb dot com/hairisle - Database: MySQL 4.1.22-max-log

So I think I have a grasp on WHAT the issue is, and if I can get some assistance to what the corrected syntax for these queries should be, I should be good to go in correcting the queries for these pages..

I am hoping a s_mack can pop in to help.. YES I read other threads on this error.. Unfortunately the queries are different, and I can't make the leap to figure out how to correct the syntax of this query based on some of the other threads.. Hope someone will take pity on me and help..

[s_mack]

Nope, can't help. Sorry.

I'm no MySQL expert by any stretch of the imagination and I have no idea what's up with your situation. Best of luck though.

[DivaVocals]

Nope, can't help. Sorry.

I'm no MySQL expert by any stretch of the imagination and I have no idea what's up with your situation. Best of luck though.

Not a problem.. It's a mySQL v5.x compatibility issue with one of the queries in this add-on..

See my post above yours.. I am already working out testing a fix which appears to have resolved the issue.. Looks like one file contained the second left join statement which caused the query to fail (hence the error message). Thanks to DrByte and a friend who both pointed out that this was the cause for the error, I searched the code and found where the second left join was coming from.. Gonna test on mySQL v4.x as well since as I understand things the second left join isn't needed anyway..