Page 1 of 1

Trouble exporting translatable phrases

PostPosted: Thu Dec 26, 2019 10:29 am
by dspaan
When i want to export all phrases that can be translated to a file i get an error:

Code: Select all
/usr/share/astguiclient/ADMIN_www_languages.pl --QXZvalues >phrases.txt


Result:

"Could not connect: "
$Cmonths[$CfirstdayARY['mon']]
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mon']]'' at line 1 at /usr/share/astguiclient/ADMIN_www_languages.pl line 419.
executing: SELECT count(*) FROM www_phrases where phrase_text='$Cmonths[$CfirstdayARY['mon']]'; You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mon']]'' at line 1 at /usr/share/astguiclient/ADMIN_www_languages.pl line 419.

Re: Trouble exporting translatable phrases

PostPosted: Fri Dec 27, 2019 9:03 am
by mflorell
Upgrade to the latest svn/trunk revision, it should run cleanly now. I haven't tested that script in years, after the changes I just made it should run cleanly.

Re: Trouble exporting translatable phrases

PostPosted: Fri Dec 27, 2019 9:24 am
by dspaan
Thanks Matt, i just updated to SVN 3181 but it still produces the same error.

Re: Trouble exporting translatable phrases

PostPosted: Fri Dec 27, 2019 12:29 pm
by mflorell
apologies, I missed one thing. Please update and try again.

Re: Trouble exporting translatable phrases

PostPosted: Fri Dec 27, 2019 5:09 pm
by dspaan
Cheers! Working now. I did a full test run after the recent translation fixes but still found a bunch: http://www.vicidial.org/VICIDIALmantis/view.php?id=1197