hdx-ckan icon indicating copy to clipboard operation
hdx-ckan copied to clipboard

relation "page" does not exist - LINE 2: FROM page

Open kartikbha opened this issue 6 years ago • 1 comments

I am getting below error. Pls suggest.

File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 947, in _execute_context context) File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 435, in do_execute cursor.execute(statement, parameters) ProgrammingError: (ProgrammingError) relation "page" does not exist LINE 2: FROM page ^ 'SELECT page.id AS page_id, page.name AS page_name, page.title AS page_title, page.description AS page_description, page.type AS page_type, page.state AS page_state, page.sections AS page_sections, page.modified AS page_modified, page.status AS page_status \nFROM page \nWHERE page.state = %(state_1)s' {'state_1': 'active'}

kartikbha avatar Apr 16 '18 07:04 kartikbha

This would indicate you might have some issues on the database side. Did you initialised the database with paster db init -c /your/path/to/ckan.ini?

teodorescuserban avatar Apr 16 '18 13:04 teodorescuserban