[Python-projects] apycot

[Didrik Pinte]

Hi Sylvain,

I am stuck in the creation of the cube. Seems there is a typo in the
default user and group data :

do you want to initialize the system database? [Y/n]: Y
creating necessary tables into the system source
[....................]
install /usr/share/cubicweb/schemas/_regproc.sql.postgres
install /usr/share/cubicweb/cubes/apycot/schema/_regproc.sql.postgres
inserting default user and groups
Traceback (most recent call last):
  File "/usr/bin/cubicweb-ctl", line 4, in <module>
    run(sys.argv[1:])
  File "/usr/lib/python2.5/site-packages/cubicweb/cwctl.py", line 806,
in run
    main_run(args, __doc__)
  File "/usr/lib/python2.5/site-packages/cubicweb/toolsutils.py", line
255, in main_run
    base_main_run(args, doc)
  File "/usr/lib/python2.5/site-packages/logilab/common/clcommands.py",
line 136, in main_run
    cmd_run(arg, *args)
  File "/usr/lib/python2.5/site-packages/logilab/common/clcommands.py",
line 119, in cmd_run
    command.run(args)
  File "/usr/lib/python2.5/site-packages/cubicweb/cwctl.py", line 324,
in run
    helper.postcreate()
  File "/usr/lib/python2.5/site-packages/cubicweb/server/serverctl.py",
line 193, in postcreate
    cmd_run('db-create', self.config.appid, '--verbose=%s' % verbosity)
  File "/usr/lib/python2.5/site-packages/logilab/common/clcommands.py",
line 119, in cmd_run
    command.run(args)
  File "/usr/lib/python2.5/site-packages/cubicweb/server/serverctl.py",
line 344, in run
    cmd_run('db-init', config.appid)
  File "/usr/lib/python2.5/site-packages/logilab/common/clcommands.py",
line 119, in cmd_run
    command.run(args)
  File "/usr/lib/python2.5/site-packages/cubicweb/server/serverctl.py",
line 374, in run
    init_repository(config, drop=self.config.drop)
  File "/usr/lib/python2.5/site-packages/cubicweb/server/__init__.py",
line 97, in init_repository
    {'name': unicode(group)})
  File "/usr/lib/python2.5/site-packages/cubicweb/server/session.py",
line 299, in execute
    rset = self._execute(self, rql, kwargs, eid_key, build_descr)
  File "/usr/lib/python2.5/site-packages/cubicweb/server/querier.py",
line 648, in execute
    results = plan.execute()
  File "/usr/lib/python2.5/site-packages/cubicweb/server/querier.py",
line 161, in execute
    result = step.execute()
  File "/usr/lib/python2.5/site-packages/cubicweb/server/ssplanner.py",
line 426, in execute
    result = self.plan.insert_entity_defs()
  File "/usr/lib/python2.5/site-packages/cubicweb/server/querier.py",
line 492, in insert_entity_defs
    for edef in row])
  File "/usr/lib/python2.5/site-packages/cubicweb/server/repository.py",
line 939, in glob_add_entity
    source.add_entity(session, entity)
  File
"/usr/lib/python2.5/site-packages/cubicweb/server/sources/native.py",
line 371, in add_entity
    self.doexec(session.pool[self.uri], sql, attrs)
  File
"/usr/lib/python2.5/site-packages/cubicweb/server/sources/native.py",
line 414, in doexec
    cursor.execute(str(query), args)
psycopg.ProgrammingError: ERROR:  syntax error at or near "17"
LINE 1: ... creation_date ) VALUES ( 1, managers, 2009-03-04
17:59:31.9...
                                                             ^

INSERT INTO EGroup ( eid, name, modification_date, creation_date )
VALUES ( 1, managers, 2009-03-04 17:59:31.97, 2009-03-04 17:59:31.97 )

It seems to be missing quotes in the sql expression. 

Do you what file is in charge of generating the query ?

Didrik

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://lists.logilab.org/pipermail/python-projects/attachments/20090304/54035dc6/attachment.pgp>