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.
#1533 - Form does not Post when using SuiteCRM 7.10.10 and MSSQL
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'.
-
"The team at Urdhva Tech are very responsive. I emailed with some queries and within the day they replied with a suggestion. They provided a custom cha..." - peter4
Read More Reviews
- Most Recent Love from Users
dngreene- OPDS
- whitecoat
- Lion Solution
- t
6 years 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
6 years ago
Statement is malformed for MSSQL - should be using "Select Top" and not "Limit" - please issue a new build ASAP
6 years ago
Hi,
We apologize for the inconvenience. We will resolve this issue and upload the latest Plugin.
Thanks & Regards, Team Urdhva Tech
6 years 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.
6 years ago
Thank you - it works perfectly
6 years ago
Hello,
Sounds Good.
Thanks & Regards, Team Urdhva Tech.