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