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.
  
  
  ---
  
  