sql error for image attributes

[tec]

hi there, i installed this contribution images for attributes

 

When i ran the sql in phpmyadmin, it gave me this error

 

SQL-query:

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2

MySQL said:

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Insert into configuration set configuration_title='Large Option

 

does anyone know how to fix this?

 

:'(

[tec]

I am also getting this error since i over wrote the files with the ones in the contribution, i am getting the error in my admin

 

Fatal error: Call to undefined function: tep_output_string() in /home/teclive/public_html/pleated/admin/includes/functions/html_output.php on line 156

 

any help is much appreciated

:blush:

[Guest]

hi there, i installed this contribution images for attributes

 

When i ran the sql in phpmyadmin, it gave me this error

 

SQL-query:

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2

MySQL said: 

 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Insert into configuration set configuration_title='Large Option

 

does anyone know how to fix this?

 

:'(

<{POST_SNAPBACK}>

 

 

Make sure you place the ; at thye end of this line....

You had...

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2

 

Should be

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2;

 

 

Mike

[tec]

Make sure you place the ; at thye end of this line....

You had...

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2

 

Should be

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5,

visible =1 INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2;

Mike

<{POST_SNAPBACK}>

-------------------------------------------------------------------------------------------

 

thank you Mike, i tried opening it in excel, but i could not find it to edit it once it was open, I am not versed well enough to try to fix it in phpmyadmin, any thoughts?

[tec]

I am also getting this error since i over wrote the files with the ones in the contribution, i am getting the error in my admin

 

Fatal error: Call to undefined function: tep_output_string() in /home/teclive/public_html/pleated/admin/includes/functions/html_output.php on line 156

 

any help is much appreciated

:blush:

<{POST_SNAPBACK}>

 

--------------------------------------------------------------

sorry, i made a mistake, i am getting the error on the main page of the cart

Fatal error: Call to undefined function: tep_output_string() in /home/teclive/public_html/roman/includes/functions/html_output.php on line 81

[ubur]

If you go into PHPMyAdmin, Run SQL and just paste in the text it will work.

 

I did have to make another change, and doing this:

 

INSERT INTO configuration_group

SET configuration_group_title = 'Product Attribute Images',

configuration_group_description = 'Use Images for Product Options/Attributes instead of drop lists.',

sort_order =5, visible =1;

INSERT INTO configuration

SET configuration_title = 'Large Option Images',

configuration_key = 'OPTIONS_IMAGES_LARGE',

configuration_value = 'true',

configuration_description = 'Include larger image in pop-up window on product info page',

configuration_group_id = '14',

sort_order =2;

 

 

Added a ";" after visible=1

 

Cory