Database in upgrade

[CGPhotos]

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

[Nibbler]

Have you enabled user registration in config ?

[CGPhotos]

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

[Joachim Müller]

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

[CGPhotos]

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

[Sami]

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

[CGPhotos]

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

[Abbas Ali]

"UPDATE cpg133..." then all the info

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

[CGPhotos]

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?

[Sami]

No we are just looking for the complete string after

UPDATE cpg133

[CGPhotos]

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'

[Nibbler]

Did you run update.php?

[CGPhotos]

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?

[Sami]

yes do it agian ...

[CGPhotos]

I did it again and still cant do new users

[Sami]

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

[Stramm]

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

[CGPhotos]

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!"

[CGPhotos]

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

[Sami]

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)