Skip to content

Instantly share code, notes, and snippets.

@anibalpacheco
Created September 30, 2013 15:07
Show Gist options
  • Save anibalpacheco/6765154 to your computer and use it in GitHub Desktop.
Save anibalpacheco/6765154 to your computer and use it in GitHub Desktop.
sqlalchemy.exc.ProgrammingError: (ProgrammingError) column package.creator_user_id does not exist
(pyenv_ckan2)[ckan@ckan-desa ckan]$ paster dataset list -c development_appstore.ini
Datasets:
Traceback (most recent call last):
File "/usr/local/ckan/pyenv_ckan2/bin/paster", line 8, in <module>
load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/paste/script/command.py", line 104, in run
invoke(command, command_name, options, args[1:])
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/paste/script/command.py", line 143, in invoke
exit_code = runner.run(args)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/paste/script/command.py", line 238, in run
result = self.command()
File "/usr/local/ckan/pyenv_ckan2/src/ckan/ckan/lib/cli.py", line 817, in command
self.list()
File "/usr/local/ckan/pyenv_ckan2/src/ckan/ckan/lib/cli.py", line 827, in list
print 'count = %i' % datasets.count()
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2571, in count
return self.from_self(col).scalar()
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2215, in scalar
ret = self.one()
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2184, in one
ret = list(self)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
return self._execute_and_instances(context)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
params)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
context)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
context)
File "/usr/local/ckan/pyenv_ckan2/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) column package.creator_user_id does not exist
LINE 2: ...age_type, package.owner_org AS package_owner_org, package.cr...
^
'SELECT count(*) AS count_1 \nFROM (SELECT package.id AS package_id, package.name AS package_name, package.title AS package_title, package.version AS package_version, package.url AS package_url, package.author AS package_author, package.author_email AS package_author_email, package.maintainer AS package_maintainer, package.maintainer_email AS package_maintainer_email, package.notes AS package_notes, package.license_id AS package_license_id, package.type AS package_type, package.owner_org AS package_owner_org, package.creator_user_id AS package_creator_user_id, package.metadata_modified AS package_metadata_modified, package.private AS package_private, package.state AS package_state, package.revision_id AS package_revision_id \nFROM package ORDER BY package.name) AS anon_1' {}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment