Posts

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

kiwi wrote:

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

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

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: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

macalter wrote:

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