A bug @ www.hot.ee

February 27, 2007

I cleaned out my email account on http://www.hot.ee today and encountered a very interesting bug. Well, see for yourself:Hot.ee on fire

Nice, eh? Lugemata (unread): 0 + 7 + 0 + 0 = 577! Nice math. Love it.

Maht (size): 36 + 312 + 0 + 241 + 0 = 10608Kb! Wow! Now I can’t sleep at night.

Advertisements

MySQL Connector/Net 1.0.8 & 5.0.3

February 27, 2007

Ok, so here I am working with MySQL Connector/NET. I have the latest version of it (1.0.8). Everything worked properly in 1.0.7, so I thought that the updated version should work properly too. Well, no, actually. I don’t know what are the devs thinking, but I am outraged.

The problem is that I download a mysql dump file and after that using MySQL Connector update the local database. You think it is easy, right? Well, that’s what I thought in the first place, but turns out that it just doesn’t work.If you know C# & .NET then you know that dumps should be inserted with ExecuteNonQuery() function. Ok, sounds easy, right? Worng, all the time this crappy driver threw an exception saying “Query was empty”. Wtf? I even created a breakpoint and inserted an MessageBox.Show(command.CommandText). The query was there. I spent hours on searching the internet about this bug (or feature?). I found one bug report saying, that carriage returns were causing this and that it was fixed in 1.0.7. Screw that, this bug IS PRESENT in 1.0.8 AND 5.0.3. How do I know? Well, because I replaced all returns with spaces and it worked out perfectly! Now why the fuck I should wark around bugs, that were already fixed?? Oh, oh, and by the way – I can not post a bug report either, because on the mysql bug reporting page it says, that “cannot connect to MySQL”. That is freaking awesome – mysql’s bug reporting tool is not working because their mysql is down! In-fucking-credible!!

So, for all you guys in the same situation – you MUST remove all carriage returns in your queried before doing an ExecuteNonQuery()! Otherwise you WILL get an exception.

And for MySQL Connector/NET devs – do something about it ASAP. And by the way – this bug is also present in MySQL Connector/NET 5.0.3 (not only in 1.0.8).


The best linux FTP client: FileZilla

February 12, 2007

Hello, today I want to tell you about my search for a nice FTP client. First things first – I’ve been using gFTP for a long time and I find it to be nice, but to say the truth it lacks some features and is quite buggy. There is no recursive chmod, it crashes every time when internet stops working (this is important, since I use WiFi all the time), it waits 30 seconds if he got disconnected from server (and I haven’t found a way to stop this except restarting gFTP). That is not all, but I think that you get the point 🙂

And this is the best FTP client I knew for my Ubuntu Edgy until now. Today I found out that the FileZilla FTP client is being made cross-platform. I use that one all the time in Windows and let me put it short – “IT ROCKS!!!”. No, really, it has a very nice site manager, it does not crash (not once since I installed it on Windows and I’ll need some time to see how it goes under linux), has a great user interface, transfer queue and so on. Also it allows you to install themes (icons for buttons) ^_^

Overall, I find FileZilla to be the best choise for Linux. It is still in beta, but it is A LOT more stable that gFTP. So, if you have Ubuntu Edgy installed and you’re wiling to try it out – “apt-get install filezilla”! Don’t know about others, but Edgy repositories have it.

And in the end I’ll post an overview and features from FileZilla official site:

Overview

FileZilla is a fast and reliable FTP client for windows with lots of useful features and an intuitive interface.

Features

Among others, the features of FileZilla include the following:

  • Easy to use
  • Multilingual (English, German, French, Japanese, just to name a few)
  • Strong encryption support using SFTP over SSH and FTP over SSL/TLS
  • Supports transfer resuming and files larger than 4 GiB
  • Site Manager
  • Queue support
  • Proxy support
  • Speed limits
  • MODE Z transfer compressing
  • … and more!