I had a server that was running Red Hat that threw an error of: PHP Fatal error: Uncaught exception ‘Zend_Cache_Exception’ with message ‘cache_dir ” is not writable The directory it was trying to write to had the apache user as a group member, and group members had write permissions. I even changed the permissions to…
Log cleaning in Magento is great, and they even provide a shell script for cleaning log tables. But sometimes I just want to do it the fast way through the MySQL cli. To do that I run this script. [sql]TRUNCATE TABLE dataflow_batch_export; TRUNCATE TABLE dataflow_batch_import; TRUNCATE TABLE log_customer; TRUNCATE TABLE log_quote; TRUNCATE TABLE log_summary; TRUNCATE…
So, I setup a new e-mail account on Office 365. For two reasons: 1. I like using Outlook and a hosted Exchange instance lets me leverage way more Outlook features than something like Google Apps. 2. I am leaving my current job and will be losing my Word, Excel, etc. software when I do. It…
I’ve had issues from time to time where a sql file won’t import because if has a definer in it that doesn’t match the server I’m trying to import the file to. A simple linux command can replace the definer in these dump files to be the current user allowing everything to work as intended….
I spend a lot of time in magento development now a days, and because of that, I am constantly finding new extensions to help with my clients needs. I cam across something recently that was very cool to me. It’s an extension that allows a magento site to let people design and sell their own…
It doesn’t happen often, but sometimes I need to wipe all products from a magento database during development. Either an import was written slightly off, or it was just full of test data and it’s cleaner to wipe the products instead of deleting them through the admin. A simple script for this found in a…
I had to flush the cache on a Drupal 7 site and couldn’t get to the admin. So, I needed to flush the cache straight on the database layer. Luckily all the cache tables are named cache_{something}. Flushing the cache was as simple as running this command on the database: [code language=”sql”] TRUNCATE TABLE {database_name}.cache_block;…
I was working on a site and needed to have a side nav stick to the top once the header was scrolled off the screen. Positioning it is easy enough on page load, but I wanted to move it with window scroll. First I generated the div with theside nav items in it. Positioned it…
I’ve started to move myself over to Amazon EC2 servers. I still have some at Rackspace and like a lot of what they have to offer, but I think the seemingly lower cost and flexibility offered with EC2 is becoming better suited to my business. But that’s just me right now. The problem is, I…
[code] ddlMyDropdownList.Items.Clear() [/code]