Radicore Forum: Application Development » ERROR: 22P02: invalid input syntax for integer

Home » RADICORE development » Application Development » ERROR: 22P02: invalid input syntax for integer ( LINE 1: SELECT count(*) FROM idps WHERE uid='' ^ LOCATION: pg_atoi, numutils.c:52)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: ERROR: 22P02: invalid input syntax for integer [message #4949 is a reply to message #4948]

Fri, 28 August 2015 16:53

rafs
Messages: 69
Registered: May 2015

Member

Unless I am mistaken, I think there is a logical error in dml.pgsql.class.inc.
In function: insertRecord

[Line: 973]
// find out if any field in the primary key has 'serial' (auto_increment) set

[Line:1004]
// build 'where' string using values for primary key

[Line:1034]
// validate any optional unique/candidate keys

The framework is not expecting an auto_increment candidate key, I think. Trying to modify the function...

[Updated on: Fri, 28 August 2015 19:18]

Report message to a moderator

[Message index]

		ERROR: 22P02: invalid input syntax for integer By: rafs on Thu, 27 August 2015 15:35
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Thu, 27 August 2015 21:41
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Fri, 28 August 2015 05:35
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Fri, 28 August 2015 14:29
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Fri, 28 August 2015 16:53
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Sat, 29 August 2015 05:08
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Sat, 29 August 2015 14:18
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Sun, 30 August 2015 05:28
		Re: ERROR: 22P02: invalid input syntax for integer By: rafs on Mon, 31 August 2015 16:30
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Tue, 01 September 2015 05:45
		Re: ERROR: 22P02: invalid input syntax for integer By: AJM on Wed, 02 September 2015 09:02

Previous Topic:	How to provide choices for two compound foreign keys in a form?
Next Topic:	Running batch jobs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 07 00:22:36 EDT 2024

Total time taken to generate the page: 0.01061 seconds