Fixing no thumbnail generation in Shopware 6

written: 2 years ago category: Programming

While struggling with importing images into a Shopware database, I found the column media.media_type has to have a certain value, depending on the file extension. Without a value in it, bin/console media:generate-thumbnails won't generate a thumbnail for this image.

Moving a WD MyCloud harddisk into a pc

written: 3 years ago category: Programming

I just successfully moved the WD Red harddisk out of its chassis, into my Intel/Windows 10 tower. Altough that's not what WD recommends, and I'm sure I lost any warranty with it, it's good to know there is a way to do that. E.g. in case the network controller or the power connector is broken, or whatever.

So, here's how to do that

My new favorite undelete tool

written: 5 years ago category: Programming

Just found on heise.de when searching for a tool to recover deleted files from the SD card of my 14 years old daughter. She managed to delete exactly those photos which she intended to keep. Well, I had no copies of these anywhere, as they were only some days old yet. But then came PhotoRec and saved my life: The GUI is a bit special for most users but very ok if you feel familiar with shell windows. Quite conveniant. And most important - it recovered more files than Recuva.

Spielplatzfest 2017 am Dörper Berg

written: 6 years ago category: Kids

Auf den Spuren des Käsediebes

written: 6 years ago category: Kids

La Flute De Pan

written: 6 years ago category: Music

My favorite version of La Flûte De Pan by The Art of Noise with Trevor Horn, featuring the inspiring voice of Sally Bradshaw. Music for filling up lost energy.

1 comment(s)

Bens Lego-Disco-Party

written: 6 years ago category: Kids

Our first stop-motion video with Lego mini figures, spoken sound from Ben and the Lego Movie.

2 comment(s)

Den richtigen Hund finden

written: 7 years ago category: Zitate

Man bekommt nie den Hund den man möchte,
sondern den Hund den man braucht.

Cesar Millan

Claire de Lune

written: 7 years ago category: Music

From Claude Debussy, back in 1905

Wonderful...

Code signing for Open Source executable

written: 7 years ago category: Programming

I just hassled various hours with code signing, certificates, and terms I am not handling every day with. So, here's my working tutorial for signing an .exe file using signtool.exe from Microsoft...

7 comment(s)

Execute multiple queries in one mysql command line

written: 7 years ago category: Programming

On the command line, you may want to execute more than one SQL command at once. Most hints recommend a batch file to accomplish that, but that requires an additional file placed somewhere where you may forget it.

You can also fire several queries with the --execute parameter, separated by semicolon:

mysql -hlocalhost -uroot --execute"TRUNCATE dba.log_customer; TRUNCATE dba.log_quote; TRUNCATE dba.log_summary;"

...and the slightly shorter version:

mysql -hlocalhost -uroot -e"TRUNCATE dba.log_customer; TRUNCATE dba.log_quote; TRUNCATE dba.log_summary;"

2 comment(s)

Revealing "SKU does not exist in the Amazon.com catalog"

written: 7 years ago category: Programming

Got the following error with the SubmitFeed action in Amazon's Marketplace API:

This SKU does not exist in the Amazon.com catalog. Your inventory data was not processed.
For reasons why, and help fixing this, see https://sellercentral.amazon.de/gp/errorcode/13013

The reason is self-explanatory, the product's sku is not listed in the catalog. I sent 1000 products to the API, of which only 100 were activated. So I expected 900 errors, but got only 200!

So, what's going on? Took me a while to find out:

The sku does not exist error only seems to occur on products for which you send a quantity value greater 0. Products with a quantity of 0 do not trigger the error.

Hope that helps someone saving some time on debugging.

1 comment(s)

Millenium Falcon

written: 7 years ago category: Kids

Done... finally!

1 comment(s)

Zu leben...

written: 7 years ago category: Zitate

Zu leben hat seine Zeit, zu sterben hat seine Zeit.

Kurt Wallander / Henning Mankell (♰ Oktober 2015)

Our all future

written: 8 years ago category: Zitate

