Ok, this is my first experience with Zen Cart after years of osCommerce. I've installed v1.37 + Multisites from scratch and am still getting this error. I've read every single post in this forum related to this issue (1054 Unknown column 'CATEGORIES_ROOT' in 'where clause') and have followed the install instructions exactly.

Can someone please give a definitive answer as to why this is not working?

I have:

in /public_html/includes/config_sites/www.mysite.org_config.php

define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');
$template_dir = "classic";
define('SITE_NAME','MySite');
define('CATEGORIES_ROOT','1');


in /public_html/includes/configure.php

include_once('includes/config_sites/sites_switch.php');


According to instructions and every post I have read on the subject, this is all that should be required to resolve the issue. But the only way I can get past this so far is to alter includes/modules/meta_tags.php from:

cd where c.parent_id = ".CATEGORIES_ROOT." ....

to

cd where c.parent_id = 1 ....


So it seems like the file meta_tags is not picking up the variable "1" from includes/config_sites/www.mysite.org_config.php. How can that be?