[turba] [Spam?] Re: Upgrading from Turba 1.2 to 2.0

[Brett Charbeneau]

On Tue, 4 Jul 2006, Michael Rubinsky wrote:

MR> Quoting Brett Charbeneau <brett at wrl.org>:
MR> > 
MR> > For whatever reason, the turba mysql_create.sql script created two  turba
MR> > fields
MR> > called "object_members" and "object_type" which are NOT in the original
MR> > database.
MR> 
MR> What version of Turba did you say you were upgrading from? More than likely
MR> it is older than 1.2...

	Both test.php and the install package itself identify as 1.2 - I've not 
played with any earlier versions.

MR> > UNFORTUNATELY, while this routine did not result in any MySql errors, when
MR> > I
MR> > log into IMP and go to the Address Book the only thing I see in "My
MR> > Addressbook"
MR> > are entries for "D" and "S" - which I cannot delete. Below please see
MR> > appropriate chunks of my sources.php file:
MR> 
MR> Can you do:
MR> 
MR> EXPLAIN turba_objects;
MR> 
MR> on your new turba_objects table and post the results, along with maybe one
MR> or two rows of values (if no sensitive data is in there).


	I apologize for my ignorance of MySQL - I could not get this command to 
function from the mysql prompt, but phpadmin gave me this output:

EXPLAIN turba_objects



Field 			Type 		Null 	Key 	Default 	Extra
object_id 		varchar(32) 	  	PRI 	  	 
owner_id 		varchar(255) 	  	MUL 	  	 
object_name 		varchar(255) 	YES 	  	NULL 	 
object_alias 		varchar(32) 	YES 	  	NULL 	 
object_email 		varchar(255) 	YES 	  	NULL 	 
object_homeaddress 	varchar(255) 	YES 	  	NULL 	 
object_workaddress 	varchar(255) 	YES 	  	NULL 	 
object_homephone 	varchar(25) 	YES 	  	NULL 	 
object_workphone 	varchar(25) 	YES 	  	NULL 	 
object_cellphone 	varchar(25) 	YES 	  	NULL 	 
object_fax 		varchar(25) 	YES 	  	NULL 	 
object_title 		varchar(255) 	YES 	  	NULL 	 
object_company 		varchar(255) 	YES 	  	NULL 	 
object_notes 		text 		YES 	  	NULL 	 
object_uid 		varchar(255) 	YES 	  	NULL 	 
object_freebusyurl 	varchar(255) 	YES 	  	NULL 	 
object_smimepublickey 	text 		YES 	  	NULL 	 
object_pgppublickey 	text 		YES 	  	NULL 	 


-- 
********************************************************************
Brett Charbeneau
Network Administrator
Williamsburg Regional Library
7770 Croaker Road
Williamsburg, VA 23188-7064
(757)259-4044          www.wrl.org
(757)259-4079 (fax)    brett at wrl.org
********************************************************************