Help - I've killed my shop!!!

Hi All,

Complete newbie here out of his depth but refusing to admit it.

I have got Zen Cart installed and a pre-installed template running.

Then I tried to do something fancy (b.t.w A sticky on "How to back up" wouldn't go amiss:blink:) by installing one of the downloads on this site.

It was for zone shipping and I have Smart FTP installed.

After I uploaded the new files I got this:

1146 Table 'eskrimak_root.TABLE_METATAGS_CATEGORIES_DESCRIPTION' doesn't exist
in:
[select * from TABLE_METATAGS_CATEGORIES_DESCRIPTION mcd where mcd.categories_id = '0' and mcd.language_id = '1']

Now, in my admin area when I hover over the meta tag features nothing happens. Also, I can't find this menu / file in all the mumbo jumbo through Smart FTP.

Can anybody spare my considerable blushes???!!:oops:

Take a look at the file

..../includes/database_tables.php

make sure the file exists / and the following line is present:-

Line #52 : define('TABLE_METATAGS_CATEGORIES_DESCRIPTION', DB_PREFIX . 'meta_tags_categories_description');

Thanks very much for your reply. I was just looking at the control panel and it says something was wrong with my:

pl_modules_categories_tabs.php on line 14

This is that file:

Any takers :unsure:

Off to follow your advice now...

Well, I inserted that code and the header comes back up but the rest of the home page is obscured by:

Warning: main(includes/modules/FILENAME_CATEGORIES_TABS.php) [function.main]: failed to open stream: No such file or directory in /home/eskrimak/public_html/shop/includes/templates/template_default/templates/tpl_modules_categories_tabs.php on line 14

Warning: main(includes/modules/FILENAME_CATEGORIES_TABS.php) [function.main]: failed to open stream: No such file or directory in /home/eskrimak/public_html/shop/includes/templates/template_default/templates/tpl_modules_categories_tabs.php on line 14

Warning: main() [function.include]: Failed opening 'includes/modules/FILENAME_CATEGORIES_TABS.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/eskrimak/public_html/shop/includes/templates/template_default/templates/tpl_modules_categories_tabs.php on line 14
1146 Table 'eskrimak_root.TABLE_EZPAGES' doesn't exist
in:
[select * from TABLE_EZPAGES where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title]

:(

sounds like you have some corrupted uploads or incomplete uploads. there is nothing wrong with that file , but possibly the modules that it is calling are missing / not named .

If you did your overides correctly , and have not altered core code , I would be tempted to re upload the shop source code , or at least try and locate missing files by selecting , don't overwrite. then it will only replace and missing files if there are any.

Thanks very much for your reply. I was just looking at the control panel and it says something was wrong with my:

pl_modules_categories_tabs.php on line 14

This is that file:

Any takers :unsure:

Off to follow your advice now...

think our posts crossed ! - anyway the file that is wrong now is :-

.../includes/filenames.php

Line #165 : define('FILENAME_CATEGORIES_TABS','categories_tabs.php');

and also again

includes/database_tables.php

Line #42 : define('TABLE_EZPAGES', DB_PREFIX . 'ezpages');

try reuploading those 2 files from the original - otherwise we will be adding lines forever !