PHP Fatal error: 1060:Duplicate column name 'products_id'

[swguy]

If you look at admin/includes/classes/products_with_attributes_stock.php line 389, you're going to see that it calls numberRows() with a string that looks like this:

SELECT DISTINCT pa.products_id, pd.products_name, p.products_quantity, p.products_model, p.products_image, p.products_type, p.master_categories_id, p.products_id

Just remove the last part (, p.products_id) so it looks like this:

SELECT DISTINCT pa.products_id, pd.products_name, p.products_quantity, p.products_model, p.products_image, p.products_type, p.master_categories_id