Troubleshooting mysql error messages – Adobe Dreamweaver CC 2014 v.13 User Manual
Page 651
Here are possible causes and solutions:
The server behavior is trying to update a database table’s auto-number field or to insert a record into an auto-number field. Because auto-
number fields are populated automatically by the database system, any attempt to externally populate them with a value fails.
The data the server behavior is updating or inserting is the wrong type for the database field, such as inserting a date into a Boolean (yes/no)
field, inserting a string into a numeric field, or inserting an improperly formatted string into Date/Time field.
[Reference]800a0bcd—Either BOF or EOF is true
This error occurs when you attempt to view a dynamic page in a web browser or in Live view.
The problem occurs when the page tries to display data from an empty recordset. To solve the problem, apply the Show Region server behavior to
the dynamic content to be displayed on the page, as follows:
1. Highlight the dynamic content on the page.
2. In the Server Behaviors panel, click the Plus (+) button and select Show Region > Show Region If Recordset Is Not Empty.
3. Select the recordset supplying the dynamic content and click OK.
4. Repeat steps 1 to 3 for each element of dynamic content on the page.
Troubleshooting MySQL error messages
One common error message that you might encounter when testing a PHP database connection to MySQL 4.1 is “Client does not support
authentication protocol requested. Consider upgrading MySQL client.”
You may have to revert to an earlier version of MySQL, or install PHP 5 and copy some dynamic link libraries (DLLs). For detailed instructions, see
Setting up a PHP development environment.
644