[FIXED] Error after updating to Version 9.4.025

Scriptcase 9 General
#1

After updating to Version 9.4.025, there is a problem I am experiencing on Dashboard applications INDEX widgets; and on hitting SUMMARY button on CHARTS applications - charts rendering fine. Other apps seem to be working without throwing up any issues so far. May be its my installation (macOS Catalina 10.15.4), but wanted to check if anyone else experience similar issues? Grateful for any advice or workarounds. Many thanks!

Error message on Index Widget:
Notice: Undefined property: dashboard_ini::$force_db_utf8 in /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/test_project/dashboard/index.php on line 646
Notice: Undefined property: dashboard_ini::$force_db_utf8 in /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/test_project/dashboard/index.php on line 882

Example error on Summary Grid from Chart:
Fatal error: Uncaught Error: Using $this when not in object context in /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/uasb_io_cod_resumo_sc_free_group_by.class.php:3383 Stack trace: #0 /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/index.php(4515): uasb_io_cod_resumo::formatValue(1, 2523) #1 /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/index.php(4496): uasb_io_cod_apl->outputCombinationTableRow(Array, 0, ‘comb_table_def’) #2 /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/index.php(3819): uasb_io_cod_apl->outputCombinationTable() #3 /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/index.php(6640): uasb_io_cod_apl->controle() #4 {main} thrown in /Applications/Scriptcase/v9-php73/wwwroot/scriptcase/app/SM/uasb_io_cod/uasb_io_cod_resumo_sc_free_group_by.class.php on line 3383
wWWWtEfficiency (%)CODe (mg/l)46883

#2

I am having the same issue on index widgets. I am on a Windows server, so it is not your OS that is the issue.

I also noticed that a summary was broken but I didn’t catch the error. I assume it is also the same issue.

Also on 9.4.025.

Notice: Undefined property: dashboard_ini::$force_db_utf8 in E:\scriptcase\wwwroot\scriptcase\app\ProjectName\ApplicationName\index.php on line 657 Notice: Undefined property: dashboard_ini::$force_db_utf8 in E:\scriptcase\wwwroot\scriptcase\app\ProjectName\ApplicationName\index.php on line 898

It looks like this is a new bug. I am going to open a chat with Scriptcase which they will hopefully see Monday morning.

#3

Thanks Alan, appreciate the feedback. I spoke with a couple others who were able to replicate the issue(s). Something appears to have broken during the upgrade - the latest changelog appears to point to specific changes made to the charts and summary functionality.

#4

I found an additional bug:

I just sent this back to Scriptcase’s help desk:

I have another related bug to report:

When using a Dashboard application, not only am I getting the errors at the top of the screen when using an Index widget, but if I turn on logging (log access event) then none of the applications in the Dashboard load.

If I only include a link widget with a chart then the dashboard loads successfully.

When there is an index widget and logging is turned on then the log insertion is happening but then the widgets never appear.

The Dashboard will work if I either turn off logging or remove the index widget. It is not sufficient to remove the “Access” event from the logged events, I have to remove the value from the Schema drop-down in the Log screen in order to make the Dashboard work when there is an index widget in the Dashboard.

#5

Scriptcase support can’t duplicate my latest observation, so if anyone is reading this an has the time to experiment (and has a project with a logging schema set up) can you try it in your environment?

Create a dashboard application.

Place an index widget in the application.

Turn on logging of access to the dashboard.

Run the application.

Does the widget load onto the screen?

If not, remove the logging schema from the ‘Log’ settings and re-run the application. Does the widget load?

My setup is Windows server and a MS SQL database connection.

I also just tested this in a completely separate environment that is Windows server, MS SQL database connection for application data, but MySQL for the logging connection. It has the same issue with trying to use logs and an index widget at the same time. I just get a blank page and the widgets don’t load. That environment is on SC 9.4.024

#6

I think they were able to duplicate the second issue in some database connection types and resolved it in 9.4.026 along with the error message at the top of the screen. However I now have a new issue… it looks like 9.4.026 blew out all the formatting on my index widgets. They are simple small black text on a white background. I had to go through a dashboard with six widgets and set each of the fonts, font sizes, and colors for each of the data types for each widget. I don’t know if this is related to the css theme I have selected or if this is a global issue. Can anyone else try to create a new index widget and see if it carries any default formatting?

#7

My widgets are doing OK after the update. I am using one of the default SC templates.

#8

Hello,

This problem has been fixed in the version 9.4.026. Please, update your Scriptcase.

Thank you!