Subject cannot restore db (time and timestamp)
Author pablosanchezuy
I have converted 2 attributes on table from timestamp to time format, yesterday . Engine didn't complain on that .

I'm trying to restore last night backup from Flamerobin and getting the following error:

Database restore canceled 01:43:40 PM due to IBPP exception:

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -833
expression evaluation not supported

Engine Code : 335544912
Engine Message :
value exceeds the range for a valid time
gds_$send failed


Production server is ubuntu 10.04 linux/amd64, firebird classic v 2.1 ( 2.1.3.18185-0.ds1-6build1 ) .
I'm trying to run un update of both fields to null, but query never gets back (after 12 minutes, i suspended it) . I'm using to restore v 2.5.1.26351 .

Is there any way this can be fixed or should start looking to other alternatives right now?

Regards

Pablo