Hello Mr. Hoffmann,

thank you for your hints ... 

the half way luck was on my side ;)

as a first step I tried the former ZMySQLDA Version

change my.cnf and altered the table as suggested

restarted mysql and zope-instance

after that I was able to initalize the ZMSSQLdb object - so that i see the various columns :)

but then... 

when trying to access the special object node in zmi the same error is shown:

Error Type: AttributeError
Error Value: Name

error log is different now:

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 76, in render
    * Module App.special_dtml, line 65, in __call__
    * Module DocumentTemplate.DT_String, line 476, in __call__
    * Module DocumentTemplate.DT_Let, line 76, in render
    * Module App.special_dtml, line 65, in __call__
    * Module DocumentTemplate.DT_String, line 476, in __call__
    * Module DocumentTemplate.DT_In, line 703, in renderwob
    * Module DocumentTemplate.DT_Let, line 76, in render
    * Module DocumentTemplate.DT_Util, line 196, in eval
      __traceback_info__: getLangStr
    * Module <string>, line 0, in ?
    * Module App.special_dtml, line 65, in __call__
    * Module DocumentTemplate.DT_String, line 476, in __call__
    * Module DocumentTemplate.DT_In, line 703, in renderwob
    * Module DocumentTemplate.DT_Util, line 196, in eval
      __traceback_info__: renderShort
    * Module <string>, line 0, in ?
    * Module Products.zms.zmssqldb, line 659, in renderShort
    * Module Products.zms.zmssqldb, line 651, in _getBodyContent
    * Module App.special_dtml, line 65, in __call__
    * Module DocumentTemplate.DT_String, line 476, in __call__
    * Module DocumentTemplate.DT_In, line 626, in renderwob
    * Module DocumentTemplate.DT_Util, line 196, in eval
      __traceback_info__: getEntities
    * Module <string>, line 0, in ?
    * Module Products.zms.zmssqldb, line 380, in getEntities

AttributeError: Name 

when trying to insert a record manually its possible to data in the database :)

but ALL the fields are set as mandatory !?

Are there eventually further steps I could try ... (beside upgrading to zms 2.11) ? 

best regards 

Th. Weber

Am 12.11.2008 um 20:03 schrieb Dr. Frank Hoffmann:

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: zms-developers@yahoogroups.com [mailto:zms-developers@yahoogroups.com]
Im Auftrag von Thorsten Weber
Gesendet: Dienstag, 11. November 2008 21:28
An: zms-developers@yahoogroups.com
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

 <ZMSSQLDB_config.png>