Imported Database broke site

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
6/8/2008 1:18:30 AM
D0cNet
Gravatar
Total Posts 11
View Posts

Imported Database broke site

Trying to install mojoPortal on a webhost.

The after initial installation, i realized the database on the host was screwed.

So i imported data from my database from my development machine.

They are have the same tables.

However, now whenever i try to edit/add a forum or blog entry i get this:

 

We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page.

I examined the currentlog.config file and found the time stamp it happened.

2008-06-08 02:09:38,445 [4308] ERROR mojoPortal.Web.Global [(null)] - 72.252.29.240-en-US - /ForumPostEdit.aspx?forumid=5&pageid=3
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ThreadID', table ' ....

Could some links have been broken when i imported the data?

6/8/2008 5:27:19 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Imported Database broke site

When you import objects from one database to another a lot gets lost in the import including identity specifications. ThreadID is an auto increment identity column and this was lost during import along with who knows what else, possibly foreign keys, default values, etc.

My recommendation is delete all stored procs then delete all tables and let mojo setup create the correct schema for you.

Hope it helps,

Joe

6/8/2008 2:08:20 PM
D0cNet
Gravatar
Total Posts 11
View Posts

Re: Imported Database broke site

Ok.

The thing is, i have made a few customizations and data entries to blogs and forums.

How do i carry these changes to the newly create site? i.e How do i deploy my own custom site?

6/8/2008 2:32:42 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Imported Database broke site

The normal way to move a populated site from one server to another would require creating a database backup and restoring it on the target machine along with all the files. However, you may need help from your hosting provider to accomplish this as typically the db user will become orphaned when you restore the db and they will have to fix it for you.

However, this process is really for moving a production site from one hosting provider to another where the domain stays the same in both places. You will likely have additional problems moving a site from localhost to a another domain. For example if you posted any images in the blog the urls will be incorrect because they will still point to localhost.

Its really just not a great idea to try and populate a content management system on a dev machine and then move it and its data to production. I do not recommend that approach.

Hope it helps,

Joe

6/8/2008 5:29:55 PM
D0cNet
Gravatar
Total Posts 11
View Posts

Re: Imported Database broke site

ok thanks Joe. I guess i'll just have to start from scratch on the live host, at least i have the dev site to template from.

You must sign in to post in the forums. This thread is closed to new posts.