Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #42192

Re: Cannot run a single MySQLdb execute....

Path csiph.com!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!mx05.eternal-september.org!.POSTED!not-for-mail
From Alan Meyer <ameyer2@yahoo.com>
Newsgroups comp.lang.python
Subject Re: Cannot run a single MySQLdb execute....
Date Thu, 28 Mar 2013 16:54:55 -0400
Organization A noiseless patient Spider
Lines 30
Message-ID <5154AE1F.6010309@yahoo.com> (permalink)
References <c0c16d2d-b4b2-4d7a-8f1e-606ee2030ad9@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding 8bit
Injection-Info mx05.eternal-september.org; posting-host="cd35b235ebd83fc247d9b6a5b22d0560"; logging-data="2389"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/jAUvqgrLnWkRgHBOqUty+"
User-Agent Mozilla/5.0 (Windows NT 6.0; WOW64; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
In-Reply-To <c0c16d2d-b4b2-4d7a-8f1e-606ee2030ad9@googlegroups.com>
Cancel-Lock sha1:8mpfOFgrlMK+eSLvJlUQSVAawBY=
Xref csiph.com comp.lang.python:42192

Show key headers only | View raw

On 3/27/2013 11:50 PM, Νίκος Γκρ33κ wrote:
> I'am about to go nuts with python 3.2.3
>
> Do you see somehtign wrong with the following statement?
>
> cur.execute( '''SELECT hits FROM counters WHERE url = ?''', (page,) )
> data = cur.fetchone()
>
> because as you can see by visiting my webpage at http://superhost.gr it produces an error and i dont have  aclue why.
>
> Please help. i'am using MySQLdb
>
Nikos,

When I try to connect to that web page I see the following error message:

"ImportError: No module named pymysql "

If that's what you're getting, there's nothing wrong with your SQL or 
your cur.execute statement.  The problem is that the web server is not 
finding the pymysql module.

Is pymysql installed on the computer that is running your application? 
Can the web server module find it?

I must be missing something because, if that's the problem, your object 
named "cur" could not have been created successfully.  Maybe what I'm 
seeing is a new problem?

     Alan

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Cannot run  a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 20:50 -0700
  Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:00 +1100
    Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:03 -0700
      Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:08 -0700
        Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:14 +1100
      Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:08 +1100
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:18 -0700
          Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:26 +1100
            Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:30 -0700
              Re: Cannot run a single MySQLdb execute.... Chris Angelico <rosuav@gmail.com> - 2013-03-28 15:35 +1100
                Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:39 -0700
                Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:39 -0700
            Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:30 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:18 -0700
      Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:08 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 02:44 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 02:44 -0700
      Re: Cannot run a single MySQLdb execute.... David M Chess <chess@us.ibm.com> - 2013-03-28 10:51 -0400
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 12:35 -0700
        Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-28 12:35 -0700
    Re: Cannot run a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-27 21:03 -0700
  Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-28 16:54 -0400
    Re: Cannot run  a single MySQLdb execute.... Νίκος Γκρ33κ <nikos.gr33k@gmail.com> - 2013-03-29 00:40 -0700
      Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-29 13:32 -0400
        Re: Cannot run  a single MySQLdb execute.... Alan Meyer <ameyer2@yahoo.com> - 2013-03-29 13:39 -0400
          Re: Cannot run  a single MySQLdb execute.... nagia.retsina@gmail.com - 2013-03-29 12:24 -0700

csiph-web