Jump to content

Community

Forms Support


Michael.J

Recommended Posts

Hey, I have a problem with your plugin. I get these error when doing a select list.

UPDATE `form_fields` form_fields  SET `field_value`='',`field_type`='Select',`field_options`='["SimZOr","Pepper"]',`field_multiple`=false,`field_required`=false,`field_search_type`='exact' WHERE field_id=82 
IPS\Db\Exception: Unknown column 'field_search_type' in 'field list' (1054)
#0 /var/www/frog_forums/public_html/system/Db/Db.php(991): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array)
#1 /var/www/frog_forums/public_html/system/Patterns/ActiveRecord.php(491): IPS\_Db->update('`form_fields` f...', '`field_value`=?...', 'WHERE field_id=...')
#2 /var/www/frog_forums/public_html/system/Node/Model.php(2014): IPS\Patterns\_ActiveRecord->save()
#3 /var/www/frog_forums/public_html/system/Node/Model.php(2691): IPS\Node\_Model->save()
#4 /var/www/frog_forums/public_html/system/Node/Controller.php(383): IPS\Node\_Model->saveForm(Array)
#5 [internal function]: IPS\Node\_Controller->form()
#6 /var/www/frog_forums/public_html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#7 /var/www/frog_forums/public_html/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute()
#8 /var/www/frog_forums/public_html/applications/form/modules/admin/form/forms.php(35): IPS\Node\_Controller->execute()
#9 /var/www/frog_forums/public_html/system/Dispatcher/Dispatcher.php(129): IPS\form\modules\admin\form\_forms->execute()
#10 /var/www/frog_forums/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#11 {main}

 

Link to comment
Share on other sites

  • 3 weeks later...

I am also getting the error, including for Radio:

UPDATE `form_fields` form_fields  SET `field_value`='',`field_type`='Radio',`field_options`='["Prefix","Tag"]',`field_multiple`=false,`field_required`=false,`field_search_type`='exact' WHERE field_id=78 
IPS\Db\Exception: Unknown column 'field_search_type' in 'field list' (1054)
#0 /home/chronill/public_html/system/Db/Db.php(991): IPS\_Db->preparedQuery('UPDATE `form_fi...', Array)
#1 /home/chronill/public_html/system/Patterns/ActiveRecord.php(493): IPS\_Db->update('form_fields', Array, Array)
#2 [internal function]: IPS\Patterns\_ActiveRecord->save()
#3 /home/chronill/public_html/init.php(448) : eval()'d code(68): call_user_func_array('parent::save', Array)
#4 /home/chronill/public_html/system/Node/Model.php(2015): IPS\Patterns\rules_hook_ipsPatternsActiveRecord->save()
#5 /home/chronill/public_html/system/Node/Model.php(2692): IPS\Node\_Model->save()
#6 [internal function]: IPS\Node\_Model->saveForm(Array)
#7 /home/chronill/public_html/init.php(448) : eval()'d code(83): call_user_func_array('parent::saveFor...', Array)
#8 /home/chronill/public_html/system/Node/Controller.php(383): IPS\Node\rules_hook_ipsNodeModel->saveForm(Array)
#9 /home/chronill/public_html/system/Dispatcher/Controller.php(86): IPS\Node\_Controller->form()
#10 /home/chronill/public_html/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute()
#11 /home/chronill/public_html/applications/form/modules/admin/form/forms.php(35): IPS\Node\_Controller->execute()
#12 /home/chronill/public_html/system/Dispatcher/Dispatcher.php(129): IPS\form\modules\admin\form\_forms->execute()
#13 /home/chronill/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#14 {main}

 

Link to comment
Share on other sites

  • 4 weeks later...
  • 5 weeks later...

UPDATE `form_fields` form_fields  SET `field_pf_allow_attachments`=1,`field_value`='Default fied value',`field_form_id`=2,`field_type`='Text',`field_options`='[]',`field_multiple`=false,`field_required`=true,`field_max_input`=0,`field_input_format`='' WHERE field_id=5 
IPS\Db\Exception: Unknown column 'field_pf_allow_attachments' in 'field list' (1054)
#0 /home/panamyfo/public_html/system/Db/Db.php(990): IPS\_Db->preparedQuery('UPDATE `form_fi...', Array)
#1 /home/panamyfo/public_html/system/Patterns/ActiveRecord.php(492): IPS\_Db->update('form_fields', Array, Array)
#2 [internal function]: IPS\Patterns\_ActiveRecord->save()
#3 /home/panamyfo/public_html/init.php(447) : eval()'d code(120): call_user_func_array('parent::save', Array)
#4 /home/panamyfo/public_html/system/Node/Model.php(2183): IPS\Patterns\rules_hook_ipsPatternsActiveRecord->save()
#5 [internal function]: IPS\Node\_Model->save()
#6 /home/panamyfo/public_html/init.php(447) : eval()'d code(990): call_user_func_array('parent::save', Array)
#7 /home/panamyfo/public_html/system/Node/Model.php(2955): IPS\Node\collab_hook_ipsNodeModel->save()
#8 [internal function]: IPS\Node\_Model->saveForm(Array)
#9 /home/panamyfo/public_html/init.php(447) : eval()'d code(83): call_user_func_array('parent::saveFor...', Array)
#10 /home/panamyfo/public_html/system/Node/Controller.php(391): IPS\Node\rules_hook_ipsNodeModel->saveForm(Array)
#11 /home/panamyfo/public_html/system/Dispatcher/Controller.php(85): IPS\Node\_Controller->form()
#12 /home/panamyfo/public_html/system/Node/Controller.php(62): IPS\Dispatcher\_Controller->execute()
#13 /home/panamyfo/public_html/applications/form/modules/admin/form/forms.php(35): IPS\Node\_Controller->execute()
#14 /home/panamyfo/public_html/system/Dispatcher/Dispatcher.php(142): IPS\form\modules\admin\form\_forms->execute()
#15 /home/panamyfo/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#16 {main}

Link to comment
Share on other sites

10 hours ago, kmk said:

UPDATE `form_fields` form_fields  SET `field_pf_allow_attachments`=1,`field_value`='Default fied value',`field_form_id`=2,`field_type`='Text',`field_options`='[]',`field_multiple`=false,`field_required`=true,`field_max_input`=0,`field_input_format`='' WHERE field_id=5 

Try the above patch but add this line as well. What version of IPB4 are you using?

unset( $form->elements['']['pf_allow_attachments'] );

 

Link to comment
Share on other sites

On 6/25/2017 at 1:38 PM, kmk said:

Can you guide me how archive it?

Open applications/form/sources/Form/Field.php

Find:

unset( $form->elements['']['pf_format'] );

Add BELOW:

unset( $form->elements['']['pf_allow_attachments'] );

Save.

8 hours ago, superj707 said:

is this mod 4.2 compatible?

Apart from the above error reported, I haven't had anymore confirmed issues. But I will be releasing an update for IPB 4.2 that includes some more existing bug fixes.

Link to comment
Share on other sites

  • 4 weeks later...
On ‎3‎/‎14‎/‎2017 at 8:33 AM, FadedHazard said:

Hey, I have a problem with your plugin. I get these error when doing a select list.


UPDATE `form_fields` form_fields  SET `field_value`='',`field_type`='Select',`field_options`='["SimZOr","Pepper"]',`field_multiple`=false,`field_required`=false,`field_search_type`='exact' WHERE field_id=82 
IPS\Db\Exception: Unknown column 'field_search_type' in 'field list' (1054)
#0 /var/www/frog_forums/public_html/system/Db/Db.php(991): IPS\_Db->preparedQuery('/*IPS\\Node\\_Mod...', Array)
#1 /var/www/frog_forums/public_html/system/Patterns/ActiveRecord.php(491): IPS\_Db->update('`form_fields` f...', '`field_value`=?...', 'WHERE field_id=...')
#2 /var/www/frog_forums/public_html/system/Node/Model.php(2014): IPS\Patterns\_ActiveRecord->save()
#3 /var/www/frog_forums/public_html/system/Node/Model.php(2691): IPS\Node\_Model->save()
#4 /var/www/frog_forums/public_html/system/Node/Controller.php(383): IPS\Node\_Model->saveForm(Array)
#5 [internal function]: IPS\Node\_Controller->form()
#6 /var/www/frog_forums/public_html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#7 /var/www/frog_forums/public_html/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute()
#8 /var/www/frog_forums/public_html/applications/form/modules/admin/form/forms.php(35): IPS\Node\_Controller->execute()
#9 /var/www/frog_forums/public_html/system/Dispatcher/Dispatcher.php(129): IPS\form\modules\admin\form\_forms->execute()
#10 /var/www/frog_forums/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#11 {main}

 

On ‎4‎/‎10‎/‎2017 at 7:15 PM, Simon Woods said:

I am also getting the error, including for Radio:


