[Zope] ZBabel Issues

Chris Herrnberger chris123@magma.ca
Tue, 29 May 2001 17:39:59 -0500

With apologies, as the above message squeeked out befor completing it. 

Starting out with ZBabel to translate a test page and ran into some issues. 
(nubie alert). Intend is to create a dual language en/fr site.

The latest ZBabel's readme indicates the presence of a ZBabel.sql file to 
setup MySQL. This file was only found in ver. 0.0.3 and not present in the 
current release. 

Ok installed that .sql file then installed and tested ZMySQL adapter and 
installed ZBabel tower in Zope232/python1.5 Creating a very simple test page 
and including the <dtm-babel> tags as described results in the following 

1. eg: Test Page

Title=Test English Page

<dtml-var standard_html_header>
<dtml-babel src=en dist=fr literal='1'>
<h2><dtml-var title_or_id></h2>
This is the <dtml-var id> Document.
<dtml-var standard_html_footer>	

2. Error Messages from ZBabelTower when translating the page from en to fr=> 
Error Type: OperationalError
                   Error Value: (1064, "You have an error in your SQL syntax 
near 'SELECT md5hash\012 FROM phrases\012 WHERE lang='fr' )\012 AND lang = 
'en' ; ' at line 4")

Further: the lables and initTables/View tabs from the management interface 
generate errors as well when viewed. 

Could someone point me in the right direction as to where I should look to 
sort this out. 

Best and many thanks