RE: [Phpgedview-talk] [Phpgedview-talk]Updating to ver 3.2.1

[John F. <Joh...@by...>]

Hi Stuart,

You need the new authentication_mysql.php file.  The readme instructions
should refer to the authenticate.php file which you will only have if
you are using Index mode.

--John


-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Stuart
Phethean
Sent: Monday, December 20, 2004 10:50 AM
To: php...@li...
Subject: [Phpgedview-talk] [Phpgedview-talk]Updating to ver 3.2.1

When I upload the new files for version 3.2.1, following the update
instructions in readme.txt I get the following errors. I have copied in
my
original config.php and authentication_mysql.php and chmod these to 777.
I
have checked that the index file (relocated into
/files/home2/phethean/cgi-bin/index) is also chmod to 777. If I use the
original config files it all starts up ok, but I don't want to loose any
subscriber data in the mysql database!
=20
=20
________________________________________________________________________
____
____________________

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line
235
ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_users (u_username VARCHAR(30) NOT NULL, u_password
VARCHAR(255), u_fullname VARCHAR(255), u_gedcomid TEXT, u_rootid TEXT,
u_canadmin ENUM('Y','N'), u_canedit TEXT, u_email TEXT, u_verified
VARCHAR(20), u_verified_by_admin VARCHAR(20), u_language VARCHAR(50),
u_pwrequested VARCHAR(20), u_reg_timestamp VARCHAR(50), u_reg_hashcode
VARCHAR(255), u_theme VARCHAR(50), u_loggedin ENUM('Y','N'),
u_sessiontime
INT(14), u_contactmethod VARCHAR(20), PRIMARY KEY(u_username))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_messages (m_id INT NOT NULL auto_increment, m_from
VARCHAR(255), m_to VARCHAR(30), m_subject VARCHAR(255), m_body TEXT,
m_created VARCHAR(255), PRIMARY KEY(m_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_favorites (fv_id INT NOT NULL auto_increment,
fv_username VARCHAR(30), fv_gid VARCHAR(10), fv_type VARCHAR(10),
fv_file
VARCHAR(100), PRIMARY KEY(fv_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_blocks (b_id INT NOT NULL auto_increment,
b_username
VARCHAR(100), b_location VARCHAR(30), b_order INT, b_name VARCHAR(255),
PRIMARY KEY(b_id))

ERROR:DB Error: already exists=20
SQL:CREATE TABLE pgv_news (n_id INT NOT NULL auto_increment, n_username
VARCHAR(100), n_date INT, n_title VARCHAR(255), n_text TEXT, PRIMARY
KEY(n_id))


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in /files/home2/phethean/test/authentication_mysql.php on line
210

Warning: Cannot modify header information - headers already sent by
(output
started at /files/home2/phethean/test/authentication_mysql.php:235) in
/files/home2/phethean/test/session.php on line 313=20




=20
=20
Best wishes,
=20
=20
Stuart
=20
 __________________________________
Stuart Phethean
Hampshire, UK
Family web Pages:
http://www.phethean.co.uk <http://www.phethean.co.uk/>=20
_____________________________________
=20
=20


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004



--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.0 - Release Date: 17/12/2004
=20



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.=20
http://productguide.itmanagersjournal.com/
_______________________________________________
Phpgedview-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpgedview-talk