Search
Forums
Kiwitrees on Twitter
    Tags

    DSGVO, simpl_research, Require visitor authentication, add, Fancy imagebar, not married, advent, divorce, descendants, Default record, server, Batch Updates, chart, living, drag, .mo, fancy image bar, add missing death, reports, title, age, 3.1, progress, BURI, menus, edit menu, pop-ups, type, latest version, simpl_pages, order, googlemaps, media_links, library, fatal error, updates, upgrade, defacto, 2.0, emmigration, notes, prison, data errors, sanity checker, ckeditor, danish, button, folder, missing data, login, set link, stories, Search and replace, beta, I18N, Advanced search, Administration, fancy tree view, sanity, index

    Topic:   New setup  

    This topic contains 11 replies, has 2 voices, and was last updated by kiwi kiwi 8 months, 2 weeks ago.

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

      466 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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10042
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
      macalter
      macalter
      Participant

      466 posts

      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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10044
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
      macalter
      macalter
      Participant

      466 posts

      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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10046
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
      macalter
      macalter
      Participant

      466 posts

      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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10048
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
      macalter
      macalter
      Participant

      466 posts

      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: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10050
      kiwi
      kiwi
      Keymaster

      1660 posts

      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
      #10091
      macalter
      macalter
      Participant

      466 posts

      I created an empty SQL database and ran setup. When it got to log in page I went to my FTP directory and substituted the empty database name for the imported name. It worked. I am now at the log in page. I’m one version behind so before reviewing modules etc will run the 3.3.3 update. After backup 🙂

      Would you suggest this route when I do bring over my personal family dB? Not in hurry to do so, so may wait until I’m more comfortable with what took place.

      -----
      [updated: 01 Apr 2018]
      MacOS: 10.11.6  (El Capitan)
      Safari  11.1;  Firefox 59.0.2

      PHP 7.1 Fast CGI
      mySQL server: 5.1.56

      Kiwitrees:
      "The Royals 3.3.3 (03)" <royals.rbcsolutions.ca>

      "Rebbes of Ger 3.3.3 (03)" <private>

      "Uncle Ummie's Journal 3.3.3 (03)" <private>

      #10092
      kiwi
      kiwi
      Keymaster

      1660 posts

      Would you suggest this route when I do bring over my personal family dB? Not in hurry to do so, so may wait until I’m more comfortable with what took place.

      No. It’s not necessary to make life that complex.

      If you have already imported your database from the old to a new server, that is all you need. You don’t need to run setup at all. Just copy all the kiwitrees 3.3.2 files from your old system to wherever you want them on your new server, then modify the file /data/config.ini.php so it’s content settings match those required by the new server.

      Once that is done, you can upgrade to 3.3.3 in the normal way – which is just copying files again.

      Nigel
      My personal kiwitrees site is www.our-families.info
    Viewing 12 posts - 1 through 12 (of 12 total)

    You must be logged in to reply to this topic.