Hi Mart I did it without the quotes around the -y and -Y and when the quotes are completely removed, the command line arguments do not get passed completely and incorrectly parse. So I tried it with quotes around -Y and it parses the commands. Still doesn't work.
It looks like the DAL creates some field with a value of NoType in SQLite and the conversion script and code get hung up on this. I will review the SQLite strucuture and see where the NoType is and attempt to change it to something workable. Thanks for your help Dave On Friday, July 19, 2013 5:24:02 AM UTC-4, mart wrote: > > Hi Dave, > > try it again without the quotes around the -y and -Y option values (an > error in the book) > > I.e.: *sudo python scripts/cpdb.py -f applications/Wikispots/databases > -y sqlite://storage.sqlite -Y mysql://userxx:password@localhost/web2py* > > > I hope it helps ! :) > > If not, let me know and I can debug from here. > > regards, > Mart > > On Friday, July 19, 2013 1:50:45 AM UTC-7, Dave Carlson wrote: >> >> Hi Mart, >> >> this is the entirety of what I'm inputting and getting back in my shell >> on the command line. Minus the actual username and password for my setup of >> course. >> >> *[ dave@andromeda(0.18,) 4:45:37am ] /home/www-data/web2py >> $ sudo python scripts/cpdb.py -f applications/Wikispots/databases -y >> 'sqlite://storage.sqlite' -Y 'mysql://userxx:password@localhost/web2py' >> creating tables... >> EXCEPTION: could not make a copy of the database >> 'NoneType' object is not iterable >> [ dave@andromeda(0.27,) 4:45:49am ] /home/www-data/web2py >> $ >> * >> Thanks >> David* >> * >> >> On Friday, July 19, 2013 3:30:33 AM UTC-4, mart wrote: >>> >>> can you provide the exact cmd line that you used as well as the full >>> output displayed in your shell ? >>> >>> Thanks, >>> Mart >>> >>> On Wednesday, July 17, 2013 2:06:39 AM UTC-7, Dave Carlson wrote: >>>> >>>> Using the provided script cpdb.py and following the outlined procedure >>>> in the documentation ( >>>> http://web2py.com/books/default/chapter/29/06#Copy-data-from-one-db-into-another >>>> ) >>>> >>>> I get the following error >>>> >>>> * creating tables...* >>>> *EXCEPTION: could not make a copy of the database* >>>> *'NoneType' object is not iterable* >>>> >>>> in this particular case, I've been using sqlite to build up a wiki and >>>> want to migrate the data to MariaDB, which I have installed, it is working >>>> and it is functioning correctly. Opening, connecting and I have used >>>> another app to interact with the database, before I attempted this copying >>>> process. >>>> >>>> Any suggestions? >>>> >>>> Thanks >>>> Dave >>>> >>> -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
