Hi everyone,
I've been trying to move my sqlite database to a nysql database for
production.
I've been trying the recipe, but get only two responses:
1) when I type the following command on the command line :
(User) C:\Users\Lenovo\Documents\git>python web2py.py -S site -M -N -R
applications\site\private\mover.py
Usage: python web2py.py
web2py.py: error: no such option: -N
2) when I ommit the option -N, I get:
(User) C:\Users\Lenovo\Documents\git>python web2py.py -S site -M -R
applications\site\private\mover.py
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2018
Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
Database drivers available: pg8000, pyodbc, psycopg2, imaplib, sqlite3,
pymysql
creating tables...
Traceback (most recent call last):
File "C:\Users\Lenovo\Documents\git\gluon\shell.py", line 274, in run
execfile(startfile, _env)
File "C:\Users\Lenovo\Documents\git\gluon\shell.py", line 42, in execfile
exec(code, global_vars, local_vars)
File "applications\site\private\mover.py", line 27, in <module>
main()
File "applications\site\private\mover.py", line 7, in main
other_db.define_table(table._tablename,*[field for field in table])
File "C:\Users\Lenovo\Documents\git\gluon\packages\dal\pydal\base.py",
line 586, in define_table
table = self.lazy_define_table(tablename, *fields, **args)
File "C:\Users\Lenovo\Documents\git\gluon\packages\dal\pydal\base.py",
line 598, in lazy_define_table
table = table_class(self, tablename, *fields, **args)
File "C:\Users\Lenovo\Documents\git\gluon\packages\dal\pydal\objects.py",
line 363, in __init__
field.bind(self)
File "C:\Users\Lenovo\Documents\git\gluon\packages\dal\pydal\objects.py",
line 1672, in bind
'Field %s is already bound to a table' % self.longname)
ValueError: Field auth_user.id is already bound to a table
The new database is empty. How come auth_user.id is already bound to a
table. I do not get it
Any help is greatly appreciated.
Cheers,
--
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/d/optout.
