kmgalanakis / Inceptive-Multiple-Categories-for-K2

Inceptive Multiple Categories for K2 is an easy way to assign multiple categories to K2 items without hacking the K2 core.
0 stars 5 forks source link

Cant Manually Sort K2 items #9

Closed PixelPerfectCreative closed 6 years ago

PixelPerfectCreative commented 6 years ago

Hi there, I can no longer do a manual sort of my K2 items. When I click on the arrows to be able to sort them I get an error. You can see in the image below what is happening. If I turn on Inceptive Multiple Categories, I can then sort normally, with no error. I brought this up on the K2 forum and they suggested I contact you first... https://www.joomlaworks.net/forum/k2-en/48473-user-ordering#165312

I am using this for my largest client and they need to be able to sort the items, AND have multiple categories. They have over a thousand items, so switching so another plugin, or hacking the code to achieve this would be a huge ordeal.

Any help would be greatly appreciated.

Thanks!

3zhwe0ug

PixelPerfectCreative commented 6 years ago

Any chance of getting help here? Thanks in advance for any update.

bositman commented 6 years ago

In incptvk2multiplecategories.php , on line 82 try replacing $query = str_replace("ORDER BY i.catid","ORDER BY mc.catid",$query); with $query = str_replace("ORDER BY i.catid","ORDER BY mc.catID",$query);

kmgalanakis commented 6 years ago

@PixelPerfectCreative, @bositman suggestion seems to be correct, have you tried it yet? Did it solve your issue?

franco2mada commented 6 years ago

has the same problem; the solution from @bositman works

In incptvk2multiplecategories.php , on line 82 try replacing $query = str_replace("ORDER BY i.catid","ORDER BY mc.catid",$query); with $query = str_replace("ORDER BY i.catid","ORDER BY mc.catID",$query);

kmgalanakis commented 6 years ago

This is fixed by https://github.com/kmgalanakis/Inceptive-Multiple-Categories-for-K2/commit/0e890d0578cff3d0746430fa63327c164df7e0dd.

I'm closing this.