Hi,
I'm inserting records from PHP / Apache / Ubuntu in a Firebird
table. This table has an integer non null field, and a before insert
trigger which takes care of setting it to the next integer value in case
the user attempts to set this field to null.
If this field is set to any integer from PHP there is no problem.
On the other hand, if it is set to null ( lefting to the trigger
the task of assigning it ) any of the following behaviours happens
(randomly)
1) A -804 error is shown in the apache log, with the message: "Dynamic
SQL Error SQL error code = -804 Incorrect values within SQLDA structure"
2) The Apache sub process is aborted, with the log message: "child pid
NNNN exit signal Segmentation fault (11)"
3) A random integer is assigned to the field. This behaviour is by far
less frequent, but happened a couple of times.
Thanks in advance for any help.
Aldo Caruso
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
