Trouble exporting translatable phrases

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Trouble exporting translatable phrases

Postby dspaan » Thu Dec 26, 2019 10:29 am

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.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Trouble exporting translatable phrases

Postby mflorell » Fri Dec 27, 2019 9:03 am

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.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Trouble exporting translatable phrases

Postby dspaan » Fri Dec 27, 2019 9:24 am

Thanks Matt, i just updated to SVN 3181 but it still produces the same error.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Trouble exporting translatable phrases

Postby mflorell » Fri Dec 27, 2019 12:29 pm

apologies, I missed one thing. Please update and try again.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Trouble exporting translatable phrases

Postby dspaan » Fri Dec 27, 2019 5:09 pm

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
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 49 guests