physmed wrote on Saturday, May 02, 2009:
Hi Tony
I have tried to register and install your form PFSH and I keep getting the error message that the field is too large! I found another message about this in the user forum that was posted after you posted that these forms were available! Just thought that you would want to know.
Rick
tmccormi wrote on Saturday, May 02, 2009:
I’ll have Aron take a look at it, we have made some updates to that and all the other forms recently and are about ready to post the chances. Thanks for the heads up.
–Tony
penguin8r wrote on Friday, May 08, 2009:
Physmed, if you want a quick fix for this problem, go into your openemr/interface/forms/pfsh directory.
Edit the table.sql file, you will find three lines toward the end that look like this:
`past` varchar(30000) NOT NULL DEFAULT ‘’,
`family` varchar(30000) NOT NULL DEFAULT ‘’,
`social` varchar(30000) NOT NULL DEFAULT ‘’,
Change the 30000 values to 20000 in those three lines to look like this:
`past` varchar(20000) NOT NULL DEFAULT ‘’,
`family` varchar(20000) NOT NULL DEFAULT ‘’,
`social` varchar(20000) NOT NULL DEFAULT ‘’,
now you should be able to install & use the form.
I believe this is a an issue with MySQL not being able to handle more than ~65000 characters at a time, so lowering those values to make the total less than 65000 seems to fix the problem.
Tony, if this isn’t an acceptable workaround, let us know & we’ll wait for a better fix.
HTH
tmccormi wrote on Friday, May 08, 2009:
We will get an update of that form and the and several others in the set for posting this weekend. That fix will do, the update will actually change those elements to type ‘TEXT’ which does not have that limit.
In the meantime that fix should work and it won’t interfere with with the changes.
Tony
physmed wrote on Friday, May 08, 2009:
Thanks that did the trick and will allow me to evaluate it to see if it fits our needs.
Rick
tmccormi wrote on Friday, May 08, 2009:
I’d be very interested in your feed back.
–Tony