Hello,
Please can anyone help. I've just installed cs.cart and the banners are not showing on the store front end, I figured the problem was to install the banners management addon but I get this error message:
An error in an SQL query occurred during the add-on installation. The add-on will not be installed.
[color=#B94A48]Table 'thoughtf_studios.cscart_images' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images
(image_id
, image_path
, image_x
, image_y
) VALUES(189, 'common_image_1.jpg', 171, 149);
[color=#B94A48]Table 'thoughtf_studios.cscart_images' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images
(image_id
, image_path
, image_x
, image_y
) VALUES(190, 'common_image_2.gif', 171, 170);
[color=#B94A48]Table 'thoughtf_studios.cscart_images' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images
(image_id
, image_path
, image_x
, image_y
) VALUES(233, 'banner_1.jpg', 940, 400);
[color=#B94A48]Table 'thoughtf_studios.cscart_images' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images
(image_id
, image_path
, image_x
, image_y
) VALUES(234, 'banner_2.jpg', 940, 400);
[color=#B94A48]Table 'thoughtf_studios.cscart_images' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images
(image_id
, image_path
, image_x
, image_y
) VALUES(235, 'banner_3.jpg', 940, 400);
[color=#B94A48]Table 'thoughtf_studios.cscart_images_links' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images_links
(pair_id
, object_id
, object_type
, image_id
, detailed_id
, type
, position
) VALUES(136, 1, 'promo', 189, 0, 'M', 0);
[color=#B94A48]Table 'thoughtf_studios.cscart_images_links' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images_links
(pair_id
, object_id
, object_type
, image_id
, detailed_id
, type
, position
) VALUES(137, 2, 'promo', 190, 0, 'M', 0);
[color=#B94A48]Table 'thoughtf_studios.cscart_images_links' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images_links
(pair_id
, object_id
, object_type
, image_id
, detailed_id
, type
, position
) VALUES(177, 3, 'promo', 233, 0, 'M', 0);
[color=#B94A48]Table 'thoughtf_studios.cscart_images_links' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images_links
(pair_id
, object_id
, object_type
, image_id
, detailed_id
, type
, position
) VALUES(178, 4, 'promo', 234, 0, 'M', 0);
[color=#B94A48]Table 'thoughtf_studios.cscart_images_links' doesn't exist [/color]b[/b][color=#B94A48]:[/color]REPLACE INTO cscart_images_links
(pair_id
, object_id
, object_type
, image_id
, detailed_id
, type
, position
) VALUES(179, 5, 'promo'
Hello,
Did you get this fixed? I suspect it's because your table prefix isn't cs_cart but something else. I am having the same problem. Any help would be appreciated.
Christine
Just figured it out. Here is the solution for anyone else that needs it.
Go to:
/app/addons/banners/database
open data.sql
Replace the table prefix of “cscart_” with your table prefix “xxx_”
Save the file.
[quote name='oopsie' timestamp='1411386183' post='192662']
Just figured it out. Here is the solution for anyone else that needs it.
Go to:
/app/addons/banners/database
open data.sql
Replace the table prefix of “cscart_” with your table prefix “xxx_”
Save the file.
[/quote]
Please post this issue to the bug tracker.