CiviCRM Community Forums (archive)

Hi Guys,

I am trying to install a CiViCRM module on a drupal 7.x multisite, which has 2 other sites running inside it.

Now I installed CiviCRM correctly no problems,  but I come to changing this "define( 'CIVICRM_MULTISITE', 1 );" I can not find it in the civicrm.settings.php, is there something I am missing? Can I add the line myself to the config?

Kind regards,

Jamie

My apologies, seems all I need to do is enable it within the multi site configuration in the updated version.

I am currently getting an error on step 2 with "'FROM civicrm_domain cd WHERE cd.id = 1)"

INSERT INTO `civicrm_domain` (`name`, `description`, `version`)
SELECT 'site 2', 'second test site', cd.version FROM civicrm_domain cd WHERE cd.id = 1;

Also isn't SELECT meant to be VALUES?

As I currently can't access the database I have to do this manually

<?php
$con = mysql_connect("localhost","db","pw");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("db", $con);

mysql_query("INSERT INTO civicrm_domain (name, description, version)
SELECT ('site', 'second site', cd.version FROM civicrm_domain cd WHERE cd.id = 1;)") or die(mysql_error());

echo "successfully inserted";


mysql_close($con);
?>

"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 'FROM civicrm_domain cd WHERE cd.id = 1;)' at line 2"

My apologies if this is basic!

Thanks Hershel, that seemed to do it! I will now return the table just to make sure it is inside PAIN working without phpmyadmin!

Kind regards,

Jamie

It's not my website so there we go!

Everything is gone fine so far until step 8 and 9

I can not find the: define( 'CIVICRM_DOMAIN_GROUP_ID', null );

or: define( 'CIVICRM_DOMAIN_ORG_ID'  , null );

Also seems to be missing a step 10?

I am following this:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Multi+Site+Installation

Would it be okay to add those lines myself? with the right ID of course, or is this done somewhere else?

I have disabled the CiviCRM module on each site and this has fixed the people page again, I shall uninstall and try again from fresh.. any help or suggestions would be highly appreciated

edit:

It won't uninstall.. comes up with a blank page, afterwards the module still exists, I will manually destroy everything in the database and FTP and try again..

I did do that on the main site, but not on the added sites under the multi site, I wasn't aware that I needed to do this within every site under the multi-site?

I have ran into a slight other problem after reinstalling CiviCRM, after successfully installing it throws up this error:

Exception: XML data could not be loaded. Make sure you specified the correct path. in IDS_Filter_Storage->getFilterFromXML() (line 220 of /var/www/vhosts/carolinebadley.co.uk/httpdocs/sites/all/modules/civicrm/packages/IDS/Filter/Storage.php).

I believe I need to delete the ConfigAndLog directory as well as the templates_c directory from the previous install that didn't go too well, although I don't seem to have permission through the FTP to do basically anything specifically to that civicrm folder..  strange problem but I read somewhere else on this forum that they should contact the provider for that.

Once that is sorted out I will continue and try the multi-site steps again on the page I mentioned, do you Hershel or anyone  know if with those steps it should work out or if there is any important information missing?

Thanks for your help so far Hershel, I appreciate it.