Add a date to a JPG in Lightroom

If you import JPG files or other images in Lightroom which haven’t been captured by a camera or lost EXIF and other timestamp data, you can add a capture time this way:

  1. Go to grid view
  2. Select one or more image thumbs
  3. Choose Metadata > Edit capture time…
    (there is also the option to automatically use the date when the file was created)
Logo taken from Wikipedia (Public Domain)

Pitfalls when moving your BOX cloud to another computer

Beware that BOX doesn’t sync dot files, and ignores some other filetypes.

At first you might not notice, and when you do it might be too late (when you don’t care for accurate backups). Then there’s another dangerous pitfall when you try to bypass the necessary first sync from the cloud.

Preparations

  1. Make sure all files are synched through the box sync app on your old computer
  2. Make a backup copy of the ENTIRE Box Sync folder on an external drive
    Typically under c:\Users\<username>\Box Sync\

Migrating to a new computer / installing on a secondary computer

1) Download and install the BOX app
2) Run the BOX app and login
3) Let BOX download everything from the cloud onto your computer. Do not copy the backup to your new computer! Chances are BOX sees these files as new ones and your sync will eventually end up with an unexpected amount of duplicate files!

Now you may wonder why you need the backup or the old copy of the Box Sync folder?

BOX does not support certain files, they are not synched, but you’ll find them in your existing backup.
If you use a MAC, if you are a webdeveloper, chances are that you have a lot of files that start with a dot.
.htaccess
.gitignore
and many more like .PST and so on …

This is not a problem that is only related to BOX. Other cloud storage services have similar downsides. Stack also doesn’t .htaccess files to their cloud storage, although they recognize the need (especially for webdevelopers). There shouldn’t be a problem with folders starting with a dot.

All these files are considered ‘hidden’ by BOX, though they are not!
You need to copy those files manually to the new BOX location.

So that’s why BOX cannot be considered as a complete backup in the cloud!

How to deal with dozens of ignored files?

If you had a lot of dot files, it will be a burden to copy these files manually. But fortunately there are lots of applications which can make life easer for you. I use Total Commander (Commands > Synchronize dirs…) to make sure all these dot files are copied to their respective locations.

FileZilla als portable app installeren

Download het ZIP-bestand rechtstreeks van de FileZilla website (kies show all download options). Download niet via http://portableapps.com

Volg vervolgens de procedure op http://www.portablefreeware.com/forums/viewtopic.php?p=84339#p84339

created settings sub-folder
renamed fzdefaults.xml.example file from docs sub-folder to fzdefaults.xml
edit fzdefaults.xml so the string $SOMEDIR/filezilla/ from Config Location line now reads settings
moved fzdefaults.xml from docs up one level (same as filezilla.exe)
run filezilla.exe

Getest met FileZilla_3.23.0.2_win64.zip op Windows 7 Enterprise.

Result: config files are saved in settings sub-folder, but the icons cache is still created in AppData.

Kiosk

If the “Kiosk mode” setting is set to 1, FileZilla will not write any
passwords to disk. If set to 2, FileZilla will not write to any
configuration file. The latter is useful if FileZilla gets executed from
read-only media.

Geen update checks

If the “Disable update check” setting is set to 1, the capability to
check for new FileZilla versions will be completely disabled.

Getting started with WAMP: setting up

Memory exhausted problem

“Allowed memory size of 134217728 bytes exhausted”
I encountered this problem a few times, and setting memory_limit to a higher value didn’t seem to work

In php.ini:
memory_limit = -1;

Changing www root on WAMP

Open httpd.conf

Change

Listen 0.0.0.0:80
Listen [::0]:80

to

Listen 127.0.0.1:80
Listen [::1]:80

Change

DocumentRoot "C:/wamp/www/"

to

DocumentRoot "C:/Users/name/Sites/localhostwamp/"

Change

</pre>
<Directory "C:/wamp/www/">
<pre>

to

</pre>
<Directory "C:/Users/.../Sites/localhostwamp/">
<pre>

Setting mySQL password

go to shell (right click mysql shell in taskbar)

update mysql.user set Password = password('yourPasword') where User = 'root';
flush privileges;

go to phpmyadmin directory c:\…\wamp2.5\apps\phpmyadmin4.1.14\config.inc.php

replace:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

with

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

Or watch this dummy video tutorial:

Set login session to something less restrictive for testing purposes

in your config.inc.php file (apps/phpmyadmin…)

