I am trying to copy an entire Umbraco site to create a duplicate.
After some research here on the forum I have taken the following steps:
1. Backup database (MySQL) and Restore to new database (both on same server)
2. Copied entire site files from existing folder to new folder (again both on the same server)
3. Modified web.config connection string to point to new database
I am running IIS 6 on Windows Server 2003, Umbraco 4.0.3 and this is all happening on the same box.
My problem is that:
a. If I try to browse the new site, all I'm getting is 404 errors
b. If I go to the umbraco/umbraco.aspx page, I can log in, but all I get is this error:
Server Error in '/' Application.
Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[IndexOutOfRangeException: Index was outside the bounds of the array.] umbraco.cms.presentation._umbraco.Page_Load(Object sender, EventArgs e) +1716 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 umbraco.BasePages.BasePage.OnLoad(EventArgs e) +15 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
As far as I can tell, the new site is set up just the same as the existing one in IIS and everything I've read says the steps I've taken should have worked.
3a -> you'd need to publish the entire site again, right click on any top level node and select 'Publish' from the context menu. Additionally, select 'Republish entire site' from the 'Content' node.
3b -> sounds odd, and no idea what could be the issue here.
I have tested the new site using the old database and it works just fine.
I have tried dropping and recreating the new database (by backup/restore and by dumping the SQL and running it on the new db) and every time I'm getting the same error.
I guess it's down to a db issue, but I can;t figure out what...
Great debugging to deterimine that it is the database. I've done this exact thing loads of times and never had a problem... but I use MSSQL, not MySQL. Perhaps there's something unique to MySQL and the way it does backup/restore or that some table constraint isn't being maintained? It sounds like a MySQL issue.
I know that's not much help, but as you say, it narrows down the places to look.
Are there specific backup/restore tools for MySQL? Or do you have to script the tables and data as sql statements? Hopefully the former. If the latter, try this... install umbraco version "whatever-you-are-running-on-the-live-site" afresh, creating a new MySQL database. Then copy in your files from the backup. Then run your sql scripts to bring in your data.
If that all fails, tell us more about your configuration and maybe someone will have some experience to share.
I'm using NaviCat for MySQL which has Backup/Restore functions built in and I've tried using that to create both compressed and uncompressed backups which I'm then "Restoring" to the new db. It also has a SQL dump option which outputs the SQL scripts to recreate the tables and populate them.
As I say, both methods result in the same error :(
I had considered doing a fresh umbraco install and copying everything across, which I will now definitely try tomorrow morning when I'm back in the office.
I was hoping it would be more simple as the site is a template for a "product" which we're hopefully going to be reproducing many times over. I may have to reconsider my database provider - I much prefer SQL Server in any case, but obviously cost is a factor (how does Umbraco get on with SQL Express?)
Umbraco handles SQL Express fine. My Medium Trust build supports SQL Express user instances for development in VWD Express out-of-the-box if that helps.
Have you checked your MySQL DB collation? I know that that can sometimes cause issues between dev and live sites.
Great point about collation settings by Benjamin. It almost has to be something very simple but not entirely obvious, doesn't it!
Umbraco runs great with MS SQL Server Express. In fact, I've yet to run a site with anything but SQL Express. For very large sites it might be helpful but it's a simple job to upgrade if your site ever needs the extra performance more memory and cpus can give you. But as I say, SQL Express is awesome. And free.
Thanks Benjamin, I'll check the collation in the morning before anything else - Now you mention it, I feel distinctly unsure about it! Tempted to connect to the VPN to check now, but it's late - it'll wait till morning.
Doug - that's good to know - MySQL is a great resource, but I do seem to have more problems with it and TBH my heart belongs to SQL Server. I think I'll be using SQL Express for future projects.
Well, that didn't work either! I did a fresh install, copied all the files across on IIS, then used a SQL dump just to populate all the tables, but it failed. I was able to get into the CMS, but there was nothing there! Tried using the full SQL dump to rebuild the database and I'm back to the same problem. I think I'm going to rebuild the whole thing using SQL Express unless anyone has anything else to suggest?
OK, I've rebuilt the whole thing using SQL Express as the db. Fingers crossed. Incidentally what is the best way to copy the database in SQL Express (I have the 2005 version)
That was utterly painless - successfully copied the whole lot in about 15 minutes - it seems SQL Express is the way to go - thanks to you all for your help : )
I have consistently good luck with a backup/restore procedure:
- right-click the database in SQL management studio
- select Tasks > backup
- create a new/empty database; right-click; Tasks > restore
You may find that you end up with an 'orphaned user'. If so, just google it and you'll find you need to run one query to find the name of the orphaned user and another to fix it. Very simple.
Thanks Doug - worked first time! No problems at all. It's all running on SQL Express now and it's a dream : )
I'm a little frustrated that I couldn't fix the problem with MySQL, but purely because I hate to let a problem beat me - I'm actually much happier and more experienced with SQL Server.
I'll be using SQL Express for this product now as I'm confident I can duplicate/deploy in around 15 minutes (as opposed to the hours I wasted yesterday trying to get it going on MySQL!)
Hi Doug / Olly, sorry for cutting in on your post but I'm having some problems doing as per your steps Doug.
I've also had success up until recently, and while I'm trying to work out where I'm going wrong with a recent problem (see this post if your interested) I've noticed I had more of a struggle restoring the db than normal.
If I created a new database and try to restore from a backup device, I'm getting the message "The backup set holds a backup of a database other than the '(my new database name)' database".
I can get around it by choosing to overwrite the existing db, but I wondering if this is right and whether this is the source of my problem?
Sorry for my ramblings, but I'm a bit stumped and would appreciate someone who knows what they're doing giving me some advice.
When you do the db backup, be sure to set the option to NOT append to an existing backup; this will give you the smallest database backup.
Then, when you restore, go ahead and overwrite the new database you'd created.
And, you might need to handle an orphaned user but you'll see a message about it if you can't log in to the restored database. Otherwise... that should do it.
If you have more problems, start a new thread so we can keep the discussion centralized to each issue.
Lol. Funny you went for this approach. I'm running my site (finally) on GoDaddy shared hosting (hooray!) with MySQL (cause they offer 25 DBs, but only 2 MSSQL DBs, with rubbish backup/restore options, whereas with MySQL I can use HeidiSQL), and I'm having the exact same problem.
Only found this thread after debugging and puzzling through the issue. I initially installed to MySql fine, but it was when I backed up (to a SQL script) and tried to restore on a production server, I was having issues with logging in to Umbraco, plus others.
I also had a few foreign key errors on cmspropertydata (probably due to some bad cleanup when properties are renamed/deleted and the nodes have not been)
SET FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
(remember to set it back to 1 afterward you've created/imported your database)
Issues resolved. If you have a need to not use SQL Server of any flavour, or find that the limit of 1GB RAM or max DB size of 4GB might be a pain, MySql does still seem like a nice way to go without the cost overhead of full-blown SQL Server.
Problem duplicating Umbraco installation
Hi,
I am trying to copy an entire Umbraco site to create a duplicate.
After some research here on the forum I have taken the following steps:
1. Backup database (MySQL) and Restore to new database (both on same server)
2. Copied entire site files from existing folder to new folder (again both on the same server)
3. Modified web.config connection string to point to new database
I am running IIS 6 on Windows Server 2003, Umbraco 4.0.3 and this is all happening on the same box.
My problem is that:
a. If I try to browse the new site, all I'm getting is 404 errors
b. If I go to the umbraco/umbraco.aspx page, I can log in, but all I get is this error:
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
As far as I can tell, the new site is set up just the same as the existing one in IIS and everything I've read says the steps I've taken should have worked.
Can anyone help me out here?
Many thanks,
Olly
your backup/restore scenario should do fine...
3a -> you'd need to publish the entire site again, right click on any top level node and select 'Publish' from the context menu. Additionally, select 'Republish entire site' from the 'Content' node.
3b -> sounds odd, and no idea what could be the issue here.
Cheers,
/Dirk
Thanks for the reply Dirk.
Unfortunately I can't republish the entire site as I can't get into the CMS to do so because of the second issue!!
So it seems I probably just have the one problem, and when that's resolved I can republish.
Anyone else have any idea?
An update...
I have tested the new site using the old database and it works just fine.
I have tried dropping and recreating the new database (by backup/restore and by dumping the SQL and running it on the new db) and every time I'm getting the same error.
I guess it's down to a db issue, but I can;t figure out what...
Hopefully someone can help.
Great debugging to deterimine that it is the database. I've done this exact thing loads of times and never had a problem... but I use MSSQL, not MySQL. Perhaps there's something unique to MySQL and the way it does backup/restore or that some table constraint isn't being maintained? It sounds like a MySQL issue.
I know that's not much help, but as you say, it narrows down the places to look.
Are there specific backup/restore tools for MySQL? Or do you have to script the tables and data as sql statements? Hopefully the former. If the latter, try this... install umbraco version "whatever-you-are-running-on-the-live-site" afresh, creating a new MySQL database. Then copy in your files from the backup. Then run your sql scripts to bring in your data.
If that all fails, tell us more about your configuration and maybe someone will have some experience to share.
Keep us posted.
cheers,
doug
Thanks Doug.
I'm using NaviCat for MySQL which has Backup/Restore functions built in and I've tried using that to create both compressed and uncompressed backups which I'm then "Restoring" to the new db. It also has a SQL dump option which outputs the SQL scripts to recreate the tables and populate them.
As I say, both methods result in the same error :(
I had considered doing a fresh umbraco install and copying everything across, which I will now definitely try tomorrow morning when I'm back in the office.
I was hoping it would be more simple as the site is a template for a "product" which we're hopefully going to be reproducing many times over. I may have to reconsider my database provider - I much prefer SQL Server in any case, but obviously cost is a factor (how does Umbraco get on with SQL Express?)
I'll let you know how I get on in any case.
Cheers,
Olly
Hi Olly,
Umbraco handles SQL Express fine. My Medium Trust build supports SQL Express user instances for development in VWD Express out-of-the-box if that helps.
Have you checked your MySQL DB collation? I know that that can sometimes cause issues between dev and live sites.
Hope this helps.
Benjamin
Great point about collation settings by Benjamin. It almost has to be something very simple but not entirely obvious, doesn't it!
Umbraco runs great with MS SQL Server Express. In fact, I've yet to run a site with anything but SQL Express. For very large sites it might be helpful but it's a simple job to upgrade if your site ever needs the extra performance more memory and cpus can give you. But as I say, SQL Express is awesome. And free.
cheers,
doug.
Thanks Benjamin, I'll check the collation in the morning before anything else - Now you mention it, I feel distinctly unsure about it! Tempted to connect to the VPN to check now, but it's late - it'll wait till morning.
Doug - that's good to know - MySQL is a great resource, but I do seem to have more problems with it and TBH my heart belongs to SQL Server. I think I'll be using SQL Express for future projects.
Cheers guys
Collation on both databases is latin1_swedish_ci (damn!) so I'm going to try the fresh install approach.
Well, that didn't work either! I did a fresh install, copied all the files across on IIS, then used a SQL dump just to populate all the tables, but it failed. I was able to get into the CMS, but there was nothing there! Tried using the full SQL dump to rebuild the database and I'm back to the same problem. I think I'm going to rebuild the whole thing using SQL Express unless anyone has anything else to suggest?
OK, I've rebuilt the whole thing using SQL Express as the db. Fingers crossed. Incidentally what is the best way to copy the database in SQL Express (I have the 2005 version)
Many thanks,
Don't worry, I figured it out.
That was utterly painless - successfully copied the whole lot in about 15 minutes - it seems SQL Express is the way to go - thanks to you all for your help : )
I have consistently good luck with a backup/restore procedure:
- right-click the database in SQL management studio
- select Tasks > backup
- create a new/empty database; right-click; Tasks > restore
You may find that you end up with an 'orphaned user'. If so, just google it and you'll find you need to run one query to find the name of the orphaned user and another to fix it. Very simple.
Let us know how it goes!
cheers,
doug.
Thanks Doug - worked first time! No problems at all. It's all running on SQL Express now and it's a dream : )
I'm a little frustrated that I couldn't fix the problem with MySQL, but purely because I hate to let a problem beat me - I'm actually much happier and more experienced with SQL Server.
I'll be using SQL Express for this product now as I'm confident I can duplicate/deploy in around 15 minutes (as opposed to the hours I wasted yesterday trying to get it going on MySQL!)
Thanks again,
Olly
Hi Doug / Olly, sorry for cutting in on your post but I'm having some problems doing as per your steps Doug.
I've also had success up until recently, and while I'm trying to work out where I'm going wrong with a recent problem (see this post if your interested) I've noticed I had more of a struggle restoring the db than normal.
If I created a new database and try to restore from a backup device, I'm getting the message "The backup set holds a backup of a database other than the '(my new database name)' database".
I can get around it by choosing to overwrite the existing db, but I wondering if this is right and whether this is the source of my problem?
Sorry for my ramblings, but I'm a bit stumped and would appreciate someone who knows what they're doing giving me some advice.
Cheers chaps,
Barney
Barney, that's how I did it, making sure to specify the new db as the target.
As to whether it's the right way, I can't tell you, just that it works!
When you do the db backup, be sure to set the option to NOT append to an existing backup; this will give you the smallest database backup.
Then, when you restore, go ahead and overwrite the new database you'd created.
And, you might need to handle an orphaned user but you'll see a message about it if you can't log in to the restored database. Otherwise... that should do it.
If you have more problems, start a new thread so we can keep the discussion centralized to each issue.
cheers,
doug.
@Olly, yeah it's always been ok before. I've obviously done something but I can't figure out what. Typical! :)
@Doug, ok I'll try that, many thanks.
Hi Olly
did you find any solution. I´m having the axact same problem.
Regards
René
Yes - I binned off MySQL and rebuilt the site using SQL Server Express as the database!
Lol. Funny you went for this approach. I'm running my site (finally) on GoDaddy shared hosting (hooray!) with MySQL (cause they offer 25 DBs, but only 2 MSSQL DBs, with rubbish backup/restore options, whereas with MySQL I can use HeidiSQL), and I'm having the exact same problem.
Will investigate and report back.
Benjamin
I found it! :-D
When running the MySQL migration script, check your admin user ID. Mine changed from 0 to 3. This one simple thing cause me hours of pain last night!
Hope this is useful - it's not an Umbraco bug as such, just be careful with MySQL migration scripts.
Benjamin
User might be not related to any sections in the umbracoUser2app table. Add those assotiations and it will work.
Only found this thread after debugging and puzzling through the issue. I initially installed to MySql fine, but it was when I backed up (to a SQL script) and tried to restore on a production server, I was having issues with logging in to Umbraco, plus others.
Turns out that the MySql dump, by default, has an option set to "Auto value on 0", and the default Umbraco user has a PK of 0. http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_no_auto_value_on_zero
You can turn this off with
I also had a few foreign key errors on cmspropertydata (probably due to some bad cleanup when properties are renamed/deleted and the nodes have not been)
(remember to set it back to 1 afterward you've created/imported your database)
Issues resolved. If you have a need to not use SQL Server of any flavour, or find that the limit of 1GB RAM or max DB size of 4GB might be a pain, MySql does still seem like a nice way to go without the cost overhead of full-blown SQL Server.
is working on a reply...