Some help required but no sarcastic comments this time please
Hi there, i sent an email the other week regarding problems i've been experiencing with zope and MySQL. I've set up a database connection for zope and mysql and it sort of works. I can send queries to add data to my database ok but when i send a query to get data from my database i get one of 3 errors and my python server that zope runs from stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time) I've sent a few emails about this problem to various people (including to this address) and the response has been pretty poor, i've even tried to email people involved with the mysql database adaptors and got no response. It is really important that i get this problem sorted now if possible as my final year project for university depends on this 'bug' getting fixed. If you can give me help on this or point me in the direction of someone who can, i'd be grateful Cheers Alan
On Tue, Jan 23, 2001 at 11:17:32PM -0000, alankirk wrote:
Hi there, i sent an email the other week regarding problems i've been experiencing with zope and MySQL. I've set up a database connection for zope and mysql and it sort of works. I can send queries to add data to my database ok but when i send a query to get data from my database i get one of 3 errors and my python server that zope runs from stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time) I've sent a few emails about this problem to various people (including to this address) and the response has been pretty poor, i've even tried to email people involved with the mysql database adaptors and got no response. It is really important that i get this problem sorted now if possible as my final year project for university depends on this 'bug' getting fixed.
If you can give me help on this or point me in the direction of someone who can, i'd be grateful
Cheers
Alan
Alan: This is not meant sarcastically. You are probably the only person who has ever tried to do this! Probably no one can help you. (In case people don't remember, Alan is working on Win9x; windows 98, as I recall.) You are working on a platform which is known for instability, with limited debugging capabilities. I urge you to either change to NT/SQL Server or to Linux/MySql or to Linux/PostgeSQL. I can help you with the last, I suspect others can help you with either of the first two. Moreover, the fact that you are getting crashes in multiple places and .dll's suggests that you have hardware problems, like an overheating CPU, or failing RAM. Jim Penny
Alan, So what are the errors, are there any tracebacks, does the thing your trying to do work when outside of Zope? What version of MySQL is it? Can you run any queries, or is it one particular query? What versions of the MySQLDB and MySQLDA are you using? Answering some/all of these questions will get you closer to an answer. I can give you some hope though. I have a Zope+MySQL site that has been running non-stop for about 7-8 months with no problems at all, so it can be done. One final note, the people on the list are, as I'm sure you are, busy people. They do their best to help and generally do. Some posts slip through the net though, I wouldn't take offence at not getting answered. hth Phil phil.harris@zope.co.uk On Tuesday 23 January 2001 23:17, alankirk wrote:
Hi there, i sent an email the other week regarding problems i've been experiencing with zope and MySQL. I've set up a database connection for zope and mysql and it sort of works. I can send queries to add data to my database ok but when i send a query to get data from my database i get one of 3 errors and my python server that zope runs from stops. The errors i get are Python experienced an error in (either nothing,MYSQL.DLL or PYTHON15.DLL). I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time) I've sent a few emails about this problem to various people (including to this address) and the response has been pretty poor, i've even tried to email people involved with the mysql database adaptors and got no response. It is really important that i get this problem sorted now if possible as my final year project for university depends on this 'bug' getting fixed.
If you can give me help on this or point me in the direction of someone who can, i'd be grateful
Cheers
Alan
---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: ----------------------------------------
Phil Harris wrote:
Alan,
So what are the errors, are there any tracebacks, does the thing your trying to do work when outside of Zope?
What version of MySQL is it?
Can you run any queries, or is it one particular query?
What versions of the MySQLDB and MySQLDA are you using?
Answering some/all of these questions will get you closer to an answer.
Agreed
I can give you some hope though. I have a Zope+MySQL site that has been running non-stop for about 7-8 months with no problems at all, so it can be done.
One final note, the people on the list are, as I'm sure you are, busy people. They do their best to help and generally do. Some posts slip through the net though, I wouldn't take offence at not getting answered.
I would add that many of us (specially the more busy ones) ignore posts in HTML, so posting in plain text is very helpful. Just thought I'd help you to get help quicker. :) Bill PS. I skipped the request for help because I don't use MySQl, and thus wouldn't be able to help much, if any. ;^)=
On Tuesday 23 January 2001, at 23 h 17, the keyboard of "alankirk" <alankirk@genie.co.uk> wrote:
I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic = comments this time)
Feel free to interpret every comment you don't like as "sarcastic", but it will not save your business.
to this address) and the response has been pretty poor, i've even tried = to email people involved with the mysql database adaptors and got no = response.
You use a commercial operating system: pay for a commercial support.
It is really important that i get this problem sorted now if possible as = my final year project for university depends on this 'bug' getting = fixed.
If it is important, do not run it on MS-Windows. Otherwise, some people may think you know nothing about software...
----- Original Message ----- From: "Stephane Bortzmeyer" <bortzmeyer@pasteur.fr> Subject: Re: [Zope] Some help required but no sarcastic comments this time please
On Tuesday 23 January 2001, at 23 h 17, the keyboard of "alankirk" <alankirk@genie.co.uk> wrote:
I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic = comments this time)
Feel free to interpret every comment you don't like as "sarcastic", but it will not save your business.
to this address) and the response has been pretty poor, i've even tried = to email people involved with the mysql database adaptors and got no = response.
You use a commercial operating system: pay for a commercial support.
It is really important that i get this problem sorted now if possible as = my final year project for university depends on this 'bug' getting = fixed.
If it is important, do not run it on MS-Windows. Otherwise, some people may think you know nothing about software...
And this kind of harsh response was necessary, because... ? /dario *end of thread* - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario@ita.chalmers.se ICQ will yield no hits IT Systems & Services
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of alankirk Sent: Tuesday, January 23, 2001 5:18 PM To: zope@zope.org Subject: [Zope] Some help required but no sarcastic comments this time please
I am using Zope 2.2.2 on windows(this time i'd appreciate no sarcastic comments this time)
I just installed MySQL 3.23.32 on Win 2000 Pro with Zope 2.3b2 by following this HowTo: http://www.zope.org/Members/philh/mysql I had to edit the DA.py file at <zope dir>\lib\python\Products\ZMySQLDA and change the path to the connectionAdd.dtml from 'Shared/DC/ZRDB/connectionAdd' to 'Shared/DC/ZRDB/dtml/connectionAdd'. I then started ZOPE, created the DB from the MySQL admin interface, created a connection object, connected, created a table and did some minor testing. All seems to work fine currently. So, from what I can tell, aside from the minor change noted above (which without actually looking, I assume is a change from 2.2.x to 2.3) everything worked fine for me, I hope that this will help or at least give you some hope. ______________________________________________ Jeffrey D. Peterson Webmaster/Web & Web Applications Developer Range TV Cable & Broadband 1813 E. 3rd Ave. Hibbing, MN 55746 jpeterso@the-bridge.net
participants (7)
-
alankirk -
Bill Anderson -
Dario Lopez-K�sten -
Jeff Peterson -
jpenny@universal-fasteners.com -
Phil Harris -
Stephane Bortzmeyer