[Fixed] SQL error on search for v2.2.0 r1882 BETA

More
10 years 3 months ago - 10 years 3 months ago #48453 by davidote
Hi there.

When doing a search with the search engine of the front end, this error appears:
Code:
Error: 1064 - You have an error in your SQL syntax; Manual That Corresponds the check to your MySQL server version for the right syntax to use near 'and fcsjb_accessmanager_rights.type =' category ')'' at line 1 SQL = SELECT DISTINCT c.id, c.title, rel.itemid, CASE WHEN CHAR_LENGTH (c.alias) THEN CONCAT_WS (':', c.id, c.alias) ELSE c.id END as slug FROM fcsjb_categories AS c JOIN AS fcsjb_flexicontent_cats_item_relations rel = c.id WHERE ON rel.catid rel.itemid IN ('9864 ') and c.id in (select item from fcsjb_accessmanager_rights, where fcsjb_user_usergroup_map fcsjb_user_usergroup_map.group_id = fcsjb_accessmanager_rights.group and fcsjb_accessmanager_rights.type fcsjb_user_usergroup_map.user_id = and =' category ')';
The next piece of the query, attempt to ensure that the user logged in, you can access the category:
Code:
and c.id in (select item from fcsjb_accessmanager_rights, where fcsjb_user_usergroup_map fcsjb_user_usergroup_map.group_id = fcsjb_accessmanager_rights.group and fcsjb_accessmanager_rights.type fcsjb_user_usergroup_map.user_id = and = 'category') ';

It also happens in other menus using tables of Flexicontent.

FLEXIcontent version 2.2.0 r1882

Joomla 3.2.2

Best regards.
Last edit: 10 years 3 months ago by davidote.

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

More
10 years 3 months ago #48454 by ggppdk
Hello

please always mention Joomla and FLEXIcontent version


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
10 years 3 months ago #48456 by davidote
FLEXIcontent version 2.2.0 r1882

Joomla 3.2.2

I'm sorry, I've forgotten it.

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

More
10 years 3 months ago #48457 by ggppdk
Hello

you have installed v2.2.0
update to latest r1932

see our "Downloads/Latest Version"


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

More
10 years 3 months ago #48458 by davidote
Some links (not all) that generates the script that I developed, get this error:

Fatal error: Call to a member function get () on a non-object in ... / components / com_flexicontent / classes / flexicontent.fields.php on line 1106

Links construction remains the same.

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

More
10 years 3 months ago #48466 by davidote
Looks like I've solved that error message

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.282 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