Help - I've killed my shop!!!

[E.K.A]

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) 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???!!

[crazycucumber]

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');

[E.K.A]

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:

<?php
/**
* Module Template - categories_tabs
*
* Template stub used to display categories-tabs output
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_modules_categories_tabs.php 3395 2006-04-08 21:13:00Z ajeh $
*/

include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CATEGORIES_TABS));
?>
<?php if (CATEGORIES_TABS_STATUS == '1' && sizeof($links_list) >= 1) { ?>
<div id="navCatTabsWrapper">
<div id="navCatTabs">
<ul>
<?php for ($i=0, $n=sizeof($links_list); $i<$n; $i++) { ?>
<li><?php echo $links_list[$i];?></li>
<?php } ?>
</ul>
</div>
</div>
<?php } ?>

Any takers

Off to follow your advice now...

[E.K.A]

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]

[crazycucumber]

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.

[E.K.A]

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:

<?php
/**
* Module Template - categories_tabs
*
* Template stub used to display categories-tabs output
*
* @package templateSystem
* @copyright Copyright 2003-2005 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: tpl_modules_categories_tabs.php 3395 2006-04-08 21:13:00Z ajeh $
*/

include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CATEGORIES_TABS));
?>
<?php if (CATEGORIES_TABS_STATUS == '1' && sizeof($links_list) >= 1) { ?>
<div id="navCatTabsWrapper">
<div id="navCatTabs">
<ul>
<?php for ($i=0, $n=sizeof($links_list); $i<$n; $i++) { ?>
<li><?php echo $links_list[$i];?></li>
<?php } ?>
</ul>
</div>
</div>
<?php } ?>

Any takers

Off to follow your advice now...

[crazycucumber]

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




.../includes/filenames.php

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

[crazycucumber]

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 !