Skip to main content

MYSQL ERROR

Mysql exception:dbname.ISNULL function does not exist. This error actually srewed me a lot. I did lot of google but the search result were not help full. I manage to solve this error. Below is my findings that may helpfull. I have store procedure where I used ISNULL very often and even other procedures. But only one procedure was showing this Error. For this first check in procedure if there is "Enter" immediate after ISNULL then remove it. If function is used in the procedure check the same in function too. This will resolve the issue :)
Labels:

Comments

Post a Comment

Popular posts from this blog

You are here because of HDMI audio output problem. This is what worked for me.  Tried most suggestion on web: To make disabled visible under playback, scan hardware changes, update and also uninstall audio drivers. I had issue with nothing visible under "Playback" related to HDMI. Here is what I did: In device manager checked if any related device is disabled and enabled it.  This resolved the issue and my TV is visible in output device. Hope this helps.
Post a Comment
Read more

Move all files except one or few in linux

Moving all files Except one or few.  You may come to situation where you have to move file from current folder to some where else. But you also don't want to move all files.  Here is how you can do it. $ mv $(ls | grep -v exceptfile.any) ~/destinationfolder/ for Multiple files: $ mv $(ls | grep -v 'exceptfile.any\|exceptfile2.any') ~/destinationfolder/ There could be case your destination folder is current directory. As you will encounter error: mv: cannot move 'destinationfolder' to a subdirectory of itself, 'destinationfolder/destinationfolder' For this you add the destinationfolder in grep parameter as well: $ mv $(ls | grep -v 'exceptfile.any\|exceptfile2.any\|destinationfolder') ~/destinationfolder/ This will work. But incase re-run this command you like to hit output: mv: missing destination file operand after 'developer_survey_2020' Try 'mv --help' for more information. The above out can be overlooked as its correct since there...
Post a Comment
Read more

Visual Studio Code remote development SSH error in windows

  VISUAL CODE remote development. Configuring remote development extension:  Refer:  Remote development over SSH The steps are straight forward but for error like:  "Could not establish connection to "host alias name": The process tried to write to a nonexistent pipe." "Load key "key.pem": Permission denied ubuntu@hostname: Permission denied (publickey)." VSCODE uses CMD for executing SSH commands.  The command it uses are: ssh -T -D 53592 -F "C:\Users\<username>\.ssh\config" "host alias name" bash                                  OR "C:\Program Files\Git\usr\bin\ssh.exe" -T -D 53745 -F "C:\Users\<username>\.ssh\config" "host alias name" bash ( if you set remote.ssh path in extension settings) under the hood it executes:  ssh ubuntu@ec2-host.compute.amazonaws.com -i "path_to_key.pem" Surprisingly the SSH connection will work via git-bash and putty.  Here th...
Post a Comment
Read more