Skip to content

Instantly share code, notes, and snippets.

View rfay's full-sized avatar

Randy Fay rfay

View GitHub Profile
Processed 25 (12 created, 13 updated, 0 failed, 0 ignored) in 12.2 [status]
sec (123/min) - continuing with 'Lesson'
Processed 0 (0 created, 0 updated, 0 failed, 0 ignored) in 0.2 sec [completed]
(0/min) - done with 'Lesson'
Timer Cum (sec) Count Avg (msec)
page 26.84 1 26840.44
destination import 22.239 50 444.789
node_save 8.869 50 177.38
MigrateSourceMSSQL performRewind 1.403 1 1402.5
mssql_query 1.402 1 1401.57
Migration failed with source plugin exception: <em class="placeholder">mssql_query(): message: Unicode data [error]
in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC
version 3.7 or earlier. (severity 16)
$cat_query = "
SELECT tct.CategoryType, tc.CategoryDescription
FROM TSL_User_Categories tuc
LEFT JOIN TSL_Categories tc ON tc.CategoryId=tuc.CategoryId
LEFT JOIN TSL_CategoryTypes tct ON tc.CategoryTypeId=tct.CategoryTypeId
WHERE tuc.SubscriberId=" . $row->SubscriberID;
try {
$result = mssql_query($cat_query);
while($row = mssql_fetch_assoc($result)) {
SELECT TOP 100 pi.SubscriberId,
STUFF((
SELECT ',' + tct.CategoryType + '=' + tc.CategoryDescription
FROM TSL_User_Categories tuc
LEFT JOIN TSL_Categories tc ON tc.CategoryId=tuc.CategoryId
LEFT JOIN TSL_CategoryTypes tct ON tc.CategoryTypeId=tct.CategoryTypeId
WHERE pi.SubscriberId=tuc.SubscriberId
FOR XML PATH('')),1,1, '') AS categories
FROM TES_Connect_SML.dbo.TES_PROFILE_PERSONALINFORMATION pi
GROUP BY pi.SubscriberId
diff --git a/docroot/modules/user/user.install b/docroot/modules/user/user.install
index b573e72..e51a614 100644
--- a/docroot/modules/user/user.install
+++ b/docroot/modules/user/user.install
@@ -708,207 +708,207 @@ function user_update_7011() {
* Add the user's pictures to the {file_managed} table and make them managed
* files.
*/
-function user_update_7012(&$sandbox) {
-
@rfay
rfay / Jquery Module 1 Lab.markdown
Created September 27, 2015 17:45
Jquery Module 1 Lab
; Configuration for xdebug; the main file is xdebug.ini
xdebug.remote_enable=1
xdebug.remote_host=10.0.2.2
; xdebug.remote_port=9000
; you can comment the next line once Xdebug is working
xdebug.remote_log=/tmp/xdebug.log
@rfay
rfay / mandrill-webhook.txt
Last active December 21, 2015 03:49
Problem files for mandrill POST truncation
mandrill_events=%5B%7B%22event%22%3A%22inbound%22%2C%22ts%22%3A1376432762%2C%22msg%22%3A%7B%22raw_msg%22%3A%22Received%3A+from+nm16-vm3.bullet.mail.ne1.yahoo.com+%28nm16-vm3.bullet.mail.ne1.yahoo.com+%5B98.138.91.146%5D%29%5Cn%5Ctby+ip-10-246-30-150+%28Postfix%29+with+ESMTPS+id+446AA4A809A%5Cn%5Ctfor+%3Cmessages%40reply.warmshowers.org%3E%3B+Tue%2C+13+Aug+2013+22%3A26%3A00+%2B0000+%28UTC%29%5CnReceived%3A+from+%5B98.138.101.130%5D+by+nm16.bullet.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnReceived%3A+from+%5B98.138.101.169%5D+by+tm18.bullet.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnReceived%3A+from+%5B127.0.0.1%5D+by+omp1080.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnX-Yahoo-Newman-Property%3A+ymail-3%5CnX-Yahoo-Newman-Id%3A+226712.86001.bm%40omp1080.mail.ne1.yahoo.com%5CnReceived%3A+%28qmail+32961+invoked+by+uid+60001%29%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnDKIM-Signature%3A+v%3D1%3B+a%3Drsa-sha256%3B+c%3Drelaxed%5C%2Frelaxed%3B+d%3Dyaho
@rfay
rfay / gist:6066776
Created July 23, 2013 22:36
curl -XGET http://localhost:9200/logstash-2013.07.23/_mapping?pretty
{
"logstash-2013.07.23" : {
"_default_" : {
"_all" : {
"enabled" : false
},
"properties" : {
"@ message" : {
"type" : "string"
},
@rfay
rfay / gist:6066738
Created July 23, 2013 22:29
curl -XGET 'http://localhost:9200/logstash-2013.07.23/_search?sort=@timestamp:desc&pretty'
{
"took" : 34,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 933840,