Timesheet Ninja for SuiteCRM

by CRM Ninjas

Track time and measure productivity against any and all modules in SuiteCRM, including support cases and project tasks. Built in start and stop timer, automatic email and screen pop reminders, PDF timesheet templates, advanced reporting and exporting features. Ideal for generating invoices for your clients.

Cancel at any time!
Free Trial

#1552 - Does not install on SuiteCRM 7.10.10 using MSSQL

Open Bug? created by dngreene 4 years ago

Downloaded trial and attempted to install - Install failed:

Installing action_view_map extension Installing administration extension Installing Language Packs Rebuilding Language...en_us Installing layoutdefs extension Rebuilding ActionViewMap... Rebuilding ActionFileMap... Rebuilding ActionReMap... Rebuilding Administration... Rebuilding EntryPointRegistry... Rebuilding Extensions... Rebuilding FileAccessControlMap... Rebuilding Layoutdefs... Rebuilding GlobalLinks... Rebuilding LogicHooks... Rebuilding Menus... Rebuilding Include... Rebuilding ScheduledTasks... Rebuilding UserPage... Rebuilding Utils... Rebuilding Vardefs... Rebuilding JSGroupings... Rebuilding Actions... Installing Images Installing Relationships Rebuilding Vardefs... Rebuilding Layoutdefs... Installing Bean : sp_Timesheet Installing Bean : sp_timesheet_tracker Installing Bean : sp_Auto_TimeSheet_Time_Tracker Database failure. Please refer to suitecrm.log for details.

LOG Results

Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(id) FROM project_task WHERE project_task.project_id = N'3aebca04-7cd3-7a3f-616b-5be176a1d459' AND project_task.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] sub panel row count can not be negative Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] relationship name can not be empty Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] relationship name can not be empty Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(contact_id) FROM projects_contacts WHERE projects_contacts.project_id = N'3aebca04-7cd3-7a3f-616b-5be176a1d459' AND projects_contacts.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] sub panel row count can not be negative Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(account_id) FROM projects_accounts WHERE projects_accounts.project_id = N'3aebca04-7cd3-7a3f-616b-5be176a1d459' AND projects_accounts.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] sub panel row count can not be negative Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(opportunity_id) FROM projects_opportunities WHERE projects_opportunities.project_id = N'3aebca04-7cd3-7a3f-616b-5be176a1d459' AND projects_opportunities.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] sub panel row count can not be negative Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(case_id) FROM projects_cases WHERE projects_cases.project_id = N'3aebca04-7cd3-7a3f-616b-5be176a1d459' AND projects_cases.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Tue Nov 6 06:10:24 2018 [10572][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][ERROR] sub panel row count can not be negative Tue Nov 6 06:12:24 2018 [9876][1][ERROR] Pop error level. Try to remove the error_reporting() function from your code. Tue Nov 6 06:14:10 2018 [10432][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Error altering column(s) processed on table: sp_auto_timesheet_time_tracker: Query Failed: ALTER TABLE sp_auto_timesheet_time_tracker DROP CONSTRAINT DF__sp_auto_t__proce__1E256B9B ALTER TABLE sp_auto_timesheet_time_tracker ALTER COLUMN [processed] bit NULL ALTER TABLE sp_auto_timesheet_time_tracker ADD DEFAULT '0' FOR processed ::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'DF__sp_auto_t__proce__1E256B9B' is not a constraint. [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not drop constraint. See previous errors. Tue Nov 6 06:14:10 2018 [10432][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Exception handling in H:\Websites\TADCRM\include\MVC\Controller\SugarController.php:400 Tue Nov 6 06:14:10 2018 [10432][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Tue Nov 6 06:14:10 2018 [10432][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] backtrace:

0 H:\Websites\TADCRM\include\database\DBManager.php(353): sugar_die('Database failur...')

1 H:\Websites\TADCRM\include\database\DBManager.php(328): DBManager->registerError('Error altering ...', 'Error altering ...', true)

2 H:\Websites\TADCRM\include\database\SqlsrvManager.php(235): DBManager->checkError('Error altering ...', true)

3 H:\Websites\TADCRM\include\database\DBManager.php(1267): SqlsrvManager->query(' ALTER TABLE sp...', true, 'Error altering ...')

4 H:\Websites\TADCRM\include\database\DBManager.php(912): DBManager->alterColumn('sp_auto_timeshe...', Array, false)

5 H:\Websites\TADCRM\include\database\DBManager.php(764): DBManager->repairTableParams('sp_auto_timeshe...', Array, Array, true, NULL)

6 H:\Websites\TADCRM\modules\Administration\QuickRepairAndRebuild.php(177): DBManager->repairTable(Object(sp_Auto_TimeSheet_Time_Tracker), true)

7 H:\Websites\TADCRM\modules\Administration\QuickRepairAndRebuild.php(72): RepairAndClear->repairDatabaseSelectModules()

8 H:\Websites\TADCRM\ModuleInstall\ModuleInstaller.php(222): RepairAndClear->repairAndClearAll(Array, Array, true, false)

9 H:\Websites\TADCRM\modules\Administration\UpgradeWizard_commit.php(340): ModuleInstaller->install('cache/upgrades/...')

10 H:\Websites\TADCRM\include\MVC\View\SugarView.php(818): include_once('H:\Websites\TAD...')

11 H:\Websites\TADCRM\include\MVC\View\views\view.classic.php(72): SugarView->includeClassicFile('cache/upgrades/...')

12 H:\Websites\TADCRM\include\MVC\View\SugarView.php(211): ViewClassic->display()

13 H:\Websites\TADCRM\include\MVC\Controller\SugarController.php(435): SugarView->process()

14 H:\Websites\TADCRM\include\MVC\Controller\SugarController.php(375): SugarController->processView()

15 H:\Websites\TADCRM\include\MVC\SugarApplication.php(113): SugarController->execute()

16 H:\Websites\TADCRM\index.php(52): SugarApplication->execute()

17

  1. dngreene member avatar

    dngreene

    4 years ago

    FYI, Limit is not an MSSQL command, you must use "Select Top".

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • Supported Versions
  • 7.0.0 to 8.2.2
  • Most Recent Love from Users
  • bobby

Other add-ons of interest

Glances - Integrate SuiteCRM with all your apps

The simplest way to work™. Glances integrates SuiteCRM with all your favorite workplace apps, acting as your go-to hub for real-time customer insights and personal tasks.

Featured

SuiteCRM Timesheets & Invoicing

Track billable hours on Projects, Project Tasks in SuiteCRM. Easily run reports to see who needs to be invoiced and who needs to be paid.

Simple Timesheet

Easily fill out your work time and track project costs. With all your project spent time information in one place, you'll be a more organized and efficient business owner.

Rating
Productivity Reporting Productivity Reporting time tracking timesheets