Help with the Uploading database files

[Graphicpoet]

I have been pretty sure to do everything slow and percise, now I am kinda just stuck. I am not at all versed on database lingo or methodology so I am getting an error trying to install ------option_type_feature.sql-----

 

can i just paste this into the query window as is or do I need to do some manual stuff?

 

ALTER TABLE products_options
 ADD products_options_type INT( 5 ) NOT NULL ,
 ADD products_options_length SMALLINT( 2 ) DEFAULT '32' NOT NULL ,
 ADD products_options_comment VARCHAR( 32 ) ;

ALTER TABLE customers_basket_attributes
 ADD products_options_value_text VARCHAR( 32 ) ;

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (169, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (170, 'Text product option type', 'PRODUCTS_OPTIONS_TYPE_TEXT', '1', 'Numeric value of the text product option type', 6, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (171, 'Radio button product option type', 'PRODUCTS_OPTIONS_TYPE_RADIO', '2', 'Numeric value of the radio button product option type', 6, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (172, 'Check box product option type', 'PRODUCTS_OPTIONS_TYPE_CHECKBOX', '3', 'Numeric value of the check box product option type', 6, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (173, 'File product option type', 'PRODUCTS_OPTIONS_TYPE_FILE', '4', 'Numeric value of the file product option type', 6, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (174, 'ID for text and file oroducts options values', 'PRODUCTS_OPTIONS_VALUE_TEXT_ID', '0', 'Numeric value of the products_options_values_id used by the text and file attributes.', 6, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (175, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, now(), now(), NULL, NULL);
INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (176, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, now(), now(), NULL, NULL);

CREATE TABLE `products_options_types` (
 `products_options_types_id` int(11) NOT NULL default '0',
 `products_options_types_name` varchar(32) default NULL,
 `language_id` int(11) NOT NULL default '0',
 PRIMARY KEY  (`products_options_types_id`,`language_id`)
) TYPE=MyISAM COMMENT='Track products_options_types';

INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (0, 'Select', 1);
INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (1, 'Text', 1);
INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (2, 'Radio', 1);
INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (3, 'Checkbox', 1);
INSERT INTO `products_options_types` (`products_options_types_id`, `products_options_types_name`, `language_id`) VALUES (4, 'File', 1);

 

Thankx for any help in advance.

Graphicpoet.

[Guest]

so you understand phpmyadmin, i would suggest you go search the net for phpmyadmin tutorial, and you will find everything you need to know to use the application.

if i told you how to use it and you messed up on a step, then you may come back and say you were told wrong, thus it is better for you to learn how to use it, as it is most likely available via your host cpanel.

[Graphicpoet]

so you understand phpmyadmin, i would suggest you go search the net for phpmyadmin tutorial, and you will find everything you need to know to use the application.

if i told you how to use it and you messed up on a step, then you may come back and say you were told wrong, thus it is better for you to learn how to use it, as it is most likely available via your host cpanel.

<{POST_SNAPBACK}>

 

 

well thanks for your suggestion and I will do that but this is kinda the LAST Step on a project I share with one other person that needs to be up by monday. SO at least tell what you think of this error and from there I shall seek a solution:

 

Error

 

SQL-query :

 

ALTER TABLE products_options ADD products_options_type INT( 5 ) NOT NULL ,

ADD products_options_length SMALLINT( 2 ) DEFAULT '32' NOT NULL ,

ADD products_options_comment VARCHAR( 32 )

 

MySQL said:

 

#1060 - Duplicate column name 'products_options_type'

 

[Documentation] ? [back]

 

 

Thankx alot Graphicpoet

[♥bruyndoncx]

It just reports that the column already exists, so you probably already executed the query.

Since these queries do not return results, it's not that obvious if it ran successfully.

 

To check if it finished the last step, run the sql query;

select * from products_options_types

 

or select this particular table from the left and use the browse button to see the records

[Graphicpoet]

It just reports that the column already exists, so you probably already executed the query.

Since these queries do not return results, it's not that obvious if it ran successfully.

 

To check if it finished the last step, run the sql query;

select * from products_options_types

 

or select this particular table from the left and use the browse button to see the records

<{POST_SNAPBACK}>

 

 

Thank you Carine,

 

I did as you said: "run the sql query;

select * from products_options_types"

 

I got this:

 

Error

 

SQL-query :

 

SELECT *

FROM products_options_types

LIMIT 0 , 50

 

MySQL said:

 

#1146 - Table 'XXXXXX.products_options_types' doesn't exist

 

[Documentation] ? [back]

 

 

NOW as far as DATA is concerned other than the esthetics of the design there is NO data needed to be saved. From the data perspective this is a "NEW INSTALL." I just do not want it to effect any of the 3 or 4 other contributions already installed on this store site.

 

 

Now I looked for the column to see if it was present, b[/b]ut got this back:

 

 

 

The reason I am being so detailed here is this is the VERY LAST THING I HAVE TO DO to make this contribution operational. I have spent hours merging .php files and rechecking and confirming those merges. I get to this one database install and get stuck. My lack of knowledge of course but still disheartening..... I could pay someone, but I really need to do this.

 

 

here is a link to the data I am trying to put in------The Database content

 

Is there anything I can do here in this area below to put this into the database?:

 

 

[wizardsandwars]

he meant to say, select * from product_options.

 

if you see product_option_types in the results, then you have probably already executed this query. Check to see that the other columns are already included the same way.

[Graphicpoet]

he meant to say, select * from product_options.

 

if you see product_option_types in the results, then you have probably already executed this query. Check to see that the other columns are already included the same way.

<{POST_SNAPBACK}>

 

 

 

Well Chris they always said common sense beats any book or nerd-heavy-manaul .. so thanks for the common approach I did find all the tables and with doing so I also found the missing part of the data and simply pasted it in the sql query window and "WALLA" its all done.

 

 

Thanks

Graphicpoet