Just in case somebody has a similar problem… Coming mainly from MySql I had to deal with some MsSql/SQL Server specialties. Consider the following working SQL for MsSql: SELECT AK.AK_TEXT, BU.BUDGET_BEREICH ,TY.AKTIONSTYP_TEXT ,AK.AK_STARTDATUM ,AK.AK_ENDEDATUM FROM AKTIONEN AS AK WITH (nolock) LEFT JOIN BUDGET_TRAEGER AS BU ON AK.AK_BUDGET_NUMMER=BU.BUDGET_NUMMER LEFT JOIN AKTIONSTYP AS TY ON AK.AK_TYP=TY.AKTIONSTYP_TYP LEFT [...]
Archive for the ‘Problems’ Category
January 18, 2010 by marco · Comments Off
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
Filed under: Problems, Snippets
Social Tagging: mySQL • php • script
We have just had the case of having ftp access to a site on a shared hosting LAMP webspace but needed also the database and mainly the database scheme to setup our own development-system for the app. This is actually very straight forward using the following snippet uploaded and executed on the webserver: <?php exec( ’mysqldump [...]
February 20, 2009 by marco · Comments Off
Filed under: Linux, Problems, Serverstuff
Social Tagging: Debian • Linux • php
Filed under: Linux, Problems, Serverstuff
Social Tagging: Debian • Linux • php
I was having trouble with a server running Debian 4.0 (etch). Using the standard sources in the /etc/apt/sources.list the supported PHP5 version was 5.2.0-8+etch13 which contained a very annoying bug for my application. A daily running script – let’s call it the Importer – regularly exited randomly with a “Fatal error: Out of memory (allocated [...]
I have just discovered an issue if you store serialized objects into MySql. At first I used fieldtype TEXT. If in this case somebody edited another field of such a record with phpMyAdmin and pushed the save button, the stored object in that record got currupted and the object could not be deserialized and instanciated [...]
November 14, 2008 by marco · Comments Off
Filed under: Problems, Serverstuff
Social Tagging: 404 • http
Filed under: Problems, Serverstuff
Social Tagging: 404 • http
I have an individual CMS running for a customer, who can edit his events, news etc. in a typical admin area. Each of the items had an expiry date. On any call to a deep URL to one of the expired items (e.g. from Google search results) it would make a redirect to the custom [...]
I am currently migrating MySQL databases. One DB uses InnoDB tables with many foreign-key constraints. In this case you can not just dump your CREATE-TABLEs and INSERTs into an empty database. This would lead to many relation violations and incomplete imports, since records are not imported in ‘the right order’ by the dump. To prevent [...]
Today I had some more major hardware failures… After it was clear that I would be fixing things all day long, I took a deep breath and fired up Peter Dunston’s Website to relax and listen to good music while I was cleaning up the mess. What happened: The switch connecting my dev-servers with my [...]
Happy new year! Some of you may remember this image and the story around it: http://blog.t14g.de/index.php/archives/63 It happened again after a night of building an index (Solr/Lucene). This time the destruction of the filesystem looked like this: I have learnt my lesson and from now on I keep a harddisk-image of the installed system with [...]
I am currently preparing for a system load test in a customer project. This involves an awfull lot of conversion-operations on >10 Mio files, for example the conversion of legacy SGML into XML with some additional calculated content or generation of such dummy-records to find the limits of our target architecture, packing, transporting and unpacking [...]
RSS