As the error message states, you have an error in the database, not in the CakePHP application. Go through the database and establish the missing part. Enjoy, John
On May 12, 3:44 pm, Narendra Padala <[email protected]> wrote: > Hi..!, > I am new to cake php,usuing PostgreSql,When i am inserting a record > its shows the follwoing error any one please help me out. > > Error: > --------- > Warning (2):pg_query() [function.pg-query]: Query failed: ERROR: > relation "tblcdlog_id_seq" does not exist [CORE/cake/libs/model/ > datasources/dbo/dbo_postgres.php, line 155] > > Warning (512):SQL Error: ERROR: relation "tblcdlog_id_seq" does not > exist [CORE/cake/libs/model/datasources/dbo_source.php, line 526 > > Query: SELECT currval('tblcdlog_id_seq') as max > > ------------------------------- > My database table structure like this > Sequence "public.tblcdlog_lngcdlog_seq" > Column | Type > ---------------+--------- > sequence_name | name > last_value | bigint > increment_by | bigint > max_value | bigint > min_value | bigint > cache_value | bigint > log_cnt | bigint > is_cycled | boolean > is_called | boolean > > Table : tblcdlog > -------------------------------------------- > Table "public.tblcdlog" > Column | Type > | Modifiers > -----------------+----------------------------- > +------------------------------------------------------------- > lngcdlog | integer | not null > default nextval('tblcdlog_lngcdlog_seq'::regclass) > dtmcreated | timestamp without time zone | not null > strcdno | character varying(50) | > strversion | character varying(50) | > lngcdlog_type | integer | not null > blnsuccess | bit(1) | not > null > strerrordesc | character varying(255) | > strupdateno | character varying(10) | > blnlogged_to_rr | boolean | not null > default false > Indexes: > "tblcdlog_pkey" PRIMARY KEY, btree (lngcdlog) > Foreign-key constraints: > "tblcdlog_lngcdlog_type_fkey" FOREIGN KEY (lngcdlog_type) > REFERENCES tlkcdlog_type(lngcdlog_type) > > I was worte code like this...! > > $strDate = date("Y-m-d H:i:s"); > echo $this->data['Tblcdlog']['dtmcreated']= $strDate; > echo $this->data['Tblcdlog']['strcdno']= "C520080205"; > echo $this->data['Tblcdlog']['lngcdlog_type'] = 1; > echo $this->data['Tblcdlog']['blnsuccess'] = 0; > $this->Tblcdlog->create(); > if ($this->Tblcdlog->save($this->data)) { > $this->Session->setFlash('The clockin has been > saved'); > } > > I have to insert data this much only after some time i will update > the remaing fileds please help me out....thanks in advance > > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with > their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" 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 > athttp://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en
