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'

CommentFileSizeAuthor
#3 ecommerce.diff1.21 KBjackbravo

Comments

davepoon’s picture

Assigned: Unassigned » davepoon
Priority: Normal » Critical

Same problem when I selected the Products in the administrator page.

netbear’s picture

Assigned: davepoon » netbear

subscribe

jackbravo’s picture

Status: Active » Needs review
StatusFileSize
new1.21 KB

I'm having the same issue.

Here's a PATCH.