Answers.Body: <p>Final update, after installing and uninstalling Drupal/Civicrm multiple times, I think the root of all of my problems (which were semi-solved to various degrees by various fixes, but never completely solved) was having my web root at the wrong level.</p>
  <p>Unlike how I had Drupal 7 installed, I needed to have my domain point to [mydomain]/web and then install at www/www/[mydomain].  Prior to that I had my domain pointing at www/www, so the site was located at www/www/[mydomain]/web but the URL was rendering as www.[domain.org]/[domain.org]/web.</p>
  <p>I was using various htaccess redirects to get this setup to function, but then the site kept getting tripped up -- and Civi, in particular, was unhappy.</p>
  <p>In the answer to another question @demerit pointed out that my install seemed to be at the wrong level, so I did a final reset and although everything is not working perfectly, things are working now.</p>
  <p>Hope this may help someone else!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-28T21:18:09.393Z
Answers.LastActivityDate: 2024-05-28T21:18:09.393Z
Answers.UserDisplayName: Tiffani Chin
Answers.Body: <p><a href="https://i.sstatic.net/bmL2tFrU.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/bmL2tFrU.png" alt="Civi home screen" /></a></p>
  <p>Not really an answer but an update.  Did a full uninstall and reinstall.  According to my Drupal status page all systems are go.</p>
  <p>However, I still get this screen when I got to the Civi home screen.  When I click the Status link, the page is almost identical.</p>
  <p>It doesn't look like Civi nor is there any way for me to log in or try to set anything up.</p>
  <p>Am I missing something obvious here?</p>
  <p>Thank you!
  -tiffani</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-16T17:01:04.600Z
Answers.LastActivityDate: 2024-05-16T17:01:04.600Z
Answers.UserDisplayName: Tiffani Chin
Answers.Body: <p>After you installed Civi can you logout and login back into Civi?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-15T20:54:47.643Z
Answers.Text: I don't think I'm ever logging into Civi.  When I click the Civi link, I just get the front page content from Drupal and this note:
  
  "Access Keys:  
  System Status   Powered by CiviCRM 5.73.1, free and open source AGPLv3 software."
  
  I don't see anything that looks like a Civicrm  dashboard.
