Error message

nickle

unread,

Apr 19, 2012, 8:30:42 AM4/19/12

to scrap...@googlegroups.com

SqliteError: sqliteexecute: sqlite3.Error: no such table: main.swdata

I've cleared all the data, and get this message on the first attempt at storing data.

I presume this is an internal error because the db hasn't been cleared

What do I do?

Zarino Zappia

unread,

Apr 19, 2012, 8:31:52 AM4/19/12

to scrap...@googlegroups.com

Do you have a link to the scraper?

Zarino Zappia

VP of Product, ScraperWiki

@zarino

Ross Jones

unread,

Apr 19, 2012, 8:37:47 AM4/19/12

to scrap...@googlegroups.com

I've seen this before if you clear your data and then try to query the database before you've saved anything. Normally manifests as someone selecting something to see how far they've got on a previous run, or deleting data before a re-run . Might you be doing something like that?

Ross.

On 19 Apr 2012, at 13:30, nickle wrote:

nickle

unread,

Apr 19, 2012, 9:26:21 AM4/19/12

to scrap...@googlegroups.com

nickle / DividendNorthCote

Shyam Peri

unread,

Apr 19, 2012, 10:18:12 AM4/19/12

to scrap...@googlegroups.com

It looks like some SQL error is masked under "sqlite3.Error: no such table: main.swdata". If one would remove the unique_keys its running fine.