cohnen / tt2

Tripadvisor Stoke on Trent


Last run failed with status code 1.

Console output of last run

Starting On page http://www.tripadvisor.com/AttractionsAjax-g186378?cat=25&o=a0&sortOrder=popularity Url: http://www.tripadvisor.com/Attraction_Review-g1097116-d1997643-Reviews-Aerial_Extreme_Staffordshire-Trentham_Stoke_on_Trent_Staffordshire_England.html [] Traceback (most recent call last): File "/repo/scraper.py", line 86, in <module> parse_listing_pages(start_url) File "/repo/scraper.py", line 81, in parse_listing_pages parse_list(root) File "/repo/scraper.py", line 64, in parse_list scraperwiki.sqlite.save(unique_keys=['source_url'], data=data, table_name="tripadvisor_SOT") File "/usr/local/lib/python2.7/dist-packages/scraperwiki-0.3.7-py2.7.egg/scraperwiki/sqlite.py", line 34, in save return dt.upsert(data, table_name = table_name) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 301, in upsert self.insert(upsert=True, *args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 284, in insert self.execute(sql, values, commit=False) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 138, in execute raise self.sqlite3.InterfaceError(unicode(msg) + '\nTry converting types or pickling.') sqlite3.InterfaceError: Error binding parameter 4 - probably unsupported type. Try converting types or pickling.

Data

Downloaded 1 time by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (19 KB) Use the API

rows 10 / 26

ranking name telephone source_url address email description
Wedgwood Visitor Centre
Emma Bridgewater Factory
Burleigh Factory Tour
Wedgwood Visitor Centre
Emma Bridgewater Factory
Burleigh Factory Tour
Wedgwood Visitor Centre
Emma Bridgewater Factory
Burleigh Factory Tour
4.0
Wedgwood Visitor Centre

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 41 KB

History

  • Manually ran revision f55421a0 and failed .
    nothing changed in the database
  • Created on morph.io

Scraper code

tt2