[OzzModz] Advanced Forms [Deleted]

Ozzy47 updated [OzzModz] Advanced Forms with a new update entry:

[OzzModz] Advanced Forms for XenForo for XenForo 2.2+ Update 2.2.6 Beta 7

danger GIF
Warning Sign GIF


Now That Ive got your attention:
This is a beta release, take a full backup before installing on a production site. Optimally try it out on a test site that is a replication of your live site before installing on the live site. It has had limited testing.

2.2.6 Beta 7:

Fix: avoid DateMalformedStringException when parsing date/datetime answers
Click to expand...


Read the rest of this update entry...
 
Liam C. said:
Got a question! Looked at the documentation and found no info but we are using the "Form Cooldown" option but running into a user who is experiencing issues. We set the cooldown to 7 days.

Does this cooldown apply to per user, or to the entire community? It makes sense for per user, however a user has not submitted a thread in over 7 days however are experienced the issue. My only theory is that they are keep pressing the submit button every day, and it resets that cooldown back to 7 days? Is that possible, or am I just wrong and it is global-cooldown?
Click to expand...
Liam C. said:
Yes it was set at 604800 seconds, I've disabled it for now but we had a user who kept checking every day to see if he could submit the form and could not.
Click to expand...
@Ozzy47 Got any clue?
 
Liam C. said:
Got a question! Looked at the documentation and found no info but we are using the "Form Cooldown" option but running into a user who is experiencing issues. We set the cooldown to 7 days.

Does this cooldown apply to per user, or to the entire community? It makes sense for per user, however a user has not submitted a thread in over 7 days however are experienced the issue. My only theory is that they are keep pressing the submit button every day, and it resets that cooldown back to 7 days? Is that possible, or am I just wrong and it is global-cooldown?
Click to expand...

@Painbaker will have to get back to you as soon as he can.
 
