ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

2 databases

October 29, 2007 4:55am

Subscribe [2]
  • #1 / Oct 29, 2007 4:55am

    thisconnect.be

    73 posts

    A small question can you do this with upload paths and MSM file paths for the templates to? If so how? If not how to solve this for svn support?

    An other question about EE and SVN. How to handle the fact that we will launch a site soon but continue development on it offline and we wanne update the website later (in a few months). We will have two database with different data. Has anybody found an elegant solution for this?

    Writing custom queries sounds like allot work/testing/not good :p

    Grtz,

  • #2 / Oct 29, 2007 8:12am

    Derek Allard

    3168 posts

    Hi Grtz, I’ve gone ahead and split this from the last thread, since its a different topic, and probably belongs in “how to”. 

    I believe you’re asking “how can I have 2 installations of EE share the same database without a lot of work changing paths and such between each.  If so, then you might find some helpful suggestions in this thread.

  • #3 / Oct 29, 2007 8:22am

    thisconnect.be

    73 posts

    Hi derek,

    Yes i know this everything is already in our svn server but my question whas how to handle this when you are using the MSM.

    We have in total 3 sites but each has their own template folder.
    If know this exists : $conf[‘tmpl_file_basepath’] = “”;
    But how do it for the other sites? Something like?
    $conf[‘tmpl_file_basepath_1’] = “”;
    $conf[‘tmpl_file_basepath_2’] = “”;

    Thanks

  • #4 / Oct 29, 2007 8:26am

    Derek Allard

    3168 posts

    Ah, MSM.  Sorry, I see now, and you’re right that the suggestion wouldn’t work.  In truth, I can’t think of a convenient way if you are exporting the whole database, but I suppose you could get it all set up one time, and then only export and import the tables that have changed.  This could still end up getting messy, and I can’t think of a much nicer way of doing it.  Hopefully someone from the community will have some suggestions for you here.

  • #5 / Oct 29, 2007 8:37am

    thisconnect.be

    73 posts

    Derek,

    I’am sorry if i didnt express myself good. But the problem is that EE is under version control and we are three ppl working on it.

    For one person the path is /Users/xxx/webroot/ for the other person the path is /Users/YYY/webroot/ before the MSM this was working. But now it doesnt because each site in the MSM has an other path so i need a way to fill in the variable for each site.

    Greetings,

  • #6 / Oct 29, 2007 8:39am

    Derek Allard

    3168 posts

    I still can’t think of a good way around this, but let me ask around and see if we can come up with a good solution for you.

  • #7 / Oct 29, 2007 8:43am

    thisconnect.be

    73 posts

    yes please because we are stuck now we cant continue development and we have to go live on friday 😊

  • #8 / Oct 29, 2007 1:15pm

    Derek Allard

    3168 posts

    OK, we use SVN on our own sites, and have many different people accessing them.  In 1.6, many of the paths formerly in config.php are now saved in the database.  This is needed to keep information from conflicting between sites.  Anything that remains, can easily be kept by not putting config.php or path.php in the SVN repository.  That is what we do here at EllisLab.

    I take it that you are exporting and importing the database?  Could you simply only do the tables that have changed information?

    If you are urgently requiring someone to suggest a workflow for you, might I suggest that you make a job posting for this?

  • #9 / Oct 29, 2007 1:46pm

    thisconnect.be

    73 posts

    Derek,

    Well there is the problem we all share one database this way we dont have to import / export data. But this implies that each user has the same settings comming from the database.

    Each user overrulez most of the config params in config.php but there is simply no parameter to overrule the template path for different sites there is only one general template path config.

    Posting a job…by that time i hope we found it ourself 😊 hints from the dev guys are still more then welcome!!

    Greetings and thanks for your thoughts,

  • #10 / Oct 29, 2007 3:52pm

    thisconnect.be

    73 posts

    Ok for those interested we decided to set up a test server and just all develop on that server. I dont like this method of working i think its dangerous when multiple ppl are working on the same template file. But we have no chooise since time is the enemy here.

    Derek,

    will the EE - dev team provide a solution for this in the next update?

    Greetz,

  • #11 / Oct 29, 2007 5:44pm

    Derek Allard

    3168 posts

    We don’t tend to release roadmaps or timelines, but you may consider making a feature request.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases