search

uchup / autoblock

Automatically exported from code.google.com/p/autoblock
0 stars 0 forks source link

Some spammers do not specify a valid email address and a blank email address fails insertion #132

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Logs show:

SqlDataAccess error:  "INSERT OR REPLACE INTO inbound_blacklist (address) 
VALUES()" . QSqlError::type= "QSqlError::StatementError" , QSqlError::number= 1 
, databaseText= "near ")": syntax error" , driverText= "Unable to execute 
statement" 

Because:
=== ../src/QueryHelper.cpp 156 block (QVariant(QVariantMap, QMap(("aid", 
QVariant(double, 1.36404e+09) ) ( "cid" ,  QVariant(QString, "5444") ) ( "id" , 
 QVariant(int, 7747) ) ( "inbound" ,  QVariant(bool, true) ) ( "replyTo" ,  
QVariant(QString, "") ) ( "sender" ,  QVariant(QString, "Alcohol Detox") ) ( 
"senderAddress" ,  QVariant(QString, "") ) ( "subject" ,  QVariant(QString, 
"Drinking too much? Get help here.") ) ( "text" ,  QVariant(QString, "

Both the replyTo and the senderAddress fields are empty. We need to guard 
against this and show an appropriate error message.

Original issue reported on code.google.com by canadai...@gmail.com on 13 Jul 2014 at 5:51

GoogleCodeExporter commented 9 years ago 
1403287117121   1403485728871   1403811848736   1404535400046   1404635692456   1404909960
958 1405026480308
1403294397534   1403529005432   1404198370758   1404629674990   1404793171736   1404910004
089
1403480043975   1403529037598   1404235878101   1404631008644   1404824004475   1405000834
344

Original comment by canadai...@gmail.com on 13 Jul 2014 at 5:55

GoogleCodeExporter commented 9 years ago 
1403802394838
1403835398806
1404003435469

Original comment by canadai...@gmail.com on 13 Jul 2014 at 6:17

GoogleCodeExporter commented 9 years ago 
dc5f01fce79ce0671140921cbb960a3e01ad9c7d

Original comment by canadai...@gmail.com on 13 Jul 2014 at 7:26

GoogleCodeExporter commented 9 years ago 
v3.3 target.

Original comment by canadai...@gmail.com on 17 Jul 2014 at 4:39

GoogleCodeExporter commented 9 years ago 
Verified in GCR 3.3.0.0 on Z30, 10.3.0.914

Original comment by canadai...@gmail.com on 22 Jul 2014 at 3:27