Hello
I have question concerning the Advanced Forms. I wanted to add in the Report Title {A#) and the question number. But when i go to save it I get this error
You may not use question answer 1 in the report title. It is not a required question.

Now nowhere in the actual setup of the form is there an option to make the question required or not. Am I missing something. Thank you for the help
 
Kellendeming said:
Now nowhere in the actual setup of the form is there an option to make the question required or not
Click to expand...
To make a question required, fill out the "Question error" option under General options on a question for the form. Once the question error is defined, the field will switch to required and you should be good to go.
 
Liam C. said:
Got a question! Looked at the documentation and found no info but we are using the "Form Cooldown" option but running into a user who is experiencing issues. We set the cooldown to 7 days.

Does this cooldown apply to per user, or to the entire community? It makes sense for per user, however a user has not submitted a thread in over 7 days however are experienced the issue. My only theory is that they are keep pressing the submit button every day, and it resets that cooldown back to 7 days? Is that possible, or am I just wrong and it is global-cooldown?
Click to expand...
This is for current user and current form

Liam C. said:
Yes it was set at 604800 seconds, I've disabled it for now but we had a user who kept checking every day to see if he could submit the form and could not.
Click to expand...
Works fine for me
Are they using a form rather than manually creating a thread? This option does not limit the ability to create new threads
 
Ozzy47 updated [OzzModz] Advanced Forms with a new update entry:

[OzzModz] Advanced Forms for XenForo for XenForo 2.2+ Update 2.2.6 Release Candidate 1

danger GIF
Warning Sign GIF


Now That Ive got your attention:
This is a Release Candidate, take a full backup before installing on a production site. Optimally try it out on a test site that is a replication of your live site before installing on the live site. It has had limited testing.

2.2.6 Release Candidate 1:

  • ...
Click to expand...

Read the rest of this update entry...
 
Painbaker said:
Works fine for me
Are they using a form rather than manually creating a thread? This option does not limit the ability to create new threads
Click to expand...
Not sure what you mean by "manually creating a thread". We use AdvancedForms quite often on our site, we've used it for a few years (and not long did a massive update, not sure if it worked before that or not. Currently on 2.2.3 on AdvancedForms).

I haven't been able to test it myself either, some users experience this issue a few times a week. We've checked their activity and none of them had submitted the form.

1743928837748.webp

The date at time of screenshot was 20th of March, 2025. The user's previous time of filling out that form was December 29, 2024.



This was another case:

1743929007382.webp

They tried again later on:

1743929027475.webp
(Date and time is different from original)


We ended up creating another form in the attempt to fix it, did not resolve it. Same issue. We had to remove the cooldown for users to stop experiencing these issues.

What would you suggest?
 
If I'm reading the error log correctly, my favorite addon is throwing some errors. Ver 2.2.6 Beta 7. I get a hundreds of these over a few hour window every day. I can't seem to find any common elements of the threads being crawled. If I try to disable the addon, I very quickly accumulate thousands of errors of a different sort, but one thing at a time I guess. Any ideas?

EDIT: Disabling the addon now doesn't seem to generate errors. Not sure what was happening last time I tried it.

Code: 
XF\Db\Exception: Too many connections src/XF/Db/Mysqli/Adapter.php:172
Generated by: Unknown account Apr 15, 2025 at 4:52 AM

Stack trace

#0 src/XF/Db/Mysqli/Adapter.php(31): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 src/XF/Db/AbstractAdapter.php(62): XF\Db\Mysqli\Adapter->getConnection()
#2 src/XF/Db/AbstractAdapter.php(85): XF\Db\AbstractAdapter->connect()
#3 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
            SELECT cach...', 1)
#4 src/XF/PermissionCache.php(36): XF\Db\AbstractAdapter->fetchOne('
            SELECT cach...', 1)
#5 src/XF/PermissionSet.php(35): XF\PermissionCache->getGlobalPerms(1)
#6 src/XF/Entity/User.php(1271): XF\PermissionSet->hasGlobalPermission('snogForms', 'canViewForms')
#7 src/addons/Snog/Forms/XF/Entity/User.php(16): XF\Entity\User->hasPermission('snogForms', 'canViewForms')
#8 src/addons/Snog/Forms/Listener.php(130): Snog\Forms\XF\Entity\User->canViewAdvancedForms()
#9 src/XF/Extension.php(86): Snog\Forms\Listener::appPubStartEnd(Object(XF\Pub\App))
#10 src/XF/App.php(3368): XF\Extension->fire('app_pub_start_e...', Array, NULL)
#11 src/XF/Pub/App.php(255): XF\App->fire('app_pub_start_e...', Array)
#12 src/XF/App.php(2822): XF\Pub\App->start(true)
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state

array(4) {
  ["url"] => string(31) "/whats-new/posts/3916916/page-3"
  ["referrer"] => string(57) "https://www.penturners.org/whats-new/posts/3916916/page-3"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
Ozzy47 said:
My suggestion would be to upgrade to the latest version and see if that helps.
Click to expand...

Upgraded to RC2 and did a rebuild. Same situation: Never happens with a logged on user.

Code: 
    XF\Db\Exception: Too many connections src/XF/Db/Mysqli/Adapter.php:172 

    Generated by: Unknown account Apr 17, 2025 at 3:27 PM 

Stack trace

#0 src/XF/Db/Mysqli/Adapter.php(31): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 src/XF/Db/AbstractAdapter.php(62): XF\Db\Mysqli\Adapter->getConnection()
#2 src/XF/Db/AbstractAdapter.php(85): XF\Db\AbstractAdapter->connect()
#3 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
			SELECT cach...', 1)
#4 src/XF/PermissionCache.php(36): XF\Db\AbstractAdapter->fetchOne('
			SELECT cach...', 1)
#5 src/XF/PermissionSet.php(35): XF\PermissionCache->getGlobalPerms(1)
#6 src/XF/Entity/User.php(1271): XF\PermissionSet->hasGlobalPermission('snogForms', 'canViewForms')
#7 src/addons/Snog/Forms/XF/Entity/User.php(16): XF\Entity\User->hasPermission('snogForms', 'canViewForms')
#8 src/addons/Snog/Forms/Listener.php(130): Snog\Forms\XF\Entity\User->canViewAdvancedForms()
#9 src/XF/Extension.php(86): Snog\Forms\Listener::appPubStartEnd(Object(XF\Pub\App))
#10 src/XF/App.php(3368): XF\Extension->fire('app_pub_start_e...', Array, NULL)
#11 src/XF/Pub/App.php(255): XF\App->fire('app_pub_start_e...', Array)
#12 src/XF/App.php(2822): XF\Pub\App->start(true)
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state

array(4) {
  ["url"] => string(39) "/threads/nail-polish-to-color-pr.53018/"
  ["referrer"] => string(76) "https://www.penturners.org/threads/nail-polish-to-color-pr.53018/post-921283"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
penturners said:
Upgraded to RC2 and did a rebuild. Same situation: Never happens with a logged on user.

Code: 
    XF\Db\Exception: Too many connections src/XF/Db/Mysqli/Adapter.php:172

    Generated by: Unknown account Apr 17, 2025 at 3:27 PM

Stack trace

#0 src/XF/Db/Mysqli/Adapter.php(31): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 src/XF/Db/AbstractAdapter.php(62): XF\Db\Mysqli\Adapter->getConnection()
#2 src/XF/Db/AbstractAdapter.php(85): XF\Db\AbstractAdapter->connect()
#3 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
            SELECT cach...', 1)
#4 src/XF/PermissionCache.php(36): XF\Db\AbstractAdapter->fetchOne('
            SELECT cach...', 1)
#5 src/XF/PermissionSet.php(35): XF\PermissionCache->getGlobalPerms(1)
#6 src/XF/Entity/User.php(1271): XF\PermissionSet->hasGlobalPermission('snogForms', 'canViewForms')
#7 src/addons/Snog/Forms/XF/Entity/User.php(16): XF\Entity\User->hasPermission('snogForms', 'canViewForms')
#8 src/addons/Snog/Forms/Listener.php(130): Snog\Forms\XF\Entity\User->canViewAdvancedForms()
#9 src/XF/Extension.php(86): Snog\Forms\Listener::appPubStartEnd(Object(XF\Pub\App))
#10 src/XF/App.php(3368): XF\Extension->fire('app_pub_start_e...', Array, NULL)
#11 src/XF/Pub/App.php(255): XF\App->fire('app_pub_start_e...', Array)
#12 src/XF/App.php(2822): XF\Pub\App->start(true)
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state

array(4) {
  ["url"] => string(39) "/threads/nail-polish-to-color-pr.53018/"
  ["referrer"] => string(76) "https://www.penturners.org/threads/nail-polish-to-color-pr.53018/post-921283"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...

Okay, @Painbaker will have to look into this, as well as a couple of things reported on my site.
 
Liam C. said:
Regarding 2.2.6 Release Candidate 2, is that relating to the issue that I had posted up above?
Click to expand...
Yes

penturners said:
Upgraded to RC2 and did a rebuild. Same situation: Never happens with a logged on user.

Code: 
    XF\Db\Exception: Too many connections src/XF/Db/Mysqli/Adapter.php:172

    Generated by: Unknown account Apr 17, 2025 at 3:27 PM

Stack trace

#0 src/XF/Db/Mysqli/Adapter.php(31): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 src/XF/Db/AbstractAdapter.php(62): XF\Db\Mysqli\Adapter->getConnection()
#2 src/XF/Db/AbstractAdapter.php(85): XF\Db\AbstractAdapter->connect()
#3 src/XF/Db/AbstractAdapter.php(152): XF\Db\AbstractAdapter->query('
            SELECT cach...', 1)
#4 src/XF/PermissionCache.php(36): XF\Db\AbstractAdapter->fetchOne('
            SELECT cach...', 1)
#5 src/XF/PermissionSet.php(35): XF\PermissionCache->getGlobalPerms(1)
#6 src/XF/Entity/User.php(1271): XF\PermissionSet->hasGlobalPermission('snogForms', 'canViewForms')
#7 src/addons/Snog/Forms/XF/Entity/User.php(16): XF\Entity\User->hasPermission('snogForms', 'canViewForms')
#8 src/addons/Snog/Forms/Listener.php(130): Snog\Forms\XF\Entity\User->canViewAdvancedForms()
#9 src/XF/Extension.php(86): Snog\Forms\Listener::appPubStartEnd(Object(XF\Pub\App))
#10 src/XF/App.php(3368): XF\Extension->fire('app_pub_start_e...', Array, NULL)
#11 src/XF/Pub/App.php(255): XF\App->fire('app_pub_start_e...', Array)
#12 src/XF/App.php(2822): XF\Pub\App->start(true)
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}

Request state

array(4) {
  ["url"] => string(39) "/threads/nail-polish-to-color-pr.53018/"
  ["referrer"] => string(76) "https://www.penturners.org/threads/nail-polish-to-color-pr.53018/post-921283"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...
Likely server configuration issue
I don't think this add-on can increase the number of database connections

Check the max_connections MySQL option and investigate what creates a lot of connections to your database
 
Subject: Unnecessary DB query on every page load due to navigation callback?

Hi,

my client has a simple menu item in the main navigation that links to the Forms section – nothing more, as far as I can tell. However, I’ve noticed that even on unrelated pages like forum_view, a query like this is still being executed:

Code: 
SELECT xf_snog_forms_forms.*, xf_snog_forms_types_Type_1.*

FROM xf_snog_forms_forms

LEFT JOIN xf_snog_forms_types AS xf_snog_forms_types_Type_1 ON ...

WHERE xf_snog_forms_forms.active = 1

Is there a reason this needs to run on every page load?

Wouldn’t it be more efficient to avoid triggering this query unless the actual Forms page or sub-navigation is being rendered?

Right now, this means tens of thousands of unnecessary queries per day just for one link in the main menu.

Can this be disabled or optimized?

Thanks!
 
Robert9 said:
Subject: Unnecessary DB query on every page load due to navigation callback?

Hi,

my client has a simple menu item in the main navigation that links to the Forms section – nothing more, as far as I can tell. However, I’ve noticed that even on unrelated pages like forum_view, a query like this is still being executed:

Code: 
SELECT xf_snog_forms_forms.*, xf_snog_forms_types_Type_1.*

FROM xf_snog_forms_forms

LEFT JOIN xf_snog_forms_types AS xf_snog_forms_types_Type_1 ON ...

WHERE xf_snog_forms_forms.active = 1

Is there a reason this needs to run on every page load?

Wouldn’t it be more efficient to avoid triggering this query unless the actual Forms page or sub-navigation is being rendered?

Right now, this means tens of thousands of unnecessary queries per day just for one link in the main menu.

Can this be disabled or optimized?

Thanks!
Click to expand...
This query is only executed at session start and is cached until you make changes to forms/add a new one/delete one
 
You must log in or register to reply here.

Similar threads

Hoib3rgA
German translation: [OzzModz] Advanced Forms
Replies
7
Views
989
Hoib3rgA
Hoib3rgA
Nulumia
[OzzModz] Advanced Node List Widget
Replies
14
Views
2K
🔥Iggy🔥
🔥
Nulumia
[OzzModz] Advanced Sticky Thread Separator
2
Replies
25
Views
2K
collantphile
collantphile
TylerB
Advanced Forms
Replies
1
Views
2K
Digital Doctor
Digital Doctor
Ozzy47
Add-on [OzzModz] Advanced ACP Beta Testers
Replies
2
Views
2K
Ozzy47
Ozzy47
Back
Top Bottom