Technote Details :: Trigger cannot read bad words list
Issue
After applying the Check forbidden words trigger on a form I can no longer submit the information. I get an error message: Error Reading bad words
Reason
This happens because the database table that you have configured as storing the bad words does not exist, cannot be accessed or the table field does not contain string-type information.
Solution
To solve this issue, try the following:
- Check the database structure to see if the table exists and has the correct name. Then edit the Check forbidden words trigger and make sure that the correct table is selected.
- In Dreamweaver check that the table can be correctly accessed. To do so, in the Database tab of the Application panel expand the connection node and then right-click on the bad words table. From the menu select View data.
- Check that the correct table field has been selected in the Check forbidden words trigger interface. The table field must store string-type elements: the bad words. If needed, edit the server behavior and set the correct field.