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

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

Postby crush » Tue Apr 08, 2014 7:05 am

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
crush
 
Posts: 14
Joined: Wed Apr 03, 2013 4:19 am

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

Postby crush » Wed Apr 09, 2014 3:42 am

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.
crush
 
Posts: 14
Joined: Wed Apr 03, 2013 4:19 am

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

Postby massiws » Wed Apr 09, 2014 7:42 am

.
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy


Return to General



cron