It will definitely be a question not only be a question of intelligence whether we mankind runs into its own destruction or not. That end won't be the back of beyond. Mankind won't live as long the universe will live, and even the universe won't live forever. So it's just a question of a period of time for mankind.

SSH client on freeSSHd extremely slow

written: 8 years ago category: Programming

If you are using the freeSSHd server and you're experiencing extremely slow connection startups, downloads and uploads from any SFTP client, it is likely that you just need to turn off IP resolving in logfiles. You can disable that in the tab "Logging" > "Resolve IP addresses into hostnames".

Or, by editing the freesshdservice.ini file:

[Logging]
LogResolveIP=0

1 comment(s)

Solving hard to find "XYZ is not a constructor" JavaScript errors in Magento

written: 8 years ago category: Programming

It took me quite a few hours to find the cause of various mysterious errors in Magento's compiled JavaScript files. On most pages these errors did not occur, only on a specific product review page. Magento was told to leave some .js files away on this url. So there was a difference between the compiled .js file on that review url and the other urls. The thing which drived me nuts was: how can I have an error in JavaScript code which just has less code than some other file which was even bigger, but had no error?

Take a look at the following two snippets. The first one does not throw an error:

Product.Config.prototype = {
	// some code
}
Calendar = function() {
	// some code
};
(function(global){
	// some code
})(window);

Now, I'll remove the "Calendar" definition, and suddenly the code throws errors:

Product.Config.prototype = {
	// some code
}
(function(global){
	// some code
})(window);

The reason is a silly missing semicolon after the definition of "Product.Config.prototype". This is only a problem if the immediately following code starts with a parenthesis, like in the second snippet.

In Magento versions up to the newest v1.9 you will find such prototype definitions without a semicolon in the folder /js/varien/. Adding a semicolon at the end of these saved me from getting even more grey hair than I already have.

What is a nerd

written: 10 years ago category: Real Life

What is a nerd?

People nowadays tend to quickly name themselves a nerd when they're playing computer games and listening to electronic music in some of its wide spread flavours. In my understanding this is not the original definition of a nerd.

Wikipedia says:
A nerd [...] is a person, typically described as being overly intellectual, obsessive, or socially impaired. They may spend inordinate amounts of time on unpopular, obscure, or non-mainstream activities, which are generally either highly technical or relating to topics of fiction or fantasy, to the exclusion of more mainstream activities.

Now, come on, playing computer games the whole day is not very unpopular and obscure nowadays, is it? Compare that to e.g. programming an application which calculates the time needed for a light photon to travel through the observable or even the whole universe, in Erlang.

Mein neues Körnerkissen

written: 10 years ago category: Real Life

Entdeckt auf DaWanda

Von: weissesHaus_Nr7

Körnerkissen

http://de.dawanda.com/widget/redirect_to_object/Product-40208118-483e2c3330

Things

written: 11 years ago category: Zitate

I'm always forgetting to do really important things while I prefer to do things I don't really need to do.

I'm always forgetting to do very few really important things, while I prefer to do lots of other things I don't really need to do.

And that's modern progress, man, yeah. Well, feels more like quite a few steps backwards. Time killers. Things I don't need to do.

Nussecken

written: 11 years ago category: Real Life

Der Teig (1 Blech = 32 Nußecken):

• 130g Butter oder Margarine
• 130g Zucker
• 2 Eier
• 300g Mehl
• 1 gestrichener Teelöffel Backpulver

Alle Zutaten zu einem Knetteig verarbeiten und auf einem gefetteten Backblech ausrollen.

Der Belag

• 1 halbes bis ganzes Glas Aprikosenkonfitüre
• 200g Butter oder Margarine
• 200g Zucker
• 2 Päckchen Vanillezucker
• 200g gemahlene Haselnüsse
• 200g gehackte Haselnüsse
• 4 Esslöffel Wasser
• ca. 300g Zartbitter Kuchenglasur

Aprikosenkonfitüre großzügig auf den ausgerollten Teig streichen. Die Konfitüre macht die recht trockenen Nußecken saftig und fruchtig, lieber etwas zu viel als zu wenig nehmen.

