Page 1 of 1

SQL error--'SELECT'--when trying to add record

Posted: Mon Apr 07, 2014 11:35 pm
by crush
Hi,

I'm at the browse screen of a form. I can view, delete, duplicate and edit existing records just fine. But when I go to add a new one, I get the following bluescreen error:
The following information is only provided for users logged on as globeadmin.

SQL

SELECT

Transaction
No Transaction.

Error
0:

URL
http://
I have no idea what might cause this. I have deleted objects one by one from the form, but it doesn't help. Nor should it seem to help, if I can view and edit the form just fine.

I'm about as stumped as I've ever been with nuBuilder. Thank you for your help.

Cassidy

Re: SQL error--'SELECT'--when trying to add record

Posted: Tue Apr 08, 2014 8:12 pm
by crush
Phew, I figured this one out. I traced the stack back to line 1496 of form.php, where the Default value SQL for text fields gets executed. Turns out somehow one of my text fields had a Default SQL value of 'SELECT'. Strange but true. And, most importantly, resolved as well.

Re: SQL error--'SELECT'--when trying to add record

Posted: Wed Apr 09, 2014 12:12 am
by massiws
.