Viewing 10 posts - 1 through 10 (of 12 total)
Author
Posts
  • #10041

    It’s been quite awhile since I started from scratch. Got the latest version installed. Went thourgh setup wizard. Error at end:

    SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘personal_facts’ for key ‘PRIMARY’

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.9 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10042

    Was the database you used a new empty one, or did it have existing data in it? I can see how it might happen if using an existing database, but not a completely fresh one.

    I won’t be able to fully investigate this for a day or two though, and by then the next release will be available so perhaps wait for that?

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #10043

    It was imported from the other domain. So, it contains everything that tables contain for a site. This one is “standalone” whereas my private site has the main dB and two others.

    I’m doing the testing on The Royals as it’s not as critical. No hurry, will wait for your release notice and try again. Of note, the admin user and password for the database differ between the two domains as required by my host. I know the config.ini contains that info so it wouldn’t match. Not sure if that’s a factor either.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.9 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10044

    Sounds like you did things in the wrong order.

    You should run setup first. That creates a fresh database or uses an existing empty one).
    Then if you want to import an existing database, empty the (not delete) the newly created one before you import the old one. You can still do that now if you want.

    It sounds like you either tried to import the old data over the top of the newly created one or imported the old one before you ran setup. Either would create the error you describe.

    So no reason for you to wait, as the new version will not change this.

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #10045

    Sounds like you did things in the wrong order.

    You should run setup first. That creates a fresh database or uses an existing <span class=”gdbbx-bbcode-underline” style=”text-decoration: underline;”>empty</span> one).
    Then if you want to import an existing database, empty the (not delete) the newly created one before you import the old one. You can still do that now if you want.

    As I had difficulty importing the tables from “theroyals”, my host did it for me using the uploaded gzip file. Therefore, don’t want to delete. If I create new dB called “royals” and run setup, how do I get the tables with all my data over? Or do I need exact name thereby deleting database, setup, ask host to re-import?

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.9 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10046

    If you have a database, with all the old data already in place; and you have the code already installed from using setup, then all you need to do is modify the file /data/config.ini.php so it contains the credentials of the database you want to use.

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #10047

    Okay, copied config.ini over and changed it. As I didn’t have the admin page open, now need to access it to change status to available. Isn’t it mydomain.com/databasename/admin.php? It didn’t work.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.9 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10048

    I can confirm the “admin.php”, but not the rest. That all depends how you have set up your installation. there is no rule for that.

    Mine, for example, is http://www.mydomain/admin.php

    I would find it odd that you might use mydomain/databsename though. A common one would be mydomain/kiwitrees/. But you need to look at where your files are stored.

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #10049

    It wasn’t my database, only my imagination 🙂

    Still get the This website is temporarily unavailable notice.
    Oops! The webserver is unable to connect to the database server. It could be busy, undergoing maintenance, or simply broken. You should try again in a few minutes or contact the website administrator.

    The database reported the following error message:

    SQLSTATE[HY000] [2002] Connection refused

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9<royals.rbcsolutions.ca
    >
    The Gerrer Rebbes 3.3.9 <royals.rbcsolutions.ca/index.php?ged=rebbes>

  • #10050

    It wasn’t my database, only my imagination 🙂

    Still get the This website is temporarily unavailable notice.
    Oops! The webserver is unable to connect to the database server. It could be busy, undergoing maintenance, or simply broken. You should try again in a few minutes or contact the website administrator.

    The database reported the following error message:

    SQLSTATE[HY000] [2002] Connection refused

    That means the information you put in config.ini.php is wrong. You will need to get your web host to help you fix that.

    Nigel
    My personal kiwitrees site is www.our-families.info
Viewing 10 posts - 1 through 10 (of 12 total)
  • The topic ‘New setup’ is closed to new replies.