Search Forums
Forums
Kiwitrees on Twitter
    Tags

    contact links, custom text, GEDCOM errors, source, lists individuals families, editor, help, simpl_research, release, pages, modules, mail, bug reporting, resources, road map, title, validation, Georgian, edit, wish, kiwitrees 2.0.2, updates, 3.0.0. setup, date, delete, IE problem, Export/Import, surname, responsive menus, admin, roadmap, burial, birth, dropbox. token, kiwitrees, Histo, emmigration, seo, autocomplete, server, events of close relatives, tab, Administration, simpl_pages, fixing errors, set link, block, sidebar, emigration, not married, errors, php 5.6, marriage, 3.2.3, gallery, beta, clipboard, FAQ, 3.0.0, search

    Topic:   Kiwitrees 3.2.3 MySql access problem  

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

    Viewing 11 posts - 1 through 11 (of 11 total)
    • Author
      Posts
    • #7629

      jamesl
      Participant

      22 posts

      Hello all,

      On my local machine (iMac running Mac OS X Sierra) I’m attempting an upgrade from Kiwitrees 3.1.1 to 3.2.3. I ran into a problem with the database configuration, which threw up an error message:
      SQLSTATE[HY000] [2002] No such file or directory

      Does anyone know what could be causing this problem? I do have other php software working with SQL, including Webtrees and WordPress.

      Thanks in advance for any help.

      James

      #7632
      kiwi
      kiwi
      Keymaster

      1443 posts

      Hi James

      That error message “usually” implies a problem connecting to your database, i.e. something wrong with your kiwitrees/data/config.ini.php file that contains the connection details.

      My first guess would be that you coulld have fallen prey to the MAC upgrade issue described in the kiwitrees upgrade FAQ :

      NOTE for Macintosh users. Step 4 assumes you are using a copy tool that merges directories rather than replaces them. (Merge is standard behaviour on Windows and Linux.) If you use the Macintosh Finder or other similar tool to perform step 3, it will replace your configuration, media and other directories with the empty/default ones from the installation. This would be very bad (but you did take a backup in step 1, didn’t you!). Further details and recommendations for suitable tools can be found by searching google.com

      Any other guesses would be pure guesswork at this stage. A quick Google search for the error message throws up dozens of different possibilities – it is a pretty generic error 🙁 It might be an issue best resolved by your web host.

      Nigel

      My personal kiwitrees site is www.our-families.info

      #7633

      jamesl
      Participant

      22 posts

      I have now solved the problem. I had to use 127.0.0.1 for the server name, instead of ‘localhost’.

      However, you’re quite right that I did lose the configuration file, which is why I had to go through the configuration setup.
      Fortunately, I do have a backup copy of my media directory.

      Thanks for your help. I’ll be more careful next time!

      James

      #7634
      kiwi
      kiwi
      Keymaster

      1443 posts

      Glad to hear it’s fixed 🙂

      Regarding your backup media file (and other backup issues), you might find the new Backup to Dropbox” tool useful.

      Nigel

      My personal kiwitrees site is www.our-families.info

      #7635

      jamesl
      Participant

      22 posts

      Unfortunately, the software still isn’t working properly, even after going through the configuration procedure.
      I get the following error messages:

      ERROR 2: Invalid argument supplied for foreach()
      0 Error occurred on line 102 of file MenuBar.php in function getChartsMenu
      1 called from line 60 of file module.php in function getMenu
      2 called from line 269 of file MenuBar.php in function getMainMenus
      3 called from line 161 of file header.php in function require
      4 called from line 197 of file Page.php in function pageHeader
      5 called from line 48 of file individual.php
      Warning: Invalid argument supplied for foreach() in /Users/james/Sites/kiwitrees/library/WT/MenuBar.php on line 102

      which overwrite much of the display,

      Warning: Invalid argument supplied for foreach() in /Users/james/Sites/kiwitrees/library/WT/MenuBar.php on line 102

      #7636
      kiwi
      kiwi
      Keymaster

      1443 posts

      There have been a LOT of significant changes since 3.1.1, As a result skipping versions, although technically OK, usually means it is hard to follow all the issues that can crop up at each stage.

      In this case I suspect that this paragraph (from the upgrade instructions for version 3.2.1) may help:

      There are no special requirements if you are upgrading from any version later than 3.0.0. but you are likely to find initially that you have no menus displayed. To fix this, login (if necessary set your browser URL to your-domain/login.php to do this), and visit the administration pages. Just visiting there is sufficient to complete the upgrade process and allow the menus to display normally again. If you cannot access login at all, simply delete the folder /modules_v3/menu_calendar/ from your server. That is the one causing this issue.

      Nigel

      My personal kiwitrees site is www.our-families.info

      #7637

      jamesl
      Participant

      22 posts

      Hello Nigel,

      I visited the administration pages, which display correctly, but when I returned to the family tree pages the error messages were still present.

      James

      #7638
      kiwi
      kiwi
      Keymaster

      1443 posts

      Did you try

      … simply delete the folder /modules_v3/menu_calendar/ from your server.

      Nigel

      My personal kiwitrees site is www.our-families.info

      #7639

      jamesl
      Participant

      22 posts

      There is no such folder present. Should I create it?

      #7640
      kiwi
      kiwi
      Keymaster

      1443 posts

      There is no such folder present. Should I create it?

      Not really – it needs to be deleted, so if it’s not there that’s not the problem. There may be something else that’s not meant to be there. Can you send me a list or screen dump of the folders that are in “kiwitrees /modules_v3/”.

      This issue will be specific to your circumstances so if you want to take this off-line email me direct. (kiwi3685@me.com or admin@kiwitrees.net). It might be quicker.

      Nigel

      My personal kiwitrees site is www.our-families.info

      #7641
      kiwi
      kiwi
      Keymaster

      1443 posts

      Update to this issue:

      Warning: Invalid argument supplied for foreach() in /Users/james/Sites/kiwitrees/library/WT/MenuBar.php on line 102

      James and I identified that this was being caused by the Fan chart module failing to load correctly. This in turn was because his PHP installation did not include the FreeType library that the fanchart needs. This is normally included by default in any PHP installation, so it’s rare to find this error.

      Nigel

      My personal kiwitrees site is www.our-families.info

    Viewing 11 posts - 1 through 11 (of 11 total)

    You must be logged in to reply to this topic.