Page 1 of 1
Report Builder Problems
Posted: Tue May 21, 2024 11:03 pm
by ricklincs
I have run Fast Report and when I click on Open I get the following
report builder 1.png
If I click report Designer in any report i get a blank screen with the address https://......./core/nureportdesigner.php?tt=SQL:664cae28b234227&launch=664c571972d60d8
I have downloaded the latest nubuilder files and updated.
I am using Mariadb 10.6.16
Php 8.3.7
on a Plesk Obsidian v18.0.58_build1800240123.15 os_Ubuntu 22.04 Server.
Re: Report Builder Problems
Posted: Tue May 21, 2024 11:05 pm
by kev1n
Re: Report Builder Problems
Posted: Wed May 22, 2024 8:28 am
by ricklincs
Thanks Kev1n. I have downloaded and updated. When I click open now the table or sql opens. The address https://...../core/nureportdesigner.php?tt=TABLE:product&launch=nublank (Table) and https://......../core/nureportdesigner.php?tt=SQL:664cae28b234227&launch=nublank (sql) still gives a blank screen when I click report designer.
Re: Report Builder Problems
Posted: Wed May 22, 2024 9:03 am
by kev1n
Did you create the report again with FF after the update?
Also, if possible, show what's stored in the table zzzzsys_report, column sre_layout of that report
Re: Report Builder Problems
Posted: Wed May 22, 2024 9:10 am
by ricklincs
I have now 2 reports. FR5 which I imported from a working install of nubuilder
FR5.png
This runs when I click Report Designer.
I ran Fast Reports and created the same report as FR5 and called it FR1
FR1.png
This does not run if I click Report Designer.
Re: Report Builder Problems
Posted: Wed May 22, 2024 9:13 am
by ricklincs
This is the zzzzsys_report contents
zzzzsysreport.png
Thanks, Also I did run the update before I ran Fast Reports.
Re: Report Builder Problems
Posted: Wed May 22, 2024 9:40 am
by kev1n
Please run this SQL, then create the FF again:
Code: Select all
REPLACE INTO `zzzzsys_form` (`zzzzsys_form_id`, `sfo_type`, `sfo_code`, `sfo_description`, `sfo_group`, `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`, `sfo_style`, `sfo_mobile_view`, `sfo_json`) VALUES ('nufrlaunch', 'launch', 'nufrlaunch', 'Fast Report', NULL, NULL, '', '', '', '0', '0', '0', NULL, '', '$(\'#wrdaddable\').css({\'font-size\' : \'14px\', \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\r\n$(\'#frwrd\').css({\'font-size\' : \'14px\', \'font-weight\' : 700, \'padding\' : 5}).addClass(\'nuTabHolder\');\r\n$(\'#nufr\').css({\'text-align\' : \'left\', \'height\' : 410, \'background-color\': \'#ebebeb\'});\r\n\r\n$(\'#list\').addClass(\'nuScroll\').removeClass(\'nuReadonly\');\r\n\r\n$(\'.nuActionButton\').hide();\r\nnuAddActionButton(\'nuRunPHPHidden\', \'Build Fast Report\', \'nuRunPHPHidden(\"RUNFR\", true)\');\r\n\r\n\r\nfunction nuAddReportField(t){\r\n\r\n var f = nuPad3($(\"[data-nu-label=\'Field Name\']\").length - 1);\r\n\r\n $(\'#fast_report_sf\' + f + \'field\').val($(t).html()).change();\r\n $(\'#fast_report_sf\' + f + \'width\').val(100).change();\r\n $(\'#fast_report_sf\' + f + \'sum\').val(\'no\').change();\r\n $(\'#fast_report_sf\' + f + \'title\').val($(t).html()).change().trigger( \"select\" );\r\n \r\n}\r\n\r\n\r\nfunction nuBeforeSave(){\r\n \r\n if($(\'#table\').val() === \'\'){\r\n \r\n nuMessage([\'<b>Table Data</b>\', nuTranslate(\'Cannot be left blank...\')])\r\n return false;\r\n \r\n }\r\n \r\n \r\n if($(\'#orderby\').val() === \'\'){\r\n \r\n nuMessage([\'<b>Order By</b>\', nuTranslate(\'Cannot be left blank...\')])\r\n return false;\r\n \r\n }\r\n \r\n nuBuildFastReport();\r\n \r\n return true;\r\n \r\n}\r\n\r\n\r\nfunction nuFRSetData() {\r\n\r\nif($(\'#fieldlist\').val() !== \'\'){\r\n \r\n var s = String($(\'#fieldlist\').val());\r\n var ds = s.replaceAll(\'[\',\'\').replaceAll(\']\',\'\').replaceAll(\'\\\\\',\'\').replaceAll(\'\"\',\'\');\r\n var fl = ds.split(\',\');\r\n var fu = [];\r\n \r\n $(\'#orderby\').find(\'option\').remove();\r\n\r\n for(var i = 0 ; i < fl.length ; i++){\r\n \r\n if(fl[i] != \'KEEP EXACT HEIGHT\'){\r\n \r\n fu[i] = \'<tr><td><div style=\"overflow:hidden;width:285px;text-align:left;padding:2px\" onclick=\"nuAddReportField(this);\" class=\"nuCalculatorButton nu_input\">\' + fl[i] + \'</div></td></tr>\';\r\n \r\n $(\'#orderby\').append(\'<option value=\"\' + fl[i] + \'\">\' + fl[i] + \'</option>\');\r\n \r\n }\r\n \r\n }\r\n\r\n $(\'#nufr\').html(\'<table>\' + fu.join(\'\') + \'</table>\');\r\n \r\n}\r\n\r\n$(\'#orderby\').val(fl[0]);\r\n\r\n}', NULL, NULL, NULL, NULL, NULL)
Re: Report Builder Problems
Posted: Wed May 22, 2024 9:56 am
by ricklincs
Thanks Kev1n, that seems to be all working fine now. Just for future reference what had I messed up?
Re: Report Builder Problems
Posted: Wed May 22, 2024 10:01 am
by kev1n
There was an issue so that the necessary hash cookies were not saved in the DB table. However, this was already solved a few days ago in the development version but it did not find its way into the Github repository.