On Thu, Apr 3, 2008 at 9:34 AM, Gabriel Genellina <[EMAIL PROTECTED]> wrote:
> En Thu, 03 Apr 2008 09:43:57 -0300, Victor Subervi > <[EMAIL PROTECTED]> escribió: > > >> Steve Holden wrote: > >> Define "no longer works". > > Sorry. Throws HTTP 200 error. > > HTTP 200 means OK. Yes. But there is an error somewhere, because it doesn´t run all the code. For example, I have to manually drop the table. > > > >> > The same remarks I've posted earlier apply here. > > Must have missed those. Yes, the code works fine. Repeatedly. > > > http://groups.google.com/group/comp.lang.python/browse_thread/thread/b732eee4e91b1868/ Thank you. I believe you mean by bound, something like this, right? binary(picdata) I am now doing that, if I am not mistaken. > display or *log* errors... Yeah. There are always errors... > *post*? This is the server response. Return either text *or* an image (the > text may be an html referencing the image) Yes, post. But what do I write instead of this? print 'Content-Type: image/jpeg\r\n' > Test it locally (just the database thing, no web), test the cgi script > without database interaction, only then join the two. Okay, but how do I upload an image into mysql without a script? And once I can do that, everything´s (almost) solved! > But you can read the server logs at least? I am new to Plesk. I discovered I can read logs. More following... > > Your code is throwing exceptions but you're not seeing them. Use the cgitb > module http://docs.python.org/lib/module-cgitb.html Now here you give me another laugh :) I added this line to the script import cgitb; cgitb.enable() and suddenly I can take out these junk lines that were throwing the HTTP 200 error: names = 'aramis', 'athos', 'porthos' data = {} for name in names: datum = list(name) datum.sort() data[name] = cPickle.dumps(datum, 1) Is this some kind of magic wand? :) Okay, where I am at now... I have a script called start.py which has this code in it: import cgitb; cgitb.enable() import MySQLdb import struct import _mysql, sys Lots of imports, just to try things out. Most not needed... col_names = ['id', 'name_en', 'name_es', 'name_it', 'category', 'title_en', 'title_es', 'title_it', \ 'description_en', 'description_es', 'description_it', 'price', 'bedrooms', 'bathrooms', 'pic1', 'sort_factor'] Just notice the pic1 there... Then I make a nice list of colnames like MySQL wants... col_names_with_commas = '' for name in col_names: col_names_with_commas += name + ', ' count = len(col_names_with_commas)-2 col_names_with_commas = col_names_with_commas[0:len(col_names_with_commas)-2] All that I have checked, it is good... Here is the sticky point: for id in ids: for d in id: print '<tr>\n' cursor.execute('select ' + col_names_with_commas + ' from products where id = ' + str(d) + ';') col_fields = cursor.fetchall() i = 0 x = 0 for field in col_fields[0]: if x == 0: # This is the ID field i += 1 check = 'check' + str(i) print '<td><input type="checkbox" name="', check, '" value="', field, '" /></td>\n' if x == 15: print '<td>', field, '</td>\n' else: print '<td>', field, '</td>\n' x += 1 I have to do both of those for statements. The sticky point is in the last if statement. 15 is the pic1 field. Should I use binary(field) instead? It does not like that. I send the whole thing over to another script which has this: import cgitb; cgitb.enable() import MySQLdb import cgi import struct Same old same old... Here´s the sticky part... if what_do == 'insert': data = ['', '', '', '', '', '', '', '', '', '', '', 0.0, '', '', '', 500] the_form(data, what_do) elif what_do == 'update': cursor.execute('select * from products where id=' + update_these[0] + ';') data = cursor.fetchall() the_form(data[0], what_do) And then try to render... <td> 1ra Foto Grande: </td><td> <input type='file' name='pic1' value=""" print '"', binary(data[14]), '"' print """ /> I show you both parts, because the Internal Server Error comes from the second page, but the logged error points to the first page. Here is the log record... [Thu Apr 03 09:53:33 2008] [error] [client 190.166.0.65] PythonHandler mod_python.cgihandler: File "/var/www/vhosts/ livestocksling.com/httpdocs/test/python/Shop/iud.py", line 210, in the_form\n print '"', binary(data[14]), '"', referer: http://livestocksling.com/test/python/Shop/start.py [Thu Apr 03 09:53:33 2008] [error] [client 190.166.0.65] PythonHandler mod_python.cgihandler: NameError: global name 'binary' is not defined, referer: http://livestocksling.com/test/python/Shop/start.py TIA, Victor
-- http://mail.python.org/mailman/listinfo/python-list
