Here is a collection of useful and common mysql commands for managing database users using the command line, perhaps whilst logged in to the server via ssh. The following commands work for MySql and mariaDb. Don’t forget to include the semi-colon at the ends of each command. Continue reading mySQL (mariaDb) Useful User Management Via Command Line
Query caching can really help boost Magento’s performance where common queries are being called often, especially with Magento’s sprawling data structure. Continue reading Enable MYSQL Query Caching
So, I was testing the “this site is using cookies” functionality in Magento. It worked fine on a local environment but failed to work on a test “live” IP address site. I say failed, but it worked fine in IE and Firefox whereas in Chrome hitting the “I agree to cookies” button didn’t set a cookie and redirected. I eventually solved it. Continue reading Magento Cookies not Working in Chrome or Opera on Frontend
Another Magento quickie for when you want to pass a value into your phtml template file that is set/generated inside the controller.
Inside the controller you can do this:
Where $block could be something like
$block = $this->getLayout()->getBlock(“head”) ;
if you wanted to pass the value into the head template.
You can also set a value like this:
Then, inside the phtml template file you can get the value like this
Note you can pass multiple variables through a single $block->assign() like this
This chestnut can drive developer crazy. In Google Chrome hitting “save as” or “view source” will reload the page. On pages where sessions or cookies are cleared (shop checkouts for example), form data is submitted, or the like, then the reloaded source may no-longer be the same as the page you were just looking at. Argh. Here is my solution to the issue. Continue reading Saving the page HTML in Chrome without reloading
So, you have a service running on server startup that you need to stop running. Here is how I stop a service from running on startup on Centos (Red Hat) using chkconfig. Continue reading Centos: remove service from running at server startup
As a web developer I use Chrome a lot. The dev tools are good and, in general, it is a good browser. Sometimes, though, I find some odd behaviour like the browser has cached some DNS settings that I have since changed, or I want to switch the experimental features on or off for some testing. Here is how you get to access those settings and then the page to see all the available option/settings URLs.
Ok, for reasons of general simplicity and familiarity I like to develop my php applications in a Windows environment using WAMP. However, this can be problematic when needing to apply SUPEE patches to development instances of Magento projects.
Ok, so your webserver has crashed. You reboot it and…and…nothing. No website. Your apache / httpd and mysqld services have not restarted along with the server. Here is how to check if they should and make them do so if they aren’t.
The MySQL error “28 from storage engine” basically means “not enough disk space”.
Short and sweet.