dngreene does not have any add-ons for sale.

• Does not install on SuiteCRM 7.10.10 using MSSQL

  Support November 6th, 2018 @ 11:06 am
  

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

  View Comment
  
  
• Form does not Post when using SuiteCRM 7.10.10 and MSSQL

  Support October 30th, 2018 @ 9:34 am
  

  Thank you - it works perfectly

  View Comment
  
  
• Form does not Post when using SuiteCRM 7.10.10 and MSSQL

  Support October 29th, 2018 @ 10:28 pm
  

  Statement is malformed for MSSQL - should be using "Select Top" and not "Limit" - please issue a new build ASAP

  View Comment
  
  
• Form does not Post when using SuiteCRM 7.10.10 and MSSQL

  Support October 29th, 2018 @ 10:25 pm
  

  Turned on debug and submitted again - here's the query:

  Query Failed:SELECT leads.id FROM leads INNER JOIN email_addr_bean_rel ON email_addr_bean_rel.bean_module=N'Leads' AND email_addr_bean_rel.bean_id = leads.id AND email_addr_bean_rel.deleted = 0 INNER JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id AND email_addresses.deleted=0 AND email_addresses.email_address=N'[email protected]' WHERE last_name=N'Test Last 2' AND leads.deleted=0 LIMIT 0,1 ::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Mon Oct 29 18:27:02 2018 [10836][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][DEBUG] Hook called: ::server_round_trip Mon Oct 29 18:27:02 2018 [10836][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][DEBUG] Calling Mssql::disconnect() Mon Oct 29 18:27:02 2018 [10836][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Exception handling in H:\Websites\TADCRM\include\MVC\Controller\SugarController.php:400 Mon Oct 29 18:27:02 2018 [10836][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Mon Oct 29 18:27:02 2018 [10836][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(' Query Failed:S...', ' Query Failed:S...', true)

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

  3 H:\Websites\TADCRM\modules\UT_WebToModule\WebToModuleCapture.php(152): SqlsrvManager->query('SELECT leads.id...', true)

  4 H:\Websites\TADCRM\include\MVC\Controller\SugarController.php(1020): require_once('H:\Websites\TAD...')

  5 H:\Websites\TADCRM\include\MVC\Controller\SugarController.php(468): SugarController->handleEntryPoint()

  6 H:\Websites\TADCRM\include\MVC\Controller\SugarController.php(373): SugarController->process()

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

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

  9

  View Comment
  
  
• Just installed - this is in the log

  Support October 29th, 2018 @ 9:18 am
  

  Seems to have resolved the log issues, thank you

  View Comment
  
  

dngreene has not rated any add-ons.

• WebToModule

  • 7.10.10

dngreene has not created any Wanted Add-ons.