Schema Update Failure

robc

I just performed a simple git pull on branch dev/2.0 so I need to migrate from schema 204 to 213. When I visit the Providence front page and attempt the update, it throws:

Could not connect to database. Check your database configuration in setup.php: Column 'logged_table_num' cannot be null

I then switched to caUtils which indicates I'm now up to schema 212 and need to migrate to 213. This part was successful.

Am I good to go now, or was this a serious bug? Does something need to be patched here for other users in the community?

seth

I've not seen that one. My guess is migration 211 threw it when updating your relationship type editor configuration. You should check the relationship type editor and make sure it's using new ca_relationship_type_restrictions bundle in place of the old sub_type_left_id, sub_type_right_id, include_subtypes_left and include_subtypes_right bundles. If the old ones are still there you should make the change manually. These bundles only matter if you're restricting relationship types by related record types, which is relatively rare.

robc

So... not the Relationship Types page, but the User Interfaces config... hmmm. Yes, I see "Relationship types configuration editor" in there. Then.. the "Basic info" screen. For "Type restrictions" the tooltip does say ca_relationship_type_restrictions

I'll assume this is all fine.

robc

Okay, here's something relevant from app/log/log_db_errors_2026-08-25.txt

2026-08-25 14:39:43 - ERROR --> [1::1482519] {"code":291,"errorNumber":1048,"errorMessage":"Column 'logged_table_num' cannot be null","sql":"
				INSERT INTO ca_change_log
				(
					log_id, log_datetime, user_id, unit_id, changetype,
					logged_table_num, logged_row_id, batch_id
				)
				VALUES
				(NULL, 1787683183, NULL, 'affb7153276627a5b6704c2e18afdd8c', 'I', NULL, 1, NULL)
			","stacktrace":"app/lib/Db/mysqli.php::caPrintStacktrace@356

app/lib/Db/DbStatement.php: Db_mysqli:execute@133
app/lib/BaseModel.php: DbStatement:execute@7048
app/lib/BaseModel.php:BaseModel:logChange@2880
support/sql/migrations/VersionUpdate211.php:BaseModel:insert@94
app/lib/System/Updater.php:VersionUpdate211:applyDatabaseUpdate@66
themes/default/views/system/configuration_error_schema_update_html.php:System\\Updater:performDatabaseSchemaUpdate@49
app/lib/ConfigurationCheck.php::require_once@135
index.php:ConfigurationCheck:updateDatabaseSchema@51
"}

robc

I can trace it as far back as this one line of code. Beyond that is developer territory.

https://github.com/collectiveaccess/providence/blob/16ab44133e2e4015f2f9db5fa7c2a1c12c57ff25/app/lib/BaseModel.php#L7050