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

[Stuart P. <gen...@ph...>]

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!
 
 
____________________________________________________________________________
____________________

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




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


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



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