Thread: Firmware 3.19.5613 discussion
View Single Post
Old 12-08-2015, 08:58 PM   #72
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by icallaci View Post
Oh, sorry, I thought ' ' (with a space between) isn't NULL but '' (with no space) is. My bad. It's been a while since I worked with SQL. I'll give '' a try unless someone else chimes in with a better experience-based solution. (But I don't plan to upgrade until the patches are ready, so it may be a day or two.) Thanks.
No, '' is a zero length string or an empty string and is in many cases a valid value. NULL means it does not have a value at all.

Your current setting is more likely to work than setting all the values to empty strings. It's possible the problem is that the other values don't pass a check. There are two UUIDs, two email addresses, and id for the device (a 64 character hexadecimal number) and two keys or tokens of some sort (605 characters, looks like the last character is an equals sign). Filling these fields with something that matches might work. But, syncing to get the firmware updated will probably produce the results rashkae reported.
davidfor is offline   Reply With Quote