1054 - Unknown column 'm.manufacturers_name' in 'field list' after installing Manufacturers Multilanguage With Description

[zdavatz]

Ok, I risked it and I installed:

 

http://addons.oscommerce.com/info/3521

 

Because I need separate names for the different languages of my manufacturers. I followed the Install Manual but now it get the following error after installing the above Add-On, when I click onto a category ie:

 

http://organicbeauty.ch/index.php/cPath/71

 

I get this error:

 

1054 - Unknown column 'm.manufacturers_name' in 'field list'

 

select p.products_quantity, p.products_weight, m.manufacturers_name, p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '71' order by pd.products_name limit 0, 20

 

Any help is greatly appreciated.

 

Best

Zeno

[Hotclutch]

Ok, I risked it and I installed:

 

http://addons.oscommerce.com/info/3521

 

Because I need separate names for the different languages of my manufacturers. I followed the Install Manual but now it get the following error after installing the above Add-On, when I click onto a category ie:

 

http://organicbeauty.ch/index.php/cPath/71

 

I get this error:

 

1054 - Unknown column 'm.manufacturers_name' in 'field list'

 

select p.products_quantity, p.products_weight, m.manufacturers_name, p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '71' order by pd.products_name limit 0, 20

 

Any help is greatly appreciated.

 

Best

Zeno

 

You need to edit a few bits of code to make it compatible with MySQL v5. It's not that difficult. This will explain how to do it.

[zdavatz]

1. Ok, I done exactly that. And it does not help. I checked all my ( ) before and after

 

left join

 

and

 

from

 

they are all correct. Besides: My original File this not have any of those and my shop was running just fine without them.

 

2. What does this exactly mean: Unknown column 'm.manufacturers_name'? Do I need such a table? If you look at the SQL statements of that add-on, it is slightly irritating to me. They are:

 

ALTER TABLE `manufacturers_info` ADD `manufacturers_name` VARCHAR( 32 ) NOT NULL AFTER `languages_id` ;

ALTER TABLE `manufacturers_info` ADD `manufacturers_description` TEXT NOT NULL AFTER `manufacturers_name` ;

update `manufacturers` m, `manufacturers_info` i set i.`manufacturers_name`=m.`manufacturers_name` where m.`manufacturers_id`= i.`manufacturers_id`

ALTER TABLE `manufacturers` DROP `manufacturers_name`;

 

I ran those in

 

mysql>

 

And know I somehow believe that I am missing the table: manufacturers_name

 

3. My updated Error now is:

 

1054 - Unknown column 'm.manufacturers_name' in 'field list'

 

select p.products_quantity, p.products_weight, m.manufacturers_name, p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by pd.products_name limit 0, 20

 

4. Also my manufacturer box on the left hand side disappeared.

 

5. When I search with the search Function I get:

 

1054 - Unknown column 'm.manufacturers_name' in 'where clause'

 

select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description , categories , products_to_categories where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%li%' or p.products_model like '%li%' or m.manufacturers_name like '%li%' or pd.products_description like '%li%') )

 

Please note the 'where clause' of my error which is not the same to your solutions of the 'on clause' - I have no idea what the difference between the 'where clause' and the 'on clause' are.

 

Thank you for your Feedback.

 

Zeno

[zdavatz]

I ended up installing my backups an creating the table manufacturers_name again by doing:

 

ALTER TABLE `manufacturers` add column manufacturers_name varchar (32);

 

I am still interested in installing an Add-On that gives me the possibility to save a different Manufacturer name for a different language. This is especially usefull for Japanese or Russian or Greek. But above Add-On does NOT do the job.

 

Also see:

http://www.oscommerce.com/forums/index.php?showtopic=317373

 

Best

Zeno

[zdavatz]

Ok, got it to work just fine, please see:

 

http://www.oscommerce.com/forums/index.php?s=&...t&p=1321889

 

Best

Zeno