Jump to content

Archived

This topic is now archived and is closed to further replies.

zdavatz

Do not install Manufacturers Multilanguage With Description it does not work

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×