Re: [web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread Jason Brower
I was looking at dal.py and it seems to me, that it wants all the tables first in my DAL object, and will not create them. Just import them and if they don't exist it throws an error. It will take some time to create the database here but let's see if this fixes the problem. If so, a better e

Re: [web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread Jason Brower
I got the connection to work. However, it's now throwing the same error as before. Dang. This is on a blank database to csv. Attached... On 05/24/2012 12:54 AM, pbreit wrote: It might. Can you try with an empty DB? On Wednesday, May 23, 2012 10:50:48 AM UTC-7, encompass wrote: Would havin

Re: [web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread Jason Brower
When I emptied my database locally and tried to connect to the server remotely I get ProgrammingError: ('FATAL','28000','no pg_hba.conf entry for host "85.23.56.232", user "postgres", database "postgres", SSL off') This is because I haven't setup this computer as a connectable host, I guess.

Re: [web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread pbreit
It might. Can you try with an empty DB? On Wednesday, May 23, 2012 10:50:48 AM UTC-7, encompass wrote: > > Would having an empty table raise this error? > > On 05/23/2012 08:14 PM, pbreit wrote: > > Apparently choking on this line: > > > > elif not line.startswith('TABLE ') or not

Re: [web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread Jason Brower
Would having an empty table raise this error? On 05/23/2012 08:14 PM, pbreit wrote: Apparently choking on this line: elif not line.startswith('TABLE ') or not line[6:] in self.tables: raise SyntaxError, 'invalid file format' Does your file look OK when taking this

[web2py] Re: Problem tranfering to a new database...

2012-05-23 Thread pbreit
Apparently choking on this line: elif not line.startswith('TABLE ') or not line[6:] in self.tables: raise SyntaxError, 'invalid file format' Does your file look OK when taking this into consideration? Hard to think linefeeds are the problem but you could try saving t