• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Submitting a form stopped working

jeanl

Member
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?
 
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.
 
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.
 
I have done a GitHub update on Fabrik and I still have the same issue, that I cannot save/submit a form.
 
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
 
  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\"}'
 
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
 
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.
 
Last edited:
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.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top