StalkPhish has 8 columns but 10 values were supplied
Closed this issue · 6 comments
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
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
Ok I probably forgot something when DB is create. Gonna check.
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
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 !!!
After had doing differents tests, I can't reproduce your error. I finally found someting in SQLiteCreateTable function ( 3a16d06 ), maybe it was the problem. Tell me if it's ok for you.
I did a fresh install of StalkPhish with new DB on a new system and it worked!!!!
Thanks for your help and the fix !!!!