jDownloads Support Forum

Hey,

I use this plugin: http://extensions.joomla.org/extensions/extension/site-management/seo-a-metadata/seosimple
I have a new installation of 3.2 version of jdownloads with Joomla 3.4.1
I created a category "test"
-> I can open up category test
I add a document
-> can`t open receiving a 404

function
category->getItems
dispatcher -> trying to invoke simpleseoplugin
Status: 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 '' at line 1 SQL=SELECT cat.description FROM jos_categories cat WHERE cat.id=

Fix is to deactivate SEOSimple or set attributes in plugin
Frontpage Meta Desc:Generate from content
Category Meta Desc:Generate from content


Hope this helps
Thanks for the great component

pharindoko

Hi pharin,
thanks for the post. But why think you that this is a bug in jDownloads?

This plugin tried to get data from  jos_categories for links in jD. But jD used an own category table (_jdownloads_categories).

SEOSimple:
       if ($view == 'category' && $catdesc == 0) {
$db1 = &JFactory::getDBO();
$catid = JRequest::getVar('id');
$db1->setQuery('SELECT cat.description FROM #__categories cat WHERE cat.id='.$catid);  
             $catdesc = $db1->loadResult();
if ($catdesc) { $thecontent = $catdesc; }
}

So maybe should you contact the developer from the SEOSimple plugin.

thanks for this solution!!