mysql changed format for Timestamp

As you can see on the Mysql Homepage they changed the Format for Timestamp:

From MySQL 4.1.0 on, TIMESTAMP display format differs from that of earlier MySQL releases:

• TIMESTAMP columns are displayed in the same format as DATETIME columns. In other words, the display width is fixed at 19 characters, and the format is YYYY-MM-DD HH:MM:SS.

• Display widths (used as described in the preceding section) are no longer supported. In other words, for declarations such as TIMESTAMP(2), TIMESTAMP(4), and so on, the display width is ignored.

Of course i searched some time for an error in my code.. ;-(

Windows XP 64

Since my Raid Array Failed and my Windows Installation just died, i had to reinstall my PC ... and becouse i have a Athlon 64 i decided to install Windows XP 64...

First some word about the Windows Recovery Console... my old Windows XP (normal) CD does not have an option to start the Console.. the XP 64 CD showed it.. that's a good start.
The Problem with the damn thing is: You can not change anything on other Directories than in the Windows Directory...
So if you wish to backup some very important File from your My Documents Directory, which concidential happen to be, you get a "Access Denied" Message ... WHAT THE %&$*%!!! How am i suppose to backup any files so i can reinstall Windows?

The Answer: You have to get into regedit and change it there... well without windows (which still was not able to start, what a coincidence) there is no possible way.... good work microsoft... really ;-(

Finally i found a Bootdisk for Dos, with a driver which is able to read ntfs partitions, and copied the files by hand (and with Norton Commander 5.0... still great tool)

Then i installed the new Windows without formating the harddisk, which i would have done if i could backup the files in the Recovery Console... the Problem.. dos is only able to work with Filenames which have a length of 8....

Ok, i installed the OS, i downloaded the newest drivers for my mainboard an graphic card (which were still Beta) and voila i had windows installed..

After some Windows Updates the next part for me is installing Antivirus Software.. and well look at that, Symantec is currently not having Antivirus Software for noncomercial People for Windows XP 64.. ok, what now? I mean what the hell should i do without an Antivirus Software? My first ideas of reinstalling the old windows were coming... but i finally installed the Freeware Antivirus Software from Avast.

I do not know if the Software is good or not, but if i find anything out i will probably write it down.

My Mouse (a razer diamondbback) is still not working with the razer drivers.. becouse i could not find any razer drivers for windows xp 64... they are still developing those and tuneup is also not working...

So it may be that XP 64 has some advantages, but you will definetly have problems installing your drivers and applications to it...

Raid? What for?

A couple of months ago i had a terrible Harddisk crash and lost all my data. Therefore i buyed 2 SATA Discs and build a RAID Array for more protection.

Yesterday i thought it is about time to make a Backup (which means burining all sensitive Data on CD)....

As i went home and started the computer my Raid Controller said good Evening and i have a critical Error in the Array.... WHAT THE *%/§)%"!!!

I mean 3 months and already problems is not a good way is it? I am now triing to save as much as i can, but why had i build the damn array if it fails so soon?

Fable incompatable to WindowBlinds

I just got Fable and wanted to play it... but as soon as it starts it crashes...
Then i tried multiple things until i found out: it has a Problem with windowblinds...

You have to thing about it: A microsoft programmed game does not work on a microsoft operating system with an in coporate with microsoft prgrammed styling tool....

Damn microsoft, another reason they don't know what they are doing!

Fortunately you can unload windowBlinds any Time and play fable...

As for Fable: The Intro is nice.. but has no real Story.. and What the hell with that BIG microsoft logo?? If the Title of the Game is that Big ok, but for microsoft?

I know. . it already says in Fable narcism is perfectly normal.. seems like microsoft thought of themselves...

DbDesigner Problems with MySQL

When working with Databases i use DbDesigner, since it is a free tool and is working great although they have stopped working on it a long time ago. The whole development team is working for MySQL now and are working on MySQL Workbench, but there is only an alpha yet.

So the only open source solution is still DbDesigner..
A couple of days ago i come up with a big problem .. DbDesigner on my PC was not able to connect to my Servers Database... i was looking over an over again and found the Problem...

Since i am using Debian, my MySQL Version was updatet a couple of times now and now there is a new adjustment in the my.cnf File called bind-address.

If you use:
bind-address 127.0.0.1
only the localhost can access the database. Since i am using a Server behind a FireWall and only for development purpose i just had to disable the Line and now everything is working again.

Thanx for this tipp to a good friend of mine ;-)