Страница 1 из 1

dspam-learn

Добавлено: 2008-11-10 16:04:04
kialeon
Почти собрал почтовик по статье http://www.lissyara.su/?id=1759 , все прикрасно работает , но остался не маловажный этап . Это скрипт dspam-learn сортировки спама. К сожелению при его запуске выдаются ошибки.

Код: Выделить всё

/usr/local/bin/dspam-learn:110: DeprecationWarning: begin() is non-standard and will be removed in 1.3
  connection.begin();
Processing mailbox kia1@ppp.maverick.ru ...
Traceback (most recent call last):
  File "/usr/local/bin/dspam-learn", line 115, in <module>
    main(sys.argv[1:])
  File "/usr/local/bin/dspam-learn", line 111, in main
    export(connection)
  File "/usr/local/bin/dspam-learn", line 98, in export
    process('spam')
  File "/usr/local/bin/dspam-learn", line 73, in process
    cursor_messages.execute(sql_messages[spam_class], alias)
  File "/usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'dbmail_messages.spam_flag' in 'where clause'")
Может подскажитте в чем заморочка.

Re: dspam-learn

Добавлено: 2008-11-11 13:25:42
manefesto
не хватает какого то питоновского модуля

Re: dspam-learn

Добавлено: 2008-11-11 15:21:19
kialeon
Врятли , последнии исладование показали закономерность пока не привяжеш к пользователю ящик скрипт срабатыват.

ppp# dbmail-users -a test -w password
Adding INBOX for new user... ok.
Done
test:x:11:0:0.00:0.00:
ppp# /usr/local/bin/dspam-learn
ppp# dbmail-users -c test -s test@mydomain.ru
Performing changes for user [test]...
[test@mydomain.ru]
Done
ppp# /usr/local/bin/dspam-learn
Processing mailbox test@mydomain.ru ...
Traceback (most recent call last):
File "/usr/local/bin/dspam-learn", line 117, in <module>
main(sys.argv[1:])
File "/usr/local/bin/dspam-learn", line 113, in main
export(connection)
File "/usr/local/bin/dspam-learn", line 100, in export
process('spam')
File "/usr/local/bin/dspam-learn", line 75, in process
cursor_messages.execute(sql_messages[spam_class], alias)
File "/usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'dbmail_messages.spam_flag' in 'where clause'")