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

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

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

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

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

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

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

Did you try

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

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

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

jamesl wrote:

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. ([email protected] or [email protected]). It might be quicker.

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