The dreaded FLEXI_ITEM mysql_num_rows() problem

Hello community. I now have the dreaded FLEXI_ITEM problem. The only thing I know is that I only get it on the directory page (the page with all your categories and subcategories) of Flexicontent.

(This started happening when I still have 1.5.2 installed, btw. So I stopping using it, but now I want to get back into using FlexiContent)

I created a menu item to link to the Directory of the categories I have:[attachment=2:3e9x2nq7]<!-- ia2 -->flexidirectory1.jpg<!-- ia2 -->[/attachment:3e9x2nq7]

I made things simple after the upgrade to 1.5.4 just to check:[attachment=1:3e9x2nq7]<!-- ia1 -->flexidirectory2.jpg<!-- ia1 -->[/attachment:3e9x2nq7]

The Categories are published. I have added a couple of items to make sure. I do have custom fields, but they're like textarea and something else.

The individual page for the item works fine. Its just the DIRECTORY page that throws these two errors:
[attachment=0:3e9x2nq7]<!-- ia0 -->flexidirectory3.jpg<!-- ia0 -->[/attachment:3e9x2nq7]

??

I turned on Joomla's debug system, I saw more specifics:

500 - JDatabaseMySQL::query: 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 'AND c.access <= 2' at line 1 SQL=SELECT c.id FROM jos_categories AS c WHERE c.published = 1 AND c.section = 10 AND c.parent_id = AND c.access <= 2

do you change item deph to 0 to do some test ?

micker wrote: do you change item deph to 0 to do some test ?

Hi. Yes I did. When i first tried it, I had the item depth set to "root". I changed it to 1, then to 2 hoping that maybe it would work.

I also went to
admin > Tools > Clean cache
and
admin > Tools > Purge expired cache

I fixed the 2nd error. For some reason, my line 61 in default_categories.php looked like this:
...when I think it should look like this: (I'm not a php coder, but some of the other code looked like that, so I changed it)

I changed it and didn't see the 2nd error anymore. But I can't check to make sure that was the right change because I still have the 1st error.

I don't really know a whole lot, but shouldn't there be a value for c.parent or is that the way it's supposed to come out?

500 - JDatabaseMySQL::query: 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 'AND c.access <= 2' at line 1 SQL=SELECT c.id FROM jos_categories AS c WHERE c.published = 1 AND c.section = 10 AND c.parent_id = AND c.access <= 2

[attachment=0:1dbfxn1f]<!-- ia0 -->flexidirectory5.jpg<!-- ia0 -->[/attachment:1dbfxn1f]

I haven't search all the files, but the only one I've found so far with these kinds of codes in it is
components > com_flexicontent > models > flexicontent.php

c.parent_id looks like this:


and this:

.
What version of MySQL are you using?


.