Drupal 5.7
Mysql 5.0.32
ecommerce 5.x-3.4
i18n 5.x-2.2
ecommerce/product/product_overview:1120
replace this:
$sql = 'SELECT n.nid, n.title, p.* FROM {node} as n, {ec_product} as p WHERE n.vid = p.vid AND n.status = 1'. tablesort_sql($header);
on this way:
$sql = 'SELECT n.nid, n.title, p.* FROM {ec_product} as p, {node} as n WHERE n.vid = p.vid AND n.status = 1'. tablesort_sql($header);
SELECT COUNT( * )
FROM ed_node AS n, ed_ec_product AS p
LEFT JOIN ed_i18n_node i18n ON n.nid = i18n.nid
WHERE (
i18n.language = 'en'
OR i18n.language = ''
OR i18n.language IS NULL
)
AND (
n.vid = p.vid
AND n.status =1
);
SELECT n.nid, n.title, p. *
FROM ed_node AS n, ed_ec_product AS p
LEFT JOIN ed_i18n_node i18n ON n.nid = i18n.nid
WHERE (
i18n.language = 'en'
OR i18n.language = ''
OR i18n.language IS NULL
)
AND (
n.vid = p.vid
AND n.status =1
)
LIMIT 0 , 30
#1054 - Unknown column 'n.nid' in 'on clause'
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | ecommerce.diff | 1.21 KB | jackbravo |
Comments
Comment #1
davepoon commentedSame problem when I selected the Products in the administrator page.
Comment #2
netbear commentedsubscribe
Comment #3
jackbravo commentedI'm having the same issue.
Here's a PATCH.