Submitting a form stopped working

[jeanl]

Hello

I have a system that was working for a long time, but recently, when we fill in the form, and want to submit the form, the submit button just greys out and the system stays frozen. It is a system @cheesegrits assisted me with some time ago. Is there anyone that can take a look for me, please?

 

[troester]

You don't mention your versions. If your signature shows really your system all is totally outdated.

You hoster may have upgraded the php version.

 

[jeanl]

Hi Troester

Thank you. I cannot update my signature for some reason. The PHP version is on 7.4.33. I will update my F! version from Github and see if it solves the issue.

 

[jeanl]

I have done a GitHub update on Fabrik and I still have the same issue, that I cannot save/submit a form.

 

[achartier]

Open the developer window of your browser and check for javascript errors.

 

[jeanl]

Thank you, I will do that. Is there a specific PHP version I need to use?

 

[jeanl]

This is what I get when in debug mode. I do not have any knowledge about this, so would appreciate it if anyone can assist..?

#3 #19
2 duplicates: #4 #20

1. SELECT `data`
   
   FROM `par_session`
   
   WHERE `session_id` = X'6d7635626a6f66747268733436646d7174326961366638703573'
   Explain
   Profile
   Call Stack
2. SHOW FULL COLUMNS
   FROM `par_users`
   Explain
   
   Profile
   Call Stack
3. Duplicate queries: #19
   SELECT *
   
   FROM `par_users`
   
   WHERE `id` = 243
   Explain
   Profile
   Call Stack
4. Duplicate queries: #20
   SELECT `g`.`id`,`g`.`title`
   
   FROM `par_usergroups` AS g
   
   INNER JOIN `par_user_usergroup_map` AS m
   ON m.group_id = g.id
   
   WHERE `m`.`user_id` = 243
   Explain
   Profile
   Call Stack
5. SELECT id, rules
   
   FROM `par_viewlevels`
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE par_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 7
   Profile
   Call Stack
6. SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
   FROM `par_extensions`
   
   WHERE `type` = 'component'
   AND `state` = 0
   AND `enabled` = 1
   Explain
   Profile
   Call Stack
7. SELECT b.id
   
   FROM par_user_usergroup_map AS map
   
   LEFT JOIN par_usergroups AS a
   ON a.id = map.group_id
   
   LEFT JOIN par_usergroups AS b
   ON b.lft <= a.lft
   AND b.rgt >= a.rgt
   
   WHERE map.user_id = 243
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE map ref PRIMARY PRIMARY 4 const 4 Using index
   1 SIMPLE a eq_ref PRIMARY PRIMARY 4 autostatus.map.group_id 1
   1 SIMPLE b ALL idx_usergroup_nested_set_lookup NO INDEX KEY COULD BE USED NULL NULL 11 Range checked for each record (index map: 0x10)
   Profile
   Call Stack
8. SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
   FROM par_extensions
   
   WHERE enabled = 1
   AND type = 'plugin'
   AND state IN (0,1)
   AND access IN (1,1,2,3)
   
   ORDER BY ordering
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE par_extensions ref extension extension 82 const 280 Using index condition; Using where; Using filesort
   Profile
   Call Stack
9. SET SQL_BIG_SELECTS=1, GROUP_CONCAT_MAX_LEN=10240
   Explain
   
   Profile
   Call Stack
10. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
    FROM par_menu AS m
    
    LEFT JOIN par_extensions AS e
    ON m.component_id = e.extension_id
    
    WHERE m.published = 1
    AND m.parent_id > 0
    AND m.client_id = 0
    
    ORDER BY m.lft
    Explain
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE m ALL NULL NO INDEX KEY COULD BE USED NULL NULL 103 Using where; Using filesort
    1 SIMPLE e eq_ref PRIMARY PRIMARY 4 autostatus.m.component_id 1 Using where
    Profile
    Call Stack

 

[jeanl]

1. SELECT id, home, template, s.params
   
   FROM par_template_styles as s
   
   LEFT JOIN par_extensions as e
   ON e.element=s.template
   AND e.type='template'
   AND e.client_id=s.client_id
   
   WHERE s.client_id = 0
   AND e.enabled = 1
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 6 Using where
   1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 autostatus.s.template,const 1 Using index condition; Using where
   Profile
   Call Stack
2. SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
   FROM `par_extensions`
   
   WHERE `type` = 'library'
   AND `element` = 'joomla'
   Explain
   Profile
   Call Stack
3. UPDATE `par_extensions`
   
   SET `params` = '{\"mediaversion\":\"9742ecbb0d0c4f6e16336c7e171146a6\"}'
   
   WHERE `type` = 'library'
   AND `element` = 'joomla'
   Explain
   
   Profile
   Call Stack
4. SELECT *
   
   FROM par_languages
   
   WHERE published=1
   
   ORDER BY ordering ASC
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE par_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort
   Profile
   Call Stack
5. SELECT *
   
   FROM `par_users`
   
   WHERE `id` = 271
   Explain
   Profile
   Call Stack
6. SELECT `g`.`id`,`g`.`title`
   
   FROM `par_usergroups` AS g
   
   INNER JOIN `par_user_usergroup_map` AS m
   ON m.group_id = g.id
   
   WHERE `m`.`user_id` = 271
   Explain
   Profile
   Call Stack
