error after front end log in.

More
13 years 1 month ago #19660 by mwprojects
Hi,
Since a few days i have an error. It appears when i log in on the frontend and go to a flexcontent category. It seems there is something missing, but i can't figure out what it is.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/stichtin/public_html/libraries/joomla/database/database/mysqli.php on line 360

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/stichtin/public_html/libraries/joomla/database/database/mysqli.php on line 360

Warning: Invalid argument supplied for foreach() in /home/stichtin/public_html/components/com_flexicontent/classes/flexicontent.fields.php on line 68

Warning: Invalid argument supplied for foreach() in /home/stichtin/public_html/components/com_flexicontent/classes/flexicontent.fields.php on line 74

When putting Debug on:
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 ') )ORDER BY ordering ASC'
at line 1 SQL=SELECT c.*, CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug FROM jos_categories AS c WHERE c.published = 1 AND c.parent_id = 28 AND ( c.access <= 2 OR c.id IN () ) ORDER BY ordering ASC

FLEXIcontent version 1.5.5 stable (r607)
Joomla! 1.5.23 Stable
Thanx a lot for your kind help.

Please Log in or Create an account to join the conversation.

More
13 years 1 month ago #19661 by mwprojects
i'm also using FlexiAccess.

I found the query mentioned in the previous post in com_flexicontent\models\category.php in line 445.
It seems there is something wrong with filter by permissions (line 432).

Please Log in or Create an account to join the conversation.

More
13 years 1 month ago #19662 by micker
hello
can you do a backup and try to update to 1.5.6 beta 2 ?
code.google.com/p/flexicontent/d ... z&can=2&q=
regards

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.458 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline