[TH] Custom Fields [Deleted]

Renegade said:
Why would I get this error even if the custom fields are not even enabled for this forum section

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'custom_post_fields' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: blkrb0t, Yesterday at 10:34 PM
Stack Trace
#0 /home/techencl/public_html/community/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/techencl/public_html/community/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/techencl/public_html/community/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/techencl/public_html/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_post', Array)
#5 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
#6 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
#7 /home/techencl/public_html/community/library/XenForo/ControllerPublic/Thread.php(549): XenForo_DataWriter->save()
#8 /home/techencl/public_html/community/library/Waindigo/CustomFields/Extend/XenForo/ControllerPublic/Thread.php(167): XenForo_ControllerPublic_Thread->actionAddReply()
#9 /home/techencl/public_html/community/library/DoublePost/ControllerPublic/Thread.php(40): Waindigo_CustomFields_Extend_XenForo_ControllerPublic_Thread->actionAddReply()
#10 /home/techencl/public_html/community/library/XenForo/FrontController.php(347): DoublePost_ControllerPublic_Thread->actionAddReply()
#11 /home/techencl/public_html/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/techencl/public_html/community/index.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(99) "http://www.techenclave.com/community/threads/playstation-4-news-rumors-speculations.86873/add-reply"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(376) "<p>[QUOTE="Gollum, post: 1924056, member: 54749"]I collect stuff.</p><p>I didn't even have a tv when I bought the PS3[/QUOTE]</p><p>What? LOL...</p><p><br></p><p>Do you also snuggle beside your collections and mumble "my precious" <img src="styles/soft_responsive/xenforo/clear.png" class="mceSmilieSprite mceSmilie8" title="Big Grin    :D" alt=":D" data-smilie="yes"><br></p>"
    ["_xfRelativeResolver"] => string(97) "http://www.techenclave.com/community/threads/playstation-4-news-rumors-speculations.86873/page-16"
    ["attachment_hash"] => string(32) "8e0364a89bd84b4411c15a33842dfcd2"
    ["last_date"] => string(10) "1394383442"
    ["last_known_date"] => string(10) "1394383442"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(71) "/community/threads/playstation-4-news-rumors-speculations.86873/page-16"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

And another type of error
Code: 
ErrorException: Fatal Error: syntax error, unexpected end of file, expecting function (T_FUNCTION) - library/Waindigo/Listener/TemplateHook/20130522.php:1220
Generated By: Unknown Account, Yesterday at 10:21 PM
Stack Trace
#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}
Request State
array(3) {
  ["url"] => string(119) "http://www.techenclave.com/community/threads/suggest-a-home-ups-which-can-run-3-fans-and-3-lights-for-2-3-hours.129401/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
Click to expand...
First error seems to be due to Custom Fields not installing properly. Try reinstalling.

Second error seems to be an error that occurred as you were uploading all the add-on files. As long as this is not a re-occurring error, it is nothing to worry about. You may want to consider using an add-on installer add-on (e.g. our Install and Upgrade by Waindigo add-on) as these errors don't happen if you upload everything through the Admin Control Panel rather than with FTP.
 
Wesker said:
Quick question by the way. I've set this up so a specific text field is created before posting a new thread. How do you edit the CSS so the text that is displayed is changed without affecting the entire website. What specific file/line is this?
Click to expand...
Assuming you are using the "Viewable on Thread View" option, this is not currently possible. You will have to use the HTML option, which can be found by going to the appropriate node edit page, going to the Thread Fields tab, and entering appropriate HTML into the text box there. You can then add any CSS classes you like.
 
estranged said:
Getting this error while editing my nodes.

Code: 
Mysqli statement execute error : Truncated incorrect DOUBLE value: 'location'
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
Zend_Db_Adapter_Abstract->update() in Waindigo/CustomFields/Extend/XenForo/DataWriter/Forum.php at line 507
Waindigo_CustomFields_Extend_XenForo_DataWriter_Forum->updateCustomFields() in Waindigo/CustomFields/Extend/XenForo/DataWriter/Forum.php at line 258
Waindigo_CustomFields_Extend_XenForo_DataWriter_Forum->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in XenForo/ControllerAdmin/Forum.php at line 122
XenForo_ControllerAdmin_Forum->actionSave() in Waindigo/CustomFields/Extend/XenForo/ControllerAdmin/Forum.php at line 111
Waindigo_CustomFields_Extend_XenForo_ControllerAdmin_Forum->actionSave() in Waindigo/Thumbnails/Extend/XenForo/ControllerAdmin/Forum.php at line 53
Waindigo_Thumbnails_Extend_XenForo_ControllerAdmin_Forum->actionSave() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/x/public_html/admin.php at line 13
Click to expand...
This seems like an error with a different add-on. Have you tried disabling other add-ons?
 
This is the full error in the log. 'location' is the field id of the custom field.

Mysqli statement execute error : Truncated incorrect DOUBLE value: 'location'

Code: 
#6 /home/x/public_html/library/XenForo/ControllerAdmin/Forum.php(122): XenForo_DataWriter->save()
#7 /home/x/public_html/library/Waindigo/CustomFields/Extend/XenForo/ControllerAdmin/Forum.php(111): XenForo_ControllerAdmin_Forum->actionSave()
#8 /home/x/public_html/library/XenForo/FrontController.php(347): Waindigo_CustomFields_Extend_XenForo_ControllerAdmin_Forum->actionSave()
#9 /home/x/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/x/public_html/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(44) "http://x.com/admin.php?forums/74/save"
  ["_GET"] => array(1) {
    ["forums/74/save"] => string(0) ""
  }
  ["_POST"] => array(26) {
    ["title"] => string(12) "Alım Satım"
    ["node_name"] => string(0) ""
    ["description"] => string(45) "Alınık, satılık, takaslık ürünleriniz."
    ["parent_node_id"] => string(2) "45"
    ["display_order"] => string(1) "1"
    ["display_in_list"] => string(1) "1"
    ["allow_posting"] => string(1) "1"
    ["count_messages"] => string(1) "1"
    ["find_new"] => string(1) "1"
    ["allowed_watch_notifications"] => string(4) "none"
    ["default_sort_order"] => string(9) "post_date"
    ["default_sort_direction"] => string(4) "desc"
    ["available_prefixes"] => array(4) {
      [0] => string(1) "1"
      [1] => string(1) "2"
      [2] => string(1) "4"
      [3] => string(2) "42"
    }
    ["default_prefix_id"] => string(1) "0"
    ["available_fields"] => array(3) {
      [0] => string(8) "location"
      [1] => string(1) "2"
      [2] => string(1) "1"
    }
    ["thread_header"] => string(0) ""
    ["thread_footer"] => string(0) ""
    ["post_header"] => string(0) ""
    ["post_footer"] => string(0) ""
    ["custom_fields"] => array(3) {
      ["location"] => string(0) ""
      [2] => string(0) ""
      [1] => string(0) ""
    }
    ["custom_fields_shown"] => array(3) {
      [0] => string(8) "location"
      [1] => string(1) "2"
      [2] => string(1) "1"
    }
    ["node_type_id"] => string(5) "Forum"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(24) "/admin.php?nodes/74/edit"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
 
Waindigo said:
First error seems to be due to Custom Fields not installing properly. Try reinstalling.
Click to expand...
They both must have occurred while I was uploading and installing on live forum. The timestamp is from that hour and none after that. The add-on is live and working fine.
 
estranged said:
This is the full error in the log. 'location' is the field id of the custom field.

Mysqli statement execute error : Truncated incorrect DOUBLE value: 'location'

Code: 
#6 /home/x/public_html/library/XenForo/ControllerAdmin/Forum.php(122): XenForo_DataWriter->save()
#7 /home/x/public_html/library/Waindigo/CustomFields/Extend/XenForo/ControllerAdmin/Forum.php(111): XenForo_ControllerAdmin_Forum->actionSave()
#8 /home/x/public_html/library/XenForo/FrontController.php(347): Waindigo_CustomFields_Extend_XenForo_ControllerAdmin_Forum->actionSave()
#9 /home/x/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /home/x/public_html/admin.php(13): XenForo_FrontController->run()
#11 {main}
Request State
array(3) {
  ["url"] => string(44) "http://x.com/admin.php?forums/74/save"
  ["_GET"] => array(1) {
    ["forums/74/save"] => string(0) ""
  }
  ["_POST"] => array(26) {
    ["title"] => string(12) "Alım Satım"
    ["node_name"] => string(0) ""
    ["description"] => string(45) "Alınık, satılık, takaslık ürünleriniz."
    ["parent_node_id"] => string(2) "45"
    ["display_order"] => string(1) "1"
    ["display_in_list"] => string(1) "1"
    ["allow_posting"] => string(1) "1"
    ["count_messages"] => string(1) "1"
    ["find_new"] => string(1) "1"
    ["allowed_watch_notifications"] => string(4) "none"
    ["default_sort_order"] => string(9) "post_date"
    ["default_sort_direction"] => string(4) "desc"
    ["available_prefixes"] => array(4) {
      [0] => string(1) "1"
      [1] => string(1) "2"
      [2] => string(1) "4"
      [3] => string(2) "42"
    }
    ["default_prefix_id"] => string(1) "0"
    ["available_fields"] => array(3) {
      [0] => string(8) "location"
      [1] => string(1) "2"
      [2] => string(1) "1"
    }
    ["thread_header"] => string(0) ""
    ["thread_footer"] => string(0) ""
    ["post_header"] => string(0) ""
    ["post_footer"] => string(0) ""
    ["custom_fields"] => array(3) {
      ["location"] => string(0) ""
      [2] => string(0) ""
      [1] => string(0) ""
    }
    ["custom_fields_shown"] => array(3) {
      [0] => string(8) "location"
      [1] => string(1) "2"
      [2] => string(1) "1"
    }
    ["node_type_id"] => string(5) "Forum"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(24) "/admin.php?nodes/74/edit"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
Click to expand...
Try running the upgrade XML file again. There seems to be a problem with one of your database tables which is structured incorrectly. Not sure if this has been caused by some other add-on or for some other reason.

If you continue to get an error, please run the following query in PhpMyAdmin (or similar) and post the results here:
Code: 
DESCRIBE xf_forum_field
 
I think I noticed a bug. The order of field groups is not the same in all the 3 places. In admin page the lower display order value gets higher visibility. Same in the thread view. But when creating a thread the lower value gets lower visibility.
 
Waindigo said:
Try running the upgrade XML file again. There seems to be a problem with one of your database tables which is structured incorrectly. Not sure if this has been caused by some other add-on or for some other reason.

If you continue to get an error, please run the following query in PhpMyAdmin (or similar) and post the results here:

Code: 
DESCRIBE xf_forum_field
Click to expand...

Running the upgrade didn't fix the issue. I didn't have this problem when I first installed the addon but after adding and deleting a few custom fields, I started getting it.

Capture.webp
 
Thank you, and now i want to show a group field below edit area and orthe one above the editor.
C
How can do that?
sory for my bad English !:p
 
There is something wrong with the add-on. After updating to latest version none of the users were able to make any post in any thread on the forum. There is nothing in the error logs as well.

Tried uninstalling and it wont go through either

Code: 
Mysqli statement execute error : Can't DROP 'custom_post_fields'; check that column/key exists

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Waindigo/Install/20140226.php at line 820
Waindigo_Install->_dropTableChanges() in Waindigo/CustomFields/Install/Controller.php at line 436
Waindigo_CustomFields_Install_Controller->_preUninstall() in Waindigo/Install/20140226.php at line 293
Waindigo_Install->_uninstall() in Waindigo/Install/20140226.php at line 127
Waindigo_Install::uninstall()
call_user_func() in XenForo/DataWriter/AddOn.php at line 200
XenForo_DataWriter_AddOn->_postDelete() in XenForo/DataWriter.php at line 1779
XenForo_DataWriter->delete() in XenForo/ControllerAdmin/AddOn.php at line 122
XenForo_ControllerAdmin_AddOn->actionDelete() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/techencl/public_html/community/admin.php at line 13


Edit: I uninstalled and reinstalled. Still the same problem. Not able to post in any forum.
 
Last edited:
I'd like to give our users the ability, when submitting a resource, to add up to 3 member names to the resource (via custom fields) who will act as representatives for that resource. They would simply enter the username in the field and that username would then be displayed on the resource. Ideally I'd like it to work similar to the XF search function where it autofills the member name, but that's not necessarily critical. I'll customize the output to display a link to the member's profile. Of course, without validation, there's the opportunity to have bad data in there.

What would be the best way to achieve this?
 
Hi Jon,

I have a question regarding this. I have set up a custom thread field for a URL. The user inputs the URL and the URL is displayed under the thread title on both the discussion list and on the first post of the thread.

What I would like to do is check the inputted URL to see if it is an image or video. Example www.url.com/image.jpg

If it is an image, I would like the first post to automatically wrap up the URL in
bb code so the content can be shown as well as the link. Same as a video (youtube). Is this possible?

Thanks.
 
Ludachris said:
I'd like to give our users the ability, when submitting a resource, to add up to 3 member names to the resource (via custom fields) who will act as representatives for that resource. They would simply enter the username in the field and that username would then be displayed on the resource. Ideally I'd like it to work similar to the XF search function where it autofills the member name, but that's not necessarily critical. I'll customize the output to display a link to the member's profile. Of course, without validation, there's the opportunity to have bad data in there.

What would be the best way to achieve this?
Click to expand...
Dynamic said:
Hi Jon,

I have a question regarding this. I have set up a custom thread field for a URL. The user inputs the URL and the URL is displayed under the thread title on both the discussion list and on the first post of the thread.

What I would like to do is check the inputted URL to see if it is an image or video. Example www.url.com/image.jpg

If it is an image, I would like the first post to automatically wrap up the URL in bb code so the content can be shown as well as the link. Same as a video (youtube). Is this possible?

Thanks.
Click to expand...
Both of these would require a custom PHP callback. Please PM me if you would like help in developing these.
 
Any idea how do I go past this error. I tried uninstalling, resinstalling

Code: 
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'custom_post_fields' in 'field list' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Pseudo Admin, A moment ago
Stack Trace
#0 /home/techencl/public_html/community/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/techencl/public_html/community/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/techencl/public_html/community/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/techencl/public_html/community/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('xf_post', Array)
#5 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
#6 /home/techencl/public_html/community/library/XenForo/DataWriter.php(1405): XenForo_DataWriter->_save()
#7 /home/techencl/public_html/community/library/XenForo/ControllerPublic/Thread.php(549): XenForo_DataWriter->save()
#8 /home/techencl/public_html/community/library/Waindigo/CustomFields/Extend/XenForo/ControllerPublic/Thread.php(167): XenForo_ControllerPublic_Thread->actionAddReply()
#9 /home/techencl/public_html/community/library/DoublePost/ControllerPublic/Thread.php(40): Waindigo_CustomFields_Extend_XenForo_ControllerPublic_Thread->actionAddReply()
#10 /home/techencl/public_html/community/library/XenForo/FrontController.php(347): DoublePost_ControllerPublic_Thread->actionAddReply()
#11 /home/techencl/public_html/community/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#12 /home/techencl/public_html/community/index.php(13): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
  ["url"] => string(96) "http://www.techenclave.com/community/threads/forum-software-upgrade-on-saturday.146243/add-reply"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["message_html"] => string(46) "<p>Will look into the mobile theme logo.</p>
"
    ["_xfRelativeResolver"] => string(93) "http://www.techenclave.com/community/threads/forum-software-upgrade-on-saturday.146243/page-5"
    ["attachment_hash"] => string(32) "6478e976c8141df86fb1cb6740a548de"
    ["last_date"] => string(10) "1394694347"
    ["last_known_date"] => string(10) "1394694347"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(67) "/community/threads/forum-software-upgrade-on-saturday.146243/page-5"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
You must log in or register to reply here.

Similar threads

XenSoluce
[Xen-Soluce] Required Custom Fields On Forum [Paid]
2
Replies
21
Views
1K
Alfaloji
A
RallyFan
  • Question Question
XF 2.1 Conditional Statements - Are words, spam phrases, custom fields possible?
Replies
2
Views
825
RallyFan
RallyFan
sbj
  • Suggestion Suggestion
Lack of interest Enter choices for drop downs (custom fields) in the front-end
Replies
0
Views
370
sbj
sbj
XenSoluce
[Xen-Soluce] Required Custom Fields On Upgrade [Paid]
2 3 4
Replies
72
Views
3K
XenSoluce
XenSoluce
CMTV
  • Suggestion Suggestion
Advanced Custom Fields
Replies
10
Views
5K
btmgreg
btmgreg
Top Bottom