Butter, Zucker und Vanillezucker in einem mittelgroßen Topf erhitzen, bis der Zucker sich gelöst hat. Die Nüsse zusammen mit Wasser unter die Butter-Zucker-Masse rühren. Dann alles auf die Konfitüre streichen.

Bei 175 Grad ca. 25 Minuten backen. Noch warm zunächst in Rechtecke, dann in Dreiecke schneiden.

Kuchenglasur in einer Tasse im Wasserbad erhitzen. Die Ecken in die Schokolade tauchen. Fertig! Leider dauert das Abkühlen einige Stunden, aber es schmeckt ja auch warm.

World population

written: 11 years ago category: Funstuff

Helge Schneider in Emsdetten

written: 11 years ago category: Real Life

Am 30. September gab es Helge Schneider in Emsdetten. Zum zweiten Mal in meinem Leben gesehen, diesmal mit meiner Liebsten. Und Helge war echt gut diesmal. Er war gut gelaunt, und ich hatte den Eindruck er mochte das Publikum wirklich. Soviel Blödsinn wie man ihm zutrauen mag, wenn er sagt das dass Publikum heute wunderbar ist, hatte ich das Gefühl das er das auch wirklich so meint. Mehr noch, ich denke Helge braucht ein Publikum dass ihn bzw. die tiefe Absurdität hinter seinem Humor nachvollziehen kann.

Wie auch immer - es gab viele alte Hits wie Telefonmann und Meisenmann, bis zur Unkenntlichkeit unglaublich gut improvisiert. Und der alte Witz mit dem von der Hand abgelesenen "hier im schönen Emsdetten ..." war natürlich dabei. Musikalischer Höhepunkt war der Gastautritt von Tyree Glenn Jr., der mit seinen geschätzten 65 Jahren und unglaublicher Wucht eine Solonummer auf seinem Saxophon dahinlegte.

Der Gedanke

written: 11 years ago category: Zitate

"Der Gedanke ist nur ein Blitz zwischen zwei langen Nächten;
aber dieser Blitz ist alles."

Henri Poincaré (1854 - 1912), französischer Mathematiker

CSS Lint

written: 12 years ago category: Programming

Not just another CSS validator, but more: checks your CSS code for bad, unpreferred and browser-incompatible code: https://csslint.net/

HeidiSQL im MariaDB Installer

written: 12 years ago category: HeidiSQL

Ich war hin und weg als Vladislav mich fragte ob sie mein "Baby" HeidiSQL in den nächsten MariaDB Installer packen könnten. Ich sagte zu, implementierte noch schnell Unterstützung für virtuelle Spalten und das richtige Icon im Datenbank-Baum auf der linken Seite:

Vor 3 Tagen kam dann die News zum neuen MariaDB release. Einen Tag später sogar auf heise.de in den Top-News - was heidisql.com natürlich einigen Traffic bescherte.

Im Nachhinein betrachtet kann ich sagen: im Paket geschnürt kann OpenSource Software Ihre Stärken richtig ausspielen. Vielen Dank auch an Monty!

3 comment(s)

The web gets social

written: 12 years ago category: Zitate

The web gets social, and finally hits puberty.

1 comment(s)

Set meta description in extension

written: 12 years ago category: Programming

To set a page title from within any Typo3 extension, you just access the relevant page array item:

$GLOBALS['TSFE']->page['title'] = 'My title'

Now, if you expect this to work also for the meta description you will probably be disappointed. Try this instead, which worked for me on a 4.1 installation:

$GLOBALS['TSFE']->cObj->data['description'] = 'My description'

2 comment(s)

How fucked is your database?

written: 13 years ago category: Programming

Wenn du loslässt ...

written: 13 years ago category: Zitate

... hast du zwei Hände frei.

aus China

2 comment(s)

Delphi shortcut

written: 13 years ago category: Programming

Just found by accident: When editing a .pas unit, Shift + Ctrl + [ArrowUp or ArrowDown] jumps from procedure declaration to implementation. Very nice if you have large units with several thousands of lines and numerous procedures and functions.

Stargate Universe

written: 13 years ago category: Funstuff

