[Cubicweb] ProgrammingError: (1064

Sylvain Thénault sylvain.thenault at logilab.fr
Mon Aug 3 08:30:13 CEST 2009


On 02 août 17:19, Nicolas Chauvat wrote:
> On Sun, Aug 02, 2009 at 10:34:09AM +0530, Dhaval Sharma wrote:
> > 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")
> > ...
> > 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'>,
> 
> I do not have mysql installed. Is is the 'SELECT 1' that it finds
> troubling ?

actually, this is most probably the missing FROM clause that mysql dislike. I'll
take a look at this.
-- 
Sylvain Thénault                               LOGILAB, Paris (France)
Formations Python, Debian, Méth. Agiles: http://www.logilab.fr/formations
Développement logiciel sur mesure:       http://www.logilab.fr/services
CubicWeb, the semantic web framework:    http://www.cubicweb.org




More information about the Cubicweb mailing list