Need help with installing a contribution

[bittke07]

Brand new to contributions and I don't even know where to start. So guess I'll ask that first.

 

I've downloaded the Attributes Sets Plus from http://www.oscommerce.com/community/contributions,3610 and I used the one that says "Attribute Sets Plus v1.01"

 

I've unzipped the files and know where they are.

 

The first step is to Use the file Linkmatics_AttributeSetsPlus_lct.sql to create new tables in the database. Yep I have NO idea how to do that. I'm guessing I'm supposed to go into the MyPHPAdmin from my control panel but i have no clue what to do from there. Any help you can give me would be greatly appreciated.

[MJP]

go into Phpmyadmin, select your database and click the SQL tab at the top and then copy and paste the code in the box that appears and click Go. That's it.

[bittke07]

That's the first place im stuck at. Not sure what database I pick? Here's what i have.

 

[MJP]

well, what did you name your database when you set it up for OsCommerce? it's that database you select to work with.

[bittke07]

oh ok i see, it named one for me so it would be the osc1.

 

I did it, clicked go, and it tells me:

 

Error

 

SQL query:

 

# The 'drop table' commands should only be uncommented if your are re-installing

# attributes sets plus for any reason. For a first time install they are not required.

# drop table products_attributes_sets;

CREATE TABLE products_attributes_sets(

products_attributes_sets_id int( 11 ) NOT NULL AUTO_INCREMENT ,

products_attributes_sets_name varchar( 50 ) NOT NULL default '',

products_options_id int( 11 ) NOT NULL default '',

PRIMARY KEY ( products_attributes_sets_id )

) TYPE = MYISAM ;

 

MySQL said: Documentation

#1067 - Invalid default value for 'products_options_id'

 

 

 

I'm so confused =( Hey if I pay you will you do it for me? lol.

[MJP]

try this:

 

CREATE TABLE products_attributes_sets (

products_attributes_sets_id int(11) NOT NULL auto_increment,

products_attributes_sets_name varchar(50) NOT NULL default '0',

products_options_id int (11) NOT NULL default '0',

PRIMARY KEY (products_attributes_sets_id)

) TYPE=MyISAM;

[bittke07]

That worked! Thank you SO much!!!!

[bittke07]

UH OH.......ok 1 more question. I went through all of the instructions and changed every line/file etc that it told me to and I was pretty confident that I did everything right. I was especially confident when I went to my attributes page and saw the 'Attributes Sets' link right there under the 'Products Attributes' link. BUT.......of course when I click on Attributes Sets I get: Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

So my question is........do I need to start from the beginning again and go through every single file to see where I messed up? Or is there an easy way to find out exactly where I need to go (crossing fingers for an easy way).

[Brazilianlink]

go into Phpmyadmin, select your database and click the SQL tab at the top and then copy and paste the code in the box that appears and click Go. That's it.

 

Hello!

I am having a similar problem, I'd appreciate very much if you could give me an idea. I am trying to install a contribution called world_zones.sql via myPHPAdmin.

When I select my osc database in myPHPadmin and then click SQL, I can't see at all a browse to select the world_zones.sql file saved in my computer, how can I copy and paste the code??

Thanks in advance.

Regards,

 

BrazilianLink