Clearing down test orders in Ubercart

Posted by matason on Friday, 23 October, 2009 - 22:10

Setting up and testing a Drupal 6 + Ubercart site with a payment service provider can result in a lot of test orders on the system so here's a quick procedure for clearing them down before handing the site over to the client.

Use at your own risk and ensure you have a back up of your database before you start!

Back up your database.
No really, back up your database, if you make a mistake here your data is gone bye-bye!

Okay, now we can begin.

MySQL Character Encoding Issues

Posted by matason on Monday, 28 September, 2009 - 18:10

These MySQL commands might come in handy when running up against character encoding issues:

mysql> use `your_database`;
Database changed
mysql> show variables like "collation_database";
+--------------------+-----------------+
| Variable_name      | Value           |
+--------------------+-----------------+
| collation_database | utf8_general_ci | 
+--------------------+-----------------+
1 row in set (0.00 sec)
mysql> show variables like "character_set_database";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+