After installing the "commerce_node_checkout"-Module, my site shows this error:

EntityMetadataWrapperException: Unknown data property commerce_node_checkout_node. in EntityStructureWrapper->getPropertyInfo() (line 335 of /home/drupalpro/websites/jobboard.dev/sites/all/modules/entity/includes/entity.wrapper.inc).

When I run "drush cron" I get this

WD cron: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jobboard_dev.field_data_commerce_node_checkout_node' doesn't exist: SELECT                       [error]
n.commerce_node_checkout_node_target_id AS commerce_node_checkout_node_target_id, max(e.commerce_node_checkout_expires_value) AS expires
FROM 
{field_data_commerce_node_checkout_expires} e
LEFT OUTER JOIN {field_data_commerce_node_checkout_node} n ON n.entity_id = e.entity_id
LEFT OUTER JOIN {node} node ON n.commerce_node_checkout_node_target_id = node.nid
LEFT OUTER JOIN {commerce_line_item} cli ON e.entity_id = cli.line_item_id
WHERE  (node.status = :db_condition_placeholder_0) 
GROUP BY n.commerce_node_checkout_node_target_id
HAVING  (expires  1
    [:time] => 1406213518
)
 in commerce_node_checkout_expire_load_expiring_nodes() (line 504 of
/home/drupalpro/websites/jobboard.dev/sites/all/modules/commerce_node_checkout/commerce_node_checkout_expire/commerce_node_checkout_expire.module).
Cron run successful.

I have no idea how to proceed. I would be glad to get a hint.

Comments

mstef’s picture

mstef CreditAttribution: mstef commented

Was this a clean install or an upgrade from an earlier version other than beta1?

Liliplanet’s picture

Liliplanet CreditAttribution: Liliplanet as a volunteer commented

Hi mstef, decided to give it another try, but getting the same errors as above EntityMetadataWrapperException: Unknown data property commerce_node_checkout_node.

You asked if it was an upgrade from an earlier version, I'm guessing I installed and uninstalled the module a long time ago, so now when I add a pay to publish node, site just says 'error' and blank page.

I had a look at the instructions and went through the process to migrate from References to Entity reference, no easy job .. still no joy.

Then went into the database to remove all node-checkout entries, website completely died and had to do backup.

Would absolutely love to be able to add your module :)

The question is: if there was entries from an old installation of node_checkout, how do I upgrade or delete to make it work please?

Liliplanet’s picture

Liliplanet CreditAttribution: Liliplanet as a volunteer commented

Solution: I think I got it to work! Yippee!

Uninstall module
Remove the product type (pay to publish)
Remove all rules related to node checkout

Make a backup of your database

In mysql remove references to node_checkout in:

variables
system
field_node_checkout and revision
menu items

and looking good, thank you so much for the module :)

frederico’s picture

frederico CreditAttribution: frederico commented

Liliplanet, you are a genius!!! Thank you. Your solution worked for me. Thanks again for taking the time to share your fix with the rest of us.