MultiSite Module Support Thread

[nakins]

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:

<?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.

[triad]

hello

thanks for this contribution. as far as I understand I must install an addon domain or parked domain to use this module. but I would like to use this module with seperate ssl certificates (that would mean I should add seperate ip addresses for each domain, if I'm not wrong). Is it possible. or have you got a solution for this situation?

In addition, I suppose this module should work with different servers via putting all files to each servers. but it's going to be hard to update files for per server.

Any comments about installing different ssl certificates for each domain are wellcome. (A possible solution might be using a root domain as secure server but it may seems unprofessional to customers)

[KThompson]

nakins,

your code for "www.yoursite.com_congfig.php" should be

$template_dir = "your_site_template_directory";
define('SITE_NAME','Your Site Name'); 

i.e. mine is

$template_dir = "2fast_shoes";
define('SITE_NAME','Shoes'); 

[nakins]

nakins,

your code for "www.yoursite.com_congfig.php" should be

$template_dir = "your_site_template_directory";
define('SITE_NAME','Your Site Name'); 

i.e. mine is

$template_dir = "2fast_shoes";
define('SITE_NAME','Shoes'); 

I had changed that to:

<?php
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');
$template_dir = "site1";
define('SITE_NAME','site1');
?>

And used site2 for the second config file. I'm still getting the 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]

Where and how is CATEGORIES_ROOT defined?

Thanks

[KThompson]

add this to your www.yoursite.com_config.php

define('CATEGORIES_ROOT','1'); //root categories is 1 for this site 

change "1" to whatever category number you need to show contents of in your category box. 0 will be all categories

hope that helps

[nakins]

Ok, this is still not working.

I started over by deleting my cart dir and I did a drop tables. I uploaded zen cart into /cart. I ran the install and input all the info requested. I renamed the install dir and set the permissions in the configuration.php to 444. I checked
to see if it worked in the browser, and it did.

I uploaded all the ADD files and all the MODIFIED files. I ran the ALTER TABLES query. I added the INCLUDE ONCE line to that file. I created two template dirs in cart/includes/templates. These were 'main' and 'site2', along with 'classic' and 'template_default'. I changed the name in the template_info files to main and site2 respectively. I created two config_site files.

www.mysite.com_config.php

<?php
    define('DIR_WS_CATALOG', '/');
	define('DIR_WS_HTTPS_CATALOG', '/');
	$template_dir = "main";
	define('SITE_NAME','main');
	define('CATEGORIES_ROOT','1'); //root categories is 1 for this site
?>

And another for mysite2.

I added main-site2 to the cats. I tried that and <?--main-site2-->. the last one never could be entered or show up correctly in on the admin page.

I'm still getting this 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]

This isn't fun

[KThompson]

try putting 0 instead of 1 for

define('CATEGORIES_ROOT','1'); //root categories is 1 for this site.

I'm lost if that doesn't work i'll try and make some better instructions for you

[nakins]

Nope, this didn't work either. Could this be a php4/5 issue?

[KThompson]

nakins,

you should private message me. so we can exchange emails. and I'll walk you through it on instant messenger if you'd like.

[marknew]

If a customer signs up on site 1, can they log into site 2 with there login from site 1?