Hello,
according to the documentation, I am trying to upload the error tickets
in my database (MySQL) with this script:
nohup python web2py.py -S myapp -M -R scripts/tickets2db.py &
But I always obtain this error:
Created by Massimo Di Pierro, Copyright 2007-2014
Version 2.8.2-stable+timestamp.2013.11.28.07.51.37
Database drivers available: SQLite(sqlite3), MySQL(pymysql), MySQL(MySQLdb),
PostgreSQL(pg8000), IMAP(imaplib)
Traceback (most recent call last):
File "/srv/http/batisense/gluon/shell.py", line 266, in run
execfile(startfile, _env)
File "scripts/tickets2db.py", line 27, in <module>
db=tk_db, tablename=ts.tablename, app=request.application)
File "/srv/http/batisense/gluon/restricted.py", line 88, in _get_table
db.Field('created_datetime', 'datetime'))
File "/srv/http/batisense/gluon/dal.py", line 8139, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "/srv/http/batisense/gluon/dal.py", line 8176, in lazy_define_table
polymodel=polymodel)
File "/srv/http/batisense/gluon/dal.py", line 1058, in create_table
self.create_sequence_and_triggers(query,table)
File "/srv/http/batisense/gluon/dal.py", line 1899, in
create_sequence_and_triggers
self.execute(query)
File "/srv/http/batisense/gluon/dal.py", line 1916, in execute
return self.log_execute(*a, **b)
File "/srv/http/batisense/gluon/dal.py", line 1910, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1050, "Table 'web2py_ticket_api' already exists")
I can modify it with fake_migrate or migrate_enabled in the DAL, but I thought
that script should run fine "out of the box".
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
