News:

Simutrans Sites
Know our official sites. Find tools and resources for Simutrans.

Error looking for a translated text - Simutrans extended

Started by Milko, March 14, 2018, 10:56:00 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Milko

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

makie

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."')";