Re: AW: Problem with SQL-Datasource

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: [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
>
>
>  <ZMSSQLDB_config.png>