Hard crashing due to fields not specified in SQL

[Thorsten Hohage]

Hello,

On 2007-07-06, at 08:49, Ivan Smahin wrote:
> Strange.

I'm late on this topic, but I want to remind you of an issue I had  
several weeks ago.

After upgrading to Valentina 3.0.1 and ... (some more work I didn't  
remember) my app (REALbasic 2007R3) starts simply crashing on Win XP  
on startup. We spend several hours to find an issue, but we finally  
didn't find a "real" issue,

BUT

I found out, that I've got one table for storing properties and there  
was a "special" datetime column and in contrast to all other datetime  
columns in all tables, in this table and column there was some values

	"0002-11-30 00:02:01:000"

I'm not sure if this was due to a data import from mySQL or some  
changes, but there are this values. After nullifying these values my  
app starts fine again. And this was reproducible, restoring a backup  
using this values and the crash reappears.


So you should perhaps check the table and column if there are any  
"illegal" values inside and check if the crash dissapears if you  
change them.

regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany