vtiger CRM 5.0.0 patch3-rc2 is available.

Comments

• 6 Comments sorted by Votes Date Added
• mahi

  January 2007 Vote Up0Vote Down

  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

  January 2007 Vote Up0Vote Down

  "mahi&quot 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 <!-- m --><a class="postlink" href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/2949">http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/2949</a><!-- m -->
• mahi

  January 2007 Vote Up0Vote Down

  thank you onwealdandy
  
  
  i will make the modification manualy.
  
  best
• VinOnTiger

  March 2007 Vote Up0Vote Down

  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

  March 2007 Vote Up0Vote Down

  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
  <!-- m --><a class="postlink" href="http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/1802">http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/1802</a><!-- m -->
  
  my database size is 600kb
  
  
  thank you