About ScriptCase RAD

Scriptcase Rapid Application Development:
Non-journalistic written documentation (responsibility on scriptcase.net):
https://en.wikipedia.org/wiki/Scriptcase
The servers of supplier Netmake are not state-of-the-art:
https://en.internet.nl/site/scriptcase.net
https://en.internet.nl/mail/scriptcase.net
https://en.internet.nl/site/scriptcase.host
https://en.internet.nl/mail/scriptcase.host
long-standing hosting:
https://en.internet.nl/site/hoo.st
https://en.internet.nl/mail/hoo.st

About deployment:

Analyze an installation failure:
https://example.com/scriptcase94/diagnosis.php

In case a start fails:
Try a switch of file name in https://example.com/scriptcase94 between config.php and config_.php

Guarantee file properties (-R for recursive and to change to your details):
During the first login
$ find /home/admin/domains/dev.hostfusion.nl/public_html/scriptcase/ -type d -exec chmod 755 {} \;
$ find /home/admin/domains/dev.hostfusion.nl/public_html/scriptcase/ -type f -exec chmod 744 {} \;
$ chown root:root ixed.8.1.lin
$ chown -R yourusername:yourownergroup scriptcase
if you do not prepare php.ini is properly, the application cannot work.

In case of many labels, max_input_vars must be high in PHP in order to save them:
max_input_vars = 10000 and maintain many other settings in php.ini.
Note: This max_input_vars is also an important setting in PHP 8.3 in DirectAdmIn to see databases in case of many imported databases.

Before import of bigger databases:
execute SQL statement: set global max_allowed_packet=104857600

Operational environment (control panel DirectAdmin):
After extraction of a zip file:
$ find /home/yourusername/domains/example.com/public_html/folder/ -type d -exec chmod 755 {} \;
$ find /home/yourusername/domains/example.com/public_html/folder/ -type f -exec chmod 744 {} \;
Note: For PDF the file _lib/prod/third/wkhtmltopdf/linux-amd64/wkhtmltopdf-amd64 requires 744.

How to deploy a new application?
When implementing a new application, the second libraries / labels form field must be checked to write the url in … / _ lib / friendly_url /. Otherwise, the security settings sync cannot find a new application.

Workaround for Scriptcase database connections:
With the ‘Linux64 choice’, I think, a database connection having SSL enabled, blocks. Before any ‘engine’ update, make sure that SSL is disabled, or delete and create a connection again. An outdated password stored in the web browser does disturb lookup. Clearing the password first, helps to look up databases properly, instead of endless loading by HTML. If loading does not work, save with the first database and switch over afterwards. You can maintain UTF8 under ‘Advanced’.

Workaround for a global variable:
Do not use eg [InvoicingYear] but use [invoicing_year]; having capital letters, values are lost.
In OnValidate in your Login application eg:
$invoicing_year = date(“Y”);
sc_set_global($invoicing_year);

Workaround for losing a minus sign when leaving a field:
AJAX event:
{ReceiptAmount} = -999.99;
{ReceiptAmount} = AdjustAmount();

Communicate analysis:
bugs@scriptcase.net
suggestion@scriptcase.net

Example of code:
PHP code in Scriptcase

PHP (Hypertext Preprocessor) related:
– A new (sub) version of PHP 7.3 / 7.4 requires improved code and good testing;
– A stable release of encoder ionCube for PHP 7.4 was from July 13, 2020 after delivery of PHP 7.4 on Nov 28, 2019;
– Scriptcase can use a fix for multi-byte in standard tcpdf in order to work with PHP 7.4;
– Scriptcase needs a technical way for the Java replacing component for PDF; OpenSSL 1.1 needs another version;
– Using IPv6, there are minor bugs; eg the logging table needs for an IP-address 45 characters instead of 32.

SSLVersion for TLS:
From PHP 7.2 outbound email is streamed with the highest possible SSLVersion for TLS.
Up to and including PHP 7.1, Scriptcase lacks an important solution from July 2018 in Swift Mailer, located in /prod/third/swift/classes/Swift/Transport/StreamBuffer.php, that allows TLS 1.1 and TLS 1.2: STREAM_CRYPTO_METHOD_TLSv1_0_CLIENT | STREAM_CRYPTO_METHOD_TLSv1_1_CLIENT | STREAM_CRYPTO_METHOD_TLSv1_2_CLIENT.

F12 in web browsers:
Supplier Netmake really pays attention to constantly new notifications in web browsers.

HTML (Hypertext Markup Language):
Supplier Netmake wants to work seriously on good HTML code, although many shortcomings exist.