The International Simutrans Forum

 

Author Topic: Error looking for a translated text - Simutrans extended  (Read 1794 times)

0 Members and 1 Guest are viewing this topic.

Offline Milko

  • Devotee
  • *
  • Posts: 824
Error looking for a translated text - Simutrans extended
« on: March 14, 2018, 10:56:00 AM »
If I look for a translated text I get error:

SQL error: Can't find FULLTEXT index matching the column list
SELECT * FROM `translations_101` t WHERE MATCH(t.tr_text) AGAINST('posta') AND  t.language_language_id='it'   ORDER BY t.object_obj_name ASC;
/var/www/vhosts/simutrans-germany.com/httpdocs/translator/script/directions.php
Zeile : 330 Funktion : db_query
SQL error

The configuration used is as follows:
Simutrans-extended, All objects, Italian language, show all, text to found = "posta".

I have no problem selecting "Base text".

Giuseppe

Online makie

  • *
  • Posts: 24
  • Languages: DE
Re: Error looking for a translated text - Simutrans extended
« Reply #1 on: March 14, 2018, 11:55:40 AM »
Frank made some changes to direction.php.
Unfortunately he does not use latest version, and thereby had taken back changes made by me.

-    $sort = 't.object_obj_name COLLATE utf8_unicode_ci';
-    $suche = "LCASE(t.tr_text) LIKE '%".db_real_escape_string($sr_string2)."%' ";
+    $suche = "MATCH(t.tr_text) AGAINST('".$sr_string."')";