I’ve recently started using the Wordbook module. I am using Version 1.16.

I encountered a problem with letter.php where a request to show all entries had no results.

It seems as though this was corrected in Wordbook v1.17 RC 1. However, I can’t find a download for v1.17 anywhere.

In searching the forums I found references to a replacement module called Lexikon but I can’t find a download for this module anywhere.

So I decided to figure out what was wrong with letter.php.

I’m posting the resolution here in case there are others who are using Wordbook v1.16.

Line 74 in letter.php reads:

$queryA = "SELECT w. * , c.name AS catname FROM ".$xoopsDB -> prefix( 'wbentries' )." w LEFT JOIN ".$xoopsDB -> prefix( 'wbcategories' )."c ON w.categoryID = c.categoryID WHERE w.submit = '0' AND w.offline = '0' ORDER BY w.term ASC";

There is a space missing before “c ON w.categoryID”.

The statement should be:

$queryA = "SELECT w. * , c.name AS catname FROM ".$xoopsDB -> prefix( 'wbentries' )." w LEFT JOIN ".$xoopsDB -> prefix( 'wbcategories' )." c ON w.categoryID = c.categoryID WHERE w.submit = '0' AND w.offline = '0' ORDER BY w.term ASC";

Thank you so much for that fix. :)