UPDATE `form_fields` form_fields  SET `field_value`='',`field_type`='Radio',`field_options`='["Prefix","Tag"]',`field_multiple`=false,`field_required`=false,`field_search_type`='exact' WHERE field_id=78 
IPS\Db\Exception: Unknown column 'field_search_type' in 'field list' (1054)
#0 /home/chronill/public_html/system/Db/Db.php(991): IPS\_Db->preparedQuery('UPDATE `form_fi...', Array)
#1 /home/chronill/public_html/system/Patterns/ActiveRecord.php(493): IPS\_Db->update('form_fields', Array, Array)
#2 [internal function]: IPS\Patterns\_ActiveRecord->save()
#3 /home/chronill/public_html/init.php(448) : eval()'d code(68): call_user_func_array('parent::save', Array)
#4 /home/chronill/public_html/system/Node/Model.php(2015): IPS\Patterns\rules_hook_ipsPatternsActiveRecord->save()
#5 /home/chronill/public_html/system/Node/Model.php(2692): IPS\Node\_Model->save()
#6 [internal function]: IPS\Node\_Model->saveForm(Array)
#7 /home/chronill/public_html/init.php(448) : eval()'d code(83): call_user_func_array('parent::saveFor...', Array)
#8 /home/chronill/public_html/system/Node/Controller.php(383): IPS\Node\rules_hook_ipsNodeModel->saveForm(Array)
#9 /home/chronill/public_html/system/Dispatcher/Controller.php(86): IPS\Node\_Controller->form()
#10 /home/chronill/public_html/system/Node/Controller.php(63): IPS\Dispatcher\_Controller->execute()
#11 /home/chronill/public_html/applications/form/modules/admin/form/forms.php(35): IPS\Node\_Controller->execute()
#12 /home/chronill/public_html/system/Dispatcher/Dispatcher.php(129): IPS\form\modules\admin\form\_forms->execute()
#13 /home/chronill/public_html/admin/index.php(14): IPS\_Dispatcher->run()
#14 {main}

 

 

 

On ‎4‎/‎11‎/‎2017 at 4:58 PM, Mike John said:

What was the manual fix for this error?

When I click on the link, the page no longer exists.

 

I found the fix:

https://www.devfuse.com/forums/topic/11577-forms-error/

Edited by GrooveOnBeat
Link to comment
Share on other sites

10 hours ago, Mike John said:

This app allows custom fields but not sure what you mean by support requests?

Its possible to create custom fields when a users create a support requests?

Original Ip.Board custom fields are really limited.

Thanks you

Link to comment
Share on other sites

On 7/25/2017 at 8:35 PM, modman said:

Its possible to create custom fields when a users create a support requests?

Original Ip.Board custom fields are really limited.

Right now it will only support the default IPB 4 custom fields that you see when creating a profile field for example.

Link to comment
Share on other sites

  • 3 weeks later...

I'm attempting to test out the forms in widgets and the block is not appearing in the block manager for me to choose it. Weirdly, it appears in the list when creating a custom block from a plugin.

System logs threw this up:

Template store key: template_21_cf26a6e403c332934cdd22fea1e7c649_widgets missing (form, front, widgets)

#0 /var/www/html/r266536/system/Theme/Theme.php(785): IPS\_Log::log('Template store ...', 'template_store_...')
#1 /var/www/html/r266536/system/Widget/Widget.php(122): IPS\_Theme->getTemplate('widgets', 'form', 'front')
#2 /var/www/html/r266536/applications/form/widgets/formForm.php(44): IPS\_Widget->init()
#3 /var/www/html/r266536/system/Widget/Widget.php(103): IPS\form\widgets\_formForm->init()
#4 /var/www/html/r266536/system/Widget/Widget.php(295): IPS\_Widget->__construct('59910d600a2a6', Array, '["sidebar","cms...', NULL)
#5 /var/www/html/r266536/applications/core/modules/front/system/widgets.php(71): IPS\_Widget::load(Object(IPS\form\Application), 'formForm', '59910d600a2a6', Array, '["sidebar","cms...', NULL)
#6 /var/www/html/r266536/system/Dispatcher/Controller.php(85): IPS\core\modules\front\system\_widgets->getBlockList()
#7 /var/www/html/r266536/applications/core/modules/front/system/widgets.php(38): IPS\Dispatcher\_Controller->execute()
#8 /var/www/html/r266536/system/Dispatcher/Dispatcher.php(146): IPS\core\modules\front\system\_widgets->execute()
#9 /var/www/html/r266536/index.php(12): IPS\_Dispatcher->run()
#10 {main}

 

Edited by Simon Woods
Link to comment
Share on other sites

On 8/14/2017 at 0:41 PM, Simon Woods said:

I'm attempting to test out the forms in widgets and the block is not appearing in the block manager for me to choose it. Weirdly, it appears in the list when creating a custom block from a plugin.

What page are you originally trying to add a form widget to? A forum area or something within the Pages app?

Link to comment
Share on other sites

15 hours ago, Simon Woods said:

Initially it was the board index but I just tried within Pages and in a forum area, where it also isn't appearing.

I don't seem to be able to reproduce this in the forums or pages app. Can you reproduce this with the default "Contact Form" or do you have a customized form? If the later, if I could get acp login details. I'll try and reproduce this with your exact setup.

VME9ALe.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy