SQL error when I try ti recompile all languages

D 7.1.4

Query:
DELETE FROM `sys_localization_keys`, `sys_localization_strings` USING `sys_localization_keys`, `sys_localization_strings` WHERE `sys_localization_keys`.`ID`=`sys_localization_strings`.`IDKey` AND `sys_localization_keys`.`Key`='_FieldValues_It's Complicated'
Mysql 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 's Complicated'' at line 1

Found error in the file '/home/nguoimau/public_html/mysite.com/inc/classes/BxDolInstaller.php' at line 660.
Called 'db_res' function with erroneous argument #0.

Quote · 12 Aug 2016

I can tell you exactly why it is tripping up, it is the single quote in the It's Complicated.  Single quotes has caused problems in Dolphin before.

Geeks, making the world a better place
Quote · 12 Aug 2016

Quick fix, change it to "It is Complicated"

Geeks, making the world a better place
Quote · 12 Aug 2016

Thank you, Geek Girl.

I cannot find any It's Complicated in the mentioned file (at line 660, the _FieldValues_ is not "it's complicated").

 

BxDolInstaller.php · 30.5K · 143 downloads
Quote · 12 Aug 2016

No, you don't understand, the value is not in that file, it is in the keys.  A query is form in the BxDolInstaller and that query is ill formed due to the single quote.  This is a bug and needs to be addressed.  Probably to fix will mean a database edit to change the key.  If you are unsure about doing database edits, then send me a PM.  Of course always do a database backup before manually editing the database.

Geeks, making the world a better place
Quote · 12 Aug 2016

Oh, just say that you are at 7.1.4 so this might have already been fixed.  By the way, if you are intending to stay at 7.1 line I would suggest upgrading to 7.1.6 to pick up some bugs and security fixes and then there is the security issue stated during the 7.2 line that can be manually done to the 7.1 line.

Geeks, making the world a better place
Quote · 12 Aug 2016

Actually, you may be able to change the value for that Field Caption by going to your Profile Builder.  However, it may throw an error there as well when it tries to load the key into the builder.

Geeks, making the world a better place
Quote · 12 Aug 2016
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.