by urdhvatech

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 11 months 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

    11 months 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

    11 months ago

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

  3. urdhvatech member avatar

    urdhvatech Provider Affiliate

    11 months 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

    urdhvatech Provider Affiliate

    11 months 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

      11 months ago

      Thank you - it works perfectly

  5. urdhvatech member avatar

    urdhvatech Provider Affiliate

    11 months 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