<div>Forgive my ignorance, but not quite sure how to do that. Nonetheless...</div>
<div>1) There was no problem with any of this on the old server until the server crashed.</div>
<div>2) My backups were taken from a time when the old server was was working fine.</div>
<div>3) This problem occurs with *all* my shopping carts, not just this one.</div>
<div>Consequently, I have a hard time believing this is a code error. There *must* be something more fundamental at play here.</div>
<div> </div>
<div>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.</div>
<div>TIA,</div>
<div>Tony<br>
<br>
<br>
-----Original Message-----<br>
From: Jonathan <dev101@magma.ca><br>
To: zope@zope.org; tonylabarbara@aol.com<br>
Sent: Mon, 16 Jul 2007 9:12 am<br>
Subject: Re: [Zope] Problem w/ ZMySQLDA<br>
<br>
</div>
<div id=AOLMsgPart_0_ca44dfb2-cf9e-4c5f-8b52-8ede7c42c065 style="FONT-SIZE: 12px; MARGIN: 0px; COLOR: #000; FONT-FAMILY: Tahoma, Verdana, Arial, Sans-Serif; BACKGROUND-COLOR: #fff">----- Original Message ----- From: <<A href="mailto:tonylabarbara@aol.com">tonylabarbara@aol.com</A>> <br>
To: <<A href="mailto:zope@zope.org">zope@zope.org</A>> <br>
Sent: Monday, July 16, 2007 8:55 AM <br>
Subject: [Zope] Problem w/ ZMySQLDA <br>
<br>
> <br>
> ----- Original Message ----- > From: <tonylabarbara at aol.com> <br>
> To: <zope at zope.org> <br>
> Sent: Saturday, July 14, 2007 5:43 PM <br>
> Subject: [Zope] Problem w/ ZMySQLDA <br>
> <br>
> <br>
>> > Hi; <br>
>> > ? I just built out a new server and transfered my databases. I use Zope >> > to <br>
>> > server my web sites and ZMySQLDA to interface between the two. >> > Everything <br>
>> > seems <br>
>> > to be fine. I can see the databases, the tables, the columns in the <br>
>> > tables, the <br>
>> > permissions are correct, etc. I hook up ZMySQLDA and that seems to be <br>
>> > fine. It <br>
>> > connects to the database. However, when I go to look at the pages from <br>
>> > served <br>
>> > the database, the browser hangs. Any ideas how to troubleshoot this? <br>
> <br>
>> You should have a MySQL_database_connection object in a folder somewhere >> (in <br>
>> the ZMI).? The "Status" for this object should say "The database >> connection <br>
>> is open".? There is a "Test" tab for this object in which you can enter >> an <br>
>> sql query. If this query works ok, then the next step is to test your Z >> SQL <br>
>> Method(s). <br>
> <br>
> 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! <br>
> <br>
> <tal:block metal:define-macro="content" <br>
> ?????????? define="dummy python:request.set('category', 5)"> <br>
> <br>
> ? <tal:block > metal:use-macro="here/Store/Main_frame_content/macros/content" /> <br>
> <br>
> </tal:block> <br>
> <br>
> Furthermore, mytop shows the user is hanging: <br>
> ???? 30 mysqluser?????? localhost mrtableclo?????? 473? Sleep <br>
> <br>
> What should I do next to troubleshoot this? <br>
<br>
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. <br>
<br>
Jonathan <br>
</div>
<!-- end of AOLMsgPart_0_ca44dfb2-cf9e-4c5f-8b52-8ede7c42c065 --><div class="AOLPromoFooter">
<hr style="margin-top:10px;" />
AOL now offers free email to everyone. Find out more about what's free from AOL at <a href="http://www.aol.com?ncid=AOLAOF00020000000437" target="_blank"><b>AOL.com</b></a>.<br />
</div>