Hi!
Firstly, thanks for writing this component. As you can see, there was a need for it. I'm modifying it a little for our needs and have come across a bug if the table prefix is not jos_ (e.g. mine is mos_ from Mambo days).
File: jombib.php
Line: 506
Old:
$database->setQuery("SELECT COUNT(#__bib.authorid) from #__bib left join #__bib_auth on #__bib.authorid=#__bib_auth.id left join jos_bib_categories on jos_bib.authorid=jos_bib_categories.id ".$andfilter);
New:
$database->setQuery("SELECT COUNT(#__bib.authorid) from #__bib left join #__bib_auth on #__bib.authorid=#__bib_auth.id left join #__bib_categories on #__bib.authorid=#__bib_categories.id ".$andfilter);
and Line: 562
Old:
$database->setQuery("select #__bib.*,#__bib_auth.last from #__bib left join #__bib_auth on #__bib.authorid=#__bib_auth.id left join jos_bib_categories on jos_bib.authorid=jos_bib_categories.id ".$andfilter." order by ".$orderby, $limitstart, $limit );
New:
$database->setQuery("select #__bib.*,#__bib_auth.last from #__bib left join #__bib_auth on #__bib.authorid=#__bib_auth.id left join #__bib_categories on #__bib.authorid=#__bib_categories.id ".$andfilter." order by ".$orderby, $limitstart, $limit );
Thanks again,
akame