7. SELECT aa_online_branch
   
   FROM aa_online_userdb
   
   WHERE aa_online_userid ='243'
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE aa_online_userdb ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where
   Profile
   Call Stack
8. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
   
   FROM par_modules AS m
   
   LEFT JOIN par_modules_menu AS mm
   ON mm.moduleid = m.id
   
   LEFT JOIN par_extensions AS e
   ON e.element = m.module
   AND e.client_id = m.client_id
   
   WHERE m.published = 1
   AND e.enabled = 1
   AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-11-20 14:07:52')
   AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-20 14:07:52')
   AND m.access IN (1,1,2,3)
   AND m.client_id = 0
   AND (mm.menuid = 781 OR mm.menuid <= 0)
   
   ORDER BY m.position, m.ordering
   Explain
   id select_type table type possible_keys key key_len ref rows Extra
   1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 135 Using where; Using filesort
   1 SIMPLE mm ref PRIMARY PRIMARY 4 autostatus.m.id 1 Using where; Using index
   1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 autostatus.m.module,const 1 Using index condition; Using where
   Profile
   Call Stack
9. Duplicate queries: #3
   SELECT *
   
   FROM `par_users`
   
   WHERE `id` = 243
   Explain
   Profile
   Call Stack
10. Duplicate queries: #4
    SELECT `g`.`id`,`g`.`title`
    
    FROM `par_usergroups` AS g
    
    INNER JOIN `par_user_usergroup_map` AS m
    ON m.group_id = g.id
    
    WHERE `m`.`user_id` = 243
    Explain
    Profile
    Call Stack

15 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

1. 3 × SELECT *
   FROM `par_users`
2. 3 × SELECT `g`.`id`,`g`.`title`
   FROM `par_usergroups` AS g
   INNER JOIN `par_user_usergroup_map` AS m
   ON m.group_id = g.id
3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   FROM `par_extensions`
4. 1 × SELECT `data`
   FROM `par_session`
5. 1 × SELECT id, rules
   FROM `par_viewlevels
6. 1 × SELECT b.id
   FROM par_user_usergroup_map AS map
   LEFT JOIN par_usergroups AS a
   ON a.id = map.group_id
   LEFT JOIN par_usergroups AS b
   ON b.lft <= a.lft
   AND b.rgt >= a.rgt
7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   FROM par_extensions
8. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   FROM par_menu AS m
   LEFT JOIN par_extensions AS e
   ON m.component_id = e.extension_id
9. 1 × SELECT id, home, template, s.params
   FROM par_template_styles as s
   LEFT JOIN par_extensions as e
   ON e.element=s.template
   AND e.type='template'
   AND e.client_id=s.client_id
10. 1 × SELECT *
    FROM par_languages
11. 1 × SELECT aa_online_branch
    FROM aa_online_userdb
12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    FROM par_modules AS m
    LEFT JOIN par_modules_menu AS mm
    ON mm.moduleid = m.id
    LEFT JOIN par_extensions AS e
    ON e.element = m.module
    AND e.client_id = m.client_id

OTHER Tables:

1. 1 × SHOW FULL COLUMNS
   FROM `par_users
2. 1 ×
   SET SQL_BIG_SELECTS=1, GROUP_CONCAT_MAX_LEN=1024
3. 1 × UPDATE `par_extensions`
   SET `params` = '{\"mediaversion\":\"9742ecbb0d0c4f6e16336c7e171146a6\"}'

 

[troester]

No, not the J! debug output.

the submit button just greys out and the system stays frozen

Have a look in your browser console to see the Javascript errors.
Is this a multipage form? -> try without page breaks

 

[jeanl]

No, not the J! debug output. Have a look in your browser console to see the Javascript errors.
Is this a multipage form? -> try without page breaks

Where would I see the JS errors when in debug mode?

 

[jeanl]

A

No, not the J! debug output. Have a look in your browser console to see the Javascript errors.
Is this a multipage form? -> try without page breaks

Also, there are no page breaks:

 

[troester]

Greyed-out submit button:
I can't imagine when a standard form would show this.
So if your form is not multipage (you are showing only the setting of a group, do you have only one group in this form?) how do you call it, what is not default? (Ajax validation, Toggle Submit, Save partly, custom JS added..., )

For the browser dev console:
Right-click somewhere in your form, select something like "Examine" (depends on your browser and language), reload your form.
In the browser dev tool there's a tab like "Console" showing debug infos, JS errors etc.

 

[jeanl]

Greyed-out submit button:
I can't imagine when a standard form would show this.
So if your form is not multipage (you are showing only the setting of a group, do you have only one group in this form?) how do you call it, what is not default? (Ajax validation, Toggle Submit, Save partly, custom JS added..., )

For the browser dev console:
Right-click somewhere in your form, select something like "Examine" (depends on your browser and language), reload your form.
In the browser dev tool there's a tab like "Console" showing debug infos, JS errors etc.

The Submit Button is not greyed out, but when you click on it, it greys out and nothing happen. Let me check on those JS errors and paste what I find here.