forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: CGPhotos on October 05, 2006, 10:04:44 pm

Title: Database in upgrade
Post by: CGPhotos on October 05, 2006, 10:04:44 pm

I imported my database from my 1.3.3 version to my 1.4.9 and everything works except no new users can register.  Where do  I need to change the script?  My user tables begin with cpg133

Title: Re: Database in upgrade
Post by: Nibbler on October 05, 2006, 10:06:13 pm

Have you enabled user registration in config ?

Title: Re: Database in upgrade
Post by: CGPhotos on October 05, 2006, 10:12:48 pm

Yes and when I try to add a user in admin I also get "There was an error while processing a database query"

Title: Re: Database in upgrade
Post by: Joachim Müller on October 05, 2006, 11:10:54 pm

Then enable debug_mode to see the actual error message (the query that fails). Do not post debug_output, but just the error message.

Title: Re: Database in upgrade
Post by: CGPhotos on October 06, 2006, 03:29:23 am

I went to set to debug and accidentally hit reset to default....how can I fix this?

Title: Re: Database in upgrade
Post by: Sami on October 06, 2006, 07:05:37 am

You can't !
how did you do that it'll prompt you for sure

But you didn't loss anything except any custom file-type defined and any bridge information
You should set all other config setting again

Or you could reastore your old db backup again if you don't change anything after last reastore

Title: Re: Database in upgrade
Post by: CGPhotos on October 06, 2006, 02:28:50 pm

It did not prompt!!  one click and POOF Gone!!!  Up again....here is the info from debug:

"There was an error while processing a database query" and the first line in the debug box says:
While executing query "UPDATE cpg133..." then all the info

Title: Re: Database in upgrade
Post by: Abbas Ali on October 06, 2006, 02:34:21 pm

Quote from: CGPhotos on October 06, 2006, 02:28:50 pm

"UPDATE cpg133..." then all the info

That all info is the actual error message. Do as suggested and post complete error message.

Title: Re: Database in upgrade
Post by: CGPhotos on October 06, 2006, 02:41:10 pm

Quote from: GauGau on October 05, 2006, 11:10:54 pm

Then enable debug_mode to see the actual error message (the query that fails). Do not post debug_output, but just the error message.

I am not sure what exactly is requested from this post  Do you want everything in the debug box or not?

Title: Re: Database in upgrade
Post by: Sami on October 06, 2006, 05:20:45 pm

No we are just looking for the complete string after

Quote

UPDATE cpg133

Title: Re: Database in upgrade
Post by: CGPhotos on October 06, 2006, 06:57:07 pm

While executing query "UPDATE cpg133_users SET user_name = 'test', user_email = 'carin@caringlaser.com', user_active = 'YES', user_group = '2', user_profile1 = 'USA', user_profile2 = 'Team 1', user_profile3 = 'NA', user_profile4 = '', user_profile5 = '', user_profile6 = '', user_group_list = '', user_password = 'test1' WHERE user_id = '16'" on 0

mySQL error: Unknown column 'user_profile1' in 'field list'

Title: Re: Database in upgrade
Post by: Nibbler on October 06, 2006, 07:00:57 pm

Did you run update.php?

Title: Re: Database in upgrade
Post by: CGPhotos on October 06, 2006, 07:07:42 pm

Yes I did thats how all the albums and users got to this server with the updated version.  Do I need to do it again?

Title: Re: Database in upgrade
Post by: Sami on October 08, 2006, 06:04:57 am

yes do it agian ...

Title: Re: Database in upgrade
Post by: CGPhotos on October 09, 2006, 02:57:06 am

I did it again and still cant do new users

Title: Re: Database in upgrade
Post by: Sami on October 09, 2006, 05:47:43 am

- Post a link to you gallery
- Re-upload sql/basic.sql
- run update.php again

Title: Re: Database in upgrade
Post by: Stramm on October 09, 2006, 10:56:01 am

ands make sure your mysql user (you're using for cpg) has the rights to ALTER tables

Title: Re: Database in upgrade
Post by: CGPhotos on October 09, 2006, 01:49:40 pm

1.  http://www.caringlaserphotography.com/coppermine/index.php
2.  I re uploaded the basic sql
3.  I rerean phpupdate and when I viewed the files I founf the oly thing wrong is I am missing this:
"albums/edit/no_FTP-uploads_into_this_folder!"

Title: Re: Database in upgrade
Post by: CGPhotos on October 09, 2006, 01:50:35 pm

Quote from: Stramm on October 09, 2006, 10:56:01 am

ands make sure your mysql user (you're using for cpg) has the rights to ALTER tables

I am not sure how to do this

Title: Re: Database in upgrade
Post by: Sami on October 09, 2006, 02:24:20 pm

Your registration is fine and it's working !
I've already register a user "sami"
but you have miss configuration
- Your admin email is :you@somewhere.com (This way all activation mail goes to junk mail for sure)
- You didn't set the correct url for your gallery (this way all activation URL goes to sourceforge.net instead of your gallery)

Title: Re: Database in upgrade
Post by: CGPhotos on October 09, 2006, 03:43:52 pm

Thank you, I did have that set but in all the resetting and re uploading makes it hard to remember which things require you do redo other stuff.....thank you for your patience. ;D