https://www.machform.com/forums/ MachForm Community Forums Topic: Error while creating forms en Sun, 03 May 2026 20:45:37 +0000 https://www.machform.com/forums/topic/error-while-creating-forms#post-24588 Fri, 18 Dec 2015 10:21:57 +0000 SimoneV 24588@https://www.machform.com/forums/ <p>I still can't get any help... they suggested that we change from MySQL to MYISAM. I have recreated all the forms from scratch but there seems to be no logic to it not working. We have had this package since mid november and it has not worked for 1/2 the time.</p> <p>I can have a form working fine but add a small text field and it stops working. Once it stops you can not just delete a few fields because it says the same error. You don't know that there is a problem until you save it and once you save that version is "corrupt". You have to start from the last working copy therefore everytime you make a change you have to save, duplicate etc etc. </p> <p>My IT people have tried to contact support but there has been no response </p> https://www.machform.com/forums/topic/error-while-creating-forms#post-24543 Thu, 10 Dec 2015 23:40:46 +0000 Saghalie 24543@https://www.machform.com/forums/ <p>What it looks like is happening is that you don't have permissions to ALTER tables in this SQL server. It also looks like you are passing a NULL value to a table column that is NOT NULL (so you can't have NULL values).</p> <p>So while you are trying to add data to the new table, this error is telling you that you need to drop the table and recreate the table and for some reason you do not have the permissions to do that.</p> <p>I would stop using MSSQL and create a new database with MySQL. Although this is a bit extreme.</p> <p>You could try and get the provider to give you higher permissions.</p> <p>Hope this helps.</p> <p>Regards,</p> <p>Saghalie<br /> <a href="http://www.kcmhosting.com" rel="nofollow">http://www.kcmhosting.com</a> </p> https://www.machform.com/forums/topic/error-while-creating-forms#post-24520 Mon, 07 Dec 2015 14:38:10 +0000 SimoneV 24520@https://www.machform.com/forums/ <p>I am trying to create a form, but I get an error that says it is an "SQL" error. On replicating this it always seems to happen when I get to a certain length of document - my form is currently 180 fields. I have tried to get support BUT my website provider will not give the FTP details out. </p> <p>Error while saving. Error Message: SQL:[76] ALTER TABLE<code>ap_form_20782_review</code>ADD COLUMN<code>session_id</code>varchar(128) NULL<br /> Params: 0<br /> Query Failed: SQLSTATE[HY000]: General error: 1005 Can’t create table <code>ThoconForms.#sql-1138_6245c7</code> (errno: 139)</p> <p>Any suggestions? </p>