Search Forums
4 posts Started 1 year ago by 86me Latest reply from Anthony Theocharis
I am getting this error when trying to upload a video: "CompileError: Bind parameter name 'media_id' is reserved for the VALUES or SET clause of this insert/update statement."
I am using MediaCore-0.7.2 with the paste development server.
The last traceback is:
Module sqlalchemy.sql.compiler:553 in visit_bindparam
>> % bindparam.key
Any ideas?
That's odd, on what page and under what circumstances is this occurring?
It's happening when trying to upload a video. Here is the full error:
URL: http://intelflv.com:8080/upload_submit
File '/home/egon/lib/python2.5/site-packages/WebError-0.10.2-py2.5.egg/weberror/evalexception.py', line 431 in respond
app_iter = self.application(environ, detect_start_response)
File '/home/egon/lib/python2.5/site-packages/TurboGears2-2.0.3-py2.5.egg/tg/configuration.py', line 655 in wrapper
return app(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/TurboGears2-2.0.3-py2.5.egg/tg/configuration.py', line 555 in remover
return app(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/repoze.tm2-1.0a5-py2.5.egg/repoze/tm/__init__.py', line 23 in __call__
result = self.application(environ, save_status_and_headers)
File '/home/egon/lib/python2.5/site-packages/repoze.who-1.0.8-py2.5.egg/repoze/who/middleware.py', line 107 in __call__
app_iter = app(environ, wrapper.wrap_start_response)
File '/home/egon/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/middleware.py', line 43 in __call__
return self.wsgi_app(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/middleware.py', line 68 in wsgi_app
resp = req.get_response(self.application)
File 'build/bdist.linux-i686/egg/webob/request.py', line 919 in get_response
File 'build/bdist.linux-i686/egg/webob/request.py', line 887 in call_application
File '/home/egon/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/resource_injector.py', line 68 in _injector
resp = req.get_response(app)
File 'build/bdist.linux-i686/egg/webob/request.py', line 919 in get_response
File 'build/bdist.linux-i686/egg/webob/request.py', line 887 in call_application
File '/home/egon/lib/python2.5/site-packages/Beaker-1.5.3-py2.5.egg/beaker/middleware.py', line 73 in __call__
return self.app(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/Beaker-1.5.3-py2.5.egg/beaker/middleware.py', line 152 in __call__
return self.wrap_app(environ, session_start_response)
File '/home/egon/lib/python2.5/site-packages/Routes-1.10.3-py2.5.egg/routes/middleware.py', line 130 in __call__
response = self.app(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/Pylons-0.9.7-py2.5.egg/pylons/wsgiapp.py', line 125 in __call__
response = self.dispatch(controller, environ, start_response)
File '/home/egon/lib/python2.5/site-packages/Pylons-0.9.7-py2.5.egg/pylons/wsgiapp.py', line 324 in dispatch
return controller(environ, start_response)
File '/home/egon/lib/python2.5/site-packages/Pylons-0.9.7-py2.5.egg/pylons/controllers/core.py', line 221 in __call__
response = self._dispatch_call()
File '/home/egon/lib/python2.5/site-packages/Pylons-0.9.7-py2.5.egg/pylons/controllers/core.py', line 172 in _dispatch_call
response = self._inspect_call(func)
File '/home/egon/lib/python2.5/site-packages/Pylons-0.9.7-py2.5.egg/pylons/controllers/core.py', line 107 in _inspect_call
result = self._perform_call(func, args)
File '/home/egon/MediaCore-0.7.2/mediacore/lib/base.py', line 91 in _perform_call
self, controller, params, remainder=remainder)
File '/home/egon/lib/python2.5/site-packages/TurboGears2-2.0.3-py2.5.egg/tg/controllers.py', line 172 in _perform_call
output = controller(*remainder, **dict(params))
File '/home/egon/MediaCore-0.7.2/mediacore/controllers/media.py', line 560 in upload_submit
kwargs['tags'], kwargs['file']
File '/home/egon/MediaCore-0.7.2/mediacore/controllers/media.py', line 593 in _save_media_obj
media_file = _add_new_media_file(media_obj, file.filename, file.file)
File '/home/egon/MediaCore-0.7.2/mediacore/controllers/media.py', line 624 in _add_new_media_file
DBSession.flush()
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/scoping.py', line 129 in do
return getattr(self.registry(), name)(*args, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/session.py', line 1332 in flush
self._flush(objects)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/session.py', line 1410 in _flush
flush_context.execute()
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 255 in execute
UOWExecutor().execute(self, tasks)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 745 in execute
self.execute_save_steps(trans, task)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 760 in execute_save_steps
self.save_objects(trans, task)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 751 in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/orm/mapper.py', line 1466 in _save_obj
c = connection.execute(statement.values(value_params), params)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 1086 in execute
return Connection.executors[c](self, object, multiparams, params)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 1148 in _execute_clauseelement
inline=len(params) > 1),
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/expression.py', line 1257 in compile
compiler.compile()
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 663 in compile
self.string = self.process(self.statement)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 676 in process
return obj._compiler_dispatch(self, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/visitors.py', line 47 in _compiler_dispatch
return getter(visitor)(self, **kw)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 833 in visit_insert
colparams = self._get_colparams(insert_stmt)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 1025 in _get_colparams
values.append((c, self.process(c.default.arg.self_group())))
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 676 in process
return obj._compiler_dispatch(self, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/visitors.py', line 47 in _compiler_dispatch
return getter(visitor)(self, **kw)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 306 in visit_grouping
return "(" + self.process(grouping.element, **kwargs) + ")"
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 676 in process
return obj._compiler_dispatch(self, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/visitors.py', line 47 in _compiler_dispatch
return getter(visitor)(self, **kw)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 749 in visit_select
t = self.process(select._whereclause, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 676 in process
return obj._compiler_dispatch(self, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/visitors.py', line 47 in _compiler_dispatch
return getter(visitor)(self, **kw)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 489 in visit_binary
**kw
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 526 in _operator_dispatch
return fn(OPERATORS[operator])
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 487 in <lambda>
opstr +
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/engine/base.py', line 676 in process
return obj._compiler_dispatch(self, **kwargs)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/visitors.py', line 47 in _compiler_dispatch
return getter(visitor)(self, **kw)
File '/home/egon/lib/python2.5/site-packages/SQLAlchemy-0.6beta3-py2.5.egg/sqlalchemy/sql/compiler.py', line 553 in visit_bindparam
% bindparam.key
CompileError: Bind parameter name 'media_id' is reserved for the VALUES or SET clause of this insert/update statement.
Sorry for a late reply on this. The problem here is SQLAlchemy 0.6.
MediaCore 0.7.2 didn't specify which version of SQLAlchemy it needs, and recently the wrong version has been getting installed. You can fix this problem by adding the line "'SQLAlchemy == 0.5.8'," to setup.py in the install_requires list, then installing MediaCore again.
Actually... while you're at it, you should make sure all of the dependencies are up to date. The install_requires list should look like this:
install_requires = [
'SQLAlchemy == 0.5.8',
'Pylons == 0.9.7',
'Routes == 1.10.3',
'repoze.who == 1.0.18',
'TurboGears2 >= 2.0.3',
'ToscaWidgets == 0.9.9',
'tw.dynforms',
'zope.sqlalchemy',
'repoze.what-quickstart',
'MySQL-python >= 1.2.2',
'BeautifulSoup == 3.0.7a',
# We monkeypatch this version of BeautifulSoup in mediacore.__init__
# Patch pending: https://bugs.launchpad.net/beautifulsoup/+bug/397997
'akismet',
]These dependency problems will all be fixed out of the box in the next release, MediaCore 0.8
You must log in to post.