forum.coppermine-gallery.net

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

Code: [Select]

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:

Code: [Select]

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.