Quote Originally Posted by nakins View Post
I've been trying to get this thing going and I'm having problems. I uploaded a new install of zen cart, ran the ALTER TABLE query, then I added the NEW/ADD_FILES and then I uploaded the MODIFIED files. I thought that I could then test load the cart to see if it would load the index page, but I got the following error.

1054 Unknown column 'CATEGORIES_ROOT' in 'where clause'
in:
[select cd.categories_name from STORE_categories c, STORE_categories_description cd where c.parent_id = CATEGORIES_ROOT and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1]

What did i do wrong? It would seem that I missed a database modification somewhere. But i didn't anything about this in the instructions. Help!
Ok, I created a site_config.php named www.my.com_config.php and put in the following:

Code:
<?php
	$template_dir = "template_default";
	define('www.my.com','template_default');
?>
I'm still getting the same error.

Btw, someone needs to rewrite these instructions. there are 2 step 4.'s and some more clarity would be nice.