Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

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

Locked
crush
Posts: 14
Joined: Tue Apr 02, 2013 8:49 pm

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

Unread post 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
crush
Posts: 14
Joined: Tue Apr 02, 2013 8:49 pm

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

Unread post 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.
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

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

Unread post by massiws »

.
Locked