Git Product home page Git Product logo

Comments (3)

feferri avatar feferri commented on June 20, 2024

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.

tomslee avatar tomslee commented on June 20, 2024

@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.

luisencalada avatar luisencalada commented on June 20, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.