Problem with ZSQLMethods/MySQL after update
Hi everybody! 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." This happens only when using my old zope instance (which I need to) but not when using a freshly created zope instance. Is this a known problem? I couldn't find anything in my zope mailing list archive. Cheers, Ragnar P.S.: Here are the contents of my ProductManagement screen: BTreeFolder2 (Installed product BTreeFolder2 (BTreeFolder2-1.0.1)) 2005-06-20 10:35 DocFinderEverywhere (Installed product DocFinderEverywhere (DocFinderEverywhere-0.4.1)) 2003-02-14 08:39 ExternalMethod (Installed product ExternalMethod (External Method-1-0-0)) 2000-10-12 15:51 Five (Installed product Five (Five 1.0.1)) 2005-06-20 10:35 MIMETools (Installed product MIMETools) 2001-01-05 14:31 MailHost (Installed product MailHost (MailHost-1-3-0)) 2003-05-11 23:00 OFSP (Installed product OFSP (OFSP-1-0-0)) 2000-10-12 15:51 PageTemplates (Installed product PageTemplates (PageTemplates-1-4-0)) 2002-05-07 13:53 PluginIndexes (Installed product PluginIndexes) 2001-09-04 13:29 PythonScripts (Installed product PythonScripts (PythonScripts-2-0-0)) 2001-09-04 10:13 Sessions (Installed product Sessions) 2002-05-07 13:53 SiteAccess (Installed product SiteAccess (SiteAccess-2-0-0)) 2001-09-04 11:38 SiteErrorLog (Installed product SiteErrorLog) 2003-02-14 08:39 StandardCacheManagers (Installed product StandardCacheManagers (StandardCacheManagers-1-1-0)) 2001-09-04 10:13 TemporaryFolder (Installed product TemporaryFolder) 2002-05-07 13:53 Transience (Installed product Transience) 2002-05-07 13:53 ZCTextIndex (Installed product ZCTextIndex) 2003-02-14 08:39 ZCatalog (Installed product ZCatalog (ZCatalog-2-2-0)) 2000-10-12 15:51 ZGadflyDA (Installed product ZGadflyDA) 2001-01-05 14:31 ZMySQLDA (Installed product ZMySQLDA (ZMySQLDA 2.0.8)) 2003-11-30 20:17 ZODBMountPoint (Installed product ZODBMountPoint) 2005-06-20 10:36 ZReST (Installed product ZReST (1.1)) 2005-06-20 10:36 ZSQLMethods (Installed product ZSQLMethods) 2000-10-12 15:51 ZopeTutorial (Installed product ZopeTutorial (Zope Tutorial 1.2)) 2005-06-20 10:36
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
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 <dieter@handshake.de> 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
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 <retheoff@gmail.com> 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 <dieter@handshake.de> 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
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 <dieter@handshake.de> 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 )
participants (4)
-
Andy Dustman -
Dieter Maurer -
Greg Fischer -
Ragnar Beer