# Manual testing #1

## General

* [X] Changes to enable fen database access 2026-05-09 cause a critical failure on the wordpress website.   Plugin disabled and wait for codex limits to reset to address.
* [X] Plugin did not know fen database name
* [X] Be robust against missing credentials
* [X] Be robust against (partly) missing schema
* [X] Do not take a long time executing on plugin register
* [X] ads and advertisers where ad-in-issue(125) only shows advertiser name field (twice) - it should include all ads and all advertisers fields in the result.  The same goes for all built-in joins.
* [X] Mailshot test "Select a mailshot" error is misleading because a mailshot was selected,  it should say "load recipients".  Better still - make "load recipients" obsolete.  Load on page entry and change of data source.  Remove button.
* [X] Mailshot test to above DSL with template "{{ ads_adsize }}
  {{ ads_state }}
  {{ advertisers_advertisername }}
  {{ advertisers_islapsed }}
  {{ advertisers_home_phone }}" returned:  "qp Confirmed A R Aspinall & Sons Ltd �"
* [X] DSL should allow field test to "blank" - which should be true for null and empty string.
* [X] fenedgec_members.renewal_accounts_with_contacts generate error "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1"
* [X] "contacts and accounts and issues where fen1-contact and issue(125)" gives error "No approved join path between accounts and issues" - should allow the join to "tack on" the issue data
* [X] "contacts and accounts and issues where fen1-contact and issue(125) and member-or-affiliate-or-parish-council" gives too many (103) - need is_deleted filter generates error: "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='"
* [X] "contacts and accounts and issues where fen1-contact and issue(125) and member-or-affiliate-or-parish-council and account-has-article-in-issue(125)" validates OK, but preview gives: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
* [X] issues.CopyDate and issue.PublicationDate render as e.g. "2026-02-23 00:00:00",  would prefer to render dates as e.g. "Friday 23 February 2026"
* [X] I made an edit to a mailshot (),  with a 9kb message.  Save did not close the dialog - but did not show any errors.  There was a long pause (long enough to start typing this report) before it appeared to have had an effect (mailshot saved message).  But Edit button on Mailshot doesn't appear to do anything now browser shows page still loading.   https://fenedge.co.uk is not responding.
* [X] Edit Data Source save DSL="ads and advertisers where issue(125)" takes a very long long time to repond.
* [X] Downloaded merged pdf or .zip should be named after maiilshot purpose
* [X] Mailshot data sources.  Add "Duplicate" button per row.
* [X] Select a single row in "review recipients".   "Run Mailshot to selected rows" says "Run mailshot to 1 selected rows?".  Yes -> error "None of the selected recipient rows exist in the current query result."
* [X] Error report from wordpress. - packaging was missing a file
* [ ] Subject to "Memory box café generates an error from receiveing yahoo email "subject contains an invalid character".   Need to check rules for character set in subject and modify special characters accordingly.
