AW: Problem with SQL-Datasource

Hello,
Using the zmssqldb object within a container content object class is no
problem.
But, please use the former ZMySQLDA-Version 2.0.8; only this will work well
- at the moment.

Even using utf8 is no problem, if MySQL does not transform the charset while
communicating with Zope:
consider the topic concerning /etc/my.cnf
https://mail.dzug.org/pipermail/zope/2007-April/003482.html
....
[mysqld]
init_connect="SET NAMES utf8"
....
And set the default charset to UTF8
ALTER DATABASE `mytable` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci 

Good luck,
Best regards
fh, moderator

PS:
Try the latest build 2.11.1#15
http://bscw.hoffmannliebenberg.de/pub/bscw.cgi/d454265/zms-2.11.1.tar.gz
It allows (semi) automatic generation of the xml database model file. The
screen shot shows the new graphical user interface. This is a very helpful
feature.


________________________________

Von: [email protected] [mailto:[email protected]]
Im Auftrag von Thorsten Weber
Gesendet: Dienstag, 11. November 2008 21:28
An: [email protected]
Betreff: [zms-developers] Problem with SQL-Datasource


Hello 


i have a problem inserting SQL-Datasource within special object:


i configured Z MySQL Database Connection successfully
but when i add SQL-Datasource via ZMI always an error comes up:


Error Type: AttributeError
Error Value: Name


the object itself is inserted in the system


ZMS: ZMS 2.10.5-24 (Build #129f)
ZOPE: (Zope 2.10.4-final, python 2.4.4, linux2)
PYTHON: 2.4.4 (#7, Sep 5 2008, 14:29:18) [GCC 4.2.1 (SUSE Linux)]
ZMySQLDA-3.0
MySQL Version: 5.0.45


Traceback (innermost last):


      *  Module ZPublisher.Publish, line 119, in publish
    * Module ZPublisher.mapply, line 88, in mapply
    * Module ZPublisher.Publish, line 42, in call_object
    * Module App.special_dtml, line 65, in __call__
    * Module DocumentTemplate.DT_String, line 476, in __call__
    * Module DocumentTemplate.DT_Let, line 75, in render
    * Module DocumentTemplate.DT_Util, line 196, in eval
      __traceback_info__: getEntities
    * Module <string>, line 0, in ?
    * Module Products.zms.zmssqldb, line 380, in getEntities
    * Module Products.ZMySQLDA.DABase, line 130, in __getattr__




Does anybody has a tipp?

regards, Th. Weber