vtiger

[philip]

Hi,

We have released vtigerCRM 5.0.0 Patch3-rc2 (do not apply in production only for testing), this patch will have all the fixes which has been fixed in 5.,0.3-rc2.
For the users who are 5.0,x and need the below fixes mentioned in the following url
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/query?status=closed&milestone=5.0.3&order=priority
can apply the patch.

The patch can be downloaded from the following url
http://nchc.dl.sourceforge.net/sourceforge/vtigercrm/vtigercrm-5.0.0-patch3-rc2.zip

Procedure for migration:
1) Download the patch and unzip it under vtigerCRM home directory
2) Login as admin
3) Go to Settings -> Migration Wizard and follow the procedure as given.
4) After database changes Remove the files and directores given in the Section IV. How to apply the patch in the release notes.
For release notes check the following url
http://sourceforge.net/project/shownotes.php?release_id=481220&group_id=117522

Do post your comments/issues you encounter during migration.

Regards,
Philip

[mahi]

hello,

there is a problem for the database update 5.02 to 5.03
False for :

ALTER TABLE vtiger_parenttabrel ADD CONSTRAINT fk_2_vtiger_parenttabrel FOREIGN KEY (parenttabid) REFERENCES vtiger_parenttab(parenttabid) ON DELETE CASCADE

best

[onwealdandy]

mahi wrote: hello,

there is a problem for the database update 5.02 to 5.03
False for :

ALTER TABLE vtiger_parenttabrel ADD CONSTRAINT fk_2_vtiger_parenttabrel FOREIGN KEY (parenttabid) REFERENCES vtiger_parenttab(parenttabid) ON DELETE CASCADE

best

.. I ran into this a coupld of days ago as well and posted it to trac http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/2949

[mahi]

thank you onwealdandy


i will make the modification manualy.

best

[VinOnTiger]

I'm having problem applayng the patch.

My start configuration is:
Win 2003 + IIS 6.0
PHP 5.1.6
MySql 5.0
vTiger 5.0.2

Aftert copyng the files I've selected the Migration wizard with the first
default option giving all parameters about the live database.
But when I press the Migrate button I've this error:


Both the databases are the same.
Warning: exec() [function.exec]: Unable to fork [echo 'set FOREIGN_KEY_CHECKS = 0;' > dump_vtigercrm502.txt] in C:\vtigercrm5\vtigercrm\modules\Migration\Migration.php on line 130

Warning: exec() [function.exec]: Unable to fork [mysqldump -uroot -paccess0!1 -h 172.18.19.27 --port=3306 vtigercrm502 >> dump_vtigercrm502.txt] in C:\vtigercrm5\vtigercrm\modules\Migration\Migration.php on line 131

Warning: exec() [function.exec]: Unable to fork [echo 'set FOREIGN_KEY_CHECKS = 1;' >> dump_vtigercrm502.txt] in C:\vtigercrm5\vtigercrm\modules\Migration\Migration.php on line 132

Warning: exec() [function.exec]: Unable to fork [cp "C:\Program Files\MySQL\MySQL Server 5.0\bin\dump_vtigercrm502.txt" "C:\vtigercrm5\vtigercrm\dump_vtigercrm502.txt] in C:\vtigercrm5\vtigercrm\modules\Migration\Migration.php on line 134

The Source database dump taken may not contain all values. So please use other option.
Fatal error: Call to a member function query() on a non-object in C:\vtigercrm5\vtigercrm\modules\Migration\MigrationStep1.php on line 133


So I've done a manual dump of the database with thi command

mysqldump -uroot -paccess0!1 -h 172.18.19.27 --port=3306 vtigercrm502 >> dump_vtigercrm502.txt

and I've modified it following the instructions
add SET FOREIGN_KEY_CHECKS = 0; -- at the start of the dump file
add SET FOREIGN_KEY_CHECKS = 1; -- at the end of the dump file

but when I've pressed the migrate button I've got this other error:

Please enter a valid Dump file.

Any idea?
Than you

[VinOnTiger]

I've done more tests resolving some of the problems.

FORK PROBLEM

In Windows, when trying to execute a system call from a PHP script, you receive a warning like "Warning: system() [function.system]: Unable to fork". A related warning message is "Warning: shell_exec() [function.shell-exec]: Unable to execute"

Cause

The most likely cause is insufficient permissions to execute system calls in the web server environment.

Fix

You need to give the application account (network service in this case) read and execute permission to the command shell program, cmd.exe. Typically, permission to this file is explicitly denied as a security measure.

REMAINING PROBLEMS

In Migration Wizard if I choos the first option
I have access to vtiger CRM live database system
I've these errors

1) Both the databases are the same.

2) The Source database dump taken may not contain all values. So please use other option.
Fatal error: Call to a member function query() on a non-object in C:\vtigercrm5\vtigercrm\modules\Migration\MigrationStep1.php on line 133

The first error let me think that the migration has to happen between the distinct servers or there's simply a bug in testing the condition.
So I tried to specify another server as source that has the same databases and settings.
This time I have only the second error:

The Source database dump taken may not contain all values. So please use other option.
Fatal error: Call to a member function query() on a non-object in C:\vtigercrm5\vtigercrm\modules\Migration\MigrationStep1.php on line 133

I've tried with the second option, providing a dump generated with the correct syntax
mysqldump -uroot -paccess0!1 -h 172.18.19.27 --port=3306 vtigercrm502 > dump_vtigercrm502.txt
and I've added

set FOREIGN_KEY_CHECKS = 0;
set FOREIGN_KEY_CHECKS = 1;

as required, but I get this error

Please enter a valid Dump file.


I think that the problem could be about the custom fields
because trying with a new installaztion without custom fields
the migration wizard reports errors but only the ones already known.

It's similar to this ticket
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/1802

my database size is 600Kb


Thank you