Page 1 of 1

Pear Error in Insertion in Related table

PostPosted: Thu Feb 28, 2013 11:04 am
by muzafar
Dear Shannah,

I have a related table which I have already mentioned here (viewtopic.php?f=4&t=7141). I have almost 30 fields in this related table, which include upload file and comments fields, for instance, we have fields like below. the fields are more than 30. As i mentioned in the previous post, that i am using fieldgroup__template for it, and the save button is now coming at the button, as u mentioned the solution in that post. Now the problem is, that while inserting a records, it throws the following error.

[Thu Feb 28 19:55:43 2013] [error] [client 192.168.2.1] PHP Fatal
error: Uncaught exception 'Exception' with message '[pear_error:
message="11" code=0 mode=return level=notice prefix="" info="Error performing query 'INSERT INTO `Asses`
(`lComment`,`cComment`,`oComment`,`aComment`,`psComment`,`chartComment`,`generalComment`,`banionComment`,`paseComment`,`authosComment`,`antsComment`,`regateComment`,`mBODComment`,`alRComment`,`oflComment`,`cvvRemarks`,`strRemarks`,`aRemarks`,`mRemarks`,`avaRemarks`,`slsRemarks`,`agmRemarks`,`pnRemarks`)
VALUES (''sdfsdfsdfsdfsdfsfsdfsdfsfsdfsddfasdfsdafdsfsdafjsdkfhdskjfhsdkjafhsdkajfhdsauiwehruewhriewuhewiuhewewurhewurheks in /var/www/xata/Dataface/IO.php on line 1317, referer:




`lUpload` varchar(255) DEFAULT NULL,
`lComment` varchar(1500) NOT NULL DEFAULT 'Not Applicable',
`cUpload` varchar(255) DEFAULT NULL,
`cComment` varchar(1500) NOT NULL DEFAULT 'Not Applicable',
`oUpload` varchar(255) DEFAULT NULL,
`oComment` varchar(1500) NOT NULL DEFAULT 'Not Applicable',


2- I have also tried the fieldgroup tabs in order to show the fields in tabs, but same in related table, for the role Applicant, the Button along with Save, which is "NEXT", doesn't show in the related table.

Kindly lead me.

Thanks,

Re: Pear Error in Insertion in Related table

PostPosted: Thu Feb 28, 2013 8:39 pm
by sim
Issue resolved unrelated to Xatafce.
Changing the storage engine from inodb to myisam fixed the issue.