by Urdhva Tech

Need a landing page for your next campaign? A way for your customers to create support cases? Do your sales reps need a way to enter leads? With WebToModule you can create custom webforms for these any many other users. Supports all modules, including custom modules.

Includes a 30 day guarantee
Try it Now

#1533 - Form does not Post when using SuiteCRM 7.10.10 and MSSQL

Closed Bug? created by dngreene Verified Purchase a year ago

Created a form for the leads module - Web form does not post, returns Database Failure - Below is the excerpt from the log

Mon Oct 29 16:02:08 2018 [10604][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(id) FROM campaign_log WHERE campaign_log.target_id = N'499f1d46-b917-f4d5-db5d-5bd7676d5cc2' AND campaign_log.deleted=0 AND campaign_log.target_type = N'Leads' LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.
Mon Oct 29 16:02:08 2018 [10604][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(fp_events_leads_1fp_events_ida) FROM fp_events_leads_1_c WHERE fp_events_leads_1_c.fp_events_leads_1leads_idb = N'499f1d46-b917-f4d5-db5d-5bd7676d5cc2' AND fp_events_leads_1_c.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.
Mon Oct 29 16:02:08 2018 [10604][7dbd6cc4-85d6-1134-dcbd-5bd300e48830][FATAL] Query Failed:SELECT COUNT(securitygroup_id) FROM securitygroups_records WHERE securitygroups_records.record_id = N'499f1d46-b917-f4d5-db5d-5bd7676d5cc2' AND securitygroups_records.module = N'Leads' AND securitygroups_records.deleted=0 LIMIT 1::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.

  1. dngreene member avatar

    dngreene Verified Purchase

    a year ago

    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'dgreene157@gmail.com' 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 {main}

  2. dngreene member avatar

    dngreene Verified Purchase

    a year ago

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

  3. urdhvatech member avatar

    Urdhva Tech Provider Affiliate

    a year ago

    Hi,

    We apologize for the inconvenience. We will resolve this issue and upload the latest Plugin.

    Thanks & Regards,
    Team Urdhva Tech

  4. urdhvatech member avatar

    Urdhva Tech Provider Affiliate

    a year ago

    Hello,

    We have released the latest version(4.6) of WebToModule. Please download it and install it. Let us know, how it will go.

    Thanks & Regards,
    Team Urdhva Tech.

    • dngreene member avatar

      dngreene Verified Purchase

      a year ago

      Thank you - it works perfectly

  5. urdhvatech member avatar

    Urdhva Tech Provider Affiliate

    a year ago

    Hello,

    Sounds Good.

    Thanks & Regards,
    Team Urdhva Tech.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "Does everything I expected and the developers extended its functionalities as per my needs."

    Read More Reviews