[Cubicweb] ProgrammingError: (1064

Dhaval Sharma dhavalsharma at gmail.com
Sun Aug 2 07:04:09 CEST 2009


The following error generally comes in anonymous login or when the current
user's session is timed out and if you try to access links. Sometimes
anonymous access shows indev view and sometimes the following error comes?

an error occured
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'WHERE X.cw_eid=432)' at line 3")

(1064, "You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'WHERE X.cw_eid=432)' at line 3")


File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/application.py, line
322, function main_publish:

  result = controller.publish(rset=rset)


[+]
ctrlid='view', self=<cubicweb.web.application.CubicWebPublisher object at
0x8f8c24c>,
req=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>,
controller=<cubicweb.web.views.basecontrollers.ViewController object at
0x999e34c>,
ex=ProgrammingError(1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'WHERE X.cw_eid=432)' at line 3"),
tstart=6.0599999999999996, path='/userprofile/eid/446',

File
/home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/basecontrollers.py,
line 112, function publish:

  return self.vreg.main_template(self.req, template, rset=rset, view=view)


[+]
self=<cubicweb.web.views.basecontrollers.ViewController object at
0x999e34c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>, template='main-template',
view=<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/cwvreg.py, line 219,
function main_template:

  res = self.render('views', oid, req, **context)


[+]
self=<cubicweb.cwvreg.CubicWebRegistry object at 0x8f8c3ec>,
oid='main-template',
req=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
context={'rset': <resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1
rows): [446L] (('UserProfile',))>, 'view':
<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/cwvreg.py, line 212,
function render:

  return selected.render(**context)


[+]
oid='main-template', self=<cubicweb.cwvreg.CubicWebRegistry object at
0x8f8c3ec>,
req=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>,
selected=<cubicweb.web.views.basetemplates.TheMainTemplate object at
0x999f68c>,
context={'view': <cubicweb.web.views.primary.PrimaryView object at
0x999e46c>}, registry='views',
objclss=[<class
'cubicweb.web.views.basetemplates.NonTemplatableViewTemplate'>, <class
'cubicweb.web.views.basetemplates.TheMainTemplate'>],

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 148,
function render:

  view_func(**context)


[+]
w=None, stream=<cubicweb.utils.HTMLStream object at 0x995ab2c>,
self=<cubicweb.web.views.basetemplates.TheMainTemplate object at 0x999f68c>,

context={'view': <cubicweb.web.views.primary.PrimaryView object at
0x999e46c>},
view_func=<bound method TheMainTemplate.call of
<cubicweb.web.views.basetemplates.TheMainTemplate object at 0x999f68c>>,
row=None,

File
/home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/basetemplates.py,
line 124, function call:

  view.render(w=w)


[+]
etypefilter=None, vtitle=None,
self=<cubicweb.web.views.basetemplates.TheMainTemplate object at 0x999f68c>,

w=<bound method HTMLStream.write of <cubicweb.utils.HTMLStream object at
0x995ab2c>>,
view=<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 148,
function render:

  view_func(**context)


[+]
w=<bound method HTMLStream.write of <cubicweb.utils.HTMLStream object at
0x995ab2c>>, stream=None,
self=<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>,
context={},
view_func=<bound method PrimaryView.call of
<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>>, row=None,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 173,
function call:

  self.wview(self.id, rset, row=i, **kwargs)


[+]
i=0, wrap=False, self=<cubicweb.web.views.primary.PrimaryView object at
0x999e46c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>, kwargs={},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 212,
function wview:

  self.view(__vid, rset, __fallback_vid, w=self.w, **kwargs)


[+]
self=<cubicweb.web.views.primary.PrimaryView object at 0x999e46c>,
_View__fallback_vid=None, _View__vid='primary',
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>, kwargs={'row': 0},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/appobject.py, line 192,
function view:

  return self.vreg.view(__vid, self.req, rset, __fallback_vid, **kwargs)


[+]
_AppRsetObject__vid='primary', self=<cubicweb.web.views.primary.PrimaryView
object at 0x999e46c>, _AppRsetObject__fallback_vid=None,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>,
kwargs={'w': <bound method HTMLStream.write of <cubicweb.utils.HTMLStream
object at 0x995ab2c>>, 'row': 0},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/cwvreg.py, line 270,
function view:

  return view.render(**kwargs)


[+]
self=<cubicweb.cwvreg.CubicWebRegistry object at 0x8f8c3ec>,
req=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>,
_CubicWebRegistry__fallback_vid=None, _CubicWebRegistry__vid='primary',
kwargs={'w': <bound method HTMLStream.write of <cubicweb.utils.HTMLStream
object at 0x995ab2c>>, 'row': 0},
view=<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 148,
function render:

  view_func(**context)


[+]
w=<bound method HTMLStream.write of <cubicweb.utils.HTMLStream object at
0x995ab2c>>, stream=None,
self=<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>,
context={'col': 0, 'row': 0},
view_func=<bound method PrimaryView.cell_call of
<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>>, row=0,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/primary.py,
line 43, function cell_call:

  self.render_entity(self.complete_entity(row, col))


[+]
self=<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>, col=0,
row=0,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/primary.py,
line 49, function render_entity:

  self.render_entity_metadata(entity)


[+]
self=<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>,
entity=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/primary.py,
line 109, function render_entity_metadata:

  entity.view('metadata', w=self.w)


[+]
self=<cubicweb.web.views.primary.PrimaryView object at 0x99a1aac>,
entity=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/entity.py, line 374,
function view:

  row=self.row, col=self.col, **kwargs)


[+]

self=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,
_Entity__registry='views', vid='metadata',
kwargs={'w': <bound method HTMLStream.write of <cubicweb.utils.HTMLStream
object at 0x995ab2c>>},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/cwvreg.py, line 212,
function render:

  return selected.render(**context)


[+]
oid='metadata', self=<cubicweb.cwvreg.CubicWebRegistry object at 0x8f8c3ec>,

req=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
rset=<resultset u'Any X WHERE X is UserProfile, X eid %(x)s' (1 rows):
[446L] (('UserProfile',))>,
selected=<cubicweb.web.views.baseviews.MetaDataView object at 0x995a34c>,
context={'w': <bound method HTMLStream.write of <cubicweb.utils.HTMLStream
object at 0x995ab2c>>, 'col': 0, 'row': 0},
registry='views', objclss=[<class
'cubicweb.web.views.baseviews.MetaDataView'>],

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/view.py, line 148,
function render:

  view_func(**context)


[+]
w=<bound method HTMLStream.write of <cubicweb.utils.HTMLStream object at
0x995ab2c>>, stream=None,
self=<cubicweb.web.views.baseviews.MetaDataView object at 0x995a34c>,
context={'col': 0, 'row': 0},
view_func=<bound method MetaDataView.cell_call of
<cubicweb.web.views.baseviews.MetaDataView object at 0x995a34c>>, row=0,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/web/views/baseviews.py,
line 176, function cell_call:

  if entity.creator:


[+]
self=<cubicweb.web.views.baseviews.MetaDataView object at 0x995a34c>, row=0,
col=0,
_=<bound method GNUTranslations.ugettext of
<cubicweb.gettext.GNUTranslations instance at 0x9360b8c>>,
entity=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/entities/__init__.py,
line 122, function creator:

  return self.created_by[0]


[+]

self=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/entity.py, line 961,
function __get__:

  return eobj.related(self._rtype, self._role, entities=True)


[+]

eobj=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,
self=<cubicweb.entity.SubjectRelation object at 0x97f736c>, eclass=<class
'cubes.rosecube.entities.UserProfile'>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/entity.py, line 681,
function related:

  rset = self.req.execute(rql, {'x': self.eid}, 'x')


[+]
rtype='created_by',
self=<Entity UserProfile 446 ['affliatedto', 'creation_date', 'eid',
'modification_date', 'hourlyrate'] at 161357660>,
entities=True, role='subject', limit=None,
rql=u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA, X
firstname AB, X surname AC, X modification_date AD',

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/dbapi.py, line 258,
function execute:

  return self.cursor.execute(*args, **kwargs)


[+]
self=<cubicweb.etwist.request.CubicWebTwistedRequestAdapter object at
0x999e40c>,
args=(u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA, X
firstname AB, X surname AC, X modification_date AD', {'x': 446L, u'B':
432L}, 'x'),
kwargs={},

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/dbapi.py, line 586,
function execute:

  parameters, eid_key, build_descr)


