Friday, November 21, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Help  upgraded to 2.1...
 upgraded to 2.1, imported db, having trouble
 
staplebottom
4 posts
www.careerquestions.com
Joined
4/18/2008

upgraded to 2.1, imported db, having trouble
Posted: 18 Apr 08 1:13 PM
hi, I have been using the crm on our local server and was happy with 1.4. We decided to upgrade to 2.1, and to move to a online server, so went ahead and installed 2.1. This went fine. I then imported the xml export from the db from the 1.4 version. It went fine. but now when I am trying to send an email, and trying to choose a contact i get an error, about a label not being found.

I sometimes get errors about the id being on the same page twice.

Does anyone have any advice.?
staplebottom
4 posts
www.careerquestions.com
Joined
4/18/2008

Re: upgraded to 2.1, imported db, having trouble
Posted: 18 Apr 08 1:19 PM
actually i am having lots of errors now. When i try to view the account list it gives me an error about a guid have 32 characters.

Did i upgrade the wrng way?
support
2098 posts
1st
Joined
1/3/2006

Re: upgraded to 2.1, imported db, having trouble
Posted: 18 Apr 08 7:59 PM

It would be helpful to know the exact error text.  You can also send screen captures to our support staff to further describe the problem.

I suspect that you may need to recompile the views.  You can do this from the Admin area, but the best way is to use the SplendidCRM Configuration Wizard. 

 

staplebottom
4 posts
www.careerquestions.com
Joined
4/18/2008

Re: upgraded to 2.1, imported db, having trouble
Posted: 21 Apr 08 4:37 PM
1. it shows only two of my accounts in the list and this error :

Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).


2. on my menus on the left, everyhting is duplicated, I have two of every menu item.

3. When i go to send and email, and click the button to choose a contact i get the following error :

invalid column name 'ADDRESS_TYPE'.


This is where i stopped trying. I can start from scratch. Is it ok to acutally import a 1.4 database to a 2.1 build? What else could be wrong?
support
2098 posts
1st
Joined
1/3/2006

Re: upgraded to 2.1, imported db, having trouble
Posted: 21 Apr 08 6:02 PM

I would have expected the import to work fine.  By why didn't you use the normal upgrade process to go from 1.4 to 2.1?  For best results, you should upgrade by running the SplendidCRM Configuration Wizard on the old database.  It will do everything necessary to upgrade the database.

I suspect that the reason that you have multiple menu entries is because some of these records already existed in the 2.1 database before you imported the 1.4 data.  The import is rather blind and does not make any attempt to determine table uniqueness other than using the ID field.  In the case of menu items, this is not appropriate.

When you import an entire database, it is usually a good idea to truncate all existing data.

 

  Mainstream Forums  Help  upgraded to 2.1...

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.