"unexpected error" crash site when activate order

Thank for the help. This was the case before I deleted anything. I couldn't get order to be re-activate after I de-activate it at the first place. I thought that clearing out commerce of my db will allow fresh install. Any suggestion how to clear it all out and restart?

SOLUTION !!!

After straggling with this many weeks, I finally found a solution which work and managed to cleanly remove commerce (!) and get it to reinstall and activate all its component !!!

I know it is not a clean way, since you need to mess with the DB, but in fact, it is a big issue for many. I found a script which I modified to do all of the above with some addition and it works.

I wish, someone with more knowledge than me, best some commerce guy, will use it to create an uninstall option from commerce, until all the loss ends will come together.

Basically I combined #858722: Cannot reinstall Commerce modules after uninstall due to field deletion failure by improving a script I found in
http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cts=13317....

Here is the process step by step:

1. Disable commerce components one by one or using a single drush command drush pm-disable commerce
2. Uninstall commerce components one by one (if possible). Drush currently can't do it in a single command.
3. Delete folder sites/all/modules/commerce
4. Create a php file under your drupal directory, with a name commerce_cleanup_script.php
5. Paste the following code into it, after replacing myDBname, myDBuser, myDBpass with your DB name, user and password.

<?php

// Select your database 
$db = 'myDBname';

$final_buffer = '';
$buffer = '';

mysql_connect('localhost','myDBuser','myDBpassword', true) or die('Couldn\'t connect to MySQL!' . mysql_error());

$result = mysql_query("delete from $db.system where filename like '%contrib/commerce/%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("DELETE FROM $db.field_config WHERE field_name LIKE '%commerce%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("DELETE FROM $db.field_config_instance WHERE field_name LIKE '%commerce%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 2 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 2 (delete) Success<br />";
}

$result = mysql_query("delete from $db.rules_config where name like 'commerce_%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("delete from $db.rules_trigger where event like 'commerce_%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("delete from $db.variable where name like 'commerce_%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("delete from $db.registry where filename like '%contrib/commerce%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("delete from $db.registry_file where filename like '%contrib/commerce%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("delete from $db.block where module like '%commerce_%'");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 1 (delete) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 1 (delete) Success<br />";
}

$result = mysql_query("TRUNCATE $db.cache_field");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 3 (truncate) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 3 (truncate) Success<br />";
}

$result = mysql_query("TRUNCATE $db.cache_bootstrap");
if (!$result)
{
        // Return an error for this statement
        $buffer .= "Statement 4 (truncate) Did Not Work - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $buffer .= "Statement 4 (truncate) Success<br />";
}

$drop_buffer = "Dropping Tables ...<br /><br />";

// array the table names
$tables = array("customer_address", "customer_billing", "display_path", "line_items", "order_total", "price", "product", "total", "unit_price");

foreach ($tables as $suffix)
{
        $result = mysql_query("drop table if exists $db.drupal_field_data_commerce_$suffix");
        if (!$result)
        {
                // Return an error for this statement
                $drop_buffer .= "[Fail] Did Not Drop $suffix<br />";
        }
        else
        {
                // Return true for this statement
                $drop_buffer .= "[Success] Dropped $suffix<br />";
        }
}

// drop all remaining tables
$result = mysql_query("drop table if exists '$db.%commerce%'");
if (!$result)
{
        // Return an error for this statement
        $final_buffer .= "No Final Tables Dropped - " . mysql_error() . "<br />";
}
else
{
        // Return true for this statement
        $final_buffer .= "Final Tables Were Dropped<br /><br />";
}

$final_buffer .= "Script End";

echo "$buffer<br /><br />";
echo "$drop_buffer<br /><br />";
echo "$final_buffer<br /><br />";

?>

6. In SQl run the following command: show tables like '%commerce%';
7. Drop each if the tables in the list (if still exists).
8. Clear ALL cache (using Drush cc).

Backup your DB which is clean of commerce.

Reinstall commerce, its an incredible module.

Hope it helps.