Include yiiGridView Javascript

02 Sep 2013 http://chevronscode.com/yii-include-preload-yiigridview-javascript/

I ended up with the following code at the top of the page (since I'm not using a layout):

Yii::app()->clientScript->registerCoreScript('jquery');
$assetsScriptUrl = Yii::app()->getAssetManager()->publish(Yii::getPathOfAlias('zii.widgets.assets'));
Yii::app()->getClientScript()->registerScriptFile($assetsScriptUrl .'/gridview/jquery.yiigridview.js');

PHP Best Practices

20 Aug 2013 https://phpbestpractices.org/

Things I learned:

It's easy to install PHP-APC for quick opcode caching, and it apparently serves the same purpose as memcached for a single server.
Memcache and Memcached are two different libraries.
There's a different (a small one) in speed between single and double quotes.
Use phpass to store passwords.

Set Up Wordpress For FTP

16 Aug 2013 If it's asking you for FTP login information when you try to update wordpress or a plugin, you don't need to do that! Chances are you don't have permissions correctly configured on that directory. Make sure apache owns the directory. On ubuntu, this will probably work (depending on which user owns apache):

sudo chown -R www-data:www-data /var/www

Add Multiple Unique Indexes - MySQL

15 Aug 2013 alter table users add unique index(id, name, phone);

Bootstrap Span Is Overlapping

15 Aug 2013 Try setting a static width on the span. This ensures responsive knows when to put it on another line. It solved my issues with the spans overlapping.

example: add style="width: 520px" to your div with class="span6"

mysql-client 5.6 or phpmyadmin for mysql 5.6

15 Aug 2013 Mysql-client 5.6 doesn't seem to exist, and you don't need it. Phpmyadmin installs mysql-client 5.5 automatically, and that works with mysql server 5.6. If you're having issues, you probably need to run "sudo dpkg-reconfigure phpmyadmin".

Turn Off MySQL Strict Mode

14 Aug 2013 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

09 Aug 2013 http://stackoverflow.com/questions/10983616/parameterized-queries-in-oursql

pymssql SELECT Always Returns None - Python

07 Aug 2013 apt-get remove python-pymssql

The 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

07 Aug 2013 sudo apt-get install python-dev

Running that command on ubuntu will fix the issue.

If you're installing lxml:

Also try this:

sudo apt-get install libxslt1-dev libxslt1.1 libxml2-dev libxml2 libssl-dev

Older Newer