[+]
build_descr=True,
operation=u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA,
X firstname AB, X surname AC, X modification_date AD',
eid_key='x', parameters={'x': 446L, u'B': 432L}, self=<cubicweb.dbapi.Cursor
object at 0x999e70c>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/repository.py,
line 592, function execute:

  build_descr)


[+]
session=<cubicweb.server.session.Session object at 0x9858a4c>,
self=<cubicweb.server.repository.Repository object at 0x8fe016c>,
args={'x': 446L, u'B': 432L}, eid_key='x', build_descr=True,
sessionid='43eb12911fbbf7d6400ee5aef1d59a12',
rqlstring=u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA,
X firstname AB, X surname AC, X modification_date AD',

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/querier.py, line
649, function execute:

  results = plan.execute()


[+]

cachekey=(u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA,
X firstname AB, X surname AC, X modification_date AD', 'UserProfile'),
self=<cubicweb.server.querier.QuerierHelper object at 0x910a12c>, args={'x':
446L, u'B': 432L},
orig_rqlst=Any VarRef(0X99C602C) to X(0X99A7EFC),VarRef(0X99C60CC) to
AA(0X99A7F2C),VarRef(0X99C614C) to AB(0X99A7F5C),VarRef(0X99C61CC) to
AC(0X99A7F8C),VarRef(0X99C624C) to AD(0X99A7FBC) WHERE
Relation(VarRef(0X99C636C) to E(0X99C802C) eid = %(x)s) AND
Relation(VarRef(0X99C644C) to E(0X99C802C) created_by = VarRef(0X99C658C) to
X(0X99A7EFC)) AND Relation(VarRef(0X99C656C) to X(0X99A7EFC) login =
VarRef(0X99C66CC) to AA(0X99A7F2C)) AND Relation(VarRef(0X99C66AC) to
X(0X99A7EFC) firstname = VarRef(0X99C67CC) to AB(0X99A7F5C)) AND
Relation(VarRef(0X99C67AC) to X(0X99A7EFC) surname = VarRef(0X99C690C) to
AC(0X99A7F8C)) AND Relation(VarRef(0X99C68EC) to X(0X99A7EFC)
modification_date = VarRef(0X99C6A0C) to AD(0X99A7FBC)),
eid_key=('x',), build_descr=True, session=<cubicweb.server.session.Session
object at 0x9858a4c>,
plan=<cubicweb.server.querier.ExecutionPlan object at 0x99ca82c>, key='x',
etype='UserProfile',
rqlst=Any VarRef(0X997B8AC) to X(0X9AA56EC),VarRef(0X997BC0C) to
AA(0X99A747C),VarRef(0X997B68C) to AB(0X99A78CC),VarRef(0X98606EC) to
AC(0X99A78FC),VarRef(0X98602EC) to AD(0X99A73BC) WHERE Relation(%(x)s
created_by = VarRef(0X99EFCEC) to X(0X9AA56EC)) AND
Relation(VarRef(0X99EF4AC) to X(0X9AA56EC) login = VarRef(0X99EFE6C) to
AA(0X99A747C)) AND Relation(VarRef(0X99EF68C) to X(0X9AA56EC) firstname =
VarRef(0X99EFE8C) to AB(0X99A78CC)) AND Relation(VarRef(0X99EF8CC) to
X(0X9AA56EC) surname = VarRef(0X99EFA4C) to AC(0X99A78FC)) AND
Relation(VarRef(0X986056C) to X(0X9AA56EC) modification_date =
VarRef(0X99EF80C) to AD(0X99A73BC)) AND EXISTS(Relation(VarRef(0X99EFB0C) to
X(0X9AA56EC) identity = %(B)s)) AND Relation(VarRef(0X99EFBAC) to
X(0X9AA56EC) is = CWUser),
rql=u'Any X,AA,AB,AC,AD WHERE E eid %(x)s, E created_by X, X login AA, X
firstname AB, X surname AC, X modification_date AD',
select=Any VarRef(0X99C602C) to X(0X99A7EFC),VarRef(0X99C60CC) to
AA(0X99A7F2C),VarRef(0X99C614C) to AB(0X99A7F5C),VarRef(0X99C61CC) to
AC(0X99A7F8C),VarRef(0X99C624C) to AD(0X99A7FBC) WHERE
Relation(VarRef(0X99C636C) to E(0X99C802C) eid = %(x)s) AND
Relation(VarRef(0X99C644C) to E(0X99C802C) created_by = VarRef(0X99C658C) to
X(0X99A7EFC)) AND Relation(VarRef(0X99C656C) to X(0X99A7EFC) login =
VarRef(0X99C66CC) to AA(0X99A7F2C)) AND Relation(VarRef(0X99C66AC) to
X(0X99A7EFC) firstname = VarRef(0X99C67CC) to AB(0X99A7F5C)) AND
Relation(VarRef(0X99C67AC) to X(0X99A7EFC) surname = VarRef(0X99C690C) to
AC(0X99A7F8C)) AND Relation(VarRef(0X99C68EC) to X(0X99A7EFC)
modification_date = VarRef(0X99C6A0C) to AD(0X99A7FBC)),

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/querier.py, line
161, function execute:

  result = step.execute()


[+]
step=<cubicweb.server.ssplanner.OneFetchStep object at 0x994636c>,
self=<cubicweb.server.querier.ExecutionPlan object at 0x99ca82c>,

File /home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/ssplanner.py,
line 348, function execute:

  inputmap)


