This scrapper runs fine returning results. However, when I try to reduce the number of schools in the following line from: colleges = {“580”:(“MIT”,16),“1222”:(“Yale”,23),“181”:(“CMU”,28), “1085”:(“UChicago”,28),“1040”:(“Tufts”,46), “1350”:(“Duke”,84),“1255”:(“UTexas”,84),“953”:(“Stanford”,32),“799”:(“Rice”,17),“780”:(“Princeton”,16)}
to
colleges = {“580”:(“MIT”,16)}
I get the following error:
error":“no such table: data”}
I understand that this issue is rather specific… However any insight to this problem would be greatly appreciated.
Using the following SQL query: select * from data limit 10
When I curl it or click the URL, it yields the following error: error":“no such table: data”}
It is rather strange considering the only thing that I modified is the amount of colleges. The reduction of colleges is the only thing I’ve changed yet the input is resulting in an error. If I use the original code from:
All the data in the scraper has now disappeared so I guess you changed something else since I last looked.
Post here when you’ve got data back in the scraper and I can have a look again. I suspect the table name was just different (ScraperWiki used swdata) so all you probably need to do is change the SQL query the API is using.