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
Have you enabled user registration in config ?
Yes and when I try to add a user in admin I also get "There was an error while processing a database query"
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 went to set to debug and accidentally hit reset to default....how can I fix this?
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
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
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.
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?
No we are just looking for the complete string after
QuoteUPDATE cpg133
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'
Did you run update.php?
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?
yes do it agian ...
I did it again and still cant do new users
- Post a link to you gallery
- Re-upload sql/basic.sql
- run update.php again
ands make sure your mysql user (you're using for cpg) has the rights to ALTER tables
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!"
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
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)
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