Announcement

Collapse
No announcement yet.

[SOLVED] form generation hangs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] form generation hangs

    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 ???

    Comment


    • #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

      Comment


      • #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

        Comment


        • #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

          Comment


          • #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

            Comment


            • #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 ;

              Comment


              • #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.
                Albert Drent
                aducom software netherlands
                scriptcase partner, reseller, support and (turn-key) development
                www.scriptcase.eu / www.scriptcase.nl

                Comment


                • #9
                  Originally posted by find1001 View Post
                  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
                  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

                  Comment


                  • #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

                    Comment


                    • #11
                      Could you post the solution? What did you have to increase. Time limits on php execution?
                      Albert Drent
                      aducom software netherlands
                      scriptcase partner, reseller, support and (turn-key) development
                      www.scriptcase.eu / www.scriptcase.nl

                      Comment


                      • #12
                        memory_limit -> 1024M

                        max_execution_time -> 360

                        post_max_size -> 256M

                        this fixed the problem

                        Comment

                        Working...
                        X