Error SQL Syntax when getting filters J2.5->J3.1

More
11 years 1 month ago #40959 by mtgt
Error SQL Syntax when getting filters J2.5->J3.1 was created by mtgt
Hi,

I just migrate from 2.5 to 3.1 and I got this error when I want dislay a category
Code:
Error: 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 fi.ordering, fi.name' at line 1 SQL=SELECT fi.* FROM jom2_flexicontent_fields AS fi WHERE fi.published = 1 AND fi.isfilter = 1 AND fi.access IN (0,1,1) AND fi.id IN () ORDER BY fi.ordering, fi.name

Any help will be really helpfull.
Thanks in advance
Greg
Greg
"La vie n'est qu'opportunité !" ;-)

www.nomadsroad.com Nomads Road - Une aventure interactive autour du monde
www.voyage-australie-nz.com Infos pour préparer son voyage en Australie et en Nouvelle-Zélande

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

More
11 years 1 month ago #40960 by ggppdk
Replied by ggppdk on topic Error SQL Syntax when getting filters J2.5->J3.1
Hello

in file
component/com_flexicontent/models/category/php
find line about 1563:
Code:
if ($filter_ids === false) return $filters;
and add after it:
Code:
if ( is_string($filter_ids) ) $filter_ids = array($filter_ids); $filter_ids = array_filter($filter_ids, 'is_numeric');

-- 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
11 years 1 month ago #41058 by mtgt
Replied by mtgt on topic Error SQL Syntax when getting filters J2.5->J3.1
Hi,

the line 1563:
Code:
if ($filter_ids === false) return $filters; and add after it:
was commented
in place it was:
Code:
if (empty($filter_ids)) return $filters;
So I copy and paste the code you gave me to add.

And I got thi error:
Code:
Warning: array_filter() expects parameter 1 to be array, integer given in /home3/mtgt69/public_html/nomadsroad/components/com_flexicontent/models/category.php on line 1566 Warning: array_filter() expects parameter 1 to be array, integer given in /home3/mtgt69/public_html/nomadsroad/components/com_flexicontent/models/category.php on line 1566

I've tried to uncomment the line 1563 but that gave me the same error. Even I comment both
Code:
//if ($filter_ids === false) return $filters; if (empty($filter_ids)) return $filters;

But it's better, now I have categories displayed but with this two error sentences

Thanks in advance for your help
Greg
"La vie n'est qu'opportunité !" ;-)

www.nomadsroad.com Nomads Road - Une aventure interactive autour du monde
www.voyage-australie-nz.com Infos pour préparer son voyage en Australie et en Nouvelle-Zélande

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

More
11 years 1 month ago #41059 by ggppdk
Replied by ggppdk on topic Error SQL Syntax when getting filters J2.5->J3.1
Hello

please install v2.1.1 r1789, it has this and a few other bugs fixed for J3.1

code.google.com/p/flexicontent/downloads/list

(NOTE: you need jQueryEasy in J3.1 because loading of jQuery autocomplete is broken)


IMPROVEMENTS
1. Improved component installer to
(a) abort installation only if installing for first time,
(b) to provide more clear feedback of what when wrong and if a rollback / abort was done

FIXES (J3.1 specific)
1. Fixed universal module being empty
2. Fixed SQL error while creating filters in J3.1 after upgrading from J2.5
3. Fixed duplicating/deleting templates in J3.x (replaced mootools AJAX with jQuery AJAX)
4. Fixed using CAPTCHA form field

FIXES (All Joomla version)
1. Fixed frontend order override for "Best rated" and "Most commented"
2. Fixed jumpy behavior when sorting fields in positions of template layouts
3. Fixed / allowed using single quotes in tags
4. Fixed the single quote being truncated half way by FLEXIcontent strip and cut text helper function

NEW FEATURES
1. Added preview to CSV import task, and made it multi-step (AJAX based) to avoid timeouts, ability to continue interrupted import

2. Added ability to call plugin functions as tasks via frontend controller (these are limited to an 'allowed' list of functions)

3. Added 2 tasks to file field, that are used to optionally display button that opens a popup e-mail FORM with the purpose of sharing the file download link with a friend

Regards

-- 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
11 years 1 month ago #41064 by mtgt
Replied by mtgt on topic Error SQL Syntax when getting filters J2.5->J3.1
Hi,

I still got
Code:
Warning: array_filter() expects parameter 1 to be array, integer given in /home3/mtgt69/public_html/nomadsroad/components/com_flexicontent/models/category.php on line 1567 Warning: array_filter() expects parameter 1 to be array, integer given in /home3/mtgt69/public_html/nomadsroad/components/com_flexicontent/models/category.php on line 1567

For JQUery in configuration is checked both butif it's jQueryEasy or another one. How to know or to get it?

Thansk again for your help
Greg
"La vie n'est qu'opportunité !" ;-)

www.nomadsroad.com Nomads Road - Une aventure interactive autour du monde
www.voyage-australie-nz.com Infos pour préparer son voyage en Australie et en Nouvelle-Zélande

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

More
11 years 1 month ago #41068 by ggppdk
Replied by ggppdk on topic Error SQL Syntax when getting filters J2.5->J3.1
Hello

please change line:
Code:
if ( is_string($filter_ids) ) $filter_ids = array($filter_ids);
to become:
Code:
if ( !is_array($filter_ids) ) $filter_ids = array($filter_ids);

-- 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.

Moderators: vistamedia, joomlacorner, ggppdk
Time to create page: 0.888 seconds

Last FLEXI-site

Last Faq articles

Newsletter

Last Tutos about FLEXIcontent

Login

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