[Zope] Re: Problem w/ ZMySQLDA

[J Cameron Cooper]

tonylabarbara at aol.com wrote:
> Forgive my ignorance, but not quite sure how to do that. Nonetheless...
> 1) There was no problem with any of this on the old server until the 
> server crashed.
> 2) My backups were taken from a time when the old server was was working 
> fine.
> 3) This problem occurs with *all* my shopping carts, not just this one.
> Consequently, I have a hard time believing this is a code error. There 
> *must* be something more fundamental at play here.

Code and configuration often interact. You may find that one or the 
other was fragile.

        --jcc

> I had some problems with the python-eggs, but I don't imagine that's it, 
> since the connection works, I can query the database, etc.
> TIA,
> Tony
> 
> 
> -----Original Message-----
> From: Jonathan <dev101 at magma.ca>
> To: zope at zope.org; 
> tonylabarbara at aol.com
> Sent: Mon, 16 Jul 2007 9:12 am
> Subject: Re: [Zope] Problem w/ ZMySQLDA
> 
> ----- Original Message ----- From: 
> <tonylabarbara at aol.com 
> <mailto:tonylabarbara at aol.com>> 
> To: <zope at zope.org 
> <mailto:zope at zope.org>> 
> Sent: Monday, July 16, 2007 8:55 AM 
> Subject: [Zope] Problem w/ ZMySQLDA 
>  
>  > 
>  > ----- Original Message ----- > From: <tonylabarbara at aol.com> 
>  > To: <zope at zope.org> 
>  > Sent: Saturday, July 14, 2007 5:43 PM 
>  > Subject: [Zope] Problem w/ ZMySQLDA 
>  > 
>  > 
>  >> > Hi; 
>  >> > ? I just built out a new server and transfered my databases. I use 
> Zope >> > to 
>  >> > server my web sites and ZMySQLDA to interface between the two. >> 
>  > Everything 
>  >> > seems 
>  >> > to be fine. I can see the databases, the tables, the columns in the 
>  >> > tables, the 
>  >> > permissions are correct, etc. I hook up ZMySQLDA and that seems to be 
>  >> > fine. It 
>  >> > connects to the database. However, when I go to look at the pages 
> from 
>  >> > served 
>  >> > the database, the browser hangs. Any ideas how to troubleshoot this? 
>  > 
>  >> You should have a MySQL_database_connection object in a folder 
> somewhere >> (in 
>  >> the ZMI).? The "Status" for this object should say "The database >> 
> connection 
>  >> is open".? There is a "Test" tab for this object in which you can 
> enter >> an 
>  >> sql query. If this query works ok, then the next step is to test 
> your Z >> SQL 
>  >> Method(s). 
>  > 
>  > Thanks. That clarified a lot. The MySQL query comes back fine. I'm > 
> troubleshooting a complex shop I had a programmer who worked for me > 
> build...so it's not my code...and it's complex ;) I went into the > 
> shopkeeper's side and was able to successfully query the database. I 
> was, > for example, able to display the "cotton" products for editing. 
> However, > when I do essentially_the_same_thing TTW with the following 
> code snippet, > it hangs! 
>  > 
>  > <tal:block metal:define-macro="content" 
>  > ?????????? define="dummy python:request.set('category', 5)"> 
>  > 
>  > ? <tal:block > 
> metal:use-macro="here/Store/Main_frame_content/macros/content" /> 
>  > 
>  > </tal:block> 
>  > 
>  > Furthermore, mytop shows the user is hanging: 
>  > ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep 
>  > 
>  > What should I do next to troubleshoot this? 
>  
> I would test the code outside of tal. Just execute (test) the routine by 
> itself to see what it is returning. A couple of things to check: (i) is 
> the routine receiving the correct input parameters, (ii) is the routine 
> returning what you are expecting. 

-- 
Connexions
http://cnx.org

"Building Websites with Plone"
http://plonebook.packtpub.com