On 9/1/05, michael [EMAIL PROTECTED] wrote:
Hi, I am trying to set this up, following install instructions from
zope.org/Members/Mike/ZMySQLDA
make -f Makefile command works fine, but 'make' afterwards produces
the following error:
That page, which no longer exists, was
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 [EMAIL PROTECTED] 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
On 6/3/05, Hugo Ramos [EMAIL PROTECTED] wrote:
I already know what exactly makes Zope hang!
The problem is located at times.py that was installed by MySQL-Python
1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip)
This is a package for Python-2.4. Are you using Python-2.4 with
Zope-2.7? If you are,
On 6/3/05, Hugo Ramos [EMAIL PROTECTED] wrote:
Yellow,
I wrote the wrong version.
I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3
Take a look at ZMySQLDA/db.py:
On 5/14/05, David H [EMAIL PROTECTED] wrote:
Greg,
Have you contacted the mySQL product maintainer? This is not a Zope
community issue. Which is to say, many of us have the instinct to help
but simply do not use mySQL and therefore have nothing to suggest.
Other than what is obvious:
a)
On 5/12/05, Greg Fischer [EMAIL PROTECTED] wrote:
Thanks Andy. I do have those versions. But Python is 2.3.5 because I
didnt want to move to 2.4.x as I think I read something in the README
for Zope stating it was not tested for compatibility. (right?) I
guess my thought is... Does 2.3.5
On 5/11/05, Asad Habib [EMAIL PROTECTED] wrote:
Is there a reason why Z SQL methods do not allow the use of the LIMIT
clause? I am absolutely certain that my query has the right syntax since I
executed it against the MySQL server and it gave me the correct results.
FYI, I have provided the
On 5/6/05, robert rottermann [EMAIL PROTECTED] wrote:
Hi there,
I have a problem using MySQLdb and unicode.
with older version (0.92) I could set a parameter unicode to the
connect() method to tell MySQLdb what charset to use.
This parameter is not accepted anymore.
The only way to deal
On Fri, 16 Jul 2004 10:36:27 -0400, Brad Clements [EMAIL PROTECTED] wrote:
The SAP folks say their adapter is multi-thread capable, but I've come to believe
that only
means that it's ok to open a connection in one thread and use it in another, but NOT
to have
2 threads make requests on
On Wed, 2002-03-13 at 12:04, Brian Lloyd wrote:
- Absolutely eliminate SQL db access as a cause (it sounds
like we have proof of this now)
This sounds like it is not specific to any DA. Is that the case?
--
Andy Dustman PGP: 0x930B8AB6
@ .net http://dustman.net
() as a keyword
parameter to maintain backwards compatibility with older Zopes.
Adding this would make Z SQL Methods work a bit more like dtml-in ...
start=skip_rows size=max_rows. There may be issues with result caching,
but I don't think it'll be too much of a problem.
--
Andy Dustman PGP
connections, since I expect this would
cause problems on virtually all implementations.
--
Andy Dustman PGP: 0x930B8AB6
@ .net http://dustman.net/andy
You can have my keys when you pry them from my dead, cold neurons.
___
Zope-Dev
into the other fields one char at a time.
Any help would be GREATLY appreciated.
Owner id (owner_id) can't be 'P' because it is a numeric column. I suspect
if you use the mysql client program, you will find that the correct values
are in there.
--
Andy Dustman PGP: 0xC72F3F1D
@ .net
, as longs are no longer rendered
with the L suffix.
That's my preferred solution, but also see:
http://www.zope.org/Members/adustman/Tips/no_el
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
"Normally with carbonara you use eggs, but I used lobster b
, INTEGER (particularly UNSIGNED) can overflow in Python, so
they need to be returned as Python long integers. Python adds the L when
doing str(), but Python 2.0+ does not do this (only on repr()).
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
"Nor
.
That sounds very much like a good thing. I will have to add that to the
tip I have (really, re-write it). I actually forgot that it did
that. Randy, does setting max_rows to zero fix things for you?
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
"Nor
On Fri, 26 Jan 2001, Randall F. Kern wrote:
You will get 0 rows if you use max_rows=0.
OK, I agree that this is a legit bug, and I am in the process of working
up a new patch. I'll send it off-list when it's ready.
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http
exception.
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
"Normally with carbonara you use eggs, but I used lobster brains instead."
-- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle
__
named sql
See, you have the same problem for the ZSolidDA. I would suggest modifying
z2.py to print sys.path shortly after importing sys. This will tell you
where python is looking for modules. If MySQLdb is not installed in one of
those directories, that is your problem.
--
Andy Dustman
n some user
feedback). I'm going to send that to you off-list, along with
MySQLdb-0.3.0.
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/z
the top of that file?:
from Products.ZMySQLDA.db import *
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML en
ized object
I don't know if this is the problem, but ZMySQLDA-2.0.1 requires
MySQLdb-0.3.0 (aka MySQL-python). These should both work with
MySQL-3.22.23, though I would recommend an upgrade to at least 3.22.32 (or
3.23.30).
--
andy dustman | programmer | comstar.net is part of the Glob
need a UNIX user by that name. Your GRANT statement
looks basically correct, but check the MySQL documentation.
--
Andy Dustman PGP: 0xC72F3F1D
@ .net http://dustman.net/andy
___
Zope maillist - [EMAIL PROTECTED]
http
On Thu, 11 Jan 2001, Martin Fekete wrote:
sombody compiled MySQLdb under WIN32 ?
Somebody has. Look for a link at:
http://dustman.net/andy/python/MySQLdb/0.3.0
--
andy dustman | programmer | comstar.net is part of the Globix network
telephone: 770.485.6025 / 706.549.7689 | icq
try:
http://www.zope.org/Members/adustman
for MySQLdb-0.3.0 and ZMySQLDA-2.0.1, which includes a transactional DA
for MySQL servers with BDB tables (3.23.30 recommended).
--
andy dustman | programmer | comstar.net is part of the Globix network
telephone: 770.485.6025 / 706.549.7689 | icq
without any
problem. The issue is the names of the columns returned by a SELECT.
--
andy dustman | programmer | comstar.net is part of the Globix network
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d
"Therefore, sweet knights, if you may doubt your strength or
Sadly, 2.2.1 seems to break all my ZClass objects. The Products themselves
look fine, but any object made with them comes up as broken. The Class ID
(in the HTML source) looked like it had a * in front of it. I retrograded
to 2.2.0 and the problems went away.
--
andy dustman
told. If you can't get it to compile or
something, I can't help you.
--
andy dustman | programmer/analyst | comstar.net, inc.
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d
"Therefore, sweet knights, if you may doubt your strength or courage,
ss is used for the database
connection. This might be workable, not really sure.
--
andy dustman | programmer/analyst | comstar.net, inc.
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d
"Therefore, sweet knights, if you may doubt your strength or courage,
, the
transactions are going to be whacky.
--
andy dustman | programmer/analyst | comstar.net, inc.
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d
"Therefore, sweet knights, if you may doubt your strength or courage,
come no further, for death awaits yo
;must" use the AS statement? Do you get an error
otherwise?
MySQLdb 0.2.2 is broken when used with ZMySQLDA. But 0.2.1 works okay for
me. Andy Dustman (author of the MySQLdb) said he will fix it and hinted
that one should use the ZMySQLDA that is on Zope.org (v1.2.0 now I believe).
Sinc
31 matches
Mail list logo
