sql question - installing a purchased template

I have a new installation of zen cart and am installing a template I bought.
Here is the error i get when I choose to insert the new template. I used fantastico to intal the cart first then I ftp'd the inclues, admin, and js, folders for the template into the store root directory.

this is the error
_________________________________________________________
1146 Table 'wwwimag_zc1.wwwimag_zc1_layout_boxes' doesn't exist
in:
[INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes values(NULL,'ZC03C00179','categories_az06_bg.php',1,0,2,0,0) ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
______________________________________________________________

my template sql file includes the text below, do I need to make some other changes to this? Or what should I do to fix this problem?
_________________________________________________
INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes values(NULL,'#tID#','categories_az06_bg.php',1,0,2,0,0);
INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes values(NULL,'#tID#','whats_new.php',1,0,3,0,0);
INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes values(NULL,'#tID#','specials.php',1,0,4,0,0);
INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes values(NULL,'#tID#','featured.php',1,0,5,0,0);
_________________________________________________________

I am using the current version of zen cart and this is the server
Linux 2.6.17.8-grsec

Thanks agin for any help..

the site is located at www.imaging-world.com/store

Jim Bonesho

The template information doesn't go into the root. It should be utilizing the ZC override system and be included in folders like /includes/template and /includes/languages. Were ther instructions with the template?

You need to talk to whomever you bought your template from and ask them to give you "good" SQL code to use.
It appears that they've hard-coded table names into the SQL ... names which don't match yours.

INSERT INTO wwwimag_zc1.wwwimag_zc1_layout_boxes...

You should also confirm what version of Zen Cart the template was designed for, and if it's not built for the version you have installed, get them to update it, or prepare to do an upgrade yourself.

That was the sqy, that I tried to fix here is what they included.

_________________________
INSERT INTO layout_boxes values(NULL,'#tID#','categories_az06_bg.php',1,0,2,0,0);
INSERT INTO layout_boxes values(NULL,'#tID#','whats_new.php',1,0,3,0,0);
INSERT INTO layout_boxes values(NULL,'#tID#','specials.php',1,0,4,0,0);
INSERT INTO layout_boxes values(NULL,'#tID#','featured.php',1,0,5,0,0);
____________________________________

should that work?


Theses are the included instructions..

http://www.imaging-world.com/TEMPLATE_INSTALLATION.html

Thanks

Jim Bonesho

Those instructions don't deal with installing any SQL portion.

Again, you should be asking them:
a) what version of Zen Cart it's designed for
b) how to install the "whole" template, not just how to "activate" the template once installed.