Sim Tsai SimTsai

Fixing a Microsoft SQL Server LocalDB trigger error

This is a note on how I fixed a relatively minor issue with Microsoft SQL Server Express LocalDB. The solution was a bit difficult to find. Therefore I'm writing this in the hope that it will be found by other people who have the same problem and Google the error message text. This is based on a StackOverflow answer by Yennefer. I've added a bit more detail and an alternative way to delete the triggers. I'm leaving out most of my mistakes, several dead ends, etc.

I'm certainly no expert on anything in this document. I'm just sharing what worked for me.

The error

When I opened Microsoft's Volume Activation Management Tool (VAMT) and tried to connect to my LocalDB instance as usual, I got this error:

On your gitlab server run gitlab-rails console production

Find your user via user = User.find_by(email: "[email protected]")

Optionally change the user's email with user.email = "[email protected]" Then run user.save!

Get the user's token with user.confirmation_token

https://PutYourGitlabHere/users/confirmation?confirmation_token=PutYourTokenHere

Note

Apple will reject apps that are using private url schemes (Ugh, Apple....) if they are pretty much obvius. Some apps are rejected and others are not, so, be aware of this issue before implementing any of those URL's in your app as a feature.

Updates

[UPDATE 4] iOS 10 update: apparently settings now can be reached using App-Pref instead of prefs
~~[UPDATE 3] For now you just can use url schemes to open your apps's settings with Swift 3.0 (Xcode 8). I'll keep you informed when OS preferences can be reached~~
~~[UPDATE 2] The openURL() method of UIApplication is now deprecated. You should use application(_:open:options:) instead~~
~~[UPDATE 1] Not yet tested in iOS 10. It will fail because of policies changes in URL scheme handling.~~

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

	IFS=$'\n'
	myUser=`whoami`
	echo Local user is $myUser
	SYNO_USER=`psql synofoto -t -c "select id from user_info where name='$myUser'"`
	echo SYNO_USER is $SYNO_USER

	echo Scanning for video files..
	for i in `find . -iname \*.mov -type f \| grep -v eaDir \| grep -v "_3"`; do
	#echo i is $i
	fname=$(dirname ${i})/@eaDir/$(basename ${i})/SYNOPHOTO_FILM_H.mp4;

	#!/bin/bash

	rev="12"

	_log(){
	echo "$(date '+%Y-%m-%d %H:%M:%S') - ${streamid} - $1" >> /tmp/ffmpeg.log
	}

	_log_para(){
	echo "$1" \| fold -w 120 \| sed "s/^.*$/$(date '+%Y-%m-%d %H:%M:%S') - ${streamid} - = &/" >> /tmp/ffmpeg.log