Re: when i am trying to insert a data in to database the following error shows please help me out
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 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 outthanks 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 cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
when i am trying to insert a data in to database the following error shows please help me out
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 outthanks 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
