do you have .table files inside the databases/ folder ?
On Monday, March 3, 2014 5:27:10 PM UTC+1, Rémy Reche wrote:
>
> 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.
