error

Talend Open Studio + JRE Error

I’ve just installed TOS 8 on my Windows 10 machine, and after trying to execute it an error appears (I wonder if some day a program running Java not bundled will work at first after being installed):

After installing the latest JDK version, it always throughs the same error.

No matter the times you install/uninstall JDKs, change environment variables, try to launch an inexistent Java Control Panel: always the same error.

The solution

Go to Start Button in Windows
Locate the TOS Menu
Open TOS Menu and right-click on icon launcher
Click on More
Click on Open File Location
Right-Click the Link File and click on Properties
Change the Destination folder to the one containing your Java binaries

HeidiSQL CREATE FUNCTION errors

No matter how simple you define your function, its creation will fail when using HeidiSQL interface.

CREATE FUNCTION `fn_my_function`(
    `parameter_a` INT
)
RETURNS INT
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
   return 0; 
END

After reviewing your code, you can’t find any syntax error. You try to fix it by removing the COMMENT ” line, but nothing seems to work.

The solution is quite simple:

Tell the SQL engine a new DELIMITER:
- DELIMITER //
After the END; line, add another one to restore the DELIMITER to ;
- DELIMITER ;
That’s all

DELIMITER //

CREATE FUNCTION `fn_my_function`(
    `parameter_a` INT
)
RETURNS INT
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
   return 0; 
END

DELIMITER ;

Please note that there is a space separator between DELIMITER and ;

Laravel 8 + Socialite + Google Login = Error with no message

After struggling for three hours, and making a useless bunch of changes in my code and server configuration, I finally found the solution to this:

When you finish your coding, and test it in your localhost deployment, you can login using Google and there’s no problem in getting all the user profile information.
Then you deploy the application in your cloud server environment and a “no message” error appears and doesn’t allow you to log into your application.
Laravel Socialite Google Login Error with No Message