vtiger

[asknow]

Hi,

I am currently installing vtiger from source and an running into some problems.

Pre
- IIS (on Win server 2003), PHP 5.2.4 and MySQL are already installed and running several web apps succesfully (including MySQL connections to our MySQL DB server).
- I already setup and empty MySQL DB with corresponding user and sufficient rights on the DB server.
- php.ini is configured to match the installation prerequisites.
- IIS has full permissions (since it's a testing environment) on the vtiger installation dir.

Already solved problems
I ran into some basic installation problems I already solved, but which might be applicable: http://forums.vtiger.com/viewtopic.php?p=64482#64482

Problem
On Finish screen I get this message:
Warning: fopen(tabdata.php) [function.fopen]: failed to open stream: Permission denied in D:\www\vtigercrm\include\utils\CommonUtils.php on line 1846
Cannot open file (tabdata.php)

Sounds like some permission thing again, even though IIS has full recursive write permissions on the vtiger dir. In a search on these forums I found the following post:
http://forums.vtiger.com/viewtopic.php?t=15537&highlight=tabdata+php&sid=1231e0064d480165bede689eca7bf3b6. I copied the tabdata.php content in the topic and pasted is into my tabdata.php

Old tabdata.php:
Code: <?php
/*********************************************************************************
  ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   * ("License"); You may not use this file except in compliance with the License
   * The Original Code is:  vtiger CRM Open Source
   * The Initial Developer of the Original Code is vtiger.
   * Portions created by vtiger are Copyright (C) vtiger.
   * All Rights Reserved.
  *
 ********************************************************************************/

//This file contains the commonly used variables

$tab_info_array=array('Home'=>3,'Leads'=>7,'Accounts'=>6,'Contacts'=>4,'Potentials'=>2,'Notes'=>8,'Calendar'=>9,'Emails'=>10,'HelpDesk'=>13,'Products'=>14,'Dashboard'=>1,'Faq'=>15,'Events'=>16,'Vendors'=>18,'PriceBooks'=>19,'Quotes'=>20,'PurchaseOrder'=>21,'SalesOrder'=>22,'Invoice'=>23,'Rss'=>24,'Reports'=>25,'Campaigns'=>26,'Portal'=>27,'Webmails'=>28,'Users'=>29,);

$tab_seq_array=array('3'=>0,'7'=>0,'6'=>0,'4'=>0,'2'=>0,'8'=>0,'9'=>0,'10'=>0,'13'=>0,'14'=>0,'1'=>0,'15'=>0,'16'=>2,'18'=>0,'19'=>0,'20'=>0,'21'=>0,'22'=>0,'23'=>0,'24'=>0,'25'=>0,'26'=>0,'27'=>0,'28'=>0,);
?>


New, manually replaced new tabdata.php from forum:
Code: <?php
/*********************************************************************************
  ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   * ("License"); You may not use this file except in compliance with the License
   * The Original Code is:  vtiger CRM Open Source
   * The Initial Developer of the Original Code is vtiger.
   * Portions created by vtiger are Copyright (C) vtiger.
   * All Rights Reserved.
  *
 ********************************************************************************/

//This file contains the commonly used variables

$tab_info_array=array('Dashboard'=>1,'Potentials'=>2,'Home'=>3,'Contacts'=>4,'Accounts'=>6,'Leads'=>7,'Notes'=>8,'Calendar'=>9,'Emails'=>10,'HelpDesk'=>13,'Products'=>14,'Faq'=>15,'Events'=>16,'Vendors'=>18,'PriceBooks'=>19,'Quotes'=>20,'PurchaseOrder'=>21,'SalesOrder'=>22,'Invoice'=>23,'Rss'=>24,'Reports'=>25,'Campaigns'=>26,'Portal'=>27,'Webmails'=>28,'Users'=>29,);

$tab_seq_array=array('1'=>0,'2'=>0,'3'=>0,'4'=>0,'6'=>0,'7'=>0,'8'=>0,'9'=>0,'10'=>0,'13'=>0,'14'=>0,'15'=>0,'16'=>2,'18'=>0,'19'=>0,'20'=>0,'21'=>0,'22'=>0,'23'=>0,'24'=>0,'25'=>0,'26'=>0,'27'=>0,'28'=>0,'29'=>0,);

$tab_ownedby_array=array('1'=>1,'2'=>0,'3'=>1,'4'=>0,'6'=>0,'7'=>0,'8'=>1,'9'=>0,'10'=>1,'13'=>0,'14'=>1,'15'=>1,'16'=>0,'18'=>1,'19'=>1,'20'=>0,'21'=>0,'22'=>0,'23'=>0,'24'=>1,'25'=>1,'26'=>0,'27'=>1,'28'=>1,'29'=>1,);

$action_id_array=array('Save'=>0,'SavePriceBook'=>0,'SaveVendor'=>0,'DetailViewAjax'=>1,'EditView'=>1,'PriceBookEditView'=>1,'QuickCreate'=>1,'VendorEditView'=>1,'Delete'=>2,'DeletePriceBook'=>2,'DeleteVendor'=>2,'index'=>3,'Popup'=>3,'DetailView'=>4,'PriceBookDetailView'=>4,'TagCloud'=>4,'VendorDetailView'=>4,'Import'=>5,'Export'=>6,'Merge'=>8,'ConvertLead'=>9);

$action_name_array=array(0=>'Save',1=>'EditView',2=>'Delete',3=>'index',4=>'DetailView',5=>'Import',6=>'Export',8=>'Merge',9=>'ConvertLead');
?>


Still, I get the following error in the "finish" section of the install.php:
Code:
Can't create table '.\crm\#sql-1174_4db.frm' (errno: 121)Error: Tables partially created. Table creation failed.


When I then view the index.php page, I can't login with the default admin or default default_user passwords. Only 302 of the needed 317 tables (I read somewhere that the total amount of tables after a clean installation should be 317) are created. Seems like the database installation did not fully complete.

Any advice on the above problems would be very welcome, as I'm kinda getting stuck in the situation :).
Thanks in advance,

Remko

[Villaine]

I am having exactly the same chain of errors that you experienced using IIS 7 on the new server 2008.

Did you ever get any help or figure out how to proceed?

[asknow]

Somehow, while the IUSR had full permission on the directory, some files could not be written. Due to this, some database tables were not created. Giving "everyone" full permissions on the directory, though not gracefully, was a solution. If you use this solution, don't forget to delete the "everyone" permissions afterwards.

[Villaine]

Bizarre, but that did the trick !

Thanks :)