[+]

cachekey=(u'Any X,AA,AB,AC,AD WHERE %(x)s created_by X, X login AA, X
firstname AB, X surname AC, X modification_date AD, EXISTS(X identity
%(B)s), X is CWUser', 'UserProfile'),
inputmap=None,
union=Any VarRef(0X997B8AC) to X(0X9AA56EC),VarRef(0X997BC0C) to
AA(0X99A747C),VarRef(0X997B68C) to AB(0X99A78CC),VarRef(0X98606EC) to
AC(0X99A78FC),VarRef(0X98602EC) to AD(0X99A73BC) WHERE Relation(%(x)s
created_by = VarRef(0X99EFCEC) to X(0X9AA56EC)) AND
Relation(VarRef(0X99EF4AC) to X(0X9AA56EC) login = VarRef(0X99EFE6C) to
AA(0X99A747C)) AND Relation(VarRef(0X99EF68C) to X(0X9AA56EC) firstname =
VarRef(0X99EFE8C) to AB(0X99A78CC)) AND Relation(VarRef(0X99EF8CC) to
X(0X9AA56EC) surname = VarRef(0X99EFA4C) to AC(0X99A78FC)) AND
Relation(VarRef(0X986056C) to X(0X9AA56EC) modification_date =
VarRef(0X99EF80C) to AD(0X99A73BC)) AND EXISTS(Relation(VarRef(0X99EFB0C) to
X(0X9AA56EC) identity = %(B)s)) AND Relation(VarRef(0X99EFBAC) to
X(0X9AA56EC) is = CWUser),
self=<cubicweb.server.ssplanner.OneFetchStep object at 0x994636c>,
args={'x': 446L, u'B': 432L},
source=<system source @0x9153aac>, session=<cubicweb.server.session.Session
object at 0x9858a4c>, limit=None, result=[], offset=None,

File
/home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/sources/native.py,
line 313, function syntax_tree_search:

  cursor = self.doexec(session, sql, args)


[+]

cachekey=(u'Any X,AA,AB,AC,AD WHERE %(x)s created_by X, X login AA, X
firstname AB, X surname AC, X modification_date AD, EXISTS(X identity
%(B)s), X is CWUser', 'UserProfile'),
union=Any VarRef(0X997B8AC) to X(0X9AA56EC),VarRef(0X997BC0C) to
AA(0X99A747C),VarRef(0X997B68C) to AB(0X99A78CC),VarRef(0X98606EC) to
AC(0X99A78FC),VarRef(0X98602EC) to AD(0X99A73BC) WHERE Relation(%(x)s
created_by = VarRef(0X99EFCEC) to X(0X9AA56EC)) AND
Relation(VarRef(0X99EF4AC) to X(0X9AA56EC) login = VarRef(0X99EFE6C) to
AA(0X99A747C)) AND Relation(VarRef(0X99EF68C) to X(0X9AA56EC) firstname =
VarRef(0X99EFE8C) to AB(0X99A78CC)) AND Relation(VarRef(0X99EF8CC) to
X(0X9AA56EC) surname = VarRef(0X99EFA4C) to AC(0X99A78FC)) AND
Relation(VarRef(0X986056C) to X(0X9AA56EC) modification_date =
VarRef(0X99EF80C) to AD(0X99A73BC)) AND EXISTS(Relation(VarRef(0X99EFB0C) to
X(0X9AA56EC) identity = %(B)s)) AND Relation(VarRef(0X99EFBAC) to
X(0X9AA56EC) is = CWUser),
varmap=None, query_args={}, args={'x': 446L, u'B': 432L},
session=<cubicweb.server.session.Session object at 0x9858a4c>,
sql='SELECT X.cw_eid, X.cw_login, X.cw_firstname, X.cw_surname,
X.cw_modification_date\nFROM created_by_relation AS rel_created_by0,
cw_CWUser AS X\nWHERE rel_created_by0.eid_from=%(x)s AND
rel_created_by0.eid_to=X.cw_eid AND EXISTS(SELECT 1 WHERE X.cw_eid=%(B)s)',
self=<system source @0x9153aac>,

File
/home/dhaval/sample/cubicweb/cubicweb/cubicweb/server/sources/native.py,
line 423, function doexec:

  cursor.execute(str(query), args)


[+]
self=<system source @0x9153aac>, args={'x': 446L, u'B': 432L},
cursor=<MySQLdb.cursors.Cursor object at 0x983ddac>,
session=<cubicweb.server.session.Session object at 0x9858a4c>,
ex=ProgrammingError(1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'WHERE X.cw_eid=432)' at line 3"),
query='SELECT X.cw_eid, X.cw_login, X.cw_firstname, X.cw_surname,
X.cw_modification_date\nFROM created_by_relation AS rel_created_by0,
cw_CWUser AS X\nWHERE rel_created_by0.eid_from=%(x)s AND
rel_created_by0.eid_to=X.cw_eid AND EXISTS(SELECT 1 WHERE X.cw_eid=%(B)s)',

File
/usr/local/lib/python2.6/dist-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg/MySQLdb/cursors.py,
line 173, function execute:

  self.errorhandler(self, exc, value)


[+]
args={'x': 446L, u'B': 432L}, exc=<class
'_mysql_exceptions.ProgrammingError'>,
self=<MySQLdb.cursors.Cursor object at 0x983ddac>, charset='utf8',
db=<weakproxy at 0x981ddc4 to Connection at 0x91d5b24>,
value=ProgrammingError(1064, "You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE X.cw_eid=432)' at line 3"),
query='SELECT X.cw_eid, X.cw_login, X.cw_firstname, X.cw_surname,
X.cw_modification_date\nFROM created_by_relation AS rel_created_by0,
cw_CWUser AS X\nWHERE rel_created_by0.eid_from=446 AND
rel_created_by0.eid_to=X.cw_eid AND EXISTS(SELECT 1 WHERE X.cw_eid=432)',
ListType=<type 'list'>, exc_info=<built-in function exc_info>,
TupleType=<type 'tuple'>,

File
/usr/local/lib/python2.6/dist-packages/MySQL_python-1.2.3c1-py2.6-linux-i686.egg/MySQLdb/connections.py,
line 36, function defaulterrorhandler:

  raise errorclass, errorvalue
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.cubicweb.org/pipermail/cubicweb/attachments/20090802/d27bd687/attachment-0186.html>


More information about the Cubicweb mailing list