1

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?

2
  • Not sure it makes any difference to the question at hand, but any particular reason you're using Backdrop 1.9? May 11 '20 at 17:49
  • Ah, my mistake, I must've flashed back to a previous install. 1.15.1 May 12 '20 at 0:59
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/

4
  • 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? May 9 '20 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
    May 11 '20 at 11:38
  • Pay special attention to step 9 in the docs, also described here: civicrm.stackexchange.com/questions/21085/… May 11 '20 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.... May 12 '20 at 1:02
2

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.

6
  • have you reported this bug? civicrm.org/bug-reporting
    – petednz - fuzion
    May 12 '20 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 May 13 '20 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
    May 13 '20 at 21:24
  • if you can offer suggestions on what can be improved on those instructions i will pass it on
    – petednz - fuzion
    May 13 '20 at 21:25
  • 1
    @petednz-fuzion Submitted May 14 '20 at 22:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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