Do not install Manufacturers Multilanguage With Description it does not work

[zdavatz 0]

Dear all

 

I yesterday spent a hairpicking day trying to install this extension:

 

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

 

It does not work and will make your life very hard. See:

 

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

 

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.

 

Best

Zeno

[♥geoffreywalton 139]

Looks like you were unable to correct the code to be mysql 5 compliant. It will work fine on server running v4, rather than it not working at all.

[zdavatz 0]

Correct! But I am very willing to test anybodies changes / inputs or continued help in this matter! I have not given up on the idea!

 

Also I do not understand why this table is being dropped:

 

ALTER TABLE `manufacturers` DROP `manufacturers_name`;

 

but not corrected in the code.

 

The author does not use the extension himself, as far as I can tell by his website. That is also a very bad sign if you ask me.

 

http://www.wheeloftime.nl/

 

Best

Zeno

[♥geoffreywalton 139]

Try www.w3schools.com and look at the mysql section.

 

Only the field is being dropped from one table. I expect it is being added to a language version of the table.

[zdavatz 0]

And where would that be? After re-adding that field, everything worked fine again! It seems really strange to me to drop that field. Obviously it is totally missing in the code.

[zdavatz 0]

Ok, I can now proudly claim that this Extension does work for me on my local machine. I will try to reproduce the steps on my Online Machine tomorrow. A lot of the links I read to make it work can be found here:

 

http://friendfeed.com/rooms/oscommerce

 

If you are running on PHP 5.2 and MySQL 5 then

 

1. Ignore the SQL line: "ALTER TABLE `manufacturers` DROP `manufacturers_name`;"

2. If you have array problems remember to fix them according to http://forums.polurnet.com/index.php?showtopic=657#

3. If you have "1054 - Unknown column 'p.products_id' in 'on clause'" problems do the "()" after 'from' and before 'left join' according to http://forums.oscommerce.nl/index.php?show...44444&st=0# and according to the AddOn http://www.oscommerce.com/community/contributions,4654

4. At some point you may also trip over the "1066 - Not unique table/alias: 'pd'" error. In that case point 3 should help as well.

5. In the very end when I tried to upload the logo of the manufacturer I got another error. In the file admin/manufacturers.php I then changed "TABLE_MANUFACTURERS_INFO" to "TABLE_MANUFACTURERS" and the image was saved like in haven (around Line 81)!

 

Best

Zeno

[shimon 0]

i could not reply earlier and

i see you have succeed installing it.

do you need anything from me?

 

frankly i do not remember that i have done this mod but i see there is my name.

i can guess it was for one of my clients.

[zdavatz 0]

Well can you help me with one thing:

 

I am trying to combine these to AddOns:

 

This Query is from the Manufacturer Multilanguage:

 

$manufacturers_query = tep_db_query("select ma.manufacturers_id, mi.manufacturers_name from " . TABLE_MANUFACTURERS . " ma," . TABLE_MANUFACTURERS_INFO . " mi where ma.manufacturers_id = mi.manufacturers_id and mi.languages_id = " . (int)$languages_id . " order by mi.manufacturers_name");

 

This Query is from the "Empty Manufacturers" AddOn - http://addons.oscommerce.com/info/5476 - :

$manufacturers_query = tep_db_query("select distinct " . TABLE_MANUFACTURERS . ".manufacturers_id, " . TABLE_MANUFACTURERS .

".manufacturers_name, products_id, products_status from " . TABLE_MANUFACTURERS . ", " . TABLE_PRODUCTS . " where " .

TABLE_MANUFACTURERS . ".manufacturers_id = " . TABLE_PRODUCTS .

".manufacturers_id and " . TABLE_PRODUCTS . ".products_status = 1 group

by manufacturers_name");

 

What I want to do is combine the two queries but I have not yet figured out how to do it! I want Multilanguage Manufacturers but I also do not want the Manufacturer name to show if all the products of the manufacturer are set to inactive.

 

Thank you for any Feedback and help.

 

Best

Zeno

[kabuca 0]

how about updating the contribution so someone doesn't have to follow 5 different web sites to find "fixes" to the original contribution?