search

t4d / StalkPhish

StalkPhish - The Phishing kits stalker, harvesting phishing kits for investigations.
GNU Affero General Public License v3.0
611 stars 81 forks source link

StalkPhish has 8 columns but 10 values were supplied #19

Closed TheQuickRedFoxx closed 4 years ago

TheQuickRedFoxx commented 4 years ago

Receiving the below error when executing StalkPhish on a fresh O/S (Raspbian) install and fresh Git Pull on July 18/2019.

2019-07-18 20:00:39,477 - StalkPhish.py - INFO - Proceeding to OSINT modules launch 2019-07-18 20:00:40,651 - urlscan.py - INFO - Searching for 'webmail'... 2019-07-18 20:00:44,297 - urlscan.py - INFO - hxxps[:]//bad-domain.com bad-domain.com x.x.x.x https://urlscan.io/result/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Thu Jul 18 20:00:40 2019 aborted 2019-07-18 20:00:44,298 - urlscan.py - ERROR - HTML parser Error: table StalkPhish has 8 columns but 10 values were supplied

TheQuickRedFoxx commented 4 years ago

Here is the header info when you run the script

2019-07-18 20:41:24,247 - StalkPhish.py - INFO - Configuration file to use: conf/example.conf 2019-07-18 20:41:24,248 - StalkPhish.py - INFO - Database: ./db/StalkPhish.sqlite3 2019-07-18 20:41:24,249 - StalkPhish.py - INFO - Main table: StalkPhish 2019-07-18 20:41:24,251 - StalkPhish.py - INFO - Investigation table: StalkPhishInvestig 2019-07-18 20:41:24,252 - StalkPhish.py - INFO - Files directory: ./files/ 2019-07-18 20:41:24,253 - StalkPhish.py - INFO - Download directory: ./dl/ 2019-07-18 20:41:24,253 - StalkPhish.py - INFO - Declared Proxy: None

t4d commented 4 years ago

Ok I probably forgot something when DB is create. Gonna check.

t4d commented 4 years ago

I checked with a fresh clone, when a new DB is created all is good. Don't you use an old database? Probably, in case, you have to had 3 columns into tables, as specified in README.md (maybe not so clearly), see https://github.com/t4d/StalkPhish/blob/master/README.md#upgrade-stalkphish-to-096

TheQuickRedFoxx commented 4 years ago

This was a new installation on a new OS, new install of StalkPhish and a fresh DB. I did not think I needed to do the upgrade as everything was new.

I added the 3 columns as mentioned in the "Upgrade StalkPhish to 0.9.6" and it works.

Appreciate your help - Awesome Tool btw !!!

t4d commented 4 years ago

After had doing differents tests, I can't reproduce your error. I finally found someting in SQLiteCreateTable function ( https://github.com/t4d/StalkPhish/commit/3a16d0685f6b1de0ce9aad098d4e995325435fa6 ), maybe it was the problem. Tell me if it's ok for you.

TheQuickRedFoxx commented 4 years ago

I did a fresh install of StalkPhish with new DB on a new system and it worked!!!!

Thanks for your help and the fix !!!!