Category Archives: Software Tips

Count occurrences both greater than, less than, or equal in MySQL

  SELECT COUNT(recycled) AS “Total”, SUM(CASE WHEN recycled = 1 THEN 1 ELSE 0 END) AS “New”, SUM(CASE WHEN recycled > 1 THEN 1 ELSE 0 END) AS “Recycled” FROM (a SELECT phone_number, count(*) AS recycled, sale_date FROM ( SELECT DISTINCT * FROM ( SELECT customers.phone_number, customers.sale_date FROM customers INNER JOIN ( SELECT customers.phone_number FROM customers WHERE sale_date BETWEEN ‘2014-05-23’ AND ‘2014-05-30’) list on customers.phone_number = list.phone_number ORDER BY phone_number DESC, sale_date DESC ) AS multiple_sales ) AS sale_dates_analysis GROUP

GoDaddy send message error on Thunderbird [SOLVED]

Reader question (Solved, see below) Yo hoss.. Any chance you could team viewer on to my computer this morning and look at my JSO email. I have been having sending issues for a long time now, and just can’t seem to get it fixed. Every time I try and send something (especially with an attachment) I get the following error message: Most of the the time it asks me to enter my password again…. Thoughts? Answer: Please check your outgoing SMTP

SQL Server database and table listing

I generally work with MySQL, not MS SQL Server. So when I needed some basic automated info about a SQL Server’s database/table layout I was thankful for the following two pages: Get list of databases from Sql Server – Stack Overflowhttp://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-serverHow can I get the list of available databases on a SQL server instance? I’m planning to make a list of them in a combo box in vb.net. Get a list of all database on a SQL Server: SELECT name

Enable PHP error reporting on Turnkey LAMP Stack

Recently while using Turnkey Linux I had some PHP scripts that were totally blank. This was just a local test server and I had a pretty good idea there were some PHP errors so I enabled PHP error reporting. If you are on a production server you would probably NOT want to do this. However, if you are like me and just doing some testing, here are the steps to enable error reporting: PHP error reporting is disabled – won’t

Turnkey SSH tunnel for MySQL PHP access

Very useful examples at the Linux Journal: http://www.linuxjournal.com/content/creating-secure-tunnels-ssh and I finally found a connection specification that would work: root@lamp ~# mysql -h localhost -P 3308 -u root -psomepassword vlmdatabase ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysq ld.sock’ (2) root@lamp ~# mysql -h localhost -P 3308 -u root -psomepassword vlmdatabase ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysq ld.sock’ (2) root@lamp ~# mysql -h 127.0.0.1 -P 3308 -u root -psomepassword vlmdatabase The last one

Keyboard not working Windows 7 [solved]

Q. My keyboard just stopped working and I have tried plugging in other USB keyboards to no avail 🙁 any suggestions? -Steve A. Check and see if ‘Filter Keys’ is enabled! Use your mouse to: Click the Start Button Select ‘Control Pane’ Select ‘East of Access’ Select ‘Easy of Access Center’ Select ‘Make the keyboard easier to use’ Uncheck the ‘Turn on Filter Keys’ box Hopefully that will help 🙂 Followup from Steve: That worked. Thank you! More info:

Access MySQL server over SSH tunnel using Navicat

Today was my first time to access a MySQL server over a SSH tunnel in Navicat. After a bit of trial and error I was finally able to achieve success 🙂 Here are the main things I learned: #1 On the client machine running Navicat, use the same credentials that you would use if you were at the console of the remote server. In this case localhost and port 3306 #2 On the SSH tab, use the remote server’s IP

Acer Aspire M5 583P wifi driver fix

Q. Here us a wifi driver question from a reader comment: hello, coming to u again for some help, this time im upgrading athe hdd to an ssd on an Acer Aspire M5 583p-9688. here is a rundown on what ive attempted. cloned original hdd to ssd using paragon software ( was successful when i cloned the hdd for the asus laptop). physically swapped the drives. f12 settings changed UFEI boot settings to Legacy, placed SSD on top of the

Page 10 of 17« First...89101112...Last »