Als größter Fan von Stargate SG1 und Atlantis bin ich von den ersten 5 Folgen von Stargate Universe enttäuscht. Bin ich zu alt und passe nicht mehr in die Zielgruppe? Muß SciFi heutzutage unbedingt so viele Kompromisse eingehen? Ok, das Militär-Style-Gequatsche war immer schon überflüssig, aber im Gegensatz zu SG1 und Atlantis gibt es bei Universe jede Menge langgezogene Gefühls-Duseleien, viele unbedeutende Dispute die nicht zur Handlung beitragen, und was das schlimmste ist: Null Humor! Kein Colonel der sich als "Fan von Jungfern und von Fahrten" outet oder "mal pinkeln muss" (O'Neill), kein cholerischer Chef-Wissenschaftler (McKay), kein Augenzwinkern. Bedeutet das im Umkehrschluß dass jüngere Zuschauer (auf die die Sendung angeblich zugeschnitten ist), keinen Sinn für Humor haben? Tsss..

3 comment(s)

Delphi generics

written: 13 years ago category: Programming

Just found a wonderful and deep look into generics, anonymous routines and routine references here . Written by Sébastien Doeraene.

Generics were introduced in Delphi 2009, and I'm a big fan of them, as they help me do less type casting on TObjectList's items for example.

Want to know how sorting a TObjectList<TWhatever> works? Here's how it works:

type
  TDBObject = class
    Name: String;
  end;
  TDBObjectList = TObjectList<TDBObject>;
  TDBObjectComparer = class(TComparer<TDBObject>)
    function Compare(const Left, Right: TDBObject): Integer; override;
  end;

procedure TMainform.btnOkClick(Sender: TObject);
var
  o: TDBObject;
begin
  Result := TDBObjectList.Create(TDBObjectComparer.Create);
  o := TDBObject.Create;
  o.Name := 'foo';
  Result.Add(o);
  o := TDBObject.Create;
  o.Name := 'bar';
  Result.Add(o);
end;

function TDBObjectComparer.Compare(const Left, Right: TDBObject): Integer;
begin
  Result := CompareText(Left.Name, Right.Name);
end;

ftp://ftp-developpez.com/sjrd/tutoriels/delphi-generics/delphi-generics.pdf

The raven

written: 13 years ago category: Real Life

Letztens nachts bei Vollmond nach draußen geschaut und den Plastik-Raben zum Verjagen von Tauben auf der Garage im fahlen Mondlicht beinah für echt gehalten. Erinnerte mich etwas an die Musik auf Tales of Mystery and Imagination von Alan Parsons bzw. The Raven von den Stranglers.

When god created the world

written: 13 years ago category: Zitate

In the beginning was the word. And the word was content-type: text/plain

Found somewhere as a forum signature.

2 comment(s)

Apfelkuchen Grossmutters Art

written: 13 years ago category: Real Life

Kommentar meines 5-jährigen Sohnes: "köstlich!"

Teig:

• 250g Butter
• 250g Zucker
• 5 Eier
• 1 Päckchen Vanillezucker
• 350g Mehl
• 1 Päckchen Backpulver
• 1kg Äpfel

Äpfel schälen und in kleine Stücke schneiden. Die Butter schaumig rühren. Eier, Zucker und Vanillezucker dazugeben und gut verrühren. Dann Mehl mit Backpulver unterrühren. Die Apfelstücke unter den Teig heben.

Die Mischung auf ein eingefettetes Backblech oder auf Backpapier streichen und bei 200 bis 220° Celsius 30 Minuten lang backen.

Puderzucker mit Zitronensaft glatt rühren und auf den heissen Kuchen verteilen. Zitronensaft kann auch weggelassen werden, aber der Puderzucker sollte schon drüber.

4 comment(s)

Typo3, exclude rootline menu on first level pages

written: 14 years ago category: Programming

On the root or first level page you probably want to hide a so called breadcrumb menu, as it would be a single word, identically with the page title, looking like a repetition of the page title. All "deeper" page levels should indeed include the complete path.

There is a HMENU.minItems property which looked pretty like what I needed. But that created a dummy item with three dots for missing level items, not what I wanted. So, the trick is to use a conditional block, where the first one is executed on page level 0 and 1, and the second one for all deeper levels:

[treeLevel = 0,1]
    # No breadcrumb on root or first level pages
    mainPage.10.marks {
        BREADCRUMB = TEXT
        BREADCRUMB.value =
    }
[else]
    mainPage.10.marks {
        BREADCRUMB = HMENU
        BREADCRUMB {
            wrap = <p>|</p>
            special = rootline
            # No item at all for the root page, so we start at level 1
            special.range = 1|-1
            1 = TMENU
            1.NO = 1
            1.NO.allWrap = | &nbsp;&raquo;&nbsp;
            1.CUR = 1
            1.CUR.doNotLinkIt = 1
        }
    }
[end]

http://typo3.org/documentation/document-library/references/doc_core_tsref/4.1.0/view/4/1/

Add anchor in getTypoLink

written: 14 years ago category: Programming

getTypoLink() doesn't allow you to pass an anchor parameter. So, in order to add an anchor to such a link you just have to add the anchor part to the id parameter:

$this->cObj->getTypoLink('Link Label', '123#myanchor');

$this->cObj->pi_linkToPage('Link Label', '123#myanchor');

$this->cObj->getTypoLink_URL('123#myanchor');

By the way, ever saw what the harmless function class.tslib_content.php:typoLink() does? Have a look just for fun, it's a 300 liner! Feels like Typo3 has a damned considerable amount of workarounds for various special cases and requirements.

http://www.typo3-jack.net/typo3-dev-lists-netfielders-de/3076-typo3-dev-typolink-anchor.html

1 comment(s)

VirtualTree Bugtracker

written: 14 years ago category: Programming

Mike has just set up a bugtracker at Google  Code for his popular VirtualTree component for Delphi. So, finally, all interested developers can actively participate in enhancing and extending this thing.

HeidiSQL makes extensive use of VirtualTree - as replacement for the normal TTree's and TListView's we had in old days. VirtualTree can display tree-like structures as well as lists, in all colors and flavours you can imagine:

Much more: it minimizes CPU and memory usage by strictly following the virtual paradigm (= just process visible nodes, nothing more, the rest is processed when the users scrolls to it). That means you can create millions of nodes in milliseconds. It has support for drag'n drop, custom cell editors (similar to plugins), images in column headers and cells, tons of useful events, and numerous other things you won't like to miss once you get used to them.

http://www.soft-gems.net/index.php?option=com_content&task=view&id=56&Itemid=1

An Asgard spaceship for Jack

written: 14 years ago category: Zitate

Sam: "Die Asgard haben ein neues Schiff entwickelt Sir. Die O'Neill. "
O'Neill: "Cool!"
Sam: "...Wir mussten es sprengen."
O'Neill: "Oh."

heidisql.com recovered

written: 14 years ago category: HeidiSQL

Phew... fixed it by upgrading the old virtual server system to a newer, slightly more speedy one. Networking on the old virtual machine was still broken today, and Parallels seem to have bigger problems finding the error cause. So I decided not to sit and wait here and ordered the mentioned upgrade, which then was a blank new virtual machine with nearly the same specs but on a different hardware. They mounted the old virtual harddisk into the new system so I could easily copy old config files and programs from O:\ to C:\ . Nameservers updated to the new IP address and tataaa - at 8:30pm the first visitors since 36 hours were back.

Btw, having a downtime on that domain also meant there was a one-minute-waiter for each HeidiSQL user at startup on earth which had updatechecks switched on ... ehm :oops:

http://www.heidisql.com/

1 comment(s)

heidisql.com broken

written: 14 years ago category: HeidiSQL

The container of the virtual machine seems to be broken since 9:30 this morning and causes random network problems. Hopefully HostEurope can fix that soon, otherwise I have to reinstall the complete system.

http://www.heidisql.com/

HeidiSQL 4.0 released

written: 14 years ago category: HeidiSQL

http://www.heidisql.com/forum/viewtopic.php?p=3192

Get number of enumerated, ordinal elements in a SET

written: 14 years ago category: Programming

Imagine some ordinal type and a set enumeration of it in Delphi:

type
  TLocation = (locHere, locThere, locElsewhere);
  TLocations = Set of TLocation;
...
var locs: TLocations;
...
begin
  Include(locs, locHere);
end;

function CountSetItems(SetValue: Integer): Byte;
var
  Mask: Integer;
begin
  Mask := $80000000;
  Result := 0;
  while Mask <> 0 do begin
    if SetValue and Mask <> 0 then
      inc(Result);
    Mask := Mask shr 1;
  end;
end;

Janoschs Traumstunde auf DVD

written: 14 years ago category: Kids

Mal was richtig gutes für Kinder die unbedingt fernsehen wollen: die alten Folgen von Janoschs Traumstunde von 1989 gibts jetzt auf DVD. Die Geschichten sind (wie mans von früher noch kennt) sehr langsam erzählt und immer ein bissel schräg. Genial: der große dicke Waldbär, der die Ansagen macht und desöfteren den Faden verliert und anfängt zu philosophieren. Oder "Oh wie schön ist Panama", bei der der Tiger und der Bär sich auf die Suche nach Panama machen und nur zuhause ankommen weil sie im Kreis gelaufen sind. Auch eine Empfehlung wert sind die jetzt auf DVD erhältlichen Folgen von Doctor Snuggles. Schräg-schöne, gewaltfreie Geschichten vom gutmütigen Maschinen-Erfinder Dr. Snuggles, seinem Dachs-Freund Dennis, der Maus Knabber, der "Wer-was-wo-Maschine" und nicht zuletzt der Rakete "Ploff-Ploff" mit der Snuggles desöfteren das Tee-trinkende Kamel im Regenbogen besucht (!)

http://www.amazon.de/Janoschs-Traumstunde-Alle-Folgen-DVDs/dp/B001COC94S/

New table designer

written: 14 years ago category: HeidiSQL

Table editing in HeidiSQL has various legacy stuff inside which is really old and needs some fresh new ideas. So I took issue #436, various hours to think and started to create a new table designer.

Ideas:

1. the table tab should go away as we don't have only tables any longer, there are several other types of database objects added in recent MySQL versions, e.g. stored routines, views. So, a own tab only for tables tends to get inconsistent
2. same applies for the Data tab
3. like views or stored routines, add a new modal dialog which offers creating and editing tables. Which not only includes columns, but also indexes and advanced options like row format and such things.

Long story short - here's the current status:

Star Wars

written: 14 years ago category: Zitate

O'Neill und Teal'c laden sich selbst bei Kollegin Carter zum Pizza essen ein, stehen vor der Tür und Carter macht auf: O'Neill: Wir haben einen Film mitgebracht Teal'c: "Star Wars." O'Neill: Er hat ihn wie oft, acht ...? Teal'c: Neun. O'Neill: Neun mal gesehn. Und wenn Teal'c ihn super findet, muss er gut sein. Carter: Sie haben noch nie "Star Wars" gesehn? O'Neill: Naja, Sie wissen ja, ich und Science-Fiction. [Schweigen]

Ixus arrived

written: 14 years ago category: Real Life

Choosing a digicam can be a quite annoying and exhausting job if you really compare conscientiously. So I'm happy I found my new one - a Canon Ixus 85 IS. I knew that it has small dimensions but as I opened the package I couldn't believe how small it is. All photos you see on the internet do not reveal the real size as you can't compare it to other things on that photo. So here's my stubby fingers hand holding this technical wonder:

2 comment(s)

Toter Planet

written: 14 years ago category: Zitate

Colonel Mitchel zu Teal'k auf einem leblosen Planeten der von einer Parasiten-Plage befallen wurde: Man, hier ist ja weniger los als in einer Texas-Salatbar

LexisNexis Mitarbeiter Feed

written: 14 years ago category: Real Life

Bodo ist ja seit kurzem nicht mehr mein Kollege, aber er hat sich trotzdem entschieden unsere gemeinsame Mitarbeiter-Blogmaschine weiter zu betreiben. Danke!!

http://lexisnexis.wannawork.de/

1 comment(s)

New HeidiSQL release: 4.0 RC3

written: 14 years ago category: Programming

Mainly a maintenance release but some nice enhancements in it:

• Legacy MDI (Multi Document Interface) has been removed completely
• Use Ctrl+Tab and Shift+Ctrl+Tab for switching main tabs
• Added quick connect sessions via drop down menu of connect button
• Session background color
• Date time editing fixed
• Various bugfixes

Download your copy.

Note that if you use the original 4.0 RC1 release your auto update mechanism won't update to this new release as in that older release it was broken (caused by the "M" in "r1901M").

In case you're wondering about the missing RC2 release: That version was created as Subversion tag but found as broken (XP theming was accidently disabled in a previous commit). So I decided to fix that first and - for consistency reasons - created a new version tag.

Bolan Website online

written: 14 years ago category: Programming

Finally done and uploaded to its correct place. A new website is born, selling home fashion and furniture by a flexible and experienced team of Bolan Home Fashion in Wettringen.

http://www.bolan-home-fashion.de/

Basic Oracle support in jHeidi

written: 14 years ago category: Programming

http://www.heidisql.com/forum/viewtopic.php?p=2961#2961

1 comment(s)

HeidiSQL 4.0 RC1 released

written: 14 years ago category: Programming

Some of the new features:

• Completely rewritten user manager
• Full Unicode support for international characters in grids, SQL queries, CSV import etc.
• New grid component, including user friendly popup editors for blobs, date/time, set, enum columns. Grid cells have customizable colors, according to their data type.
• A new view editor
• Enhanced Vista style and a new, stylish iconset
• Automatic update check
• More speed in various places
• much more ...

http://www.heidisql.com/download.php

Mau is here

written: 14 years ago category: Real Life

1 comment(s)

How to enable Unicode in VirtualTree's inplace editor

written: 15 years ago category: Programming

VirtualTree's inplace editor is the only thing which is (by default) not Unicode enabled in that package. Just found after having a Unicode enabled inplace editor for VirtualTree half implemented: If you have TNT Controls installed, you can activate "TNT support" in your [PathToVirtualTree]\Source\VTConfig.inc :

{$define TntSupport}

IE6 reserved word "functions" in class name

written: 15 years ago category: Programming

Internet Explorer 6 has several excuses for not wanting to display certain DIVs or text in DIVs. Most of them arise from the internal hasLayout property which has to forced to -1 (on!) to unhide those HTML parts. I just came around another, very odd reason for why IE6 hides text in certain situations: CSS classnames which interfere with reserved words such as functions. Simple example:

Just rename functions to whatever and you're done.

Coming soon

written: 15 years ago category: HeidiSQL

Can't wait to present that new dialog with complex but intuitive logic to the public: The new user manager in HeidiSQL. 90% ready, just a few work-evenings.

This is how it looks and feels:

The mother of all Delphi components

written: 15 years ago category: Programming

Thank you, Mike, for Virtual Treeview . It's the most useful, powerful, fast, flexible, beautiful, multifunctional Delphi component I've ever seen.

Thank you, thank you, thank you!

Where the hell gets Google all its Gmail hard drive space?

written: 15 years ago category: Funstuff

Ensuring window visibility after plugging off a second monitor

written: 15 years ago category: Programming

I recently connected my new HD TV to my notebook, to test the DVI-to-HDMI adapter I just bought and various resolutions. I played a bit with different resolutions, started HeidiSQL, moved it to the TV which was used as second desktop. Then, after having plugging off the TV I started HeidiSQL again and saw - nothing! No window visible... HeidiSQL remembered its last window position and started in the area where the TV has previously provided its resolution. So, looked like a bug :) Started Delphi and found the place where the main window restores its position (Top, Right) and size (Width, Height) from the last session. I discovered the global Screen object has some Monitor* properties - these are:

