By lil-1 on

Hi everyone,

Does somebody know if the multi-domain D6 installing is the same as for D5?
I have this common problem with cookies or js probably when installer stops at step 4 and gives the pink error square:

- user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM your_menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/paretcom/public_html/includes/menu.inc on line 315.
==

I hate it! I like the multisite idea and D6 at the same time and need them both :)
Does anyone know the sollution?

⋅ Categories: Drupal 6.x

Comments

dragonfoundry’s picture

dragonfoundry commented

I wanted to run two separate websites powered by drupal - one under its own domain and the other as an addon domain, using two seperate databases but sharing users which would enable a user can log into both sites with the same creditials.

Firstly I followed this guide http://drupal.org/node/147828 and I got a similar error as stated in your post. After an hour of playing, I came to the conclusion it was the shared tables in the database which were causing problems. I could setup one site fine but the error was reported when I tried to setup the second site.

This is what I did.

1) I created the site for the addon domain first in the normal way by going to addondomainname.com/install.php to setup a user, site email etc

2) I use phpmyadmin to access the prefix shared_ tables and dropped them while leaving the prefixed tables for the site in place

3) I then created the second site under the main domain name by going to maindomainname.com/install.php
and completed the admin details, site details for the second site

The install worked since it recreated the missing shared tables and inserted the admin user data. I was then able to log into to both sites via their urls without difficulty.

Not sure whether it will help but thought I would post just in case.

lil-1’s picture

lil-1 commented

Wow! I told my heart "Don't cry" and installed drup5 meaning to upgrate later when the drup6 is more moduled, but what you say is great, will try it. Thanks!

Cristian.Palmas’s picture

Cristian.Palmas commented

@dragonfly

I tried to understand what you have done but I could not.
What do you mean by "access the prefix shared_ tables and dropped them while leaving the prefixed tables for the site in place"?

I was looking for "shared_tables", "prefix_tables", "prefix_shared_tables", "prefix_shared" and I didn't found any of them.
Can you explain deeply what you did to make your sites work?
Thanks.

~ Cristian Palmas ~

dragonfoundry’s picture

dragonfoundry commented

When you install drupal you can prefix a table so you can use it and identify it for a specific site. For example, I have 3 sites in one database, the tables relating to the seperate sites are prefixed pg_ , pw and dwamh_. They all share the tables prefixed with shared_ such as users, sessions, roles etc.

A prefix is therefore an identifier before the table name.

If you follow the guide on the link posted you might experience difficulty when you try to install your second multisite. The reason is on the first install drupal creates the "shared_" tables, then when you do the second install for next site, drupal tries to create the "shared_" tables once more, which then causes the instalation to fail since they already exist.

In essence to avoid this problem, I used PhpMyadmin to access the prefixed "shared_" tables and dropped them (deleted them) after the first install then installed the second site. I then of course dropped the tables once more before installing the third site.

Since the shared_ tables are used by all three of my sites once the final multisite was installed and the shared_ tables created again I had an admin account for all three sites.

Hope this helps