This was the message I received when I tried to run the first script;
phpmyfamily cannot access the database server (localhost) I've checked and re-
checked and I'm certain I have the correct connection details in
database.inc.php.
Do you just read a topic once? I've been trying to carry on a conversation
with you in my previous post.
As always, thanks for your help.
Bob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
During the upgrade it's possible that the connection details need to be in both inc/config.inc.php and inc/database.inc.php or completely removed
from inc/config.inc.php - that's the only thing I can think of right now...
It must be finding inc/database.inc.php or the require_once directive in the
upgrade script would fail so I'm going to assume there's a conflict with the 2
files
If you keep having problems you might be able to get started by editing the
upgrade script (upgrade-1.4.2-2.0.0.php) to use hardcoded connection details -
I'm assuming that's where the problem is.... but if there are problems with
this then there may be other problems...
For info the other place where a database connection is made is at:
modules/db/DAOFactory.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I deleted the database connection details section from config.inc.php and ran
the 1st script, I got a message that the connection with the server had been
reset (something about timed out). I then tried to run it again and got this
message: Table 'family_config' already existsphpmyfamily: Error creating
config table!!! So I guess it connected and got started. I know next to
nothing about php so I'm kinda at a loss. What should my next step be? I'm
sorry but if we get this done you're going to heve to walk me through it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have used phpmyfamily for years from version 1.2.4 and had at last plucked
up the courage to upgrade to the latest version today. I made back-ups of the
site and the database as precaution.
I followed the upgrade instructions and the upgrade seemed to go ok except
that I got errors that page headers already existed etc..
Then when I did the second upgrade from 2.0.0 to 2.0.0-beta I got the
following error after competion...
in this error: ALTER TABLE family_users ENGINE = InnoDB phpmyfamily: Error
changing users table
my table prefixes are ourfam... so the users table is ourfam_users, and this
still exists with all data as do all the other tables with prefix ourfam_
there are 13 tables in all.
Edward J.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't know how to add a new topic header here - sorry.
This program will not install for any user that is using MySQL 5.5. That's
because the timestamp directive on line 75 of install.php is no longer
supported. It has been deprecated since MySQL 5.1.
This directive - updated timestamp(14) NOT NULL, will error out in 5.5
and should be replaced with updated timestamp NOT NULL,.
Pretty simple fix, but it could conceivably prevent complaints and headaches
that are sure to come, plus it should work fine on older versions of MySQL
too!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am trying to get email functioning in version 2.1.0-alpha-2 using ssmtp but I can not see where to enter the xeceutable path /usr/sbin/ssmtp. Where do I go to change the mail program details?
Thank you
Bill
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This was the message I received when I tried to run the first script;
phpmyfamily cannot access the database server (localhost) I've checked and re-
checked and I'm certain I have the correct connection details in
database.inc.php.
Do you just read a topic once? I've been trying to carry on a conversation
with you in my previous post.
As always, thanks for your help.
Bob
I do keep looking just have other things to do :)
During the upgrade it's possible that the connection details need to be in
both inc/config.inc.php and inc/database.inc.php or completely removed
from inc/config.inc.php - that's the only thing I can think of right now...
It must be finding inc/database.inc.php or the require_once directive in the
upgrade script would fail so I'm going to assume there's a conflict with the 2
files
If you keep having problems you might be able to get started by editing the
upgrade script (upgrade-1.4.2-2.0.0.php) to use hardcoded connection details -
I'm assuming that's where the problem is.... but if there are problems with
this then there may be other problems...
For info the other place where a database connection is made is at:
modules/db/DAOFactory.php
I deleted the database connection details section from config.inc.php and ran
the 1st script, I got a message that the connection with the server had been
reset (something about timed out). I then tried to run it again and got this
message: Table 'family_config' already existsphpmyfamily: Error creating
config table!!! So I guess it connected and got started. I know next to
nothing about php so I'm kinda at a loss. What should my next step be? I'm
sorry but if we get this done you're going to heve to walk me through it.
Before running again either delete the family_config table or in the script
change
//Create the config table
include_once "admin/configTable.php";
to
//Create the config table
/*
include_once "admin/configTable.php";
*/
Hi,
I have used phpmyfamily for years from version 1.2.4 and had at last plucked
up the courage to upgrade to the latest version today. I made back-ups of the
site and the database as precaution.
I followed the upgrade instructions and the upgrade seemed to go ok except
that I got errors that page headers already existed etc..
Then when I did the second upgrade from 2.0.0 to 2.0.0-beta I got the
following error after competion...
ALTER TABLE
family_users
ENGINE = InnoDB phpmyfamily: Error changing userstable
And when I try to access
http://genesrus.org/myfam I get the following
message on an otherwise blank page
Fatal error: Class 'Config' not found in
/home/genesrus/public_html/myfam/index.php on line 24
Help please :)
Edward J.
Just noticed something on my above post...
in this error: ALTER TABLE
family_users
ENGINE = InnoDB phpmyfamily: Errorchanging users table
my table prefixes are ourfam... so the users table is ourfam_users, and this
still exists with all data as do all the other tables with prefix ourfam_
there are 13 tables in all.
Edward J.
Hi,
Have you created, changed and checked inc/database.inc.php?
That error seems to indicate that the value for tblprefix in
inc/database.inc.php is still set to family_ instead of being changed to
ourfam_
I don't know how to add a new topic header here - sorry.
This program will not install for any user that is using MySQL 5.5. That's
because the timestamp directive on line 75 of install.php is no longer
supported. It has been deprecated since MySQL 5.1.
This directive -
updated
timestamp(14) NOT NULL, will error out in 5.5and should be replaced with
updated
timestamp NOT NULL,.Pretty simple fix, but it could conceivably prevent complaints and headaches
that are sure to come, plus it should work fine on older versions of MySQL
too!
I am trying to get email functioning in version 2.1.0-alpha-2 using ssmtp but I can not see where to enter the xeceutable path /usr/sbin/ssmtp. Where do I go to change the mail program details?
Thank you
Bill
Moved to a new topic