Answers.Body: <p>Okay, I think I got it. First, start with Pradeep's answer and Laryn's in the comments.</p>
  
  <p>There's a bug in the output text from Administer >> System Settings >> CMS Integration. It starts the block of text with <code>$database_prefix = array(</code> but it still needs the code as listed in the documentation (in an uncopyable screenshot): <code>$databases['default']['default']['prefix'] = array(</code>.</p>
  
  <p>Note for those confused if they reused the same name for the database and the user: with databases/users named Backdrop and CiviCRM, "Backdrop" goes under user in the code described by Laryn, but CiviCRM shows up as the prefix in the code copied out of CMS Integration. Aside from the initial line, the rest works as expected.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-12T19:17:34.773Z
Answers.Text: have you reported this bug? https://civicrm.org/bug-reporting
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-13T12:07:32.900Z
Answers.Text: I hadn't, and I'm willing to, but reading that list of steps makes it almost as difficult as fixing my problem in the first place
Answers.UserDisplayName: Jeff Porten
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-13T21:24:59.747Z
Answers.Text: sorry to hear that. but reporting bugs is a key task in helping this community driven free open source project improve
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-13T21:25:40.503Z
Answers.Text: if you can offer suggestions on what can be improved on those instructions i will pass it on
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-14T22:56:50.127Z
Answers.Text: @petednz-fuzion Submitted
Answers.UserDisplayName: Jeff Porten
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-15T01:26:30.763Z
Answers.Text: Well done Jeff - would be great if you could close the loop by putting a link in your Answer
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-12T01:16:50.287Z
Answers.LastActivityDate: 2020-05-12T01:16:50.287Z
Answers.UserDisplayName: Jeff Porten
Answers.Body: <p>Try adding cms integration in your backdrop settings.php</p>
  
  <p>CiviCRM >> Administer >> System Settings >> CMS Integration.</p>
  
  <p>Step by step documentation : <a href="https://docs.civicrm.org/sysadmin/en/latest/integration/backdrop/views/" rel="nofollow noreferrer">https://docs.civicrm.org/sysadmin/en/latest/integration/backdrop/views/</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-09T21:13:59.527Z
Answers.Text: I am following the documentation but the code examples do not match the output from the CMS Integration screen, and I don't have the PHP fu to figure out what to patch?
Answers.UserDisplayName: Jeff Porten
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-11T11:38:54.747Z
Answers.Text: The code in the documentation screenshot is just an example.  Copy and paste the settings for your system exactly as is from the CMS Integration page.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-11T17:51:16.300Z
Answers.Text: Pay special attention to step 9 in the docs, also described here: https://civicrm.stackexchange.com/questions/21085/how-do-i-get-views-working-with-civicrm-and-backdrop
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-12T01:02:02.180Z
Answers.Text: @aidan The code in the documentation is a screenshot, we confused folks have no choice but to get the code from the CMS integration page. What I meant earlier is that the data structure in the CMS integration output does not match what the docs say it will be. Going back to try again....
Answers.UserDisplayName: Jeff Porten
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-09T11:30:35.853Z
Answers.LastActivityDate: 2020-05-09T11:30:35.853Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Hours-old install of CiviCRM 5.25 under Backdrop 1.9. I've gotten as far as putting in the Board of Directors with dummy bio information, which I was trying to use to generate a View with a page display of names and bios. I get this, with various permutations of what table doesn't exist depending on what I'm doing:</p>
  
  <p><code>SQLSTATE[42S02]: Base table or view not found: 1146 Table 'B1.civicrm_uf_match' doesn't exist</code></p>
  
  <p>Both Backdrop and CiviCRM are using the same mysql user "B1", who has GRANT ALL permissions on the B1 and C5 tables. Obviously, the data is still there when I go back to review it in the Civi interface. What to check next?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-11T17:49:14.037Z
Comments.Text: Not sure it makes any difference to the question at hand, but any particular reason you're using Backdrop 1.9?
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-12T00:59:22.090Z
Comments.Text: Ah, my mistake, I must've flashed back to a previous install. 1.15.1
Comments.UserDisplayName: Jeff Porten
Tags: <permissions><drupal-views><mysql><backdrop>
Title: Baffled by Views database error on new install
ThreadText: # Baffled by Views database error on new install
  
  (Asked by: username_0 on 2020-05-09)
  
  Hours-old install of CiviCRM 5.25 under Backdrop 1.9. I've gotten as far as putting in the Board of Directors with dummy bio information, which I was trying to use to generate a View with a page display of names and bios. I get this, with various permutations of what table doesn't exist depending on what I'm doing:
  
  `SQLSTATE[42S02]: Base table or view not found: 1146 Table 'B1.civicrm_uf_match' doesn't exist`
  
  Both Backdrop and CiviCRM are using the same mysql user "B1", who has GRANT ALL permissions on the B1 and C5 tables. Obviously, the data is still there when I go back to review it in the Civi interface. What to check next?
  
  **Tags:** permissions, drupal-views, mysql, backdrop
  
  > **Comments:**
  > **username_1**: Not sure it makes any difference to the question at hand, but any particular reason you're using Backdrop 1.9?  
  > **username_0**: Ah, my mistake, I must've flashed back to a previous install. 1.15.1  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2020-05-12. Score: 2 | Accepted answer
  
  Okay, I think I got it. First, start with Pradeep's answer and username_1's in the comments.
  
  There's a bug in the output text from Administer >> System Settings >> CMS Integration. It starts the block of text with `$database_prefix = array(` but it still needs the code as listed in the documentation (in an uncopyable screenshot): `$databases['default']['default']['prefix'] = array(`.
  
  Note for those confused if they reused the same name for the database and the user: with databases/users named Backdrop and CiviCRM, "Backdrop" goes under user in the code described by username_1, but CiviCRM shows up as the prefix in the code copied out of CMS Integration. Aside from the initial line, the rest works as expected.
  
  > **Comments:**
  > **username_2**: have you reported this bug? https://civicrm.org/bug-reporting  
  > **username_0**: I hadn't, and I'm willing to, but reading that list of steps makes it almost as difficult as fixing my problem in the first place  
  > **username_2**: sorry to hear that. but reporting bugs is a key task in helping this community driven free open source project improve  
  > **username_2**: if you can offer suggestions on what can be improved on those instructions i will pass it on  
  > **username_0**: @petednz-fuzion Submitted  
  > **username_2**: Well done Jeff - would be great if you could close the loop by putting a link in your Answer  
  
  ---
  
  ### Answer by username_3 on 2020-05-09. Score: 3
  
  Try adding cms integration in your backdrop settings.php
  
  CiviCRM >> Administer >> System Settings >> CMS Integration.
  
  Step by step documentation : <https://docs.civicrm.org/sysadmin/en/latest/integration/backdrop/views/>
  
  > **Comments:**
  > **username_0**: I am following the documentation but the code examples do not match the output from the CMS Integration screen, and I don't have the PHP fu to figure out what to patch?  
  > **username_4**: The code in the documentation screenshot is just an example.  Copy and paste the settings for your system exactly as is from the CMS Integration page.  
  > **username_1**: Pay special attention to step 9 in the docs, also described here: https://civicrm.stackexchange.com/questions/21085/how-do-i-get-views-working-with-civicrm-and-backdrop  
  > **username_0**: @aidan The code in the documentation is a screenshot, we confused folks have no choice but to get the code from the CMS integration page. What I meant earlier is that the data structure in the CMS integration output does not match what the docs say it will be. Going back to try again....  
  
  ---
  
  