Several pages won't load or give error messages

[emilynevitt]

I encountered a few different error messages, detailed below. I've put them as one issue to avoid spamming, but I could split them up if preferred.

Survey country and languages -> Review translations

• Error:
  Illuminate \ Database \ QueryException
  PHP 8.2.1
  11.43.2
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pivot' in 'where clause'

Location levels -> farms

• Clicking 'create farm' goes to blank page with no options; clicking the create button gives query exception error:
  Illuminate \ Database \ QueryException
  SQLSTATE[HY000]: General error: 1364 Field 'location_id' doesn't have a default value

Localisation: Place-based adaptations -> Time frame

• no survey rows
• no breadcrumbs at top of page for navigation

Localisation: Place-based adaptations -> Adapt diet quality module
Page doesn't load at all – error:
Call to a member function surveyRows() on null

Localisation: Place-based adaptations -> Customise place-based questionnaire

• page doesn't load at all – error:
  Typed static property Filament\Pages\BasePage::$view must not be accessed before initialization

Localisation: Place-based adaptations -> Initial pilot

• page doesn't load at all – error:
  SimpleSoftwareIO\QrCode\Generator::generate(): Argument #1 ($text) must be of type string, null given, called in /Users/stats4sdwork/Sites/holpa-platform/storage/framework/views/620d34badd617b780819a98c07f16310.php on line 35

LISP - customise indicators - match with existing...

• clicking on an indicator on the left gives modal error
  Cannot assign array to property App\Livewire\GlobalIndicators::$selectedDomain of type ?App\Models\Holpa\Domain

Monitor data collection (from dashboard)

• Doesn't go anywhere; link just jumps up the dashboard page a bit

[dave-mills]

Going through this list:

Survey country and languages -> Review translations

This whole section is currently broken because of the introduction of LocaleOwner and LanaguageOwner. I've added #183 as a sub-issue to handle it.

Location levels -> farms
Clicking 'create farm' goes to blank page with no options;

I don't think we ever added this? Up to now the only way to get farms into the system is via file import. I've added #184 to address it.

Localisation: Place-based adaptations -> Time frame
no survey rows

This works for me - I assume these didn't show for you because you didn't have any XlsformTemplates added through the custom seeders. (here or here in the readme)

no breadcrumbs at top of page for navigation

Quick fix - tbd.

Localisation: Place-based adaptations -> Adapt diet quality module
Page doesn't load at all – error:

Looks like an error caused by the team not having any Xlsforms. Hopefully this will never happen in the live version, but we should probably handle this possible error gracefully. Have added a low-priority issue #185 to handle this.

Localisation: Place-based adaptations -> Customise place-based questionnaire
page doesn't load at all – error:
Typed static property Filament\Pages\BasePage::$view must not be accessed before initialization

Again, this page doesn't work without XlsformTemplates loaded. It also requires at least one ChoiceList entry to be marked as localisable, otherwise it throws the unhelpful error you noted here. This is because it loads up 1 'page' per localisable entry; and doesn't have a fallback page to load if there are none. I think #185 handles this.

Localisation: Place-based adaptations -> Initial pilot

page doesn't load at all – error:
SimpleSoftwareIO\QrCode\Generator::generate(): Argument #1 ($text) must be of type string, null given, called in /Users/stats4sdwork/Sites/holpa-platform/storage/framework/views/620d34badd617b780819a98c07f16310.php on line 35

This page requires the team to be linked to an ODK Central project, otherwise there is no token string to make the QR code.

LISP - customise indicators - match with existing...
clicking on an indicator on the left gives modal error
Cannot assign array to property App\Livewire\GlobalIndicators::$selectedDomain of type ?App\Models\Holpa\Domain

Looks like a typing issue; the $data['indicator']['domain'] should probably be updated so that it's actually a data model object rather than an array. Added #186 to handle it.

Monitor data collection (from dashboard)
Doesn't go anywhere; link just jumps up the dashboard page a bit

Another "tbd" page.