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.