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?

  • Not sure it makes any difference to the question at hand, but any particular reason you're using Backdrop 1.9?
    – Laryn
    Commented May 11, 2020 at 17:49
  • Ah, my mistake, I must've flashed back to a previous install. 1.15.1 Commented May 12, 2020 at 0:59

2 Answers 2


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/

  • 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? Commented May 9, 2020 at 21:13
  • 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.
    – Aidan
    Commented May 11, 2020 at 11:38
  • Pay special attention to step 9 in the docs, also described here: civicrm.stackexchange.com/questions/21085/…
    – Laryn
    Commented May 11, 2020 at 17:51
  • @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.... Commented May 12, 2020 at 1:02

Okay, I think I got it. First, start with Pradeep's answer and Laryn'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 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.

  • have you reported this bug? civicrm.org/bug-reporting
    – petednz - fuzion
    Commented May 12, 2020 at 19:17
  • 1
    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 Commented May 13, 2020 at 12:07
  • sorry to hear that. but reporting bugs is a key task in helping this community driven free open source project improve
    – petednz - fuzion
    Commented May 13, 2020 at 21:24
  • if you can offer suggestions on what can be improved on those instructions i will pass it on
    – petednz - fuzion
    Commented May 13, 2020 at 21:25
  • 1
    @petednz-fuzion Submitted Commented May 14, 2020 at 22:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.