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
Hi I fixed this issue
components/com_comprofiler/plugin/user/plug_cbjdownloads/jdownloads.php
Change Line 98 to:
$database->setQuery("SELECT id FROM #__jdownloads_groups_backup WHERE FIND_IN_SET($my->id, groups_members)");
Change Line 103 to:
$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:
$query2 = "SELECT `cat_title` FROM `#__jdownloads_cats_backup` WHERE `cat_id` = $resutlt->cat_id";
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
QuoteError: 500
View not found [name, type, prefix]: viewdownload, html, jdownloadsView
The current URL is
Quote
URL/index.php?option=com_jdownloads&Itemid=&view=viewdownload&catid=2&cid=14
The correct url i believe should look like this:
QuoteURL/index.php?option=com_jdownloads&view=download&id=15:test2&catid=3&Itemid=169
Thanks for any help
Ok the fix for this issue is
components/com_comprofiler/plugin/user/plug_cbjdownloads/jdownloads.php
Line approx 219:
$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:
$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>";