[SOLVED] form generation hangs

Applications Forms
#1

I have created a form on a mysql table. I click on the generate/run icon; i see the message “Generating source-code: form_xxx” and it hangs for ever

I am able to create forms for other tables

thanks

#2

Re: form generation hangs

What ist the sql code to get the data from the mysql-table ???

#3

Re: form generation hangs

No custom sql code; the only difference is this table has many fields (more than 50) - is this a problem?
thanks

#4

Re: form generation hangs

I don’t think that 50 fields are a problem…but perhaps a special fieldname ???
In GRID SQL you find the syntax of your SQL-query even if you use simple the table…

Best regards
Uwe Pfeiffer

#5

Re: form generation hangs

I’m having the same issue and I haven’t found a solution yet, I hope anyone has a solution

#6

Re: form generation hangs

Hello Guys,

Please update your SC to our lattermost version. Then try to create a new application using that same table and see if it keeps hanging.

regards,
Bernhard Bernsmann

#7

Hi Bernhard
I still have problems; I also opened a ticket; when I try to generate a form for the following table it hangs; please help
thanks

CREATE TABLE IF NOT EXISTS applications (
id bigint(20) NOT NULL auto_increment,
crtime timestamp NULL default CURRENT_TIMESTAMP,
academicyear_id int(11) NOT NULL,
student_name varchar(80) NOT NULL,
student_surname varchar(70) default NULL,
date_of_birth date default NULL,
class_id int(11) default NULL,
gender_id int(11) default NULL,
nationality varchar(100) default ‘Indian’,
religion varchar(100) default NULL,
mother_tongue varchar(100) default ‘Tamil’,
caste varchar(100) default NULL,
mailingaddress1 varchar(200) default NULL,
mailingaddress2 varchar(200) default NULL,
applicant_mobile int(12) NOT NULL,
applicant_email varchar(100) default NULL,
pin_code int(6) default NULL,
state_id int(11) default NULL,
home_phone varchar(100) default NULL,
second_language varchar(100) default NULL,
group varchar(100) default NULL,
father_name varchar(80) default NULL,
father_surname varchar(80) default NULL,
father_dateofbirth date default NULL,
father_nationality varchar(100) default ‘Indian’,
father_qualification varchar(100) default NULL,
father_occupation varchar(100) default NULL,
father_designation varchar(100) default NULL,
father_officeaddress varchar(200) default NULL,
father_mobile int(12) default NULL,
father_officephone varchar(80) default NULL,
father_email varchar(100) default NULL,
mother_name varchar(100) default NULL,
mother_surname varchar(100) default NULL,
mother_dateofbirth date default NULL,
mother_natioanlity varchar(100) default ‘Indian’,
mother_qualification varchar(100) default NULL,
mother_occupation varchar(100) default NULL,
mother_designation varchar(100) default NULL,
mother_officeaddresss varchar(200) default NULL,
mother_mobile int(12) default NULL,
mother_office_phone varchar(100) default NULL,
mother_email varchar(100) default NULL,
info_about_parents varchar(200) default NULL,
previous_academic_record varchar(800) default NULL,
sibling_details varchar(800) default NULL,
academic_achievements varchar(800) default NULL,
extra_curricular varchar(800) default NULL,
health_issues varchar(800) default NULL,
behavioural_problems varchar(800) default NULL,
notes_to_school varchar(800) default NULL,
identification_marks varchar(800) default NULL,
govtclassification_id int(11) default NULL,
gaurdian_details varchar(1000) default NULL,
city varchar(100) default NULL,
processed tinyint(1) NOT NULL default ‘0’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

#8

A wild guess. Try to create a table without class_id. This name might be interupting as it is also a valid name within some php classes. In general: try to start with the first 10 fields, then add some etc. Try to find out which field is causing the problem. The amount cannot be it as we have larger tables which are working w.o. problem. Are you sure it hangs by the way? We have discovered some performance issues, one screen in a project is taking over 30 seconds to generate.

#9

[QUOTE=find1001;13491]Hi Bernhard
I still have problems; I also opened a ticket; when I try to generate a form for the following table it hangs; please help
thanks[/QUOTE]

Hello,

The issue is probably happening due to something specific on your table or environment. Our support team should help you there to find out why the issue is happening.

regards,
Bernhard Bernsmann

#10

I am happy to let you know that your support team solved the problem; I had to increase my php.ini parameters

thanks
raj

#11

Could you post the solution? What did you have to increase. Time limits on php execution?

#12

memory_limit -> 1024M

max_execution_time -> 360

post_max_size -> 256M

this fixed the problem

#13

I have similar issue, the form was ok, day later generation started to hang out. The table is fine, if I make a new form from the same table it all works fine, generates fast. PHP settings did not change in one day, so it must be something else. (my form is also quite big).

btw , is this a bug or not, but i added a new table but it does not show up in the existing form/sql table list. After closing the form and even login out , the new table is still not on the list.
In the new form I see well the new table.