DBeaver 4.0.8 Cannot insert new record in an empty table.

Note: This issue has been fixed in DBeaver 4.1 :)\




I've been using DBeaver for a while to work on some Postgres databases (because PgAdmin 4 sucks!) and I found this tool to be really awesome so far. However, as we know, not everything is perfect, and I found a little bug in DBeaver which is, that you cannot add a new record by clicking on the small plus (+) sign on the grid view. This is not working only on new / empty tables. If the table has at least one record, this works.

However, you are not left alone helpless in this case. There's a small workaround to overcome the issue. This is how to insert data into a new empty table without writing a sql query.

All you have to do it press and hold the "Shift" key while cliking on that green plus sign. Then DBeaver will add a new row as usual :) That's simple, isn't it?

I hope this will be useful to someone. Please don't forget to leave a comment if you know any other work around to this :)

Solve Ubuntu Error mounting windows partition status 14: The disk contains an unclean file system

Hello guys, here is another issue I faced today with Ubuntu 16.04. I have a laptop which runs Windows 10 and Ubuntu 16.04 on dual boot. Sometimes I have to switch between the two systems depending on the project I work. So it's very usual that I switch between them a few times in some days.

If you do the same, you may have already got this error, or at some point you will get this error when you try to mount a partition that you use with Windows and Ubuntu both. I'll show you how to fix this easily.

Error Details:

