Answers.Body: <p>Did something fail during one of the composer commands at one point? You may need to run <code>composer civicrm:publish</code> manually then to copy files into web/libraries. For the DB Error, that error has come up before but shouldn't on a brand new install. Usually <code>cv ext:upgrade</code> will fix that.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-19T11:35:01.467Z
Answers.LastActivityDate: 2022-08-19T11:35:01.467Z
Answers.UserDisplayName: Demerit
Body: <ul>
  <li>New Server: Intel Xeon-E2388G 3.2, with 64GB RAM and 2 1TB nvme on
  soft raid running ubuntu server</li>
  <li>Database Server: 10.4.24-MariaDB-1:10.4.24+maria~focal</li>
  <li>PHP 7.4.30, Memory Limit 512MB</li>
  <li>Drupal 9.4.5, Standard Install</li>
  <li>CiviCRM 5.52.2 Separate database with all permissions on Drupal and CiviCRM DBs and SUPER</li>
  <li>en_GB localisation files installed after cli installation</li>
  <li>No warnings at all on Drupal Status Report</li>
  </ul>
  <p>Installed clean installation on the above, composer Drupal, composer CiviCRM as per CLI installer guide. Visiting the /civicrm page for the first time, seen permissions problem but fixed this on /sites/default/files/civicrm/...
  Refreshed with the problem text gone. Nothing displaying, other than the civicrm footer. No CiviCRM pages at all.</p>
  <p>Followed the troubleshooting steps - caches, menu etc.
  Log file contains the following:</p>
  <pre><code>Aug 19 03:12:28  [error] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; exceptionHandler
          )
  
  [code] =&gt; -18
  [message] =&gt; DB Error: no such table
  [mode] =&gt; 16
  [debug_info] =&gt; SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, 
  
  `a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
  FROM  a
  ORDER BY `label` ASC
   [nativecode=1146 ** Table 'civicrmdb.a' doesn't exist]
      [type] =&gt; DB_Error
      [user_info] =&gt; SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
  FROM  a
  ORDER BY `label` ASC
   [nativecode=1146 ** Table 'civicrmdb.a' doesn't exist].....
  </code></pre>
  <p>Any ideas? Stuck! Thanks in advance.</p>
  <p>Edit after further research:
  CLI install command used:</p>
  <pre><code>cv core:install --cms-base-url=&quot;https://example.com&quot; --lang=&quot;en_GB&quot; --db=&quot;mysql://civicrmuser:password@localhost:3306/civicrmdb&quot; -v
  </code></pre>
  <p>Result of cv:</p>
  <pre><code>{
      &quot;srcPath&quot;: &quot;/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core&quot;,
      &quot;setupPath&quot;: &quot;/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/setup&quot;,
      &quot;settingsPath&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php&quot;,
      &quot;templateCompilePath&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c&quot;,
      &quot;cms&quot;: &quot;Drupal8&quot;,
      &quot;cmsBaseUrl&quot;: &quot;https://example.com&quot;,
      &quot;db&quot;: {
          &quot;server&quot;: &quot;localhost:3306&quot;,
          &quot;username&quot;: &quot;civicrmuser&quot;,
          &quot;password&quot;: &quot;password&quot;,
          &quot;database&quot;: &quot;civicrmdb&quot;,
          &quot;ssl_params&quot;: []
      },
      &quot;cmsDb&quot;: {
          &quot;server&quot;: &quot;localhost:3306&quot;,
          &quot;username&quot;: &quot;drupaluser&quot;,
          &quot;password&quot;: &quot;password&quot;,
          &quot;database&quot;: &quot;drupaldb&quot;,
          &quot;ssl_params&quot;: null
      },
      &quot;siteKey&quot;: &quot;mySiteKey&quot;,
      &quot;credKeys&quot;: [
          &quot;aes-cbc:hkdf-sha256:myCreds&quot;
      ],
      &quot;signKeys&quot;: [
          &quot;jwt-hs256:hkdf-sha256:mySign&quot;
      ],
      &quot;loadGenerated&quot;: null,
      &quot;lang&quot;: &quot;en_GB&quot;,
      &quot;components&quot;: [
          &quot;CiviEvent&quot;,
          &quot;CiviContribute&quot;,
          &quot;CiviMember&quot;,
          &quot;CiviMail&quot;,
          &quot;CiviReport&quot;
      ],
      &quot;extensions&quot;: [
          &quot;org.civicrm.search_kit&quot;
      ],
      &quot;paths&quot;: {
          &quot;civicrm.files&quot;: {
              &quot;url&quot;: &quot;https://example.com/sites/default/files/civicrm&quot;,
              &quot;path&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm&quot;
          }
      },
      &quot;settings&quot;: [],
      &quot;mandatorySettings&quot;: [],
      &quot;extras&quot;: []
  }
  </code></pre>
  <p>Output from cv vars:show -</p>
  <pre><code>{
      &quot;CIVI_CORE&quot;: &quot;/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/&quot;,
      &quot;CIVI_DB_ARGS&quot;: &quot;-h localhost -u civicrmdb -pcivicrmdb -P 3306 civicrmdb&quot;,
      &quot;CIVI_DB_DSN&quot;: &quot;mysql://civicrmuser:pass@localhost:3306/civicrmdb?new_link=true&quot;,
      &quot;CIVI_DB_HOST&quot;: &quot;localhost&quot;,
      &quot;CIVI_DB_NAME&quot;: &quot;civicrmdb&quot;,
      &quot;CIVI_DB_PASS&quot;: &quot;password&quot;,
      &quot;CIVI_DB_PORT&quot;: 3306,
      &quot;CIVI_DB_USER&quot;: &quot;civicrmuser&quot;,
      &quot;CIVI_FILES&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/&quot;,
      &quot;CIVI_LOG&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/ConfigAndLog/CiviCRM.random.log&quot;,
      &quot;CIVI_SETTINGS&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php&quot;,
      &quot;CIVI_SITE_KEY&quot;: &quot;mySiteKey&quot;,
      &quot;CIVI_TEMPLATEC&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c/&quot;,
      &quot;CIVI_UF&quot;: &quot;Drupal8&quot;,
      &quot;CIVI_URL&quot;: &quot;https://example.com/libraries/civicrm/core/&quot;,
      &quot;CIVI_VERSION&quot;: &quot;5.52.2&quot;,
      &quot;CMS_DB_ARGS&quot;: &quot;-h localhost -u drupaluser -pdrupaldb -P 3306 drupaldb&quot;,
      &quot;CMS_DB_DSN&quot;: &quot;mysql://drupaluser:password@localhost:3306/drupaldb?new_link=true&quot;,
      &quot;CMS_DB_HOST&quot;: &quot;localhost&quot;,
      &quot;CMS_DB_NAME&quot;: &quot;drupaldb&quot;,
      &quot;CMS_DB_PASS&quot;: &quot;password&quot;,
      &quot;CMS_DB_PORT&quot;: 3306,
      &quot;CMS_DB_USER&quot;: &quot;drupaluser&quot;,
      &quot;CMS_ROOT&quot;: &quot;/var/www/vhosts/example.com/httpdocs/web/&quot;,
      &quot;CMS_URL&quot;: &quot;https://example.com/&quot;,
      &quot;CMS_VERSION&quot;: &quot;9.4.5&quot;,
      &quot;IS_INSTALLED&quot;: &quot;1&quot;,
      &quot;SITE_TYPE&quot;: &quot;cv-auto&quot;
  }
  </code></pre>
  <p>Contents of vendor/civicrm... appears complete. Contents of web/libraries/civicrm... is definitely incomplete with hundreds of files missing including jquery etc which is obviously why it's no working.</p>
  <p>Is the full core and packages required at /libraries/ or should CIVI_URL in cv be something else?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-19T04:19:08.173Z
Comments.Text: I followed all the installation instructions exactly. I am now trying to figure out why civicrm is looking in web/libraries for dependencies and not in vendor/civicrm/civicrm-packages?! I have installed the asset plugin. Or do I need to modify paths away from the default?
Comments.UserDisplayName: Mark Carson
Tags: <installation>
Title: No CiviCRM pages on completely new install
ThreadText: # No CiviCRM pages on completely new install
  
  (Asked by: username_0 on 2022-08-19)
  
  * New Server: Intel Xeon-E2388G 3.2, with 64GB RAM and 2 1TB nvme on
    soft raid running ubuntu server
  * Database Server: 10.4.24-MariaDB-1:10.4.24+maria~focal
  * PHP 7.4.30, Memory Limit 512MB
  * Drupal 9.4.5, Standard Install
  * CiviCRM 5.52.2 Separate database with all permissions on Drupal and CiviCRM DBs and SUPER
  * en\_GB localisation files installed after cli installation
  * No warnings at all on Drupal Status Report
  
  Installed clean installation on the above, composer Drupal, composer CiviCRM as per CLI installer guide. Visiting the /civicrm page for the first time, seen permissions problem but fixed this on /sites/default/files/civicrm/...
  Refreshed with the problem text gone. Nothing displaying, other than the civicrm footer. No CiviCRM pages at all.
  
  Followed the troubleshooting steps - caches, menu etc.
  Log file contains the following:
  
  ```
  Aug 19 03:12:28  [error] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => exceptionHandler
          )
  
  [code] => -18
  [message] => DB Error: no such table
  [mode] => 16
  [debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, 
  
  `a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
  FROM  a
  ORDER BY `label` ASC
   [nativecode=1146 ** Table 'civicrmdb.a' doesn't exist]
      [type] => DB_Error
      [user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`description` AS `description`, `a`.`entity_name` AS `entity_name`, `a`.`items` AS `items`
  FROM  a
  ORDER BY `label` ASC
   [nativecode=1146 ** Table 'civicrmdb.a' doesn't exist].....
  
  ```
  
  Any ideas? Stuck! Thanks in advance.
  
  Edit after further research:
  CLI install command used:
  
  ```
  cv core:install --cms-base-url="https://example.com" --lang="en_GB" --db="mysql://civicrmuser:password@localhost:3306/civicrmdb" -v
  
  ```
  
  Result of cv:
  
  ```
  {
      "srcPath": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core",
      "setupPath": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/setup",
      "settingsPath": "/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php",
      "templateCompilePath": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c",
      "cms": "Drupal8",
      "cmsBaseUrl": "https://example.com",
      "db": {
          "server": "localhost:3306",
          "username": "civicrmuser",
          "password": "password",
          "database": "civicrmdb",
          "ssl_params": []
      },
      "cmsDb": {
          "server": "localhost:3306",
          "username": "drupaluser",
          "password": "password",
          "database": "drupaldb",
          "ssl_params": null
      },
      "siteKey": "mySiteKey",
      "credKeys": [
          "aes-cbc:hkdf-sha256:myCreds"
      ],
      "signKeys": [
          "jwt-hs256:hkdf-sha256:mySign"
      ],
      "loadGenerated": null,
      "lang": "en_GB",
      "components": [
          "CiviEvent",
          "CiviContribute",
          "CiviMember",
          "CiviMail",
          "CiviReport"
      ],
      "extensions": [
          "org.civicrm.search_kit"
      ],
      "paths": {
          "civicrm.files": {
              "url": "https://example.com/sites/default/files/civicrm",
              "path": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm"
          }
      },
      "settings": [],
      "mandatorySettings": [],
      "extras": []
  }
  
  ```
  
  Output from cv vars:show -
  
  ```
  {
      "CIVI_CORE": "/var/www/vhosts/example.com/httpdocs/vendor/civicrm/civicrm-core/",
      "CIVI_DB_ARGS": "-h localhost -u civicrmdb -pcivicrmdb -P 3306 civicrmdb",
      "CIVI_DB_DSN": "mysql://civicrmuser:pass@localhost:3306/civicrmdb?new_link=true",
      "CIVI_DB_HOST": "localhost",
      "CIVI_DB_NAME": "civicrmdb",
      "CIVI_DB_PASS": "password",
      "CIVI_DB_PORT": 3306,
      "CIVI_DB_USER": "civicrmuser",
      "CIVI_FILES": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/",
      "CIVI_LOG": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/ConfigAndLog/CiviCRM.random.log",
      "CIVI_SETTINGS": "/var/www/vhosts/example.com/httpdocs/web/sites/default/civicrm.settings.php",
      "CIVI_SITE_KEY": "mySiteKey",
      "CIVI_TEMPLATEC": "/var/www/vhosts/example.com/httpdocs/web/sites/default/files/civicrm/templates_c/",
      "CIVI_UF": "Drupal8",
      "CIVI_URL": "https://example.com/libraries/civicrm/core/",
      "CIVI_VERSION": "5.52.2",
      "CMS_DB_ARGS": "-h localhost -u drupaluser -pdrupaldb -P 3306 drupaldb",
      "CMS_DB_DSN": "mysql://drupaluser:password@localhost:3306/drupaldb?new_link=true",
      "CMS_DB_HOST": "localhost",
      "CMS_DB_NAME": "drupaldb",
      "CMS_DB_PASS": "password",
      "CMS_DB_PORT": 3306,
      "CMS_DB_USER": "drupaluser",
      "CMS_ROOT": "/var/www/vhosts/example.com/httpdocs/web/",
      "CMS_URL": "https://example.com/",
      "CMS_VERSION": "9.4.5",
      "IS_INSTALLED": "1",
      "SITE_TYPE": "cv-auto"
  }
  
  ```
  
  Contents of vendor/civicrm... appears complete. Contents of web/libraries/civicrm... is definitely incomplete with hundreds of files missing including jquery etc which is obviously why it's no working.
  
  Is the full core and packages required at /libraries/ or should CIVI\_URL in cv be something else?
  
  **Tags:** installation
  
  > **Comments:**
  > **username_0**: I followed all the installation instructions exactly. I am now trying to figure out why civicrm is looking in web/libraries for dependencies and not in vendor/civicrm/civicrm-packages?! I have installed the asset plugin. Or do I need to modify paths away from the default?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-08-19. Score: 0
  
  Did something fail during one of the composer commands at one point? You may need to run `composer civicrm:publish` manually then to copy files into web/libraries. For the DB Error, that error has come up before but shouldn't on a brand new install. Usually `cv ext:upgrade` will fix that.
  
  
  ---
  
  