In WordPress, when a query does not need paging and you only want a limited amount of results, like the last 5 posts, set the ‘no_found_rows’ parameter to true. This prevents WordPress from doing additional work in counting the total matched rows,…
My Monkey Do
A Log of Coding Solutions
Tag: mysql
Migrating Multisite to Single Site
I needed to migrate a site on a multisite installation to a single installation. This article did the trick for the most part. http://beacon.wharton.upenn.edu/404/2011/02/the-return-from-multisite/
WordPress “The plugin generated xxxx characters of unexpected output during activation”
Problem I was developing a plugin for wordpress and receive a messsage: The plugin generated 496 characters of unexpected output during activation Solution I placed the following code at the end of my plugin file, update_option(‘plugin_error’, ob_get_contents()); then looked in…
MAMP – MySQL can’t connect after OS X Crash
Problem I had my macbook open, it went to sleep and I couldn’t wake it up. After holding down the powerbutton for over 10 seconds, it turned on. Everything was fine until I tried to open the MAMP home page.…
WordPress Deactive Plugin
Problem I had a wordpress site where the public side was fine, but the admin side was throwing a Internal Server Error 500 intermittently. I couldn’t figure out what was wrong since I had done no changes, and my host…
mysqldump – Using password: NO error
Problem I need to back up a mysql database on a shared hosting server. I am using the cron job to run a bash file which runs a mysqlcommand. The problem is that I can’t get MySQL to recognize the…
LemonStand eCommerce Notes
Lemonstand is an eCommerce solution that lets you try before you buy. It is very simple to use and virtually no learning curve to develop for. It uses PHP and mySQL. Check it out for yourself here. Below are just…
MySQL Auto Backup
The following commands should be run daily. This will give you a backup for 1 full month. After 1 month the backups will overwrite the oldest files. The %d is the day of the month. GoDaddy: In your Hosting Dashboard…
MySQL UTF-8
Problem: I have a database that needs to accommodate all languages. Currently it is set to the default latin1_swedish_c1. I’m thinking I need to change it to UTF8, but there are so many UTF8 encodings! Solution: “_cs” is for case…
MySQL Query Examples
MySQL examples and queries: http://www.artfulsoftware.com/infotree/queries.php This great resource showed me a simple way to pivot in MySQL. If you have the following tables: CREATE TABLE `project` ( `project_id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL, PRIMARY KEY (`project_id`), )…
