andreyuhai

How to fix "count(): Parameter must be an array or an object that implements Countable" error

Just run this below command line in terminal and come back to PhpMyAdmin. Now it works fine

sudo sed -i "s/|\s*\((count(\$analyzed_sql_results\['select_expr'\]\)/| (\1)/g" /usr/share/phpmyadmin/libraries/sql.lib.php

source

andreyuhai

Open command line (cmd) and type diskpart. Allow the windows to run it.

type list disk, and find the number of your USB flash disk.

type select disk X, and type the number of the USB disk instead of X.It should say that disk X is now selected.

type clean.

type create partition primary.

andreyuhai

To find differences between two files

grep -w -v -F -f

andreyuhai

Here is a way to import table content into a csv file that I've found on SO.

mysql --user=wibble --password wobble -B -e "use db; select * from vehicle_categories;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > vehicle_categories.csv

Reference

andreyuhai

Try sudo dpkg --configure -a when you get:

gconf2 depends on default-dbus-session-bus | dbus-session-bus; however:
  Package default-dbus-session-bus is not installed.
  Package dbus-user-session which provides default-dbus-session-bus is not configured yet.
  Package dbus-session-bus is not installed.
  Package dbus-user-session which provides dbus-session-bus is not configured yet.
  Package dbus-x11 which provides dbus-session-bus is not configured yet.

andreyuhai

sudo apt-get install autoconf bison build-essential libssl-dev libyaml-dev libreadline6-dev zlib1g-dev libncurses5-dev libffi-dev libgdbm5 libgdbm-dev -y

source

andreyuhai

Add SSH Keys After Fresh Install

chmod 600 ~/.ssh/id_rsa chmod 700 ~/.ssh

Run ssh-add on the client machine, that will add the SSH key to the agent.

Confirm with ssh-add -l (again on the client) that it was indeed added.

andreyuhai

How to use Crawlera proxy with Poltergeist/PhantomJS?

require 'capybara'
require 'capybara/poltergeist'

Capybara.register_driver :poltergeist do |app|
    Capybara::Poltergeist::Driver.new(app, js_errors: false, phantomjs_options: ['--ignore-ssl-errors=true','--load-images=no', '--proxy=proxy.crawlera.com:8010', '--ssl-protocol=any'])
end

andreyuhai

Regexp matching last name, first name and middle name

"Last Name, FirstName Middle Name".match /^(?<last_name>\p{Alpha}+)[,\s]+(?<first_name>\p{Alpha}+)(?: *)(?<middle_name>.+)?$/

andreyuhai

library(caret)
library(ModelMetrics)
library(recipes)
library(neuralnet)
library(sigmoid)

# Create the dataset
tt <- data.frame(multiplier = rep(1:10, times = 10), multiplicand = rep(1:10, each = 10))
tt <- cbind(tt, data.frame(product = tt$multiplier * tt$multiplicand))