#hoopla

The setup is: An MSSQL within a virtual machine, a Symfony 1.4 installation on Ubuntu with PHP 5.3.5.
In order to get this working, php5-sybase needs to installed and the DSN needs to be set correctly. In the PHP manuals, it says something like "mssql..", but this caused Symfony to throw the error "Couldn't locate driver named mssql". I used "dblib.." instead and it works.

One problem occurred when using Admin Generator on an existing table: 500 | Internal Server Error | Doctrine_Connection_Exception OFFSET cannot be used in MSSQL without ORDER BY due to emulation reasons." This can be solved by doing this.

Another issue was "SQLSTATE[HY000]: General error: 207 General SQL Server error: Check messages from the SQL Server [207] (severity 16)". This only occurs for tables with many (>200) columns. I removed unnecessary columns from the schema.yml and the problem was gone. Interestingly, the query with all columns was correct and worked without a problem copy-pasting it to SQL Server Management Studio. Thus, the MSSQL adapter seems to have a problem with textually long queries.

One last issue was the date format MSSQL delivers: It causes the sfDateFormatter to throw "sfDateFormat.class.php on line 487 undefined offset", mentioning the year when trying to format a month. I decided for a workaround and left out datetimes here as well. But I would be interested, how MSSQL datetimes can be accessed...

EDIT: I needed some of the previously unnecessary columns later and found, that the amount of columns was not the problem. There was one column with a German umlaut causing the problem.

After moving a Drupal 6 installation (database and files), on the new hosting, the Drupal installation screen appeared instead of the copied site. In order to complete the movement, the sites/default/files folder and its contents need to be writable by the www-data group.

Nach Einrichtung der Standard-Datensicherung unter Windows 7 brach die Sicherung immer unter einer Fehlermeldung ab. Um die Fehlermeldung anzuzeigen, kann man die Sicherung manuell starten und die Fehlermeldung ausklappen. Der Fehlercode lautete 0x81000038. Die "Lösung" dieses bekannten Bugs findet sich auf der verlinkten Webseite und hängt mit dem AppData-Ordner zusammen. Wenn man diesen explizit ausnimmt aus der Sicherung und ihn über C:\Users\...\AppData wieder der Sicherung hinzufügt, funktioniert sie.

I used to have a raw printing queue installed for a Canon bubble jet (iX 4000) with an older version of Cups (Ubuntu server 10.x) and windows 7 clients without any problem. The IPP queue was and is of the form http://server-ip:631/printers/Canon_iX4000. On upgrading to Ubuntu 12.04 LTS, the same configuration did not work reliable any more: print jobs hung arbitrarily or were "sliced" and printed on several pieces of paper.
The error log of Cups showed some errors that only seem to occur on installing a new printer in windows:

Unable to encrypt connection from 192.168.1.49 - Error in the push function.
Missing printer-uri, job-uri, or ppd-name attribute
Returning IPP client-error-bad-request for windows-ext (no URI) from 192.168.1.49

The problem with the print jobs disappeared once I navigated to https://server-ip:631 on each client Firefox and confirmed the exception for the security certificate once.

1. Copy the .xsn file, rename it to .cab and extract it
2. Open PowerShell and navigate to the extracted files

3. Enter

   $ns = @{my = "http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-11-30T20:28:56"; fn = "http://www.w3.org/2005/xpath-functions"; ms = "urn:schemas-microsoft-com:xslt"}

$xml = [xml](get-content template.xml)

Select-Xml -Xml $xml -XPath "//my:*" -Namespace $ns | select Node