Topic: Database in upgrade (Read 9765 times)

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

Nibbler · « **Reply #1 on:** October 05, 2006, 10:06:13 pm »

Have you enabled user registration in config ?

CGPhotos · « **Reply #2 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"

Joachim Müller · « **Reply #3 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.

CGPhotos · « **Reply #4 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?

Sami · « **Reply #5 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

CGPhotos · « **Reply #6 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

Abbas Ali · « **Reply #7 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.

CGPhotos · « **Reply #8 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?

Sami · « **Reply #9 on:** October 06, 2006, 05:20:45 pm »

No we are just looking for the complete string after

Quote

UPDATE cpg133

CGPhotos · « **Reply #10 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'

Nibbler · « **Reply #11 on:** October 06, 2006, 07:00:57 pm »

Did you run update.php?

CGPhotos · « **Reply #12 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?

Sami · « **Reply #13 on:** October 08, 2006, 06:04:57 am »

yes do it agian ...

CGPhotos · « **Reply #14 on:** October 09, 2006, 02:57:06 am »

I did it again and still cant do new users

Sami · « **Reply #15 on:** October 09, 2006, 05:47:43 am »

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

Stramm · « **Reply #16 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

CGPhotos · « **Reply #17 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!"

CGPhotos · « **Reply #18 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

Sami · « **Reply #19 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)

News:

Author Topic: Database in upgrade (Read 9765 times)

Nibbler

Nibbler