I was looking for openstreetmap data of my country to import it into a local database. As only small areas can be exported over the exporter of the official web page I followed the hint to planet.osm which would contain data of the whole planet. After some reading I found http://download.geofabrik.de/ where you can download […]
Openstreetmap Offline Map Data Read More »
I found strange errors like the following in my apache_error.log [Thu May 02 20:59:58 2013] [error] [client 84.114.158.229] WordPress database error ERROR: column p.id does not exist\\\\\\\\nLINE 1: SELECT p.id FROM wp_posts AS p WHERE … I found out that this comes from line 1178 in wp-includes/link-template.php. Just change the p.id at after the SELECT
WordPress problem with PostgreSQL Read More »
after an upgrade from squeeze to wheezy I had a strange error when using sudo: dpkg: warning: ‘ldconfig’ not found in PATH or not executable. dpkg: warning: ‘start-stop-daemon’ not found in PATH or not executable. dpkg: error: 2 expected programs not found in PATH or not executable. Note: root’s PATH should usually contain /usr/local/sbin, /usr/sbin
Problem with sudo after upgrade to wheezy Read More »
I recently deleted the folder “Favoriten” in the home directory of my Windows 7. This broke the explorer feature as the folder was not recreated. To do this simply open a command prompt (cmd) cd to your home directory and use the following statements to recreate the folder and restore the explorer functionality: mkdir Favorites
Restore Deleted Favorites Read More »
If you want to set the actual timestamp to a field in HQL just use current_timestamp() instead of setting it in your code via a param.
HQL current time like NOW() in PostgreSQL Read More »
to change the label on the checkout button from “Bestellung abschließen” to “Zahlungspflichtig bestellen” you just have to change the file app/locale/de_DE/Mage_Checkout.csv
Magento Button “Bestellung abschließen” Read More »
I needed the Oracle SQLPlus client. Here are the steps to get it running: Go to http://www.oracle.com/technetwork/database/features/index.html. There you find a link named Database Instant Client. Follow that link and choose x86 or x86-64. Download the following 3 packages: basic, sqlplus, devel. The install these packages with alien: sudo alien -i oracle-*sqlplus*.rpm sudo alien -i
Oracle SQLPlus under Ubuntu 12.10 Read More »
If you have a file with dos format, simply open it with vim and type :e ++ff=unix to get it as unix file format. Supported file formats are: unix LF only dos CRLF mac CR only CR is carriage return (Ctrl-M, ^M or hex 0D). LF is linefeed (Ctrl-J, ^J or hex 0A)
Change FileFormat from DOS to UNIX Read More »
I recently tried to install oracle under ubuntu. I added a new user and could not start any x-windows as this new user. “xhost +” was the solution. oracle@orabox:/home/oracle/database$ xclock No protocol specified Error: Can’t open display: :0.0 root@orabox:/home/oracle/database# xhost + access control disabled, clients can connect from any host root@orabox:/home/oracle/database# su oracle oracle@orabox:/home/oracle/database$ xclock
Error: Can’t open display: :0.0 Read More »
I had the problem that starting my jboss application server was veeeeery slow – don’t know how long it would have taken as I always killed it after a few minutes. After some experiments with more memory without a change I removed all my breakpoints in the debug view of eclipse and voilá – it
Eclipse: JBoss very slow in Debug mode Read More »