Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

restoring a 1.5 database gbak give error: "value exceeds the range for valid dates" [CORE1714] #2139

Closed
firebird-automations opened this issue Jan 29, 2008 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Paolo Fainelli (zpaolo)

Relate to CORE5178

Votes: 1

I received this error restoring some production databases from fb 1.0 or fb 1.5. Gbak work well under 1.5 and 2.0 version. If required i will send a database with this problem

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The error means to say that some column has an invalid date value (outside the supported range). Prior to v2.1, it was possible to store such invalid values in the database, but now it's prohibited. A verbose output should point you to a problematic table.

@firebird-automations
Copy link
Collaborator Author

Commented by: Stephen Gowen (stephen)

I received the same error for a database that was working quite happily with Firebird 2.04. When I upgraded to Firebird 2.1.1 I was then unable to perform a select from the table containing the relevant field. This stops my application from working as in the table is queried each time that the application opens and this failing stops my application from showing any data. I even tried doing a gBak -restore on a backup of this database but this again failed with the "value exceeds the range for valid dates" error. This I eventually found to be down to a date field that was left in the table but not used. This would stop all of my customers from working with Firebird 2.1.1 until they received an executable from me which either set this field to a valid date or null or dropped this field.

Would it not be a better solution to either in the database engine or the gBak -restore to set any fields that would result in this error, to a predetermined or null date value.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The current behavior is intended and is unlikely to be changed.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Andrei Kireev (andreik)

Just in case it would be useful for someone. We put instructions on how to deal with the problem here:

http://gedemin.blogspot.com/2011/05/value-exceeds-range-for-valid-dates.html

the page is in russian.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue relate to CORE5178 [ CORE5178 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant