coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: LilAngel on October 27, 2005, 09:23:16 PM

Title: Messed up my coppermine - help please!
Post by: LilAngel on October 27, 2005, 09:23:16 PM
/////////////
Title: Re: Messed up my coppermine - help please!
Post by: Nibbler on October 27, 2005, 09:28:57 PM
You'll need to reverse the actions of the 1.3 -> 1.4 update script. This is why downgrading is not recommended. In this case, you'll need to reverse this change


ALTER TABLE `CPG_users` CHANGE `user_location`  `user_profile1` VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_interests` `user_profile2` VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_website` `user_profile3` VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_occupation` `user_profile4` VARCHAR(255);
Title: Re: Messed up my coppermine - help please!
Post by: LilAngel on October 28, 2005, 07:41:19 PM
//////////////
Title: Re: Messed up my coppermine - help please!
Post by: Nibbler on October 28, 2005, 11:23:51 PM
Well yes, you need to do the reverse of that, which would be this:


ALTER TABLE `CPG_users` CHANGE `user_profile1` `user_location`   VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_profile2` `user_interests` VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_profile3 `user_website` ` VARCHAR(255);
ALTER TABLE `CPG_users` CHANGE `user_profile4` `user_occupation`  VARCHAR(255);
Title: Re: Messed up my coppermine - help please!
Post by: LilAngel on October 29, 2005, 08:00:02 PM
//////////////////////
Title: Re: Messed up my coppermine - help please!
Post by: kegobeer on October 29, 2005, 08:17:08 PM
Those are just notices - you can safely ignore them.  Just turn off debug notices in your config settings.