Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

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

  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
6 years 6 days ago #167575 by blocka
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?
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
5 years 11 months ago #167928 by blocka
Sorta bumping this -- wondering why the update statement would have no field associated with ``=NULL in the query error I received?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose