error when saving objects in 'sob_input_count'

[lxnunes]

Hi!

I am getting an error when saving objects:

Code: Select all

===USER==========
globeadmin

===PDO MESSAGE=== 
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'sob_input_count' at row 1

===SQL=========== 
UPDATE zzzzsys_object SET `sob_all_event` = '0', `sob_select_multiple` = '0', `sob_input_count` = '' WHERE `zzzzsys_object_id` = '61c0dd30e1f3d14';

===BACK TRACE====
/var/www/html/TestDB/core/nudata.php - line 422 (nuRunQuery)
/var/www/html/TestDB/core/nuapi.php - line 85 (nuUpdateDatabase)

As far as I can tell, only objects of type INPUT are not affected. Any ideas?

cheers

[kev1n]

Hi,

Can you upload a screenshot where I can see all information on the "All" tab?

[lxnunes]

sure, here it is:

Capture.PNG

[lxnunes]

I only noticed it today, up to now I had no issues at all

[kev1n]

Run this SQL on your DB to fix that issue:

Code: Select all

REPLACE INTO `zzzzsys_form` (`zzzzsys_form_id`, `sfo_type`, `sfo_code`, `sfo_description`, `sfo_breadcrumb_title`, `sfo_table`, `sfo_primary_key`, `sfo_browse_redirect_form_id`, `sfo_browse_row_height`, `sfo_browse_rows_per_page`, `sfo_browse_title_multiline`, `sfo_browse_autoresize_columns`, `sfo_browse_sql`, `sfo_javascript`, `sfo_browse_javascript`, `sfo_edit_javascript`) VALUES ('nuobject', 'browseedit', 'nuobject', 'Object', '#sob_all_id#|New', 'zzzzsys_object', 'zzzzsys_object_id', '', '0', '18', '1', NULL, 'SELECT * FROM zzzzsys_object\r\nJOIN #TABLE_ID# ON zzzzsys_object_id = theid\r\nJOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id\r\nJOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id \r\n\r\nWHERE (\r\n (sob_all_type = \'#nuBrowseTitle0_select#\' OR \'#nuBrowseTitle0_select#\' = \'\' OR \'#nuBrowseTitle0_select#\' LIKE \'#%\' )\r\n AND\r\n (sob_input_type = \'#nuBrowseTitle1_select#\' OR \'#nuBrowseTitle1_select#\' = \'\' OR \'#nuBrowseTitle1_select#\' LIKE \'#%\' )\r\n)\r\n\r\nORDER BY sfo_description, sob_input_type, sob_all_id', NULL, 'var a = [[\"\",\"\"],[\"calc\",\"Calc\"],[\"display\",\"Display\"],[\"contentbox\",\"ContentBox\"],[\"editor\",\"WYSIWYG Editor\"],[\"html\",\"HTML\"],[\"image\",\"Image\"],[\"input\",\"Input\"],[\"lookup\",\"Lookup\"],[\"run\",\"Run\"],[\"select\",\"Select\"],[\"subform\",\"Subform\"],[\"textarea\",\"Textarea\"],[\"word\",\"Word\"]];\r\nnuAddBrowseTitleSelect(0, a);\r\n\r\n$(\'#nuBrowseTitle9_select\').parent().unbind(\"touchstart\");\r\n\r\na = [[\"\",\"\"],[\"nuDate\",\"nuDate\"],[\"nuNumber\",\"nuNumber\"],[\"nuScroll\",\"nuScroll\"],[\"nuAutoNumber\",\"nuAutoNumber\"],[\"button\",\"Button\"],\r\n [\"checkbox\",\"Checkbox\"],[\"color\",\"Color\"],[\"datetime-local\",\"Datetime-Local\"],[\"email\",\"Email\"],[\"file\",\"File\"],\r\n [\"image\",\"Image\"],[\"month\",\"Month\"],[\"number\",\"Number\"],[\"password\",\"Password\"],[\"radio\",\"Radio\"],[\"range\",\"Range\"],\r\n [\"reset\",\"Reset\"],[\"search\",\"Search\"],[\"tel\",\"Telephone\"],[\"text\",\"Text\"],[\"time\",\"Time\"],[\"url\",\"URL\"],[\"week\",\"Week\"]];\r\n\r\nnuAddBrowseTitleSelect(1, a);\r\n$(\'#nuBrowseTitle1_select\').parent().unbind(\"touchstart\");\r\n\r\n\r\n$(\"[data-nu-column=\'0\']\").each(function() {\r\n $(this).addClass(\'nu_\' + this.textContent).addClass(\'nuCellColored\');\r\n});\r\n\r\n\r\n$(\"[data-nu-column=\'4\']\").each(function() {\r\n $(this).html(stripHTMLTags($(this).html()).replace(/&nbsp;/g, \' \').trim());\r\n});\r\n\r\n\r\nfunction stripHTMLTags(s) {\r\n return s == \'\' ? \'\' : s.replace(/<\\/?[^>]+(>|$)/g, \"\");\r\n}\r\n', '// Code Snippets form\r\nnuSetSnippetFormFilter(0, 0, 1, 0); // SQL\r\n\r\nnuHide(\'sob_code_snippet_display_lookupcode\');\r\nnuHide(\'sob_code_snippet_select_lookupcode\');\r\nnuHide(\'label_zzzzsys_event_sf\');\r\nnuHide(\'label_sob_html_code\');\r\nnuShow(\'sob_run_zzzzsys_form_open_button\', sob_run_zzzzsys_form_id.value !== \'\');\r\nnuShow(\'sob_lookup_zzzzsys_form_open_button\', sob_lookup_zzzzsys_form_id.value !== \'\');\r\nnuDisable(\'sob_calc_formula\');\r\nnuSetToolTip(\'sob_all_id_create_button\', nuTranslate(\'Add database column\'));\r\n\r\nvar tabIdDescLeft = $(\'#sob_all_zzzzsys_tab_iddescription\').cssNumber(\'left\') + 11;\r\n$(\'#sob_all_zzzzsys_tab_iddescription\').css(\'left\', tabIdDescLeft + \'px\');\r\n\r\n$(\'#zzzzsys_event_sfsev_javascript\').attr(\'id\', \'jsfuntitle\');\r\n$(\'#sob_calc_formula\').addClass(\'nuCalculatorCurrency\').css(\'font-size\', 12);\r\n$(\'#sob_all_display_condition\').addClass(\'sql\');\r\n$(\'#sob_all_default_value_sql\').addClass(\'sql\');\r\n$(\'#sob_display_sql\').addClass(\'sql\');\r\n$(\'#sob_input_datalist\').addClass(\'sql\');\r\n$(\'#sob_select_sql\').addClass(\'sql\');\r\n$(\'#sob_lookup_javascript\').addClass(\'js\');\r\n$(\'#sob_input_javascript\').addClass(\'js\');\r\n$(\'#sob_html_javascript\').addClass(\'js\');\r\n$(\'#sob_lookup_php\').addClass(\'php\');\r\n$(\'#sob_html_code\').addClass(\'html\');\r\n$(\'#sob_all_style\').addClass(\'css\');\r\n$(\'#sob_input_attribute\').addClass(\'css\');\r\n$(\"[id$=\'sev_javascript\']\").addClass(\'js\');\r\n$(\"#title_zzzzsys_event_sfsev_javascript\").removeClass(\'js\');\r\n$(\'#sob_run_zzzzsys_form_open_button\').toggleClass(\'input_button nuButton nuLookupButton\');\r\n$(\'#sob_lookup_zzzzsys_form_open_button\').toggleClass(\'input_button nuButton nuLookupButton\');\r\n$(\'#sob_subform_zzzzsys_form_open_button\').toggleClass(\'input_button nuButton nuLookupButton\');\r\n$(\'#sob_all_type_open_button\').toggleClass(\'input_button nuButton nuLookupButton\');\r\n\r\n$(\'#sob_select_sql\').focus(function() {\r\n $(this).attr(\'placeholder\', \'1. SQL: A valid SQL query that returns 2 columns:\\n\\n SELECT table_id, description FROM table\\n\\nOr:\\n\\n2. List: A list delimited by a |\\n\\n1|First|\\n2|Second|\\n3|Third\');\r\n}).blur(function() {\r\n $(this).attr(\'placeholder\', \'\');\r\n})\r\n\r\n$(\'#nuTab8\').click(function() {\r\n nuTestChart();\r\n});\r\n\r\nnuAttachButtonImage(\'icon_lujs\', \'LUJS\');\r\nnuAttachButtonImage(\'icon_html\', \'HTML\');\r\nnuAttachButtonImage(\'ab_event\', \'AB\',\'nuButtonImageSmall\');\r\n// nuAttachButtonImage(\'di_sql\', \'SQL\',\'nuButtonImageSmall\');\r\n// nuAttachButtonImage(\'se_sql\', \'SQL\',\'nuButtonImageSmall\');\r\n\r\n$(\'#viewflowchart\')\r\n .css(\'padding\', \'46px 0px 0px 3px\')\r\n .css(\'text-align\', \'left\')\r\n .css(\'background-size\', \'75px\')\r\n\r\n\r\nif ($(\'#zzzzsys_event_sf000sev_event\').val() !== \'\') {\r\n $(\'#nuTab10\').css(\'font-weight\', \'bold\');\r\n}\r\n\r\nnuInputTypeChanged(nuGetValue(\'sob_input_type\'));\r\nnuHideCalcObjects();\r\nnuPopulateHTML();\r\nnuAddDataListToRunId();\r\n\r\nnuAttachFontAwesome(\'sob_all_align_btn_left\', \'fa fa-align-left\');\r\nnuAttachFontAwesome(\'sob_all_align_btn_center\', \'fa fa-align-center\');\r\nnuAttachFontAwesome(\'sob_all_align_btn_right\', \'fa fa-align-right\');\r\nnuAttachFontAwesome(\'sob_all_validate_btn_no_duplicates\', \'fa fa-diamond\');\r\nnuAttachFontAwesome(\'sob_all_validate_btn_no_blanks\', \'fa fa-battery-full\');\r\nnuAttachFontAwesome(\'sob_all_validate_btn_no_duplicates_or_blanks\', \'fa fa-star\');\r\nnuAttachFontAwesome(\'sob_all_access_btn_hidden\', \'fa fa-eye-slash\');\r\nnuAttachFontAwesome(\'sob_all_access_btn_readonly\', \'fa fa-lock\');\r\nnuAttachFontAwesome(\'sob_all_access_btn_editable\', \'far fa-edit\');\r\nnuAttachFontAwesome(\'sob_all_validate_btn_none\', \'fa fa-globe\');\r\n\r\n$(\"button[id*=\'_btn_\']\").addClass(\'nuQuickButton\').removeClass(\'input_button nuButton\');\r\n\r\nvar filter = String(window.filter).split(\'|\');\r\n\r\nif (filter[0] == \'fromfastform\') {\r\n\r\n $(\'#nuDeleteButton\').remove();\r\n $(\'#nuCloneButton\').remove();\r\n $(\'#nuSaveButton\').remove();\r\n $(\'#sob_all_id\').val(filter[1]).addClass(\'nuHighlight\');\r\n $(\'#sob_all_label\').val(filter[2]).addClass(\'nuHighlight\');\r\n\r\n}\r\n\r\n$(\'.js\').dblclick(function() {\r\n nuOpenAce(\'Javascript\', this.id);\r\n});\r\n$(\'.sql\').dblclick(function() {\r\n nuOpenAce(\'SQL\', this.id);\r\n});\r\n$(\'.html\').dblclick(function() {\r\n nuOpenAce(\'HTML\', this.id);\r\n});\r\n$(\'.php\').dblclick(function() {\r\n nuOpenAce(\'PHP\', this.id);\r\n});\r\n$(\'.css\').dblclick(function() {\r\n nuOpenAce(\'CSS\', this.id);\r\n});\r\n\r\nnuHide(\'sob_input_format\');\r\nvar sit = nuGetValue(\'sob_input_type\');\r\nnuShow(\'sob_input_format\', sit == \'nuDate\' || sit == \'nuNumber\');\r\nnuShow(\'sob_input_javascript\', sit == \'nuScroll\');\r\n\r\nnuObjectColor();\r\nnuGetStartingTab();\r\n\r\n\r\nif (!nuIsNewRecord()) {\r\n\r\n nuDisplayIncHeightButtons();\r\n nuShowDataType();\r\n\r\n} else {\r\n\r\n nuSetValue(\'sob_all_top\', 0);\r\n nuSetValue(\'sob_all_left\', 60);\r\n nuSetValue(\'sob_all_height\', 22);\r\n nuSetValue(\'sob_all_width\', 100);\r\n nuSetValue(\'sob_all_validate\',0);\r\n nuSetValue(\'sob_all_access\',0);\r\n nuSetValue(\'sob_all_align\',\'left\');\r\n nuSetValue(\'sob_all_cloneable\',\'1\');\r\n\r\n nuHide(\'sob_all_type_open_button\');\r\n nuHide(\'sob_all_type_input\'); \r\n nuHide(\'sob_all_id_create_button\');\r\n\r\n if (nuIsIframe()) {\r\n let pTab = nuSelectedTabId(parent);\r\n if (pTab !== null) {\r\n nuGetLookupId(pTab, \'sob_all_zzzzsys_tab_id\', false);\r\n } else {\r\n if (nuGetValue(\'sob_all_zzzzsys_tab_id\') === \'\' && parent.nuCurrentProperties().form_code == \'nuuserhome\') {\r\n nuGetLookupId(\'nufastforms\', \'sob_all_zzzzsys_tab_id\', false)\r\n }\r\n }\r\n $(\'#sob_all_label\').focus();\r\n nuSetValue(\'sob_all_type\', \'input\');\r\n nuSetValue(\'sob_input_type\', \'text\');\r\n }\r\n\r\n}\r\n\r\nnuUpdateLookupDescriptionDatalist();\r\nnuUpdateIdDatalist();\r\nrunMethodChanged();\r\nnuHasNotBeenEdited();\r\n\r\n\r\nfunction nuColumnDataType(table, id) {\r\n\r\n let s = nuFORM.tableSchema[table];\r\n let i = -1;\r\n if (typeof s !== \"undefined\") {\r\n i = s.names.indexOf(id.val());\r\n }\r\n\r\n return i > -1 ? s.types[i] : \'\';\r\n\r\n}\r\n\r\nfunction nuShowDataType() {\r\n\r\n let id = $(\'sob_all_id\');\r\n let iDataType = $(\'sob_all_id_datatype\');\r\n\r\n let table = nuGetValue(\"sob_all_table\");\r\n let dataType = \'\';\r\n\r\n if (table !== \'\' && id.val() !== \'\') {\r\n dataType = nuColumnDataType(table, id);\r\n\r\n }\r\n\r\n iDataType.val(dataType);\r\n nuDisplayCreateButton();\r\n\r\n}\r\n\r\nfunction nuObjectNoId() {\r\n return [\'word\', \'html\', \'button\', \'run\', \'subform\', \'contentbox\'].indexOf(nuGetValue(\'sob_all_type\')) !== -1;\r\n}\r\n\r\nfunction nuDisplayCreateButton() {\r\n\r\n let dataType = nuColumnDataType(nuGetValue(\"sob_all_table\"), $(\'#sob_all_id\'));\r\n nuShow(\'sob_all_id_create_button\', dataType === \'\' && nuGetValue(\'sob_all_id\') !== \'\' && nuGetValue(\'sob_all_table\') !== \'\' && !nuObjectNoId());\r\n\r\n}\r\n\r\nfunction nuDisplayIncHeightButtons() {\r\n\r\n var showButtons = [\'html\', \'textarea\', \'subform\', \'image\', \'contentbox\'].indexOf(nuGetValue(\'sob_all_type\')) !== -1;\r\n\r\n $(\'[id^=sob_height_btn_set]\').nuShow(showButtons);\r\n}\r\n\r\n\r\nfunction nuTestChart() {\r\n\r\n let g = nuGetValue(\'sob_html_chart_type\');\r\n\r\n if (g === \'\' || nuGetValue(\'sob_all_type\') !== \'html\') {\r\n $(\'#google_chart\').html(\'\');\r\n return;\r\n }\r\n\r\n let c = \'ComboChart\';\r\n let t = nuGetValue(\'sob_html_title\');\r\n let x = nuGetValue(\'sob_html_vertical_label\');\r\n let y = nuGetValue(\'sob_html_horizontal_label\');\r\n let l = \'bars\';\r\n let s = false;\r\n\r\n let a = [\r\n [\'Month\', \'Shane\', \'Dave\', \'Adam\', \'Paul\', \'Chris\'],\r\n [\'2019\', 100, 200, 300, 400, 500],\r\n [\'2020\', 165, 238, 322, 498, 550],\r\n [\'2021\', 165, 938, 522, 998, 450],\r\n [\'2022\', 135, 1120, 599, 1268, 288]\r\n ];\r\n\r\n if (g == \'p\') c = \'PieChart\';\r\n if (g == \'l\') l = \'lines\';\r\n if (g == \'bh\') c = \'BarChart\';\r\n if (g == \'bhs\') c = \'BarChart\';\r\n if (g == \'bs\') s = true;\r\n if (g == \'bhs\') s = true;\r\n\r\n nuChart(\'google_chart\', c, a, t, x, y, l, s);\r\n\r\n}\r\n\r\nfunction nuChartOnReady(i, wrapper) {\r\n // let wrapper = window[\"google_chart_wrapper\"];\r\n var options = { seriesType: wrapper.m.seriesType, chartArea : {left:\"10%\", width:\"65%\"} };\r\n wrapper.setOptions(options);\r\n wrapper.draw(); \r\n}\r\n\r\nfunction nuAddDataListToRunId() {\r\n\r\n let arrRecordId = [\r\n [\" \", nuTranslate(\"Leave blank to open a Browse or Launch Form\")],\r\n [\"-1\", nuTranslate(\"Open a new Record\")],\r\n [\"#EXAMPLE_HASH_COOKIE#\", nuTranslate(\"Use a Hash Cookie\")]\r\n ];\r\n\r\n nuAddDatalist(\'sob_run_id\', arrRecordId);\r\n\r\n $(\'#sob_run_id\').on(\'input\', function() {\r\n if ($(this).val() == \' \') {\r\n $(this).val(\'\').change();\r\n }\r\n\r\n });\r\n\r\n}\r\n\r\nfunction nuObjectColor(){\r\n \r\n $(\'.nuValidate\').removeClass(\'nuValidate\');\r\n\r\n let e = $(\'#sob_all_type\').hasClass(\'nuEdited\');\r\n let o = [];\r\n\r\n o[\'run\'] = 1;\r\n o[\'display\'] = 2;\r\n o[\'select\'] = 3;\r\n o[\'lookup\'] = 4;\r\n o[\'subform\'] = 5;\r\n o[\'image\'] = 6;\r\n o[\'input\'] = 7;\r\n o[\'html\'] = 8;\r\n o[\'calc\'] = 9;\r\n \r\n\r\n $(\'#sob_all_type\').removeClass();\r\n \r\n if(e){ //-- keep class if edited\r\n $(\'#sob_all_type\').addClass(\'nuEdited\');\r\n }\r\n \r\n $(\'#sob_all_type\').addClass(\'nu_\'+$(\'#sob_all_type\').val());\r\n \r\n $(\"#sob_all_type > option\").each(function() {\r\n $(this).addClass(\'nu_\'+this.value);\r\n });\r\n\r\n let t = o[$(\'#sob_all_type\').val()];\r\n \r\n $(\"[id^=\'nuTab\']\").removeClass(\'nuRelatedTab\');\r\n \r\n for(let i = 1 ; i < o.length ; i++){\r\n $(\'#nuTab\' + i).removeClass(\'nuRelatedTab\');\r\n }\r\n \r\n $(\'#nuTab0\').addClass(\'nuRelatedTab\');\r\n $(\'#nuTab\' + t).addClass(\'nuRelatedTab\');\r\n \r\n} \r\n\r\nfunction nuAddToFormula(e) {\r\n\r\n var fld = e.target.innerHTML;\r\n var frm = $(\'#sob_calc_formula\').val();\r\n\r\n if (fld == \'Clear\') {\r\n\r\n $(\'#sob_calc_formula\')\r\n .val(\'\')\r\n .addClass(\'nuEdited\');\r\n return;\r\n\r\n }\r\n\r\n $(\'#sob_calc_formula\')\r\n .addClass(\'nuEdited\')\r\n .val(frm + fld);\r\n\r\n nuHasBeenEdited();\r\n\r\n}\r\n\r\nfunction nuDisplayAllTypeInput() {\r\n\r\n let v = nuGetValue(\'sob_input_type\', \'text\');\r\n v = nuGetValue(\'sob_all_type\') == \'input\' ? v : \'\';\r\n $(\'#sob_all_type_input\').val(v);\r\n\r\n}\r\n\r\nfunction nuTypeChanged() {\r\n\r\n nuShow(\'sob_all_type_open_button\', sob_all_type.value !== \'\');\r\n nuShow(\'sob_all_type_input\', sob_all_type.value !== \'\'); \r\n \r\n nuObjectColor();\r\n nuDisplayCreateButton();\r\n nuDisplayIncHeightButtons();\r\n nuDisplayAllTypeInput();\r\n\r\n}\r\n\r\nfunction nuInputTypeChanged(t) {\r\n\r\n nuHide(\'sob_input_format\');\r\n nuHide(\'sob_input_count\');\r\n nuHide(\'sob_input_javascript\');\r\n nuHide(\'sob_input_datalist\');\r\n\r\n if (t == \'nuScroll\') {\r\n nuShow(\'sob_input_javascript\');\r\n }\r\n\r\n if (t == \'nuAutoNumber\') {\r\n\r\n nuShow(\'sob_input_count\');\r\n $(\'#sob_input_javascript\').val(\'\').addClass(\'nuEdited\');\r\n\r\n }\r\n\r\n if (t == \'nuDate\' || t == \'nuNumber\' || t == \'number\' || t == \'text\' || t == \'email\' || t == \'search\' || t == \'month\') {\r\n nuShow(\'sob_input_datalist\');\r\n if ($(\'#sob_input_datalist\').val() == \'\' && $(\'#sob_all_id_datatype\').val() !== \'\') {\r\n // $(\'#sob_input_datalist\').val(\"SELECT DISTINCT `\" + $(\"#sob_all_id\").val() + \"` FROM `\" + $(\'#sob_all_table\').val() + \"` ORDER BY 1\").change();\r\n }\r\n }\r\n\r\n if (t == \'nuDate\' || t == \'nuNumber\') {\r\n\r\n nuShow(\'sob_input_format\');\r\n\r\n $(\'#sob_input_format\').children().each(function(index) {\r\n\r\n $(this).show();\r\n\r\n if ($(this).val()[0] == \'D\' && t != \'nuDate\') {\r\n $(this).hide();\r\n }\r\n if ($(this).val()[0] == \'N\' && t != \'nuNumber\') {\r\n $(this).hide();\r\n }\r\n\r\n });\r\n\r\n }\r\n\r\n nuDisplayAllTypeInput();\r\n\r\n}\r\n\r\nfunction nuHideCalcObjects() {\r\n\r\n var f = $(\'#sob_all_zzzzsys_form_id\').val();\r\n\r\n $(\'#add_total\').children().each(function(index) {\r\n\r\n\r\n if ($(this).val() != f) {\r\n $(this).hide();\r\n }\r\n if ($(this).text() == $(\'#sob_all_id\').val()) {\r\n $(this).hide();\r\n }\r\n\r\n });\r\n\r\n}\r\n\r\n\r\nfunction nuAddCalcObject(t) {\r\n\r\n var f = $(\'#sob_calc_formula\').val();\r\n var i = $(t).attr(\'data-nu-ids\');\r\n var s = f + \"nuTotal(\'\" + i + \"\')\";\r\n\r\n if (i == \'\') {\r\n return;\r\n }\r\n\r\n $(\'#sob_calc_formula\')\r\n .addClass(\'nuEdited\')\r\n .val(s);\r\n\r\n $(\'#add_total\').val(\'\');\r\n\r\n nuHasBeenEdited();\r\n\r\n}\r\n\r\n\r\nfunction nuPopulateHTML() {\r\n\r\n var o = nuCalcObjects();\r\n var a = [];\r\n\r\n for (var i = 0; i < o.length; i++) {\r\n\r\n var ids = String(o[i].ids);\r\n var ty = o[i].type;\r\n var id = String(o[i].ids).split(\'.\');\r\n var sp = \'&nbsp;\';\r\n\r\n if (id.length == 1) {\r\n a.push(\'<tr><td><div title=\"\' + ty + \'\" style=\"overflow:hidden;width:305px;text-align:left;padding:2px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_\' + o[i].type + \'\" data-nu-ids=\"\' + ids + \'\">\' + ids + \'</div></td></tr>\');\r\n } else {\r\n\r\n var h = \'<span title=\"subform\" class=\"nu_subform\">\' + id[0] + \'</span>.<span title=\"\' + ty + \'\" class=\"nu_input\" style=\"padding:7px 5px 7px 5px\">\' + id[1] + sp.repeat(200) + \'</span>\';\r\n a.push(\'<tr><td><div style=\"overflow:hidden;width:305px;text-align:left;padding:2px;height:28px\" onclick=\"nuAddCalcObject(this);\" class=\"nuCalculatorButton nu_subform\" data-nu-ids=\"\' + ids + \'\">\' + h + \'</div></td></tr>\');\r\n\r\n }\r\n\r\n }\r\n\r\n $(\'#add_total\').html(\'<table>\' + a.join(\'\') + \'</table>\');\r\n\r\n}\r\n\r\n\r\nfunction nuSetSelectIndex(i, index) {\r\n\r\n $(\"#\" + i).prop(\"selectedIndex\", index).change();\r\n\r\n}\r\n\r\nfunction nuSetLookupWidth() {\r\n var w = $(\'#sob_lookup_description\').val() == $(\'#sob_lookup_code\').val() ? 0 : 150;\r\n var cw = $(\'#sob_lookup_description_width\').val();\r\n if (cw == 0 || cw == 150 || w == 0) $(\'#sob_lookup_description_width\').val(w).change();\r\n}\r\n\r\n\r\nfunction subFormRowsCount(subform, fieldname) {\r\n\r\n var sf = nuSubformObject(subform);\r\n var col = sf.fields.indexOf(fieldname);\r\n var c = 0;\r\n for (var row = 0; row < sf.rows.length; row++) {\r\n if (sf.deleted[row] == 0 && sf.rows[row][col].trim() != \'\') c++;\r\n }\r\n\r\n return c;\r\n\r\n}\r\n\r\nfunction nuBeforeSave() {\r\n\r\n runMethodChanged();\r\n adjustProperties();\r\n\r\n if ($(\'#sob_all_type\').val() == \'select\') {\r\n $(\'#sob_select_multiple\').addClass(\'nuEdited\');\r\n }\r\n\r\n $(\"#sob_all_event\").prop(\'checked\', subFormRowsCount(\'zzzzsys_event_sf\', \'sev_event\') > 0).change();\r\n\r\n}\r\n\r\nfunction adjustProperties() {\r\n\r\n let type = nuGetValue(\'sob_all_type\');\r\n let access = nuGetValue(\'sob_all_access\'); \r\n let align = nuGetValue(\'sob_all_align\'); \r\n let validation = nuGetValue(\'sob_all_validate\'); \r\n let cloneable = nuGetValue(\'sob_all_coneable\'); \r\n let inputType = nuGetValue(\'sob_input_type\'); \r\n let inputFormat = nuGetValue(\'sob_input_format\');\r\n\r\n if (type !== \'input\') {\r\n if (inputType !== \'\') nuSetValue(\'sob_input_type\',\'\');\r\n if (inputFormat !== \'\') nuSetValue(\'sob_input_format\',\'\');\r\n }\r\n \r\n if (type.containsAny([\'word\', \'html\', \'image\', \'contentbox\', \'contentbox\'])) {\r\n if (validation !== \'0\') nuSetValue(\'sob_all_validate\', \'0\'); // validation --> none\r\n if (access == \'1\') nuSetValue(\'sob_all_access\', \'0\'); // readonly --> editable\r\n }\r\n\r\n if (type === \'word\') {\r\n if (access == \'1\') nuSetValue(\'sob_all_access\', \'0\'); // readonly --> editable\r\n if (validation !== \'0\') nuSetValue(\'sob_all_validate\', \'0\'); // validation --> none\r\n nuSetValue(\'sob_input_type\',\'\');\r\n nuSetValue(\'sob_input_format\',\'\');\r\n }\r\n \r\n if (type === \'display\') {\r\n if (access == \'1\') nuSetValue(\'sob_all_access\', \'0\'); // readonly --> editable\r\n }\r\n\r\n}\r\n\r\nfunction runMethodChanged() {\r\n\r\n var m = nuGetValue(\'sob_run_method\');\r\n nuEnable(\'sob_run_target\', m == \'b\');\r\n\r\n if ($(\'#sob_run_target\').prop(\"selectedIndex\") > 0 && m == \'b\') {\r\n return;\r\n }\r\n\r\n if (m == \'b\' || m == \'i\') {\r\n $(\'#sob_run_target\').prop(\"selectedIndex\", m == \'b\' ? 1 : 0).change();\r\n }\r\n\r\n}\r\n\r\nfunction nuOnClone() {\r\n nuHide(\'sob_all_id_create_button\');\r\n}\r\n\r\nfunction nuUpdateIdDatalist() {\r\n\r\n var t = nuFORM.tableSchema[nuGetValue(\"sob_all_table\")];\r\n nuAddDatalist(\'sob_all_id\', typeof t !== \"undefined\" ? t.names : []);\r\n\r\n}\r\n\r\nfunction nuUpdateLookupDescriptionDatalist() {\r\n \r\n let arr = nuFORM.tableSchema[nuGetValue(\"sob_lookup_table\")]?nuFORM.tableSchema[nuGetValue(\"sob_lookup_table\")].names:[];\r\n nuAddDatalist(\'sob_lookup_description\',arr);\r\n \r\n}\r\n')

[lxnunes]

you nailed it! I am curious, what happened? If it is again my "special" setup, I think I will rebuild the server...

[kev1n]

There has been an update today that caused that issue. Strangely enough, that error does not occur in my dev installation.

[lxnunes]

I am glad I can provide you an extra-weird environment for testing

[kev1n]