Extreme Newbie Question

[airtap]

Can someone please tell me how to go about adding a contribution to the OSCommerce (2003 version) package? I am obviously new at this. I am using the Vdeck Control Panel interface via my web host who is offering the OSCommerce package. I'm just not sure which directories files go into, and if there are any pitfals I should look for. Any info would be appreciated. Is there a reference manual anywhere?

 

Thanks

 

Jerry P.

[♥bruyndoncx]

start reading up on http://www.oscommerce.info - the Knowledge Base for general information on osCommerce installation and directories. If you are seriously going to add contributions your self, it is worthwile to cover some more of the basic topics before hand so you are more knowledgable overall and comfortable in making changes (after you have backed up your site !)

 

Also different people, freelancers/hosts provide usefull information on osCommerce. If you search google you will find those. In this case 'contributions for dummies' will yield you some interesting results :-"

[gritstoner]

Can someone please tell me how to go about adding a contribution to the OSCommerce (2003 version) package? I am obviously new at this. I am using the Vdeck Control Panel interface via my web host who is offering the OSCommerce package. I'm just not sure which directories files go into, and if there are any pitfals I should look for. Any info would be appreciated. Is there a reference manual anywhere?

 

Thanks

 

Jerry P.

<{POST_SNAPBACK}>

If you have a 'clean' oscommerce i.e no contributions already installed, it is fairly easy. it usually involves just replacing the files on your server with the ones supplied by the contribution. Often you also have to go into phpadmin and run some sql supplied with the contribution to modify or create tables. The actual process of what do do is supplied in the readme file. Contributions only get messy when you have loads already installed...

[Jack_mcs]

First off, you should not install a contribution to your main site, unless it doesn't matter if it goes down or not. It is very easy to break a shop when adding a contribution. Not that you should be afraid to try it, but by installing into a test site, you remove all of the presure of getting it right the first time.

 

Youshould also look in the contributions forum for the supoort thread for whichever contribution you are planning on installing. Read through it and see what problems others had. If you do have a problem with it, that is where you should post your question to get the fastest answer.

 

Installing contributions are part of the joy of having an OSC site. After your first one or two you will be flying through them. :)

 

Jack

[Honza]

If I am not mistaken the unanswered question associated with how do I install involves what I am not getting also.

 

I understand overwriting catalog files or modifing code in the .php files

 

where it gets confusing is when an instruction says eg. in the case of seperate pricing module

 

load the seperate_Pricing_Per_customer_v3.5.sql

 

into your data base.

 

for the experienced this is probably clear but what does that actually mean?

 

After logging into My phpadmin

 

selected customers in database and clicked sql tab ( just took a guess that customer table was the one )

 

selected autodetect in Location of the textfile: and browsed for the .sql file

 

hit go

 

the customers appears to have fields added and a new table created - product groups

 

It seems to work ( did discover deleting original demo cats and products overcame known error when inserting new products - when clean install found that is forum)

 

1062 - Duplicate entry '1' for key 1

 

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('29', '10', '1', '7')

 

[TEP STOP]

 

 

Please correct what I have gone over here if I have missed the plot, I am a newbie and haven't got a clue apart from some trial and error in getting this far.

[DataFirm]

If I am not mistaken the unanswered question associated with how do I install involves what I am not getting also.

 

I understand overwriting catalog files or modifing code in the .php files

 

where it gets confusing is when an instruction says eg. in the case of seperate pricing module 

 

load the seperate_Pricing_Per_customer_v3.5.sql

 

into your data base.

 

for the experienced this is probably clear but what does that actually mean?

 

After logging into My phpadmin

 

selected customers in database and clicked sql tab ( just took a guess that customer table was the one )

 

selected autodetect in Location of the textfile: and browsed for the .sql file

 

hit go

 

the customers appears to have fields added and a new table created - product groups

 

It seems to work ( did discover deleting original demo cats and products overcame known error when inserting new products - when clean install found that is forum)

 

1062 - Duplicate entry '1' for key 1

 

insert into products_groups (products_id, products_price, customers_group_id, customers_group_price) values ('29', '10', '1', '7')

 

[TEP STOP]

Please correct what I have gone over here if I have missed the plot, I am a newbie and haven't got a clue apart from some trial and error in getting this far.

<{POST_SNAPBACK}>

 

Sorry to bring up an old thread. I have been having some problems in tweaking the same mod and have been getting pretty bogged down with code clean up. Thought I would share some findings...

 

Honza,

 

I had the same problem. The SQL stucture is not setup correct. Instead of making the customers_group_id the primary key (which will allow no duplicates), all you need to do is take off the primary key for the customers_group_id (becuase there cannot be two primary keys) and then add another row and call it "row_id" or whatever you want. :D Then make that row the primary key. It seemed to have worked for me.

 

-A

 

(maybe rename the thread...)

[Guest]

I had the same problem with the 1062 duplicate entry. I followed the advice by Aaron but he failed to mention that the new primary key has to be AUTO-INCREMENTING - otherwise you get the same problem. (is it possible that the problem was that the primary key wasn't set to autoincrement in the first place? I can't check now I have already changed the primary key)