Answers.UserDisplayName: Tiffani Chin
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-16T08:05:03.933Z
Answers.Text: Yeah, I meant logout and login back
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-05-15T07:32:37.970Z
Answers.LastActivityDate: 2024-05-15T07:32:37.970Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Finally got a new install of Civi on what is a just installed Drupal 10 site.</p>
  <p>When I got to Civicrm, I get a system error with this informations:</p>
  <p>System Status: Error
  Public Assets Not Published
  Organization Setup
  Configure Default Mailbox
  Smarty Update (v2 =&gt; v4)</p>
  <p>When I lick the link below to &quot;Manage and see Details&quot; it just says System Error with no Civi dashboard, just the default page from my website (which I have never had appear on a Civi install before).</p>
  <p>I did look at the logs and got this:</p>
  <blockquote>
  <p>2024-05-14 14:50:27-0700  [error]
  $Fatal Error Details = array:3 [
  &quot;message&quot; =&gt; &quot;DB Error: constraint violation&quot;
  &quot;code&quot; =&gt; null
  &quot;exception&quot; =&gt; Civi\Core\Exception\DBQueryException {#2267
  #message: &quot;DB Error: constraint violation&quot;
  #code: 0
  #file: &quot;/home/vsource4/www/www/edboost.org/vendor/civicrm/civicrm-core/CRM/Core/Error.php&quot;
  #line: 974
  #cause: DB_Error {#2263
  +error_message_prefix: &quot;&quot;
  +mode: 16
  +level: 1024
  +code: -3
  +message: &quot;DB Error: constraint violation&quot;
  +userinfo: &quot;INSERT INTO <code>civicrm_dashboard_contact</code> (<code>dashboard_id</code> , <code>contact_id</code> , <code>column_no</code> , <code>is_active</code> ) VALUES ( 1 ,  2 ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (<code>vsource4_edboost2024_civicrm</code>.<code>civicrm_dashboard_contact</code>, CONSTRAINT <code>FK_civicrm_dashboard_contact_contact_id</code> FOREIGN KEY (<code>contact_id</code>) REFERENCES <code>civicrm_contact</code> (<code>id</code>) ON DELETE CASCAD)]&quot;
  +backtrace: array:46 [
  0 =&gt; array:6 [
  &quot;file&quot; =&gt; &quot;/home/vsource4/www/www/edboost.org/vendor/pear/db/DB.php&quot;
  &quot;line&quot; =&gt; 986
  &quot;function&quot; =&gt; &quot;__construct&quot;
  &quot;class&quot; =&gt; &quot;PEAR_Error&quot;
  &quot;type&quot; =&gt; &quot;-&gt;&quot;
  &quot;args&quot; =&gt; array:5 [
  0 =&gt; &quot;DB Error: constraint violation&quot;
  1 =&gt; -3
  2 =&gt; 16
  3 =&gt; array:2 [
  0 =&gt; &quot;CRM_Core_Error&quot;
  1 =&gt; &quot;exceptionHandler&quot;
  ]
  4 =&gt; &quot;INSERT INTO <code>civicrm_dashboard_contact</code> (<code>dashboard_id</code> , <code>contact_id</code> , <code>column_no</code> , <code>is_active</code> ) VALUES ( 1 ,  2 ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (<code>vsource4_edboost2024_civicrm</code>.<code>civicrm_dashboard_contact</code>, CONSTRAINT <code>FK_civicrm_dashboard_contact_contact_id</code> FOREIGN KEY (<code>contact_id</code>) REFERENCES <code>civicrm_contact</code> (<code>id</code>) ON DELETE CASCAD)]&quot;
  ]
  ]
  1 =&gt; array:7 [
  &quot;file&quot; =&gt; &quot;/home/vsource4/www/www/edboost.org/vendor/pear/pear-core-minimal/src/PEAR.php&quot;
  &quot;line&quot; =&gt; 575
  &quot;function&quot; =&gt; &quot;__construct&quot;
  &quot;class&quot; =&gt; &quot;DB_Error&quot;
  &quot;object&quot; =&gt; DB_Error {#2263}
  &quot;type&quot; =&gt; &quot;-&gt;&quot;
  &quot;args&quot; =&gt; array:4 [
  0 =&gt; -3
  1 =&gt; 16
  2 =&gt; array:2 [
  0 =&gt; &quot;CRM_Core_Error&quot;
  1 =&gt; &quot;exceptionHandler&quot;
  ]
  3 =&gt; &quot;INSERT INTO <code>civicrm_dashboard_contact</code> (<code>dashboard_id</code> , <code>contact_id</code> , <code>column_no</code> , <code>is_active</code> ) VALUES ( 1 ,  2 ,  1 ,  1 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (<code>vsource4_edboost2024_civicrm</code>.<code>civicrm_dashboard_contact</code>, CONSTRAINT <code>FK_civicrm_dashboard_contact_contact_id</code> FOREIGN KEY (<code>contact_id</code>) REFERENCES <code>civicrm_contact</code> (<code>id</code>) ON DELETE CASCAD)]&quot;
  ]
  ]
  2 =&gt; array:6 [
  &quot;file&quot; =&gt; &quot;/home/vsource4/www/www/edboost.org/vendor/pear/pear-core-minimal/src/PEAR.php&quot;
  &quot;line&quot; =&gt; 223
  &quot;function&quot; =&gt; &quot;_raiseError&quot;
  &quot;class&quot; =&gt; &quot;PEAR&quot;
  &quot;type&quot; =&gt; &quot;::&quot;
  &quot;args&quot; =&gt; array:8 [
  0 =&gt; DB_mysqli {#283
  +_debug: false
  +_default_error_mode: null
  +_default_error_options: null
  +_default_error_handler: &quot;&quot;
  +_error_class: &quot;DB_Error&quot;
  +_expected_errors: []
  +fetchmode: 1
  +fetchmode_object_class: &quot;stdClass&quot;
  +was_connected: null
  +last_query: &quot;INSERT INTO <code>civicrm_dashboard_contact</code> (<code>dashboard_id</code> , <code>contact_id</code> , <code>column_no</code> , <code>is_active</code> ) VALUES ( 1 ,  2 ,  1 ,  1 ) &quot;
  +options: array:8 [
  &quot;result_buffering&quot; =&gt; 500
  &quot;persistent&quot; =&gt; false
  &quot;ssl&quot; =&gt; false
  &quot;debug&quot; =&gt; 0
  &quot;seqname_format&quot; =&gt; &quot;%s_seq&quot;
  &quot;autofree&quot; =&gt; false
  &quot;portability&quot; =&gt; 0
  &quot;optimize&quot; =&gt; &quot;performance&quot;
  ]
  Someone with a similar problem on a Word Press site seems to have solved the problem by logging out and logging back in, but I tried that and also made a new admin Drupal user but same result.</p>
  </blockquote>
  <p>Any thoughts?  It took me a few tries to get this installed due to some other issues.  Do I uninstall and try again?</p>
  <p>** Update - I did a full uninstall including deleting the database.  Did a reinstall on a fresh DB from the command line and I've checked the civicrm.settings.php to make sure all the paths are correct.  Same issue.</p>
  <p>Thanks for any help!
  -tiffani</p>
  
Tags: <drupal><installation>
Title: System Error and no dashboard on install
ThreadText: # System Error and no dashboard on install
  
  (Asked by: username_0 on 2024-05-14)
  
  Finally got a new install of Civi on what is a just installed Drupal 10 site.
  
  When I got to Civicrm, I get a system error with this informations:
  
  System Status: Error
  Public Assets Not Published
  Organization Setup
  Configure Default Mailbox
  Smarty Update (v2 => v4)
  
  When I lick the link below to "Manage and see Details" it just says System Error with no Civi dashboard, just the default page from my website (which I have never had appear on a Civi install before).
  
  I did look at the logs and got this:
  
  > 2024-05-14 14:50:27-0700 [error]
  > $Fatal Error Details = array:3 [
  > "message" => "DB Error: constraint violation"
  > "code" => null
  > "exception" => Civi\Core\Exception\DBQueryException {#2267
  > #message: "DB Error: constraint violation"
  > #code: 0
  > #file: "/home/vsource4/www/www/edboost.org/vendor/civicrm/civicrm-core/CRM/Core/Error.php"
  > #line: 974
  > #cause: DB\_Error {#2263
  > +error\_message\_prefix: ""
  > +mode: 16
  > +level: 1024
  > +code: -3
  > +message: "DB Error: constraint violation"
  > +userinfo: "INSERT INTO `civicrm_dashboard_contact` (`dashboard_id` , `contact_id` , `column_no` , `is_active` ) VALUES ( 1 , 2 , 1 , 1 ) [nativecode=1452 \*\* Cannot add or update a child row: a foreign key constraint fails (`vsource4_edboost2024_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCAD)]"
  > +backtrace: array:46 [
  > 0 => array:6 [
  > "file" => "/home/vsource4/www/www/edboost.org/vendor/pear/db/DB.php"
  > "line" => 986
  > "function" => "\_\_construct"
  > "class" => "PEAR\_Error"
  > "type" => "->"
  > "args" => array:5 [
  > 0 => "DB Error: constraint violation"
  > 1 => -3
  > 2 => 16
  > 3 => array:2 [
  > 0 => "CRM\_Core\_Error"
  > 1 => "exceptionHandler"
  > ]
  > 4 => "INSERT INTO `civicrm_dashboard_contact` (`dashboard_id` , `contact_id` , `column_no` , `is_active` ) VALUES ( 1 , 2 , 1 , 1 ) [nativecode=1452 \*\* Cannot add or update a child row: a foreign key constraint fails (`vsource4_edboost2024_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCAD)]"
  > ]
  > ]
  > 1 => array:7 [
  > "file" => "/home/vsource4/www/www/edboost.org/vendor/pear/pear-core-minimal/src/PEAR.php"
  > "line" => 575
  > "function" => "\_\_construct"
  > "class" => "DB\_Error"
  > "object" => DB\_Error {#2263}
  > "type" => "->"
  > "args" => array:4 [
  > 0 => -3
  > 1 => 16
  > 2 => array:2 [
  > 0 => "CRM\_Core\_Error"
  > 1 => "exceptionHandler"
  > ]
  > 3 => "INSERT INTO `civicrm_dashboard_contact` (`dashboard_id` , `contact_id` , `column_no` , `is_active` ) VALUES ( 1 , 2 , 1 , 1 ) [nativecode=1452 \*\* Cannot add or update a child row: a foreign key constraint fails (`vsource4_edboost2024_civicrm`.`civicrm_dashboard_contact`, CONSTRAINT `FK_civicrm_dashboard_contact_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCAD)]"
  > ]
  > ]
  > 2 => array:6 [
  > "file" => "/home/vsource4/www/www/edboost.org/vendor/pear/pear-core-minimal/src/PEAR.php"
  > "line" => 223
  > "function" => "\_raiseError"
  > "class" => "PEAR"
  > "type" => "::"
  > "args" => array:8 [
  > 0 => DB\_mysqli {#283
  > +\_debug: false
  > +\_default\_error\_mode: null
  > +\_default\_error\_options: null
  > +\_default\_error\_handler: ""
  > +\_error\_class: "DB\_Error"
  > +\_expected\_errors: []
  > +fetchmode: 1
  > +fetchmode\_object\_class: "stdClass"
  > +was\_connected: null
  > +last\_query: "INSERT INTO `civicrm_dashboard_contact` (`dashboard_id` , `contact_id` , `column_no` , `is_active` ) VALUES ( 1 , 2 , 1 , 1 ) "
  > +options: array:8 [
  > "result\_buffering" => 500
  > "persistent" => false
  > "ssl" => false
  > "debug" => 0
  > "seqname\_format" => "%s\_seq"
  > "autofree" => false
  > "portability" => 0
  > "optimize" => "performance"
  > ]
  > Someone with a similar problem on a Word Press site seems to have solved the problem by logging out and logging back in, but I tried that and also made a new admin Drupal user but same result.
  
  Any thoughts? It took me a few tries to get this installed due to some other issues. Do I uninstall and try again?
  
  \*\* Update - I did a full uninstall including deleting the database. Did a reinstall on a fresh DB from the command line and I've checked the civicrm.settings.php to make sure all the paths are correct. Same issue.
  
  Thanks for any help!
  -username_0
  
  **Tags:** drupal, installation
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_0 on 2024-05-28. Score: 1 | Accepted answer
  
  Final update, after installing and uninstalling Drupal/Civicrm multiple times, I think the root of all of my problems (which were semi-solved to various degrees by various fixes, but never completely solved) was having my web root at the wrong level.
  
  Unlike how I had Drupal 7 installed, I needed to have my domain point to [mydomain]/web and then install at www/www/[mydomain]. Prior to that I had my domain pointing at www/www, so the site was located at www/www/[mydomain]/web but the URL was rendering as www.[domain.org]/[domain.org]/web.
  
  I was using various htaccess redirects to get this setup to function, but then the site kept getting tripped up -- and Civi, in particular, was unhappy.
  
  In the answer to another question @demerit pointed out that my install seemed to be at the wrong level, so I did a final reset and although everything is not working perfectly, things are working now.
  
  Hope this may help someone else!
  
  
  ---
  
  ### Answer by username_0 on 2024-05-16. Score: 0
  
  [![Civi home screen](https://i.sstatic.net/bmL2tFrU.png)](https://i.sstatic.net/bmL2tFrU.png)
  
  Not really an answer but an update. Did a full uninstall and reinstall. According to my Drupal status page all systems are go.
  
  However, I still get this screen when I got to the Civi home screen. When I click the Status link, the page is almost identical.
  
  It doesn't look like Civi nor is there any way for me to log in or try to set anything up.
  
  Am I missing something obvious here?
  
  Thank you!
  -username_0
  
  
  ---
  
  ### Answer by username_1 on 2024-05-15. Score: 0
  
  After you installed Civi can you logout and login back into Civi?
  
  > **Comments:**
  > **username_0**: I don't think I'm ever logging into Civi.  When I click the Civi link, I just get the front page content from Drupal and this note:  "Access Keys:   System Status   Powered by CiviCRM 5.73.1, free and open source AGPLv3 software."  I don't see anything that looks like a Civicrm  dashboard.  
  > **username_1**: Yeah, I meant logout and login back  
  
  ---
  
  