Hi everyone, I took a look at cpdb.py code and saw that "-d" option is just used to find where "dal.py" and add the folder sys.path.
So, instead of the relative path, I decided to use the absolute path. I do not get the "could not set DAL" exception anymore, but now I get the following error: "Field auth_cas.id is already bound to a table" And the warning regarding the "plural_rules". This is the command I executed: C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py>python scripts/cpdb.py -f applications/paravolcar10enero_tarde/databases -y sqlite://storage.sqlite -Y sqlite://storage3.sqlite -d C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py\gluon No handlers could be found for logger "web2py" WARNING:root:Unable to import plural rules: No module named plural_rules creating tables... EXCEPTION: could not make a copy of the database Field auth_cas.id is already bound to a table Any suggestions? What does this mean? Thanks, Jon. PS. I'm just using sqlite to sqlite copy for now, for the sake of simplicity. On Mon, Feb 4, 2019 at 10:06 AM Jon Subscripted <jonsubscripti...@gmail.com> wrote: > Hi Dave, > Yes, if you refer to the Python installed in the computer I'm using Python > 2.7.5. > > C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py>python scripts/cpdb.py > -f applications/paravolcar10enero_tarde/databases -y > sqlite://storage.sqlite -Y sqlite://storage3.sqlite -d ../gluon > No handlers could be found for logger "web2py" > WARNING:root:Unable to import plural rules: No module named plural_rules > EXCEPTION: could not set DAL > No module named dal > creating tables... > EXCEPTION: could not make a copy of the database > 'NoneType' object is not iterable > > C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py>python.exe > Python 2.7.15 (v2.7.15:ca079a3ea3, Apr 30 2018, 16:22:17) [MSC v.1500 32 > bit (Intel)] on win32 > Type "help", "copyright", "credits" or "license" for more information. > >>> > > Thanks, Jon. > > PS. I'm not fully aware of the relationship between the existing Python > installation in the computer and the pre-packed Python (delivered as part > of Web2py). > > On Sun, Feb 3, 2019 at 10:21 PM Dave S <snidely....@gmail.com> wrote: > >> >> >> On Saturday, February 2, 2019 at 6:05:55 AM UTC-8, Jonsubs wrote: >>> >>> Hi everyone, >>> I'm trying to copy my database (already populated) using cbpd.py but I >>> get an error. >>> (I'm working in Windows 10 with Web2py >>> 2.17.2-stable+timestamp.2018.10.06.18.54.02) >>> >>> >> So you're using the in-box python, which is python2? >> >> /dps >> >> >>> 1st I changed the database URI in appconfig.ini from >>> sqlite://storage.sqlite to sqlite://storage3.sqlite >>> 2nd I checked with SQLite Browser that sqlite://storage3.sqlite was >>> created and tables are created also (but empty) >>> 3rd I launched the command below, but I does not work. >>> >>> C:\Users\Jon\Downloads\web2py_winAPPLIANCES\web2py>python >>> scripts/cpdb.py -f applications/paravolcar10enero_tarde/databases -y >>> sqlite://storage.sqlite -Y sqlite://storage3.sqlite -d ../gluon >>> No handlers could be found for logger "web2py" >>> WARNING:root:Unable to import plural rules: No module named plural_rules >>> EXCEPTION: could not set DAL >>> No module named dal >>> creating tables... >>> EXCEPTION: could not make a copy of the database >>> 'NoneType' object is not iterable >>> >>> Any suggestions? I do not really know how to interpret the error. >>> Thanks, Jon. >>> >> -- >> 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. >> > -- 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.
