Στις 2/11/2013 4:00 πμ, ο/η ru...@yahoo.com έγραψε:
On Friday, November 1, 2013 9:04:08 AM UTC-6, Ferrous Cranus wrote:
Rurpy can you help me please solve this?
is enum or set column types what needed here as proper columns to store
'download' list?
I'd help if I could but I don't use MySql
You can see the erro as its appearing here:
http://superhost.gr/
Its weird that no single quotes are enclosing the string values though
and the other bizarre thign is that 'downloads' list is tryign to fiull
in all the movies.
--
https://mail.python.org/mailman/listinfo/python-list
Nick the Gr33k nikos.gr...@gmail.com writes:
sql = '''INSERT INTO visitors (counterID, refs, host, city, useros,
browser, visits, downloads) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)'''
% (cID, refs, host, city, useros, browser, visits, downloads)
It was suggested *several* times but I'll
On Sat, 02 Nov 2013 02:06:59 +0200, Nick the Gr33k wrote:
HOW this 'list' is supposed to get stored into the visitors database?
What colum is able to handle this list?
A python list is a python datatype. mysql has no equivalent data type to
a python list. You need to convert your python list
Στις 1/11/2013 12:24 πμ, ο/η Nick the Gr33k έγραψε:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
You set the value of 'downloads' to a list:
downloads = []
if data:
for torrent in data:
downloads.append( torrent )
and when you use 'downloads', use have:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
On 10/31/2013 03:24 AM, Nick the Gr33k wrote:
[...]
# find out if visitor has downloaded torrents in the past
cur.execute('''SELECT torrent FROM files WHERE host = %s''', host )
data = cur.fetchall()
downloads = []
Στις 1/11/2013 5:04 μμ, ο/η Nick the Gr33k έγραψε:
Στις 1/11/2013 12:24 πμ, ο/η Nick the Gr33k έγραψε:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
You set the value of 'downloads' to a list:
downloads = []
if data:
for torrent in data:
downloads.append(
On Fri, Nov 1, 2013 at 11:25 AM, Nick the Gr33k nikos.gr...@gmail.com wrote:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
On 10/31/2013 03:24 AM, Nick the Gr33k wrote:
[...]
# find out if visitor has downloaded torrents in the past
cur.execute('''SELECT torrent FROM files
Στις 1/11/2013 5:56 μμ, ο/η Joel Goldstick έγραψε:
On Fri, Nov 1, 2013 at 11:25 AM, Nick the Gr33k nikos.gr...@gmail.com wrote:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
On 10/31/2013 03:24 AM, Nick the Gr33k wrote:
[...]
# find out if visitor has downloaded torrents in the past
Joel Goldstick joel.goldst...@gmail.com wrote in message
news:mailman.1935.1383321401.18130.python-l...@python.org...
On Fri, Nov 1, 2013 at 11:25 AM, Nick the Gr33k nikos.gr...@gmail.com
wrote:
31/10/2013 9:22 ??, ?/? ru...@yahoo.com ??:
On 10/31/2013 03:24 AM, Nick the Gr33k wrote:
Στις 1/11/2013 7:07 μμ, ο/η Paul Simon έγραψε:
If you have a list of values of the same type, but different values,
you need a new table with a foreign key to the table it relates to.
This is a relational database question. You can read more here:
On Thu, 31 Oct 2013 11:32:29 +0200, Nick the Gr33k wrote:
The error seen form error log is:
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')
(cID, refs, host, city, useros, browser, visits, downloads) )
I
Nick the Gr33k nikos.gr...@gmail.com wrote in message
news:l50oo5$k05$1...@dont-email.me...
1/11/2013 7:07 ??, ?/? Paul Simon ??:
If you have a list of values of the same type, but different values,
you need a new table with a foreign key to the table it relates to.
This is a
Στις 1/11/2013 9:12 μμ, ο/η Denis McMahon έγραψε:
On Thu, 31 Oct 2013 11:32:29 +0200, Nick the Gr33k wrote:
The error seen form error log is:
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')
(cID, refs,
On Friday, November 1, 2013 9:04:08 AM UTC-6, Ferrous Cranus wrote:
Rurpy can you help me please solve this?
is enum or set column types what needed here as proper columns to store
'download' list?
I'd help if I could but I don't use MySql and don't know anything
about its column types. All
# if first time for webpage; create new record( primary key is
automatic, hit is defaulted ), if page exists then update record
cur.execute('''INSERT INTO counters (url) VALUES (%s) ON DUPLICATE KEY
UPDATE hits = hits + 1''', page )
# get the primary key
The error seen form error log is:
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93] Traceback
(most recent call last):
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93] File
/home/nikos/public_html/cgi-bin/metrites.py,
Στις 31/10/2013 11:32 πμ, ο/η Nick the Gr33k έγραψε:
The error seen form error log is:
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93] Traceback
(most recent call last):
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
Στις 31/10/2013 1:19 μμ, ο/η Nick the Gr33k έγραψε:
Στις 31/10/2013 11:32 πμ, ο/η Nick the Gr33k έγραψε:
The error seen form error log is:
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93]
[Thu Oct 31 09:29:35 2013] [error] [client 46.198.103.93] Traceback
(most recent call last):
[Thu
Am 31.10.13 17:49, schrieb Nick the Gr33k:
Στις 31/10/2013 1:19 μμ, ο/η Nick the Gr33k έγραψε:
someone please that is aware of what's wrong?
Your attitude.
--
https://mail.python.org/mailman/listinfo/python-list
On 10/31/2013 03:24 AM, Nick the Gr33k wrote:
[...]
# find out if visitor has downloaded torrents in the past
cur.execute('''SELECT torrent FROM files WHERE host = %s''', host )
data = cur.fetchall()
downloads = []
if data:
for torrent in data:
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
You set the value of 'downloads' to a list:
downloads = []
if data:
for torrent in data:
downloads.append( torrent )
and when you use 'downloads', use have:
INSERT INTO visitors
Στις 31/10/2013 9:22 μμ, ο/η ru...@yahoo.com έγραψε:
You set the value of 'downloads' to a list:
downloads = []
if data:
for torrent in data:
downloads.append( torrent )
and when you use 'downloads', use have:
INSERT INTO visitors
23 matches
Mail list logo