Turn Off MySQL Strict Mode
http://nickbartlett.com/wordpress/how-to-turn-off-mysql-strict-mode/SET @@global.sql_mode= ”; will set it temporarily. (to see if it will fix your problem)
To turn it off permanently, add this setting to your my.cnf (probably in /etc/mysql/my.cnf if you're using ubuntu):
[mysqld]
sql-mode =
If you're having issues getting this setting to work in your my.cnf, look for another my.cnf in /opt/mysql/server-5.6/my.cnf or elsewhere on your system using the "find / -name 'my.cnf'" command.
Using Dictionaries In Python's cursor.execute
http://stackoverflow.com/questions/10983616/parameterized-queries-in-oursqlpymssql SELECT Always Returns None - Python
apt-get remove python-pymssqlThe version from apt-get has this error. Just use easy_install to install pymssql and select statements will work.
error: Setup script exited with error: command 'x86_64-linux-gnu-gcc' failed with exit status 1
sudo apt-get install python-devRunning that command on ubuntu will fix the issue.
If you're installing lxml:
If you're installing lxml:
- http://stackoverflow.com/questions/16149613/installing-lxml-with-pip-in-virtualenv-ubuntu-12-10-error-command-gcc-failed
- http://www.isnull.com.ar/2011/10/ubuntu-11-fatal-error-libxmlxmlversionh.html
Also try this:
sudo apt-get install libxslt1-dev libxslt1.1 libxml2-dev libxml2 libssl-dev
Defcon Ace Badge
WHMCS Hook - Trigger E-mail On New User Sign-Up
This script needs to go into your WHMCS hooks folder (root/includes/hooks/):<?php
function send_invitiation_email($vars) {
$command = "sendemail";
$adminuser = "admin"; // Your admin username
$values["messagename"] = "Google Groups Invitation"; // exact name of e-mail template
$values["id"] = $vars['userid'];
$results = localAPI($command,$values,$adminuser);
}
add_hook("ClientAdd",1,"send_invitiation_email");
?>
Bootstrap Form Builder
http://minikomi.github.io/Bootstrap-Form-Builder/This looks great for non-technical users who want a form built. It's a great response to "Hey, make me a checklist!"...
"You make the checklist the way you want it using this site, then I'll put it on the web."
PHPmyAdmin Loading Slowly (or not at all)
http://future500.nl/phpmyadmin-slow-on-startup/UnicodeEncodeError: 'ascii' codec can't encode character u'\ufffd' in position 12: ordinal not in range(128)
The error in the title will occur on pre-0.12.0 versions of python’s Requests library. It seems to be fixed on later versions and maybe even earlier.
Here’s an example of how you save a zip file from behind a corporate proxy with python’s Requests library:
That’s it! Just use the write function with the content of the returned request.