Fighting WinSCP Time-Outs
WinSCP: how to prevent timeouts
That’s a guide to making WinSCP send a dummy command every 30 seconds to keep your connection alive. It’s way better than constantly having to type in your password.
Crontab Mistake
I wanted to run a script every 20 minutes, so I put this into my crontab:
20 * * * * sh script.sh
That’s wrong. That only runs it once every hour 20 minutes into the hour. For example, 20,40 * * * * sh bash.sh would run it twice - 20 and 40 minutes into the hour.
To run the script every 20 minutes like I was expecting:
*/20 * * * * sh script.sh
Include yiiGridView Javascript
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
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
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
alter table users add unique index(id, name, phone);
Bootstrap Span Is Overlapping
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
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
Reference: MySQL: Server SQL Modes
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.