jDownloads CB Plugin for Joomla 3.1 3.1 SQL ERROR

[huwhuw]

Hi i upgraded from v.1.9 to v3.2.9 beta
The CB plugin gives this error when i click on the CB Profile.

Error: 1146

Table 'xxxx_xxxx.0jo_jdownloads_groups' doesn't exist SQL=SELECT id FROM xxx_jdownloads_groups WHERE FIND_IN_SET(849, groups_members)

Any ideas on a fix?
Thanks

[huwhuw]

Hi I fixed this issue
components/com_comprofiler/plugin/user/plug_cbjdownloads/jdownloads.php
Change Line 98 to:

Code Select Expand

$database->setQuery("SELECT id FROM #__jdownloads_groups_backup WHERE FIND_IN_SET($my->id, groups_members)");
Change Line 103 to:

Code Select Expand

$database->setQuery("SELECT cat_id FROM #__jdownloads_cats_backup WHERE published = 1 AND (cat_access <= '$access' OR cat_group_access IN ($in_groups))");
Change line 179 to:

Code Select Expand

$query2 = "SELECT `cat_title` FROM `#__jdownloads_cats_backup` WHERE `cat_id` = $resutlt->cat_id";

[huwhuw]

Hi Further testing shows there is still some errors with the CB plugin
http://www.jdownloads.com/index.php?option=com_jdownloads&Itemid=133&task=view.download&catid=27&cid=335

It seems when you click on the list of uploaded files from a Community Builder users profile with SEF turned off the URL generated is incorrect resulting in a 500 error

Error: 500

View not found [name, type, prefix]: viewdownload, html, jdownloadsView

The current URL is

URL/index.php?option=com_jdownloads&Itemid=&view=viewdownload&catid=2&cid=14

The correct url i believe should look like this:

URL/index.php?option=com_jdownloads&view=download&id=15:test2&catid=3&Itemid=169

Thanks for any help

[huwhuw]

Ok the fix for this issue is
components/com_comprofiler/plugin/user/plug_cbjdownloads/jdownloads.php

Line approx  219:

Code Select Expand

$return .= "\n\t\t\t\t <a href='".JRoute::_('index.php?option=com_jdownloads&Itemid='.$Itemid.'&view=viewdownload&catid='.$resutlt->//cat_id.'&cid='.$resutlt->file_id)."'>{$resutlt->file_title}</a>";

Change to:

Code Select Expand

$return .= "\n\t\t\t\t <a href='".JRoute::_('index.php?option=com_jdownloads&view=download&catid='.$resutlt->cat_id.'&id='.$resutlt->file_id)."'>{$resutlt->file_title}</a>";