Screen.Monitors
Screen.MonitorCount
Screen.MonitorFromPoint
Screen.MonitorFromRect
Screen.MonitorFromWindow

var
  Monitor: TMonitor;
const
  MoveWinThreshold: Byte = 80;
begin
  // ...
  // 1. Some code to restore the last GUI position and dimension
  // ...

  // 2. Detect the relevant monitor object
  Monitor := Screen.MonitorFromWindow(Self.Handle);
  // 3. Now ensure the just positioned window is visible to the user
  // 3.a. Set minimal visible width
  if Left > Monitor.Left + Monitor.Width - MoveWinThreshold then
    Left := Monitor.Left + Monitor.Width - MoveWinThreshold;
  // 3.b. Set minimal visible height
  if Top > Monitor.Top + Monitor.Height - MoveWinThreshold then
    Top := Monitor.Top + Monitor.Height - MoveWinThreshold;
  ..
end

1 comment(s)

How to solve "can't open activity db - access is denied" for SVN commits

written: 15 years ago category: Programming

I somehow messed up the file privileges of a rsync'd SVN repository on a Windows server. Most probably it was rsync/cygwin which broke something here. After fiddling around with the folders and files I just zipped the complete directory of the repository, deleted the original files and then unzipped the zipfile again - works perfectly now! A ZIP file cannot store given privileges of files and folder. But be aware that RAR can, so prefer ZIP!

