Comments (3)
Does someone is getting this error?
INFO Bounding box: [38.795854, -9.090571, 38.691399, -9.229836]
INFO ======================================================================
INFO Survey 17, for Lisbon
INFO Searching by bounding box, max_zoom=8
INFO ----------------------------------------------------------------------
INFO Rectangle calculated: [38.795854, -9.090571, 38.691399, -9.229836]
INFO Searching rectangle: zoom factor = 0, node = []
ERROR Exception in get_search_page_info_rectangle
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 138, in save
self.__insert()
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 291, in __insert
cur.execute(sql, insert_args)
psycopg2.ProgrammingError: column "coworker_hosted" of relation "room" does not exist
LINE 7: coworker_hosted, extra_host_languages, n...
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 679, in search_node
if listing.save(self.config.FLAGS_INSERT_NO_REPLACE):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 148, in save
self.config.connection.conn.rollback()
AttributeError: 'psycopg2.extensions.connection' object has no attribute 'conn'
ERROR Error in recurse_quadtree
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 138, in save
self.__insert()
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 291, in __insert
cur.execute(sql, insert_args)
psycopg2.ProgrammingError: column "coworker_hosted" of relation "room" does not exist
LINE 7: coworker_hosted, extra_host_languages, n...
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 434, in recurse_quadtree
(zoomable, median_leaf) = self.search_node(quadtree_node, median_node, flag)
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 679, in search_node
if listing.save(self.config.FLAGS_INSERT_NO_REPLACE):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 148, in save
self.config.connection.conn.rollback()
AttributeError: 'psycopg2.extensions.connection' object has no attribute 'conn'
ERROR Error
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 138, in save
self.__insert()
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 291, in __insert
cur.execute(sql, insert_args)
psycopg2.ProgrammingError: column "coworker_hosted" of relation "room" does not exist
LINE 7: coworker_hosted, extra_host_languages, n...
^
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 395, in search
self.recurse_quadtree(quadtree_node, median_node, flag)
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 434, in recurse_quadtree
(zoomable, median_leaf) = self.search_node(quadtree_node, median_node, flag)
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_survey.py", line 679, in search_node
if listing.save(self.config.FLAGS_INSERT_NO_REPLACE):
File "C:\Users\fe_fe\OneDrive\Documentos\tomslee airbnb\airbnb_listing.py", line 148, in save
self.config.connection.conn.rollback()
AttributeError: 'psycopg2.extensions.connection' object has no attribute 'conn'
from airbnb-data-collection.
@tjukanovt : this problem should now be fixed.
@feferri: it seems that you have an old version of the SQL scripts. I don't have an automatic way to update that, but take a look in postgres/schema_current.sql for what it should be. Here is the table definition for the table "room" which holds most of the listings:
CREATE TABLE public.room
(
room_id integer NOT NULL,
host_id integer,
room_type character varying(255),
country character varying(255),
city character varying(255),
neighborhood character varying(255),
address character varying(1023),
reviews integer,
overall_satisfaction double precision,
accommodates integer,
bedrooms numeric(5,2),
bathrooms numeric(5,2),
price double precision,
deleted integer,
minstay integer,
last_modified timestamp without time zone DEFAULT now(),
latitude numeric(30,6),
longitude numeric(30,6),
survey_id integer NOT NULL DEFAULT 999999,
location geometry,
coworker_hosted integer,
extra_host_languages character varying(255),
name character varying(255),
property_type character varying(255),
currency character varying(20),
rate_type character varying(20),
CONSTRAINT room_pkey PRIMARY KEY (room_id, survey_id)
)
WITH (
OIDS=FALSE
);
from airbnb-data-collection.
Hello to all! I am getting this problem when searching by bbox... Warning HTTP Status 400 from web site: IP address blocked.Waiting 1.0 minutes... It seems my university IP is blocked... Do you have any recommendation to overpass this issue? When searching by zipcode or neighborhood, it finishes the process but no data is on DB.. Thanks in advance! I am looking for data within Lisbon boundaries
from airbnb-data-collection.
Related Issues (20)
- Not sure about retrieving process is running right HOT 1
- IP address blocked and survey quitting instantly HOT 4
- airbnb-home pictures-collection HOT 1
- Adding new search parameter/columns? HOT 1
- IP address blocked HOT 3
- Default Config selection HOT 2
- Suggestion : Fetching bounding box with Nominatim Api (OSM)
- Almost there... HOT 4
- IP address blocked when trying to run a search by bouding box. HOT 1
- same page of listings returned HOT 2
- Debugging/experimenting on individual property
- Airbnb API key HOT 4
- Missing properties in new version HOT 1
- get() takes exactly 1 argument (6 given) HOT 1
- Only 18 items returned HOT 1
- Proxy locations and fetched prices HOT 2
- Bounding box survey broken? HOT 2
- Conflicts between airbnb-data-collection and prompt-toolkit HOT 3
- Any up-to-date alternatives of this? HOT 5
- Some advice about license compliance
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from airbnb-data-collection.