Don't Understand Error
Victor Subervi
victorsubervi at gmail.com
Mon Nov 23 13:10:35 EST 2009
Hi;
I have the following code:
#!/usr/bin/env python
import smtplib
import cgitb; cgitb.enable()
import cgi
import sys,os
sys.path.append(os.getcwd())
from login import login
import MySQLdb
import re, string
def mailSpreadsheet():
user, passwd, db, host = login()
database = MySQLdb.connect(host, user, passwd, db)
cursor= database.cursor()
ourEmail1 = 'anemail at here.com'
ourEmail2 = 'anotheremail at here.com'
form = cgi.FieldStorage()
client = form.getfirst('client', '')
clientEmail = form.getfirst('clientEmail', '')
po = form.getfirst('po', '')
subject = 'Order From Client'
sql = 'select clientEmail from clients where client="%s";' %
(string.replace(client, '_', ' '))
cursor.execute(sql)
clientEmail = cursor.fetchone()[0]
cursor.execute('select * from %s;' % (client))
data = cursor.fetchall()
i = 0
if po != '':
order = 'PO#: %s\n' % (po)
else:
order = ''
total = 0
for row in data:
i += 1
quantity = form.getfirst('order_' + str(i), '')
if quantity != '0':
sql = 'select * from products p join %s c on p.ID=c.ID where c.ID=%s;'
% (client, str(i))
cursor.execute(sql)
stuff = cursor.fetchone()
price = str(int(stuff[5]*100))
price = price[0:len(price)-2] + '.' + price[-2:]
item, price, description, discount = stuff[2], price, stuff[3],
stuff[8]
order += 'Item #: ' + item + '\tQuantity: ' + quantity + '\tPrice: ' +
price + '\tDiscount: ' + str(discount) + '\tDescription: ' +
description[:20] + '...\n'
total += float(price) * int(quantity) * (100 - discount)/100
order += 'TOTAL: $' + str(total)
msg = 'Here is the order from %s:\n\n %s' % (string.replace(client, '_', '
'), order)
session = smtplib.SMTP("localhost")
session.login(user, passwd) # only if it requires auth
header = "Subject: %s \r\nContent-type: text/html; charset=utf-8\r\n\r\n"
% subject
# session.sendmail(clientEmail, ourEmail1, header+msg)
session.sendmail(clientEmail, ourEmail2, header+msg)
mailSpreadsheet()
The email does get sent, and it that happens out of the last line of code.
If I surround the code with code to make it print a Web page, it prints
without any error. However, as it is, it throws the following error:
The server encountered an internal error or misconfiguration and was unable
to complete your request.
Please contact the server administrator, me at creative.vi and inform them of
the time the error occurred, and anything you might have done that may have
caused the error.
More information about this error may be available in the server error log.
[Mon Nov 23 09:52:21 2009] [error] [client 66.248.168.98] Premature end of
script headers: mailSpreadsheet.py, referer:
http://globalsolutionsgroup.vi/display_spreadsheet.py
Why?
TIA,
Victor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091123/386bd2bf/attachment.html>
More information about the Python-list
mailing list