Help uninstalling a bad module

[triteldon]

I tried installing the JCRM timesheet module and received some database errors during the install. I tried the fix/repair option but this did not take care of the install issue.

While the module shows that it is not installed, it did create shortcuts within the application and appears 'partially' installed. I have tried contacting the author for support but have not hand any luck reaching him.

Is there a process to manually remove a partially installed module? We are running the latest community edition with a MYSQL database backend.

Here is the error that I receive when I run the repair option on my system:

Executing repair query: Query Failed:ALTER TABLE jcrmtime modify column invoice_id char(36) NULL , ADD INDEX JCRMTime_speed_index (assigned_user_id, date, case_id, account_id)::MySQL error 1061: Duplicate key name 'JCRMTime_speed_index'

Since this module does not appear to be supported anymore, I would really like to just completely remove it from the system. Thank you very much for any help.

- Don

[SugarDev.net]

Can you point me to the archive file you installed?

[triteldon]

Yes. I downloaded the file from: http://www.sugarforge.org/frs/?group_id=449
The version I downloaded was the latest 1.3 of JustCRMs - Time and Invoicing

- Don

[SugarDev.net]

This is going to take some time.

- Backup your Sugar files and database first
- Put Sugar in maintenance mode (either with my sugardev module or just by telling the users not to use sugar)

 'copy'     => array(

        //widget

        array('from'    => '<basepath>/widgets/SugarWidgetJCRMSubPanelIcon.php',

              'to'      => 'include/generic/SugarWidgets/SugarWidgetJCRMSubPanelIcon.php',

        ),

        //common

        array('from'    => '<basepath>/modules/JCRMReports',

              'to'      => 'modules/JCRMReports',

        ),

        //time

        array('from'    => '<basepath>/modules/JCRMTime',

              'to'      => 'modules/JCRMTime',

        ),

        array('from'    => '<basepath>/images/CreateJCRMTime.gif',

              'to'      => 'themes/Default/images/CreateJCRMTime.gif',

        ),

        array('from'    => '<basepath>/images/JCRMTime.gif',

              'to'      => 'themes/Default/images/JCRMTime.gif',

        ),

        //invoicing

        array('from'    => '<basepath>/modules/JCRMInvoices',

              'to'      => 'modules/JCRMInvoices',

        ),

        array('from'    => '<basepath>/images/CreateJCRMInvoice.gif',

              'to'      => 'themes/Default/images/CreateJCRMInvoice.gif',

        ),

        array('from'    => '<basepath>/images/JCRMInvoices.gif',

              'to'      => 'themes/Default/images/JCRMInvoices.gif',

        ),

    ),



    'language'=> array(

        array('from'     => '<basepath>/language/jcrmtimeandinvoice_cases.php',

              'to_module'=> 'Cases',

              'language' => 'en_us'

          ),

        array('from'     => '<basepath>/language/jcrmtimeandinvoice_cases.php',

              'to_module'=> 'Cases',

              'language' => 'en_gb'

                ),

        array('from'     => '<basepath>/language/ge_jcrmtimeandinvoice_cases.php',

              'to_module'=> 'Cases',

              'language' => 'ge_ge'

                ),

        array('from'     => '<basepath>/language/jcrmtimeandinvoice_accounts.php',

              'to_module'=> 'Accounts',

              'language' => 'en_us'

          ),

        array('from'     => '<basepath>/language/jcrmtimeandinvoice_accounts.php',

              'to_module'=> 'Accounts',

              'language' => 'en_gb'

                ),

        array('from'     => '<basepath>/language/ge_jcrmtimeandinvoice_accounts.php',

              'to_module'=> 'Accounts',

              'language' => 'ge_ge'

                ),

        //the following are saved to the id

        array('from'     => '<basepath>/language/app_strings.php',

              'to_module'=> 'application',

              'language' => 'en_us'

          ),

        array('from'     => '<basepath>/language/app_strings.php',

              'to_module'=> 'application',

              'language' => 'en_gb'

          ),

        array('from'     => '<basepath>/language/ge_app_strings.php',

              'to_module'=> 'application',

              'language' => 'ge_ge'

          ),

    ),



    'beans'=> array(

        array('module'=> 'JCRMTime',

              'class' => 'JCRMTime',

              'path'  => 'modules/JCRMTime/JCRMTime.php',

              'tab'   => true,

       ),

       array('module'=> 'JCRMInvoices',

             'class' => 'JCRMInvoice',

             'path'  => 'modules/JCRMInvoices/JCRMInvoice.php',

             'tab'   => true,

      ), 
  

That's the list of files added by this module. You will have to remove them all. The once with a 'to' attribute can be found on that location, the ones with 'to_module' can be found in custom/. Rebuild all + rebuild relationships when you're done, and everything should work fine. Remove any mention of this module in upgrade_history (in the database) and remove the tables from the database (the tables probably have the modules' names). Good luck.

[triteldon]

I really appreciate your reply but the instructions do not mean much to me. Do I need to paste the text into sugar somewhere or is this database stuff outside of the sugar application. If the later, I'm going to need to hire a pro to help me with this as I'm sure to break something.

- Don