Insert .sql file help

[opsrcs]

I have been banging around with the Product Attributes - Option Type Feature contribution trying to get it to work.

 

In step 3 of the included readme file see below:

 

STEP 3. Set up your TEXT Option Value.

 

 

Add a new record to the table products_options_values.

 

 

 

You can either use the enclosed insert_text_option_value.sql or you can manually update the table.

(Note: The file will create three entries with products_options_values_id=0. One with language_id=1 (English), one with language_id=2 (German), and one with language_id=3 (Spanish). If you use other languages then you must create a new entry for each additional language.)

 

 

 

products_options_values_id language_id products_options_values_name

An id that is unique to the table. Recommend 0 if it is unique or last id + 1. Set to your language id TEXT

 

 

 

IMPORTANT: You should create *exactly one* TEXT Option Value. Once you create this value, you should not change it.

 

it talks about using the enclosed insert_text_option_value.sql file OR doing the manual thing. I keep getting error messages when using the enclosed .sql file and I don't know enough SQL on my own to figure out the rest of the information needed to manually create the field.

 

Anyone care to enlighten a poor soul?

[Jack_mcs]

What's the error?

 

Jack

[opsrcs]

ERROR

SQL query:

 

INSERT INTO products_options_values( products_options_values_id, language_id, products_options_values_name )

VALUES ( 0, 1, 'TEXT' )

MySQL said:

 

 

Thats all it says.

[opsrcs]

This is the .sql file I am trying to insert:

 

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 2, 'TEXT');

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 3, 'TEXT');

 

 

 

How can I break that down and just enter the information manually?

[Jack_mcs]

You can select that table and then the add a filed option. But the error being displayed would worry me. There should be more information and that might indicate a larger issue. I don't have a fix for you but I would try to find the reason it is doing that.

 

Jack

[opsrcs]

When I use the ADD FIELD option there are more values there that need input than provided in the .sql file

[opsrcs]

Selfless bump because the duct-tape holding my head together is starting to wear out.

[Jack_mcs]

When I use the ADD FIELD option there are more values there that need input than provided in the .sql file

Then they can probably be ignored. You could also paste the changes you want to make right into the sql window (click on the sql tab).

 

Jack

[opsrcs]

When I go to add a new field using phpmyadmin this is what I see:

 

Field -- Type -- Length/Values -- Attributes -- Null -- Default -- Extra

 

 

Type has a dropdown box with 26 choices (VARCHAR,TEXT,INT, etc).

 

Attributes has a dropdown box with 3 choices (it looks like its not a mandatory choice)

 

Null is 2 choices (not null, null)

 

 

 

If anyone has this mod installed can you please take a look at your products_options_values table and post what you see.