recordset with exclamation point

[pabirds]

Dreamweaver CS6

I created a recordset (mysqli) and it tests fine.

But when I go to the Server Behaviors tab, it has a red exclamation point in front of it and won't let me create any behaviors (like Repeat Region). It says I have to create a recordset first! If I click on the recordset, and then click on Test, it still displays the records fine.

What is going on and how do I fix it?

[Jon Fritz]

I'm reasonably sure what you're seeing is "the way CS6 works".

mysqli is too new for DWCS6, and Adobe completely removed server behavior functionality from the program in later versions, rather than rewriting them with newer coding methods.

[Nancy OShea · Accepted solution]

Replace deprecated server behaviors panels with a commercial extension from WebAssist or DMX Zone.  Do not use the old behaviors panels in DW.

• http://www.webassist.com/dreamweaver-extensions/mysqli
• https://www.dmxzone.com/go/22151/database-connectivity-collection-php

[Nancy OShea]

Also see this answer from a few days ago.

https://community.adobe.com/t5/Dreamweaver/Database-Bindings-server-behaviors/td-p/10639622

[BenPleysier]

Seeing that you are already coding using MySQLi, I would suggest going for the Webassist extension as mentioned by Nancy.