tonylabarbara@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@magma.ca> To: zope@zope.org; tonylabarbara@aol.com Sent: Mon, 16 Jul 2007 9:12 am Subject: Re: [Zope] Problem w/ ZMySQLDA
----- Original Message ----- From: <tonylabarbara@aol.com <mailto:tonylabarbara@aol.com>> To: <zope@zope.org <mailto:zope@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