MySQL search and replace using update, set
[code language=”sql”]
UPDATE table SET column = replace(tablefield, "search", "replace");
[/code]
[code language=”sql”]
UPDATE table SET column = replace(tablefield, "search", "replace");
[/code]
[code] ddlMyDropdownList.Items.Clear() [/code]
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….
So, this is a WordPress Blog. Heck, if you’re reading this in the near future, it’s probably a WordPress blog with a default theme still on it. I wanted to get an XML sitemap made for this blog to submit it to Google. Not that traffic to this site is going to make me rich…
Google Adwords conversion tracking can be a useful tool. Some of the data can be found and or linked in from Google Analytics, but it’s not always as reliable or as easy to read as straight sale conversion tracking. To add sale conversion follow these steps. 1. Open the template file at /app/design/frontend/{interface}/{layout}/checkout/success.phtml Add this…
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 you want to run a few stores from one master admin in magento. Luckily, they make it easy to do. First thing’s first, secure the urls you need for your store. For my example, I’m gonna use www.evermoremagento.com as the main store and www.substore1.com as the secondary store. I’m assuming you want to keep…