Re: [Zope] Problem with ZSQLMethods/MySQL after update
Thanks a lot for your help, Dieter, Greg, and Andy! Dieter, you were absolutely right about the broken instances. All I had to do was delete ZSQLMethods from my Products folder and restart Zope. Everything was all right after that. Andy and Greg, so far I did not have any problems using mysqlpython 1.2.0 with ZMySQLDA 2.0.8. But since Andy is the expert I now installed 2.0.9b3 and am happy with it. :-) Cheers and thanks again, Ragnar On Tue, 28 Jun 2005 19:43:15 +0200 Dieter Maurer <[EMAIL PROTECTED]> wrote: > Ragnar Beer wrote at 2005-6-27 18:50 +0200: > >After upgrading Zope from version 2.6.4 to 2.8.0 and mysqlpython from > >0.9.2 to 1.2.0 I cannot add or edit ZSQLMethods anymore, although there > >is an open(MySQL)db-Connection that works just fine with the same > >ZSQLMethods that cannot be edited or with external methods. The error > >I'm getting is: > > > >"There are no SQL database connections. You need to add a Zope SQL > >database connection before you can edit a Zope SQL Method." > > Almost surely, your "ZMySQLDA" instances are broken (and then > do not behave as "SQL database connection" instances). > > Check your Zope logfile for messages of the form > "could not install product...". > > -- > Dieter > ___ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with ZSQLMethods/MySQL after update
Greg's right: ZMySQLDA-2.0.8 definitely won't work properly with MySQL-python-1.2.0. You need ZMySQLDA-2.0.9b3. On 6/29/05, Greg Fischer <[EMAIL PROTECTED]> wrote: > I could be totally wrong, but just a thought > > You might remove the Zmysqlda 2.0.8 you have and download and install > the 2.0.9b3. Do some reading before, and maybe you can simply > reinstall 2.0.8. I cant remember what it was that needed 2.0.9, maybe > it was just having mysqlpython 1.2.0. (because of mysql 4.1.x or new > python, cant remember) > > Ok I am just thinking outloud now, sorry. But heck, if it helps. :) > > Greg > > On 6/28/05, Dieter Maurer <[EMAIL PROTECTED]> wrote: > > Ragnar Beer wrote at 2005-6-27 18:50 +0200: > > >After upgrading Zope from version 2.6.4 to 2.8.0 and mysqlpython from > > >0.9.2 to > > >1.2.0 I cannot add or edit ZSQLMethods anymore, although there is an open > > >(MySQL)db-Connection that works just fine with the same ZSQLMethods that > > >cannot > > >be edited or with external methods. The error I'm getting is: > > > > > >"There are no SQL database connections. You need to add a Zope SQL database > > >connection before you can edit a Zope SQL Method." > > > > Almost surely, your "ZMySQLDA" instances are broken (and then > > do not behave as "SQL database connection" instances). > > > > Check your Zope logfile for messages of the form > > "could not install product...". > > > > -- > > Dieter > > ___ > > Zope maillist - Zope@zope.org > > http://mail.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://mail.zope.org/mailman/listinfo/zope-announce > > http://mail.zope.org/mailman/listinfo/zope-dev ) > > > > > -- > Greg Fischer > 1st Byte Solutions > http://www.1stbyte.com > ___ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > -- Computer interfaces should never be made of meat. http://www.terrybisson.com/meat.html ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with ZSQLMethods/MySQL after update
I could be totally wrong, but just a thought You might remove the Zmysqlda 2.0.8 you have and download and install the 2.0.9b3. Do some reading before, and maybe you can simply reinstall 2.0.8. I cant remember what it was that needed 2.0.9, maybe it was just having mysqlpython 1.2.0. (because of mysql 4.1.x or new python, cant remember) Ok I am just thinking outloud now, sorry. But heck, if it helps. :) Greg On 6/28/05, Dieter Maurer <[EMAIL PROTECTED]> wrote: > Ragnar Beer wrote at 2005-6-27 18:50 +0200: > >After upgrading Zope from version 2.6.4 to 2.8.0 and mysqlpython from 0.9.2 > >to > >1.2.0 I cannot add or edit ZSQLMethods anymore, although there is an open > >(MySQL)db-Connection that works just fine with the same ZSQLMethods that > >cannot > >be edited or with external methods. The error I'm getting is: > > > >"There are no SQL database connections. You need to add a Zope SQL database > >connection before you can edit a Zope SQL Method." > > Almost surely, your "ZMySQLDA" instances are broken (and then > do not behave as "SQL database connection" instances). > > Check your Zope logfile for messages of the form > "could not install product...". > > -- > Dieter > ___ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > -- Greg Fischer 1st Byte Solutions http://www.1stbyte.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with ZSQLMethods/MySQL after update
Ragnar Beer wrote at 2005-6-27 18:50 +0200: >After upgrading Zope from version 2.6.4 to 2.8.0 and mysqlpython from 0.9.2 to >1.2.0 I cannot add or edit ZSQLMethods anymore, although there is an open >(MySQL)db-Connection that works just fine with the same ZSQLMethods that cannot >be edited or with external methods. The error I'm getting is: > >"There are no SQL database connections. You need to add a Zope SQL database >connection before you can edit a Zope SQL Method." Almost surely, your "ZMySQLDA" instances are broken (and then do not behave as "SQL database connection" instances). Check your Zope logfile for messages of the form "could not install product...". -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )