Can’t Save Custom Data to sales_order Table

ce-1.4.0.1databasesales

I'm running Mage 1.4.0.1.

With a mysql setup script, I have created a new column "asyncupload_validated" (tinyint(1) not null default 0) to the "sales_order" table.

I try to set this data to 1 and save it.

Here is my code, who doesn't work currently :

$order = Mage::getModel("sales/order")->load($_POST["order_id"]);
$order->setAsyncuploadValidated(1);
$order->save(); 
echo "<p>".$this->__("Your files are now validated.")."</p>";

The code is called (tested with some Mage::log) and the POST var is ok. It seems to be the save() param who is failing.

Best Answer

I would say in version 1.4 (UPDATE!!! REALLY!!!) orders where still eav, so to add a table you should use Mage_Sales_Model_Mysql4_Setup to addAttribute(). If you want it in the sales_order table, just use as type static.

If the attribute is added and the Zend_Db cache is renewed it should be saved.

Related Solutions

Magento CE 1.8.0.0 – sales_order Table Missing After Update

The sales_order table and other tables related to sales are dropped in the upgrade script that changes the structure of the sales entities from EAV to flat.
The actual file is: app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.3.99-1.4.0.0.php.
Near the end of the file there is this code:

// Remove previous tables
$tablesToDrop = array(
    'sales_order_entity_decimal',
    'sales_order_entity_datetime',
    'sales_order_entity_int',
    'sales_order_entity_text',
    'sales_order_entity_varchar',
    'sales_order_entity',
    'sales_order_decimal',
    'sales_order_datetime',
    'sales_order_int',
    'sales_order_text',
    'sales_order_varchar',
    'sales_order'
);

foreach ($tablesToDrop as $table) {
    $table = $installer->getTable($table);
    if (!$installer->tableExists($table)) {
        continue;
    }
    $installer->getConnection()->query(
        'DROP TABLE ' . $installer->getConnection()->quoteIdentifier($table)
    );
}

But the fact that they are dropped shouldn't be an issue. I think the problem comes from a custom module that uses the sales_order table directly, without wrapping it in ->getTable('sales/order'). or it is used like this ->getTable('sales_order').
I suggest disabling your custom modules first (specially those related to sales).
If I'm right and you upgrade you won't be able to use the module in question anyway.

[EDIT] And clear the cache after upgrade.

Magento – Custom cron causing one page checkout deadlocks

Adding a sleep(3) to allow the db to settle in between cancel transactions could be a good workaround.

Best Answer

Related Solutions

Magento CE 1.8.0.0 – sales_order Table Missing After Update

Magento – Custom cron causing one page checkout deadlocks

Related Topic