Report Builder Problems

[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.

[kev1n]

Ĥi,

Try https://github.com/nuBuilder/nuBuilder- ... master.zip

And create the fast report again.

[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.

[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

[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.

[ricklincs]

This is the zzzzsys_report contents

zzzzsysreport.png

Thanks, Also I did run the update before I ran Fast Reports.

[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)

[ricklincs]

Thanks Kev1n, that seems to be all working fine now. Just for future reference what had I messed up?

[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.