Error mounting /dev/sda2 at /media/nimeshka/6E86FACC86FA93B5: Command-line `mount -t "ntfs" -o "uhelper=udisks2,nodev,nosuid,uid=1000,gid=1000" "/dev/sda2" "/media/nimeshka/6E86FACC86FA93B5"' exited with non-zero exit status 14: The disk contains an unclean file system (0, 0).
Metadata kept in Windows cache, refused to mount.
Failed to mount '/dev/sda2': Operation not permitted
The NTFS partition is in an unsafe state. Please resume and shutdown
Windows fully (no hibernation or fast restarting), or mount the volume
read-only with the 'ro' mount option.

You get this error and you are unable to mount the partition. However, Ubuntu lets you mount the partition in a read-only mode which may be enough sometimes, but it's not a real solution to this. Before diving into fixing the problem, let's look closely at the error message once again. If you read it carefully, you will see that Ubuntu reports the error in a clear and a concise way. Towards the end of the error message, you can see it states "Please resume and shutdown Windows fully (no hibernation or fast restarting)". That basically gives you a hint on the solution. It says that Windows has not been fully shutdown, hence Ubuntu is unable to mount it. So the problem is really in Windows, not in Ubuntu.

You may wonder that you didn't hibernate Windows, then how could this happen? Yeah, it happens because with recent versions of Windows, they have introduced some new features to speed up the booting process, known as "Fast Startup" in Windows 10 and "Fast Boot" in Windows 8. It's something very similar to (or almost same as) hibernate option you had with previous Windows versions.

To fix this problem, you need to login back to your Windows OS and shutdown it properly. To do that, please follow these steps.
  1. open a command prompt with administration privileges. (To open command prompt with admin privileges, right click command prompt in the start menu and choose "Run as administrator" option).
  2.  Run the following command:
  1.  shutdown /s 
  1. Now login back to Ubuntu to see that you can mount your drives back :)
 
That's it guys. I hope this wll help you. Please share this with your friends in G+, Facebook and Twitter if you think this will be helpful to them as well! Also leave a comment to give any feedback.

GIT: Display modified files in the last 'n' commits.



It's a very common thing that a developer usually commits his / her work multiple times in a day. You make changes in your branch, commit them locally, and sometimes at the end of the day, you push them to the remote repository. If you want to see the changes in your last commit, you simply run the command:

git show

But what if you only want to see the names of the files which were changed? Okay, you run the same command with the --name-only parameter. i.e.

git show --name-only

Then what if you want to see all the files which were changed today? If you have made 3 commits today, then you can run the following command to view all the files which got affected across all your commits. To do this, you have to pass the -n parameter with the number of commits you want to view.

git show -n 3 --name-only

Okay, here's another useful tip. What if you want to see the files changed in a particular commit? For that, you only have to pass the commit id.

 git show --name-only 4adf9baa857c885g5a40518ccec68961ae08cc69
And, what if you want to see the files changed in another commit along with these? To do that, again you have to pass the other commit id, as shown below.

git show --name-only 4adf9baa857c885g5a40518ccec68961ae08cc69 7bdf8bac852c865f4a40518cbec689613e07c269


That's it. I hope this will be helpful to someone :) Please don't forget to leave a comment if you know a better way or if this really helped you. You can also share this with your friends in Google+, Facebook and Twitter!

Fix HTTP Error 500 php-cgi.exe - The FastCGI process exited unexpectedly


Today I had to install IIS in my dev laptop to do some bug fixes in an old web application written with PHP 5.5. I enabled the FastCGI module in IIS and loaded the web page in the browser. But it didn't work and it kept giving me this error. It didn't explicitly mention what caused the error. So it was a bit difficult for me to find a solution to this. However finally I found a fix to this and thought I should share it in my blog so it will help someone in the future (of course, only if you had to setup IIS to work with PHP). I used PHP 5.5.3.

This is the error I received:

HTTP Error 500.0 - Internal Server Error

php-cgi.exe - The FastCGI process exited unexpectedly


Detailed Error Information
Module FastCgiModule
Notification ExecuteRequestHandler
Handler PHP
Error Code 0xc0000135 


If you get this error, the first thing you need to check is whether you have the right Visual C++ runtime package installed in your PC. If not, download and install it right away. It will surely fix your issue :)

As a help I will link to the Visual C++ package that helped me (This worked with PHP 5.5.3). If it doesn't help you, I guess you need to find the right version to download. I'll add some more links here so you can find and download it from the Microsoft website.

If you have PHP 5.5.x, Microsoft Visual C++ Redistributable 2012 package is what you need to install. Here is the link to that ->

Here is a list of other Visual C++ packages with download links from Microsoft. Make sure to download the file that suits your system architecture (32 bit / 64 bit). With 5.5, you have to download the x86 version anyway because PHP is running on 32 bit, not 64. :)

Microsoft Visual C++ Redistributable 2015

https://download.microsoft.com/download/9/3/F/93FCF1E7-E6A4-478B-96E7-D4B285925B00/vc_redist.x86.exe

https://download.microsoft.com/download/9/3/F/93FCF1E7-E6A4-478B-96E7-D4B285925B00/vc_redist.x64.exe

Microsoft Visual C++ Redistributable 2013
http://download.microsoft.com/download/2/E/6/2E61CFA4-993B-4DD4-91DA-3737CD5CD6E3/vcredist_x86.exe

http://download.microsoft.com/download/2/E/6/2E61CFA4-993B-4DD4-91DA-3737CD5CD6E3/vcredist_x64.exe

http://download.microsoft.com/download/2/E/6/2E61CFA4-993B-4DD4-91DA-3737CD5CD6E3/vcredist_arm.exe

Microsoft Visual C++ Redistributable 2012
http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU3/vcredist_x86.exe

http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU3/vcredist_x64.exe

http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU3/vcredist_arm.exe


Microsoft Visual C++ Redistributable 2010
http://download.microsoft.com/download/5/B/C/5BC5DBB3-652D-4DCE-B14A-475AB85EEF6E/vcredist_x86.exe

http://download.microsoft.com/download/3/2/2/3224B87F-CFA0-4E70-BDA3-3DE650EFEBA5/vcredist_x64.exe


Microsoft Visual C++ Redistributable 2008
http://download.microsoft.com/download/1/1/1/1116b75a-9ec3-481a-a3c8-1777b5381140/vcredist_x86.exe

http://download.microsoft.com/download/d/2/4/d242c3fb-da5a-4542-ad66-f9661d0a8d19/vcredist_x64.exe


Microsoft Visual C++ Redistributable 2005

http://download.microsoft.com/download/d/3/4/d342efa6-3266-4157-a2ec-5174867be706/vcredist_x86.exe

http://download.microsoft.com/download/9/1/4/914851c6-9141-443b-bdb4-8bad3a57bea9/vcredist_x64.exe

Please do not forget to share this post with your friends in Facebook, Google+ or Twitter if you think this will be helpful to someone :) You can also leave a comment if you have any problems.

How to connect LAN in VirtualBox Ubuntu





It's 2017 and I haven't written anything in my blog this year. That's amazing. The main reason why I was away from the blog was because I was trying YouTube videos instead of blog posts and it seems they are working really well. You can find my YouTube channel here. Please feel free to subscribe and keep in touch with my new updates.

Anyway I feel I should update the blog constantly, so today I share something I learnt recently. How to connect to LAN in Virtualbox in Ubuntu? Yesterday I was trying to access a shared drive in my Local area network and I found that it's really difficult to access them using my Ubuntu PC even with Samba. I wasn't sure why I couldn't access the shared drive, it was probably due to some password issues. So I tried an alternative way to do that. I have a Windows installation running inside my Ubuntu PC using Virtualbox and I thought it would be great if I can access the network through my Virtual PC.

But I learnt that by default, when you open your VirtualBox guest OS, you are not connected to your Local area network. Instead, it only shows your host PC, and a common drive between the Host and the virtual machine. To access the LAN, you have to change a few settings and this is how to do it in a step by step way.


  1.  First off, you have to shut down your virtual pc in Virtualbox. 
  2.  Then right click on the Virtual machine you want to connect, and select "Settings".
  3.  In the settings window, go to Network section and click on the "Adaptar 1" tab.
  4.  Now you should see that "Enable Network Adapter" option is checked. If not, check that box as shown in the image. 
  5.  Then from the "Attached to" dropdown list, select "Bridged Adapter".
  6.  From the "Name" dropdown menu, select "eth0" or the network adapter you want to connect.
  7. Click the OK button and start your VM.
  8. Now you should be able to see your LAN computers :)

Image related to Step 03.

How to connect LAN in VirtualBox in Ubuntu


That's it friends. I have made a video explaining how to do this. If these steps aren't clear to you, please check this video.




How to connect LAN in VirtualBox Ubuntu



Be kind to share this with your friends in Facebook, Twitter or Google+ if you think this will be useful to them :) Also please feel free to leave a comment and let me know what you think.