Custom module tables are not created

[galaxy101]

I have installed the latest SugarCRM 5.0.0b. It installed perfectly. This is my server spec:

----
Apache 2.0.63
PHP 5.2.5
MySQL 4.1.22
Linux
----

My problem is in the category of custom modules. No tables are created for my modules and module navigation tab is blank. When I go to create a new record for my custom module, it fails because the table is missing. I've searched through these forums and have not found solutions for any of these problems. I've enabled the errog logging feature, but I don't see any errors related to table creation problems... Is it skipping it altogether?

I also tested adding custom fields to the Leads module because I know it creates a new table for these fields. The table "leads_cstm' was created.

I've installed the same version on my local Windows PC and custom modules are working perfectly.

Any help is appreciated.

[galaxy101]

Just a quick follow up...

Admin > Repair > Repair Database

This found that I was missing tables for my custom modules and it built the SQL CREATE statements and allowed me to execute it and they are there now.

However, this doesn't solve the problem because the tables should have been created when I created the package and modules. Also, my custom modules still are represented by blank tabs.

[dpatech]

It sounds like there was some error or ommission in the manifest.php that causes it not to fully install. Did the module loader make to 100% successfully installed? Can you post the manifest.php? Try looking into the upgradeWizard.log log file and see if there were any errors.

[galaxy101]

I did not use the module loader. I built it in Module Builder and then deployed it.

This is the manifest.php file from
/public_html/crm/custom/modulebuilder/builds/CS_Computers1

<?php
	$manifest = array (
		 'acceptable_sugar_versions' => 
		  array (
	     	
		  ),
		  'acceptable_sugar_flavors' =>
		  array(
		  	'CE', 'PRO','ENT'
		  ),
		  'readme'=>'',
		  'key'=>'cspkg',
		  'author' => 'Chris',
		  'description' => 'Package that tracks clients&#039; computers.',
		  'icon' => '',
		  'is_uninstallable' => true,
		  'name' => 'CS_Computers1',
		  'published_date' => '2008-04-04 20:21:19',
		  'type' => 'module',
		  'version' => '1207340479',
		  'remove_tables' => 'prompt',
		  );
$installdefs = array (
  'id' => 'CS_Computers1',
  'beans' => 
  array (
    0 => 
    array (
      'module' => 'cspkg_CS_ComputerPeople',
      'class' => 'cspkg_CS_ComputerPeople',
      'path' => 'modules/cspkg_CS_ComputerPeople/cspkg_CS_ComputerPeople.php',
      'tab' => true,
    ),
    1 => 
    array (
      'module' => 'cspkg_ComputerList',
      'class' => 'cspkg_ComputerList',
      'path' => 'modules/cspkg_ComputerList/cspkg_ComputerList.php',
      'tab' => true,
    ),
    2 => 
    array (
      'module' => 'cspkg_CS_ComputerTest',
      'class' => 'cspkg_CS_ComputerTest',
      'path' => 'modules/cspkg_CS_ComputerTest/cspkg_CS_ComputerTest.php',
      'tab' => true,
    ),
  ),
  'layoutdefs' => 
  array (
  ),
  'relationships' => 
  array (
  ),
  'image_dir' => '<basepath>/icons',
  'copy' => 
  array (
    0 => 
    array (
      'from' => '<basepath>/SugarModules/modules/cspkg_CS_ComputerPeople',
      'to' => 'modules/cspkg_CS_ComputerPeople',
    ),
    1 => 
    array (
      'from' => '<basepath>/SugarModules/modules/cspkg_ComputerList',
      'to' => 'modules/cspkg_ComputerList',
    ),
    2 => 
    array (
      'from' => '<basepath>/SugarModules/modules/cspkg_CS_ComputerTest',
      'to' => 'modules/cspkg_CS_ComputerTest',
    ),
  ),
  'language' => 
  array (
    0 => 
    array (
      'from' => '<basepath>/SugarModules/language/application/en_us.lang.php',
      'to_module' => 'application',
      'language' => 'en_us',
    ),
  ),
);
?>

This is the manifest.php file from:
/home/appsmen/public_html/crm/custom/modulebuilder/packages/CS_Computers1/

<?php

	$manifest = array (
		 'acceptable_sugar_versions' => 
		  array (
	     	
		  ),
		  'acceptable_sugar_flavors' =>
		  array(
		  	'CE', 'PRO','ENT'
		  ),
		  'readme'=>'',
		  'key'=>'cspkg',
		  'author' => 'Chris',
		  'description' => 'Package that tracks clients&#039; computers.',
		  'icon' => '',
		  'is_uninstallable' => true,
		  'name' => 'CS_Computers1',
		  'published_date' => '2008-04-04 20:24:48',
		  'type' => 'module',
		  'version' => '1207340688',
		  'remove_tables' => 'prompt',
		  );
?>

[galaxy101]

After troubleshooting and trying different things... I finally executed a chmod on all directories and sub-directories to 777. I went back into SugarCRM module builder and re-deployed and it worked!

Of course 777 is not good, so now I have to figure out what directories I missed setting the correct permissions on. It may be an ownership issue. I noticed that my apache user runs under "nobody" instead of "apache" or the hosting user account... I should fix this too.

I thought that there would have been some error logged about permission denied or something like that, but nothing was logged...

[DragonflyMaster]

Of course 777 is not good, so now I have to figure out what directories I missed setting the correct permissions on.

For sure Sugar main directory and Cache directory (and all its sub-directories) need chmod 777; for a large part of remaining directories, you can chmod 755.