$cfg['LoginCookieValidity'] = 604800; /* 1 week */
$cfg['MaxNavigationItems'] = 1000;

mysql error logging

add these lines to my.ini

log-queries-not-using-indexes
log-warnings
long_query_time = 2
log=C:/Webservers/wamp2/logs/querylog.log
log-slow-queries=C:/Webservers/wamp2/logs/SlowQueryLog.log

import sql-data into mySQL database

Right click Wamp icon in taskbar > mySQL

show databases;
use <databasename>;
source c:\Temp\queries.sql;

mysqldump in wamp (not via mysql console!)

Go to the wamp mysql directory via cmd prompt

cd c:\Webservers\wamp2\bin\mysql\mysql5.6.17\bin\

Now ‘all’ mysql commands are available:

mysqldump -u root -p dbname table1 table2 > output.sql

[SOLVED] XAMPP Row size too large, innoDB sql import

Ran into some problems recently with XAMPP. Exported a large mySQL production database and tried to import it locally in XAMPP (through Shell access).

Error: ERROR 1118 <42000> at line 437919: Row size too large <> 8126>. Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

First I tried changing table to ROW_FORMAT=COMPRESSED doing so:

ALTER TABLE <tablename>
    ENGINE=InnoDB
    ROW_FORMAT=COMPRESSED
    KEY_BLOCK_SIZE=8;

No success with that. Then I changed innodb_buffer_pool_size to 32MB (default setting was 8 or 16) in my.ini (mySQL config file in XAMPP)

xampp control panel

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
#innodb_log_arch_dir = "/Sites/xampp-portable-win32-1.8.3-5-VC11/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 32M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 10M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table = 1
innodb_file_format = Barracuda

Doing so made it possible to import a 1GB sql table without any problem.

The above applies to XAMPP portable version xampp-portable-win32-5.5.19-0-VC11.zip

 

PHP UTF8 test-template (jQuery, Bootstrap)

This is just a webdevelopment template for PHP (all errors, xdebug), HTML, jQuery, Bootstrap (UTF8 encoding).

<?php
ini_set('display_errors' , 'On');
error_reporting(E_ALL);
session_start();
header("Content-Type:text/html;charset=utf-8");
ini_set('xdebug.var_display_max_depth', -1);
ini_set('xdebug.var_display_max_children', -1);
ini_set('xdebug.var_display_max_data', -1);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>...</title>
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="//code.jquery.com/jquery-migrate-1.2.1.min.js"></script>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/css/bootstrap.min.css" rel="stylesheet">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>

</head>
<body>

</body>
</html>

VLC stuck in a loop? Kill process seems like the only solution?

Video image freezes, audio rewinds 3 to 4 seconds and gets stuck in a loop.
A similar problem has been documented here: https://trac.videolan.org/vlc/ticket/6600.
Unfortunately there seems to be no solution. It even happens in recent VLC distributions, like VLC Rincewind 2.1.3.

I have tried using Windows Media Player Classic (MPC), without any effect. At random intervals, with any kind of video format, video playback stops.

Quite out of the blue I found this behaviour tracing back to Intel Optimus Technology. I have two video cards: HD Graphics 4600 and NVIDIA Quadro K2100M controlled by Optimus. Optimus technology switches between these two GPU’s to ensure maximum battery autonomy.

When disabling Optimus in your BIOS settings, the video problem should belong to the past. This, however, isn’t an optimal solution when you rely on Optimus to get maximum battery autonomy. At this time, with the latest BIOS and Graphic drivers video playback keeps freezing with Optimus enabled. Hopefully, a driver update will fix this in the near future.

Feedback appreciated

Password protect a subsite in a WordPress network with .htaccess

A wordpress network / multisite setup uses virtual directories.

When you have a wordpress network setup on www.yourdomain.com, you can have multiple blogs with only one WordPress installation, for example:

www.yourdomain.com
www.yourdomain.com/johndoe
www.yourdomain.com/janedoe

Suppose you want to password protect only one subsite e.g. ‘janedoe’, you can’t just create a ‘janedoe’ folder on your webserver with a particular .htaccess in it.

You need to create a secured environment for the virtual folder in your main .htaccess (where all other WordPress rules reside) using the following code:

SetEnvIfNoCase Request_URI "^/janedoe/" SECURED
AuthType Basic
AuthName "restricted area"
AuthUserFile /home/mydomain/.htpasswd
require valid-user
Satisfy any
Order allow,deny
Allow from all
Deny from env=SECURED