Filter bug in Chronoconnectivity ?

va

vales 04 Dec, 2009

I did a test of connectivity to the table jos_contents.
When I set this filter on WHERE SQL

WHERE fulltext LIKE '%joomla%'

I get this error

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 'fulltext LIKE '%joomla%'' at line 1 SQL=SELECT count(*) FROM jos_content WHERE fulltext LIKE '%joomla%'

CONTENUTI DI JOOMLA
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 'fulltext LIKE '%joomla%'' at line 1 SQL=SELECT count(*) FROM jos_content WHERE fulltext LIKE '%joomla%'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 'fulltext LIKE '%joomla%'' at line 1 SQL=SELECT count(*) FROM jos_content WHERE fulltext LIKE '%joomla%'

If you set the filter on field title or introtext everything is OK.

P.S.

CONTENUTI DI JOOMLA

It is in to Header

nm

nml375 04 Dec, 2009

Hi,
As I rougly recall, 'FULLTEXT' is a reserved keyword in MySQL, so you'll have to properly quote it:

WHERE `fulltext` LIKE '%joomla%'

Or (using the database object to quote the name and pattern on the fly):

<?php
$db = JFactory::getDBO();
echo sprintf(
  'WHERE %s LIKE %s',
  $db->nameQuote('fulltext'),
  $db->quote('%joomla%')
);
?>

/Fredrik

va

vales 05 Dec, 2009

Hi Fredrik,

Many, many, many thanks you have solved a big problem for me!

Forums

Filter bug in Chronoconnectivity ?