nuBuilder Forum

I accidentally created three forms (using the "Form Wizard") that had identical names.

When I then deleted two of them, the browser via "User Home" button looks strange, and I find I can no longer use the remaining one when I click on it; it claims I have some bad SQL (apparently with just "SELECT" and nothing else).

I have checked the SQL in that form, and it seems to be okay.

There are two other forms that are behaving badly the same way, for the same reason: I created them by accident, and deleted them, but they still show on the "User Home" browser.

What can I do to recover from this situation? I'm not afraid of PHP and SQL; I briefly looked through the "zzzsys" tables for a lone "SELECT", but found nothing.

Okay, figured it out.

If you use the Form Wizard over and over with the same information, it creates a referential integrity problem, where the "Field Name" for the button (like "Surveybtn") is the same for each object, and it appears this field should be unique.

I simply appended a character to make these fields unique, then I was able to delete them.

BUG: This column probably needs to be indexed UNIQUE to keep this from happening.

.