Error message reports SQL code that failed .. missing field name?

More
3 months 2 days ago #167575 by blocka
blocka created the topic: Error message reports SQL code that failed .. missing field name?
I have had a number of "Error saving results" emails for one of my surveys.

The relevant error portion is:


SQL CODE THAT FAILED:

UPDATE {{survey_616355}} SET `lastpage`=0, `datestamp`='2018-04-18 07:38:09', ``=NULL WHERE ID=324

ERROR MESSAGE:

And there is no error message -- although looking at the SQL I see there is a missing field before the =NULL -- it's blank ... I'd imagine that a field name should be within the quotes.

I'm running LS v 2.73.1, DB v263, build 171220

Any insights as to what is causing this?

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #167928 by blocka
blocka replied the topic: Error message reports SQL code that failed .. missing field name?
Sorta bumping this -- wondering why the update statement would have no field associated with ``=NULL in the query error I received?

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!