 |
| << | February 2010 | >> |
| Su |
Mo |
Tu |
We |
Th |
Fr |
Sa |
| |
1 |
2 |
3 |
4 |
5 |
6 |
| 7 |
8 |
9 |
10 |
11 |
12 |
13 |
| 14 |
15 |
16 |
17 |
18 |
19 |
20 |
| 21 |
22 |
23 |
24 |
25 |
26 |
27 |
| 28 |
|
|
|
|
|
 |
|
|
|
 mantas Post subject: 5.0.4 to 5.1 migration No accounts or contacts
|
Thu May 21, 2009 3:42 am
Posts: 17
Location: Atlanta, GA
|
| |
 |
I installed 5.1 and migrated from a 5.04 installation. When I click on any links such as Marketing > Accounts or Contacts or Leads I get a blank page. I can do a search and all Accounts and Contacts appear to be there.
Anybody have a similar issue and was able to fix it?
Thanks
|
|
|
|
|
 |
mantas Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
|
Sat May 23, 2009 3:15 am
Posts: 17
Location: Atlanta, GA
|
| |
|
I went and made another attempt at the migration.
I received the following unable to complete query error:
| Code: | ALTER TABLE vtiger_homestuff ADD CONSTRAINT fk_1_vtiger_homestuff FOREIGN KEY (userid) REFERENCES vtiger_users (id) ON DELETE CASCADE
CREATE TABLE IF NOT EXISTS vtiger_user_module_preferences (userid int, tabid int, default_cvid int, primary key(userid, tabid), CONSTRAINT fk_1_vtiger_user_module_preferences FOREIGN KEY (userid) REFERENCES vtiger_users (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_2_vtiger_user_module_preferences FOREIGN KEY (tabid) REFERENCES vtiger_tab (tabid) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8; :: |
Then I received the migration/install is complete message. When I log in, again there are no records under contacts, accounts, leads etc. Also the menu that lets you add a new entry (account, contact etc) is missing. But if I seach for an account it appears.
|
|
|
|
nitin Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
Senior Member
|
Mon May 25, 2009 5:16 pm
Posts: 156
|
| |
|
Hi Mantas,
Sorry for the late reply, can you please tell us that have you migrate your vtiger 504 from any other older version of the vtigercrm or its a fresh vtigercrm 504. as we are not able to reproduce the issue reported by you with migration of 504 to 5.1.0.
Its better if you share some more information on that issue so that we can look into the issue.
_________________
Regards,
Nitin Goyal
Vtiger Team
|
|
|
|
mantas Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
|
Mon May 25, 2009 8:59 pm
Posts: 17
Location: Atlanta, GA
|
| |
|
Thanks for your reply.
I did not update the 5.0.4 from an earlier version.
vtiger is running on CentOS 5, php 5.1.6.
During install I select 'migration' and enter the path to the previous installation. The vtigercrm510 database with 416 tables is created. I do receive the above error message, but then I get the page that states that the installation is complete.
I can log in fine, but no entries appear. I can search for account names and they appear but none of the associated data (contacts, leads, notes etc) are visible under 'More Information'.
Let me know if I can give you any further information
|
|
|
|
nitin Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
Senior Member
|
Wed May 27, 2009 11:26 am
Posts: 156
|
| |
|
Hi Mantas,
We are able to reproduce the issue and we will fix this issue in our upcoming release, i have reported this issue on our track (http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/5972#preview)
For now you can do one thing in place of the failed query,
CREATE TABLE IF NOT EXISTS vtiger_user_module_preferences (userid int, tabid int, default_cvid int, primary key(userid, tabid), CONSTRAINT fk_1_vtiger_user_module_preferences FOREIGN KEY (userid) REFERENCES vtiger_users (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_2_vtiger_user_module_preferences FOREIGN KEY (tabid) REFERENCES vtiger_tab (tabid) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
please run this query and you will get the list view back:
CREATE TABLE IF NOT EXISTS vtiger_user_module_preferences (userid int, tabid int, default_cvid int, primary key(userid, tabid)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
_________________
Regards,
Nitin Goyal
Vtiger Team
|
|
|
|
nitin Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
Senior Member
|
Thu May 28, 2009 6:31 am
Posts: 156
|
| |
|
Hi Mantas,
This is happening because the tables vtiger_tab and vtiger_users in this setup are not of type InnoDB, but of type MyISAM.
MyISAM type tables do not support constraints, nor do Vtiger support MyISAM type tables.
Vtiger tables strictly needs to be of type InnoDB. We make sure they are InnoDB tables through our Installation and migration scripts.
_________________
Regards,
Nitin Goyal
Vtiger Team
|
|
|
|
mantas Post subject: Re: 5.0.4 to 5.1 migration No accounts or contacts
|
Sun Jun 21, 2009 9:48 pm
Posts: 17
Location: Atlanta, GA
|
| |
|
First of all thanks a lot to Nitin for looking in to this after I emailed him my mysqldump file.
As stated above, the problem was the use of MyISAM type tables in my original 5.0.4 installation. Why this happened I don't know, but I was able to resolve the problem by modifying my mysqldump file to only use InnoDB tables, installing the database and then running the regular 5.1 migration.
Everything appears to work fine.
|
|
|
|
|
|
| |
