nant, I realize you are busy, but if you are going to take the time to reply or make a post, can you please be more helpful? beat's replies are a good example of being helpful.
I cannot use this, obviously (so, I need the right code to use for a fresh install, where all files are presently in place):
UPDATE jos_comprofiler_fields SET `table`='#__users' WHERE name='email';
UPDATE jos_comprofiler_fields SET `table`='#__users' WHERE name='lastvisitDate';
UPDATE jos_comprofiler_fields SET `table`='#__users' WHERE name='registerDate';
ALTER TABLE jos_comprofiler ADD `registeripaddr` VARCHAR( 50 ) DEFAULT '' NOT NULL AFTER `lastupdatedate`;
ALTER TABLE jos_comprofiler ADD `cbactivation` VARCHAR( 50 ) DEFAULT '' NOT NULL AFTER `registeripaddr`;
ALTER TABLE jos_comprofiler ADD message_last_sent DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `hits`;
ALTER TABLE jos_comprofiler ADD message_number_sent INT( 11 ) DEFAULT 0 NOT NULL AFTER message_last_sent;
ALTER TABLE jos_comprofiler_field_values ADD INDEX fieldid_ordering (`fieldid`, `ordering` );
ALTER TABLE jos_comprofiler_fields ADD INDEX `tabid_pub_prof_order` ( `tabid` , `published` , `profile` , `ordering` );
ALTER TABLE jos_comprofiler_fields ADD INDEX `readonly_published_tabid` ( `readonly` , `published` , `tabid` );
ALTER TABLE jos_comprofiler_fields ADD INDEX `registration_published_order` ( `registration` , `published` , `ordering` );
ALTER TABLE jos_comprofiler_members ADD INDEX `pamr` ( `pending` , `accepted` , `memberid` , `referenceid` );
ALTER TABLE jos_comprofiler_members ADD INDEX `aprm` ( `accepted` , `pending` , `referenceid` , `memberid` );
ALTER TABLE jos_comprofiler_members ADD INDEX `membrefid` ( `memberid` , `referenceid` );
ALTER TABLE jos_comprofiler_plugin ADD INDEX `type_pub_order` ( `type` , `published` , `ordering` );
ALTER TABLE jos_comprofiler_tabs ADD INDEX `enabled_position_ordering` ( `enabled` , `position` , `ordering` );
ALTER TABLE jos_comprofiler_lists ADD INDEX `pub_ordering` ( `published` , `ordering` );
ALTER TABLE jos_comprofiler_lists ADD INDEX `default_published` ( `default` , `published` );
ALTER TABLE jos_comprofiler_userreports ADD INDEX `status_user_date` ( `reportedstatus` , `reporteduser` , `reportedondate` );
ALTER TABLE jos_comprofiler_userreports ADD INDEX `reportedbyuser_ondate` ( `reportedbyuser` , `reportedondate` );
ALTER TABLE jos_comprofiler_views ADD INDEX `lastview` ( `lastview` );
ALTER TABLE jos_comprofiler_views ADD INDEX `profile_id_lastview` (`profile_id`,`lastview`);
UPDATE jos_comprofiler SET `user_id`=`id` WHERE 1>0;
ALTER TABLE jos_comprofiler ADD UNIQUE KEY user_id (`user_id`);
ALTER TABLE jos_comprofiler ADD INDEX `apprconfbanid` ( `approved` , `confirmed` , `banned` , `id` );
ALTER TABLE jos_comprofiler ADD INDEX `avatappr_apr_conf_ban_avatar` ( `avatarapproved` , `approved` , `confirmed` , `banned` , `avatar` );
ALTER TABLE jos_comprofiler ADD INDEX `lastupdatedate` ( `lastupdatedate` );
Post edited by: rofar, at: 2008/07/01 18:55