Post by Nicklez » Mon Oct 05, 2015 9:11 pm

I know its Mijoshop, but it was working well before, suddenly i cant export anymore:

Unknown column 'cg.name' in 'field list' SQL=SELECT ps.*, cg.name FROM `n6175_mijoshop_product_special` ps LEFT JOIN `n6175_mijoshop_customer_group` cg ON cg.customer_group_id=ps.customer_group_id WHERE ps.product_id BETWEEN 24 AND 719 ORDER BY ps.product_id, name, ps.priority

Someone know what I have to do to solve this?

Plugin link: http://www.opencart.com/index.php?route ... sion_id=17

Newbie

Posts

Joined
Fri Jul 10, 2015 8:06 pm

Post by straightlight » Sat Oct 10, 2015 8:13 am

Ensure that the name field exists from the customer_group table. It looks like you don't have either readings from either customer_group_description table or the name field from the customer_group table. This field has been abolished by recent versions as it has been moved into the customer_group_description table.

Is error message might be showing due to a failed migration process that needed to be done in the past.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 3 guests