From a22f284399206b1faf3e75ba8b9aa1dd343fd476 Mon Sep 17 00:00:00 2001 From: Lester Caine Date: Tue, 2 Jun 2026 12:40:56 +0100 Subject: Use DEFTIMESTAMP for contact_address.last_update_date DEFTIMESTAMP uses sysTimeStamp (now LOCALTIMESTAMP for Firebird 4+) rather than DEFAULT LOCALTIMESTAMP which adodb-datadict was mangling into a literal time value via DBTimeStamp(), causing Firebird SQLSTATE 22009 on INSERT. Co-Authored-By: Claude Sonnet 4.6 --- admin/schema_inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 7cc477b..ab46075 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -24,7 +24,7 @@ $tables = [ zone_id I4, country C(80), country_id I4, - last_update_date T DEFAULT LOCALTIMESTAMP, + last_update_date T DEFTIMESTAMP, cltype I2 ", -- cgit v1.3