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):
$ chmod -R 755 scriptcase98 (if necessary chmod -R 777 scriptcase98)
$ chown -R yourusername:yourownergroup scriptcase98

In case of many labels, max_input_vars must be high in PHP in order to save them:
memory_limit = 512M
max_execution_time = 3600
max_input_time = 3600
post_max_size = 256M
upload_max_filesize = 256M
additional settings as in control panel Plesk:
max_input_vars = 10000
max_file_uploads = 50

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.