How to have a second manufacturer for a product (HOW TO)

[Salvo]

Hi all

 

It?s my first. (Well half) considering that are only instructions at moment.

 

It will show the way to create a second manufacturer...

 

I use it as a special search facility... but some may use it as a second manufacturer.

 

http://www.oscommerce.com/community/contributions,950

 

If you have any problem or I have omitted something, please post here.

 

Salvo

 

Ps: PLEASE BACK UP YOUR FILES BEFORE START CHANGING THINGS AROUD

 

BACK UP - BACK UP - BACK UP

[valeriestw]

Hi! I tried doing this, and got several errors. I am calling my second Manufacturers dropdown box "Game System."

 

I created the database no problem. On the Admin side, Game System shows up in the Catalog box just under Manufacturers, but when I click on it, I get this error:

 

Game System Action

1054 - Unknown column 'gamesystem_name' in 'field list'

 

select gamesystem_id, gamesystem_name, gamesystem_image, date_added, last_modified from gamesystem order by gamesystem_name limit 0, 20

 

[TEP STOP]

 

On the Catalog side, my header and nav bar shows, it tries to make the categories box (except that it's across the whole screen), but nothing else shows, and I get this error:

 

1054 - Unknown column 'gamesystem_name' in 'field list'

 

select gamesystem_id, gamesystem_name from gamesystem order by gamesystem_name

 

[TEP STOP]

 

 

Let me first say - I am a complete PHP novice. I followed your instructions step by step and copied everything as perfectly as I could. However, I notice there are other files that the manufacturers code references appear that you did not mention (i.e., default.php) and I wonder if I have to do this stuff in every single file? Did you do this and have it work?

 

Let me know if any insights. Thanks!

 

Valerie

[valeriestw]

It turned out that was a database problem after all, but I've corrected those problems and now have all new ones. ;)

 

When I go into Admin, Catalog - Game System appears, but when I click on it, it gives me:

 

 

1054 - Unknown column 'gamesystem_id' in 'where clause'

 

select count(*) as products_count from products where gamesystem_id = '1'

 

[TEP STOP]

 

 

In addition, when I click on Categories/Products, I get:

 

Parse error: parse error in /home/hosting/public_html/catalog/admin/categories.php on line 204

 

 

I've checked the categories.php file and the gamesystem.php files and tried to find a discrepancy in how the code was written for the manufacturers vs. gamesystem, but I'm not finding it.

 

Also, now when I try to click on Catalog, Manufacturers in Admin, I get:

 

 

1146 - Table 'hosting_store.TABLE_MANUFACTURERS' doesn't exist

 

select count(*) as total from TABLE_MANUFACTURERS

 

[TEP STOP]

 

 

On the Catalog side, the store shows up just fine, and even gives me the Game System dropdown box, but the label on it says "BOX_HEADING_GAMESYSTEM." I've checked all the language files to see if I missed something but am not finding that either.

 

Any suggestions, anybody?

[warrenthewindmill]

I have just finished installing this mod and am having similar problems. I did find a few slight errors in the instructions that if you were following to the letter would cause problems.

Did you manage to fix your errors? If so posting what you did here would be helpful.

If not I will try and find a solution and post what I find.

[warrenthewindmill]

In addition, when I click on Categories/Products, I get:  

 

Parse error: parse error in /home/hosting/public_html/catalog/admin/categories.php on line 204  

 

 

I've checked the categories.php file and the gamesystem.php files and tried to find a discrepancy in how the code was written for the manufacturers vs. gamesystem, but I'm not finding it.  

 

Also, now when I try to click on Catalog, Manufacturers in Admin, I get:  

 

 

1146 - Table 'hosting_store.TABLE_MANUFACTURERS' doesn't exist  

 

select count(*) as total from TABLE_MANUFACTURERS  

 

parse errors are very often something simple like a , or ; missing or a missing )

I was getting the table doesn't exist error because my define said:

 

define('TABLE_PAINTERS', 'painters');

 

and when I did find/replace in the relevant files I ended up with TABLE_painters

I didn't realise it was case sensitive. I notice you have mixed case so yours could be a similar problem.

 

On the Catalog side, the store shows up just fine, and even gives me the Game System dropdown box, but the label on it says "BOX_HEADING_GAMESYSTEM." I've checked all the language files to see if I missed something but am not finding that either.  

 

I haven't got the list box but I do have the same error. I'm going back to work to try and solve this. I'll let you know how I get on

[warrenthewindmill]

Of course you have to have an entry in the table before the list box appears. When I entered a record it appeared just fine.

 

On the Catalog side, the store shows up just fine, and even gives me the Game System dropdown box, but the label on it says "BOX_HEADING_GAMESYSTEM." I've checked all the language files to see if I missed something but am not finding that either.

 

My problem was case sensitivity again. Possibly your use of the define does not exactly match the define. Use search to find files with:

BOX_HEADING_GAMESYSTEM. in it and check it matches the define exactly. I notice a full stop at the end of the word GAMESYSTEM could this be your problem?

[Wizard]

I have encountered similar problems to the ones valeriestw had... and checked all my files over and over, and still can't find a way to get it working.

 

I used the name color as my 2nd "manufacturer"

In the ADMIN section I can see the color in the catalog box, but when I click on it I get

 

1054 - Unknown column 'color_id' in 'field list'

 

select color_id, color_name, color_image, date_added, last_modified from color order by color_name limit 0, 20

 

[TEP STOP]

 

In the catalog section, I get the following error on the bottom left column:

 

1146 - Table 'zilnet_osc1.COLOR' doesn't exist

 

select color_id, color_name from COLOR order by color_name

 

[TEP STOP]

 

 

Was anyone successful in correcting the problems they had?

 

Thanks in advance

[Wizard]

Okay, I managed to find a small problem (caps insted of lower case) in my application_top.file, which the error in the catalog section, but now I am getting a new error, which is the same error that appears in the admin section, error 1054.

 

Any clues what that might be?

[bobsi18]

This thread's a bit old, but thought I'd post anyway... I've just (almost) successfully added a second manufacturer, using the contrib http://www.oscommerce.com/community/contributions,2634. A few errors in the contrib, including an error in the SQL statement, but I was (with very little php experience) able to get it - so this really a post to say IT IS POSSIBLE!!!

 

Now all I'm having trouble with is getting it to work with a search... I'll keep trying!

 

~Barbara~