Are nid and vid fields the same? The current ecommerce.mysql doesn't create a vid field only the nid field... Should I create the vid field that product.module is calling for? Or should I change the p.vid call to p.nid?
Here is the call... Line 44 of product.module
$result = pager_query(db_rewrite_sql('SELECT n.nid FROM {node} n INNER JOIN {ec_product} p ON n.vid = p.vid WHERE n.status = 1 ORDER BY n.sticky DESC, n.created DESC'), $rows * $columns, 0);
P.S. I added the field to the database and I no longer get the error. I just don't know if the module will function correctly.
Thanks,
Tom
Comments
Comment #1
WithoutaDoubt commentedI had to add the vid field to several other tables... I guess ecommerce.mysql needs to be updated. ???? Or there is some confusion about vid and nid...
I'll let the module programmers comment on how this should be handled.
Thanks very much,
Tom
Comment #2
gordon commentedDon't use ecommerce.mysql. It is no longer required. I only left this there as a reference and will not be in the 4.7 release.
The tables are created by the *.install files
Comment #3
WithoutaDoubt commentedcool, thanks!
-Tom
Comment #4
simeresolved