rslonik

if ($request_uri ~* "onesignal") {
  set $skip_cache 0;
}

rslonik

ERROR 1709 (HY000) at line 59: Index column size too large. The maximum column size is 767 bytes.

SET GLOBAL innodb_file_format = Barracuda;
SET GLOBAL innodb_large_prefix=on;
SET GLOBAL innodb_default_row_format = dynamic;

rslonik

update wp_mailster_subscribers set email = replace(email, '.comm', '.com');
update wp_mailster_subscribers set email = replace(email, '.combr', '.com.br');
update wp_mailster_subscribers set email = replace(email, 'gmail.com.br', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'gamil.com', 'gmail.com');
update wp_mailster_subscribers set email = replace(email, 'hotmal.com', 'hotmail.com');
update wp_mailster_subscribers set email = replace(email, 'homail.com', 'hotmail.com');

rslonik

for site in `ee site list | grep -v example.com | sort | sed 's/\x1B\[[0-9;]*[JKmsu]//g'`
do
	echo $site
	#scp host:file.txt /var/www/$site/htdocs/
done