Css Flyout Categories Menu troubles

Quote:

---

Originally Posted by takspeed

Where did you find the previous version? Could you please make it available online somehow?

---

This is the one I used hope it helps
http://www.zen-cart.com/archived_con...categories.zip

Quote:

---

Originally Posted by waddtown

This is the one I used hope it helps
http://www.zen-cart.com/archived_con...categories.zip

---

Hmm, I'm heving even less luck with this one! It says:

Code:

---

1064 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 cd.language_id = '1' order by c.parent_id, c.sort_or' at line 8
in:
[select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd, product_types_to_category ptc where c.categories_id = cd.categories_id and c.categories_status=1 and c.categories_id = ptc.category_id and ptc.category_id = cd.categories_id and ptc.product_type_id not in and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name]

---

I'm on mysq5, which my (probably) most hosts are going to soon, so I don't want to work backwards towards legacy apps. Hmmm. I'll see if I can figure this out!

Well, it's been about 2 hours of winmerge and general tweaking, and I can't get it going! I commented out the lines in categories_ul_generator.php below the line which said //DEBUG: These lines will dump out the array for display and troubleshooting:

And nothing was dumped. But that file is clearly being picked up, as it throws errors when I make a typo.

I switched to php4, and that was the same result. So it must be mysql. But I don't want to have to install and old version of sql to make it work locally, when it's going to break on my host!

I wonder what the difference in calls is?

I have to admit, I'm a bit stumped now. Anyone else want to take it on?!

Quote:

---

Originally Posted by kelvyn

Hmm, I'm heving even less luck with this one! It says:

Code:

---

1064 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 cd.language_id = '1' order by c.parent_id, c.sort_or' at line 8
in:
[select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd, product_types_to_category ptc where c.categories_id = cd.categories_id and c.categories_status=1 and c.categories_id = ptc.category_id and ptc.category_id = cd.categories_id and ptc.product_type_id not in and cd.language_id = '1' order by c.parent_id, c.sort_order, cd.categories_name]

---

I'm on mysq5, which my (probably) most hosts are going to soon, so I don't want to work backwards towards legacy apps. Hmmm. I'll see if I can figure this out!

---

I got the same problem when I installed the old version over the new version. Didn't have time to do anything more than back-out the change though.

Same here, the old version doesn't work either. I am running Zencart 1.3.0.1. This latest version seems to be the common denominator to the failures.

Quote:

---

Originally Posted by kelvyn

Well, it's been about 2 hours of winmerge and general tweaking, and I can't get it going! I commented out the lines in categories_ul_generator.php below the line which said //DEBUG: These lines will dump out the array for display and troubleshooting:

And nothing was dumped. But that file is clearly being picked up, as it throws errors when I make a typo.

I switched to php4, and that was the same result. So it must be mysql. But I don't want to have to install and old version of sql to make it work locally, when it's going to break on my host!

I wonder what the difference in calls is?

I have to admit, I'm a bit stumped now. Anyone else want to take it on?!

---

Same issue here ... and I'm on php 4.4/MySQL 4.1 :cry: . I'm doing some digging, it's got to be where the script tries to pickup and use the categories (can't remember the exact file.) I'm going to play around a bit more with it. So far the only real addon I've installed is the Image Handler v2.

I'm very new to zen cart so it'll probably take me some time to figure out everything. Luckly my site isn't live yet so I've got some time to play with this. If this gets working, it seems like it's far superior to the out-of-box category presentation.

Quote:

---

Originally Posted by sbuttgereit

If this gets working, it seems like it's far superior to the out-of-box category presentation.

---

Oh yes!(1.2.7- hence why it's working - sorry about the colour scheme - not my fault!)

I am trying to use it on 1.2.7 as i mentioned in the first post and it is not working for me. But it is working on my local server where i do my testing. Local server is windows web server is linux not sure if that has anything to do with it.

Quote:

---

Originally Posted by landshark

I am trying to use it on 1.2.7 as i mentioned in the first post and it is not working for me. But it is working on my local server where i do my testing. Local server is windows web server is linux not sure if that has anything to do with it.

---

Nope don't think it's that by itself either... My test setup is Apache 2.2/PHP5/MySQL 5 running on WinXP and production is Apache 1.3/PHP4/MySQL 4.1 running on Linux. Zen Cart is 1.3.0.1 in both cases...same result: stylesheets look like they're there but no category data seems to be getting passed from the object instantiated to go get it. Now, I've created custom versions of the 'classic' template that ships with Zen Cart; the only modifications I have made in that regard are changes to the CSS files. I have install Image Handler 2.

Kelvyn: Nice site and yes, this CSS flyout stuff makes a real difference. On a side note, my current Zen Cart project is a side business I'm involved in; My day job, if you will, is actually working for a chain of party stores here in the US called Party America... so I know those product lines way too well for my own good! :blink:

We have a solution! Many many MANY thanks to Paulm! Paul? Come and take a bow!

Anyway, the fix is to change line 48 in includes\classes\categories_ul_generator.php to

PHP Code:

---

from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd 


---

I've attached the corrected file. (note: change extension to .php)