HeidiSQL now with Silk icons

written: 15 years ago category: HeidiSQL

A sysiphus work for developers: Replace each of the 37 zillion icons in a complex application! HeidiSQL now uses the awesome Silk icon set by Mark James.

Now it looks like this:

Previously that looked like this:

http://www.heidisql.com/download.php

2 comment(s)

Typo3 3.5 running with PHP 5.x

written: 15 years ago category: Programming

This took me at least one hour to find out: If you encounter either this error while accessing the backend at /typo3 : Error in init.php: sitepath not specified correctly or this error while accessing the frontend: Cannot find configuration. This file is probably executed from the wrong location. Just ensure the old PHP arrays like $HTTP_SERVER_VARS are registered. You can do so by adding this PHP flag to your .htaccess :

php_flag register_long_arrays 1

Stargate Movie "Ark of Truth"

written: 15 years ago category: Funstuff

Release date: March 11 2008 for USA, unknown yet for Europe. Cover: https://www.treknews.de/treknews/newspro-treknews/upload/newsbilder/stargatearktruthr1artpic.jpg

Art of Noise

written: 15 years ago category: Funstuff

Letztens wieder entdeckt - immer noch fantastisch anzuhören: Paranoimia, Beatbox, Close (to the edit) etc. Mittlerweile gibt es scheinbar einige Remixes der Art of Noise Hits aus den 80ern, die ich bisher nie gehört habe. Und eine 4er CD mit dem Lebenswerk der Avantgardler gibt es seit Ende 2006 - diese soll u.a. eine Menge unveröffentlichtes Material enthalten, und die seltene Originalversion von Beatbox.

http://mog.com/music/Art_Of_Noise/The_Best_Of_The_Art_Of_Noise

1 comment(s)

Am Anfang war Niki

written: 15 years ago category: Programming

Meine ersten Gehversuche im Programmieren gehen zurück ins Jahr 1991, als ich ohne irgendwelche Vorkenntnisse in der 11. Schulklasse des Arnold-Janssen-Gymnasiums für ein halbes Jahr das Fach Informatik wählte. Lern-Stoff war eine abgeschlossene Programmier-Umgebung, in der man mit einem stark abgespeckten Pascal den Roboter "Niki" über ein viereckiges Feld steuern musste. Soweit ich mich erinnern kann, waren die damaligen PCs ausgestattet mit einem 80-086 Prozessor (4,7 MHz), 2 x 5¼-Zoll-Diskettenlaufwerken, Hercules-Grafik und Bernstein-Monitor. Vor kurzem fand ich die Niki-Software im Web wieder und sah mit Begeisterung, das es hier bereits eine Windows-Umsetzung gab: https://www.hupfeld-software.de/niki.php. Für alle Programmier-Anfänger heute noch wärmstens zu empfehlen