phpBB • Free and Open Source Forum Software

Aurelienazerty · by **Aurelienazerty** » Fri May 25, 2018 10:31 pm

With my server configuration all float are 2,5 and not 2.5

So, the

'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . (float) $sensitivity . '

make an SQL error.

A way to prevent is to replace

Code: Select all

'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . str_replace(',', '.', (float) $sensitivity) . '

it's quick and dirty

**My Extensions** · by **MattF** » Sat May 26, 2018 4:08 pm

Aurelienazerty wrote:With my server configuration all float are 2,5 and not 2.5

So, the
Code: Select all
'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . (float) $sensitivity . '
make an SQL error.

A way to prevent is to replace
Code: Select all
'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . str_replace(',', '.', (float) $sensitivity) . '
it's quick and dirty

What happens if you don't do that, and instead change this:

Code: Select all

// Get stored sensitivity value and divide by 10. In query it should be a number between 0.0 to 1.0.
$sensitivity = $this->config->offsetExists('similar_topics_sense') ? $this->config['similar_topics_sense'] / 10 : '0.5';

to

Code: Select all

// Get stored sensitivity value and divide by 10. In query it should be a number between 0.0 to 1.0.
$sensitivity = $this->config->offsetExists('similar_topics_sense') ? number_format($this->config['similar_topics_sense'] / 10, 1, '.', '') : '0.5';

Aurelienazerty · by **Aurelienazerty** » Tue Aug 27, 2019 3:11 pm

It's still dosent work.

We had to change

Code: Select all

'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . (float) $sensitivity . '

to

Code: Select all

'WHERE'		=> "MATCH (t.topic_title) AGAINST ('" . $this->db->sql_escape($topic_title) . "') >= " . str_replace(',', '.', (float) $sensitivity) . '

In similartopics/driver/mysqli.php (line 68)

**My Extensions** · by **MattF** » Tue Aug 27, 2019 6:31 pm

Since your SQL server expects mathematical numbers to use decimals (and not commas) you should consider fixing your server configuration to use the expected decimal standard then.

phpBB • Free and Open Source Forum Software

Precise Similar Topics

SQL error with float in french - Precise Similar Topics

SQL error with float in french

Re: SQL error with float in french

Re: SQL error with float in french

Re: SQL error with float in french

advertisements