I have no idea. Never seen this problem before. I will try debug more tomorrow.
Massimo On Jun 9, 9:53 pm, FERNANDO VILLARROEL <[email protected]> wrote: > Hi, > > Tha table exist there and the table have a unique auto-increment "id" field > also. > > The schema of table calls is the following > > id | integer | not null default > nextval('calls_id_seq'::regclass) > account_id | integer | not null > uuid | character varying(100) | not null > caller_id_number | character varying(100) | not null > destination_number | character varying(100) | not null > chan_name | character varying(100) | not null > answered_time | timestamp with time zone | not null > hangup_time | timestamp with time zone | not null > cdr_xml | text | not null > > Fernando > > --- On Tue, 6/9/09, mdipierro <[email protected]> wrote: > > > From: mdipierro <[email protected]> > > Subject: [web2py:23784] Re: Error accesing > > To: "web2py Web Framework" <[email protected]> > > Date: Tuesday, June 9, 2009, 7:50 PM > > > That just means the table "calls" does not exist. It is not > > a web2py > > errors. It is an error from the db driver. Are you sure the > > table is > > there? > > > Does the table have a unique auto-increment "id" field? > > > Massimo > > > On Jun 9, 5:16 pm, visuallinux <[email protected]> > > wrote: > > > I am new on web2py and i trying accesing a database > > existing: > > > > In my db.py i have: > > > db=SQLDB('postgres://foo:[email protected]:5432/registros') > > > > db.define_table('calls', > > > SQLField('account_id','integer'), > > > SQLField('uuid','string'), > > > SQLField('caller_id_number','string'), > > > SQLField('destination_number','string'), > > > SQLField('chan_name','string'), > > > SQLField('answered_time','datetime'), > > > SQLField('hangup_time','datetime'), > > > SQLField('cdr_xml','string'), > > > migrate=False) > > > > In my Controller default.py: > > > > def llamadas(): > > > > rows=db().select(db.calls.ALL) > > > return dict(form=form,rows=rows) > > > > But i have the following error of accesing: > > > > self._execute = lambda *a, **b: > > self._cursor.execute(*a, **b) > > > ProgrammingError: no existe la relación «calls» > > > > I hope your comments, > > > > Regards, > > > > Fernando --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
