Catatan

SQL Update with INNER JOIN

  Example query: update [signalling].[dbo].[Lokasi] SET eventLocation = s.qEventLocation  FROM [signalling].[dbo].[Lokasi] AS l  INNER JOIN [syncdb].[dbo].[stations] AS s ON s.stationname = l.station;

Encryption and Decryption in C#

References:  Encryption and Decryption in C#  - https://sankhadip.medium.com/encryption-and-decryption-in-c-f2de3d802e1d#:~:text=The%20Advanced%20Encryption%20Standard%2C%20or,to%20encrypt%20and%20decrypt%20messages. Encryption And Decryption Using A Symmetric Key In C# - https://www.c-sharpcorner.com/article/encryption-and-decryption-using-a-symmetric-key-in-c-sharp/ Public Key Encryption - https://www.tutorialspoint.com/cryptography/public_key_encryption.htm

LARAVEL 9

  How to Install Bootstrap in Laravel 9? https://medium.com/@laraveltuts/how-to-install-bootstrap-in-laravel-9-ef36be699bb6 How to Install Bootstrap 5 in Laravel 9 With Vite https://techvblogs.com/blog/how-to-install-bootstrap-5-in-laravel-9-with-vite Laravel Database Migration https://laravel.com/docs/9.x/authentication#starter-kits Laravel Authentication https://laravel.com/docs/9.x/authentication#starter-kits

Cannot connect WiFi. Network card fully utilized.

Imej
The problem: The machine denies connecting with WiFi. The Solution: Reset the log and disconnect the network using step as below; 1. Type netstat -a to check the network loopback. 2. Stop any application that uses the network card such as Apache XAMPP, IIS Server, MSSQL, or MySQL. Also, need to stop any services that used the network activity such as ping, and connect to the server. *Note: loopback can be monitored through Wireframe. *Note: If the machine has installed Docker Desktop, we need to stop the services. 3. Open a command prompt and type ipconfig /release to clear the established connection. 4. Type ipconfig /renew to renew the connection. 5. Okay done.

Eclipse - "Incompatible JVM. Version 1.8.0_261 of the JVM is not suitable for this product. Version: 11 or greater is required"

Imej
Error: Eclipse - "Incompatible JVM. Version 1.8.0_261 of the JVM is not suitable for this product. Version: 11 or greater is required" Solution:  https://stackoverflow.com/a/72326988/10763264 Step - 1 Go to the file location of the eclipse and open  eclipse.ini  in editable format Step - 2 Go to the java folder location where you find javaw.exe In my case :  C:\Program Files\Java\jdk-11.0.11\bin\javaw.exe Step - 3 Then paste the following before tag  -vmargs  inside  eclipse.ini  file -vm C:\Program Files\Java\jdk- 11.0 .11 \bin\javaw.exe The below image shows in brief

Error : mysql xampp Can't create IP socket: No such host is known.

Imej
Error :  Solution 1: Edit phpmyadmin config.inc.php File dir : C:\xampp2\phpMyAdmin\config.inc.php $cfg['Servers'][$i]['host'] = '127.0.0.1' Solution 2: Check windows host  File dir : C:\Windows\System32\drivers\etc\hosts

Response.redirect raises "Thread was being aborted"

Imej
The Problem: The redirect code shows runtime error "Thread was being aborted" Solution : Response.redirect raises "Thread was being aborted" - https://stackoverflow.com/a/4874895/10763264 HttpResponse.Redirect Method