Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help with installing a contribution


bittke07

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

  • 2 months later...
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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...