WebTechKitchen; Your Web Technology Kitchen, contact us to create, or maintain your websites and other digital properties.

If you can't enable your migrate module due to already active configuration

Submitted by barnettech on Wed, 01/23/2019 - 17:08

This was my error message:

complinetmigration already exists in active configuration

This was the solution:

drush sqlq 'SELECT * FROM config WHERE name LIKE "%complinet%";'
drush sqlq 'DELETE FROM config WHERE name LIKE "%complinet%";'
drush sqlq 'DELETE FROM config WHERE name LIKE "%to_D8%";'

also https://www.drupal.org/project/drupal/issues/2877922

Install pip3 for python3

Submitted by barnettech on Thu, 11/08/2018 - 16:29

worked on a mac book pro on 11/08/18

# download and install setuptools
curl -O https://bootstrap.pypa.io/ez_setup.py
python3 ez_setup.py
# download and install pip
curl -O https://bootstrap.pypa.io/get-pip.py
python3 get-pip.py

To stay leveraged or not?

Submitted by barnettech on Thu, 10/11/2018 - 00:52

To stay leveraged or not? That is the question that fires up passions in so many BiggerPockets forum discussions!

Most real estate investors start with some debt (although an all-cash plan is possible, too). But eventually you’ll hit a fork in the road when you must decide how to invest excess cash flow:

Should you continue to save cash for more down payments?
Or should you begin paying off your mortgages?
As I explain in the book, a lot depends upon your personal risk preferences and how big you want to grow your portfolio.

insert into temporary table in sql server

Submitted by barnettech on Thu, 08/09/2018 - 18:33


DECLARE @result1 TABLE(subtype VARCHAR(5), total INT)

INSERT INTO @result1(subtype, total)
select DISTINCT top 2 t.subtype, t.total
from [test] t, [person] p
where (t.[record] = 'fc2765f2-ca90-48c2-a705-d2526c92d56d')
and p.[id] = t.[record]
and (t.[type] = 'SATII')
/*and (t.[rank_confirmed_subtype] = 1)*/
and (confirmed != 0 or confirmed IS NULL)
order by t.[total] desc

select total from @result1