Re: AW: Problem with SQL-Datasource

Hello Mister Hoffmann,

everything is fine now!
It works great ! :)

It was my own fault - sorry!
The error was produced by duplicate ids (a hidden object in  
portalmaster) ... .

Thanks again for your support!

Best regards, Th. Weber


Am 12.11.2008 um 22:33 schrieb Thorsten Weber:

> 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>
>
>
>