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
-~----------~----~----~----~------~----~------~--~---
