`form_pscis_20230825.gpkg` wont import with `sf::st_read`

[NewGraphEnvironment]

> test <- sf::st_read('../../gis/form_pscis_20230825.gpkg')
Reading layer `form_pscis' from data source `/Users/airvine/Projects/gis/form_pscis_20230825.gpkg' using driver `GPKG'
Error in CPL_read_ogr(dsn, layer, query, as.character(options), quiet,  : 
  attempt to set index 1/1 in SET_STRING_ELT

same issue as here apparently https://github.com/NewGraphEnvironment/fish_passage_skeena_2022_reporting/issues/5

tried:

• moving gpkg to another location - did not work
• not loading any packages and using only sf call as recommended https://github.com/r-spatial/sf/issues/1087
• search mergin and geodiff on github for issue with "corrupt geopackage"
• removed row for site loaded as default to get table burned to project. That resulted in errror change

  Error in CPL_read_ogr(dsn, layer, query, as.character(options), quiet,  : 
  attempt to set index 0/0 in SET_STRING_ELT

this may have to do with renaming the gpkg when it was replaced with a newer version. shouldn't matter but...

[NewGraphEnvironment]

work around for now is to export as geojson as that seems to work

[NewGraphEnvironment]

better workaround is to export the file again and save as another gpkg with a different name (form_pscis_20230825_resaved.gpkg in this case). This avoids issues related to conflicting column types caused by geojson vs gpkg.