Author Topic: The dreaded "validation error with your HTML" You're SUSPICIOUS! (Read 1436 times)

erich_prinz · September 12, 2010, 08:07:30 am

I see the forum flooded with people having this problem and have done a few things to work around the issue such as:

--> change the editor to joomlaFCK from joomlaCK
--> upgrade from 3.1.3 to 3.2.3
--> clear the templates_c and allow all to be regenerated

Still, no success in being able to create a new Constituent Detail Report from the template.

The Joomla version is 1.5.20.

Sorry to be a broken record, but I'm out of ideas on how to fix this .... a little help please?

Error in log file is:

Sep 12 10:40:46 [info] $backTrace = /var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 189
, handle,
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2411
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 1597
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 145
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php, query, 867
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, executeQuery, 477
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, clauseComponent, 648
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form.php, postProcess, 420
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Contact/Detail.php, preProcess, 273
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php, preProcess, 314
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/html/pie/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, handle, 279
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php, run, 115
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Report/Page/Instance.php, run, 94
/var/www/html/pie/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, run, 219
/var/www/html/pie/administrator/components/com_civicrm/admin.civicrm.php, invoke, 72
/var/www/html/pie/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 45
/var/www/html/pie/libraries/joomla/application/component/helper.php, require_once, 162
/var/www/html/pie/administrator/includes/application.php, renderComponent, 136
/var/www/html/pie/administrator/index.php, dispatch, 67
/var/www/html/pie/administrator/index2.php, include, 14

Deepak Srivastava · September 13, 2010, 07:25:51 am

Suspect for some cases (which we are unable to reproduce) IDS is recording higher impact, which is probably why you see that error.

1. Try removing contents of report-header and report-footer and see if that works, which will confirm statement above.

2. Keeping the header / footer as default (ignoring #1) try applying below patch and see if it works. If it works please file an issue and apply this patch -

Code: [Select]

Index: CRM/Core/IDS.php
===================================================================
--- CRM/Core/IDS.php	(revision 29629)
+++ CRM/Core/IDS.php	(working copy)
@@ -97,6 +97,8 @@
     exceptions[]        = msg_html
     exceptions[]        = msg_text
     exceptions[]        = description
+    exceptions[]        = report_header
+    exceptions[]        = report_footer
     html[]              = intro
     html[]              = thankyou_text
     html[]              = intro_text
@@ -114,8 +116,6 @@
     html[]              = confirm_text
     html[]              = confirm_footer_text
     html[]              = confirm_email_text
-    html[]              = report_header
-    html[]              = report_footer
     html[]              = data
 ";

erich_prinz · September 18, 2010, 07:49:20 pm

Taking step number 1 (removing both the header and footer data) and saving the report back out as Constituent Report (Detail) yields:

Sorry. A non-recoverable error has occurred.
DB Error: no such field

The preview report works fine.

This is the original issue that prompted an attempt to recreate this report.

Perhaps there was an error on the database schema update when moving from 3.1.3 to 3.2.3?

CiviCRM Community Forums (archive)

News:

Author Topic: The dreaded "validation error with your HTML" You're SUSPICIOUS! (Read 1436 times)

erich_prinz

The dreaded "validation error with your HTML" You're SUSPICIOUS!

Deepak Srivastava

Re: The dreaded "validation error with your HTML" You're SUSPICIOUS!

erich_prinz

Re: The dreaded "validation error with your HTML" You're SUSPICIOUS!