"There was an error while processing a database query" involving users

[omaetoy]

"There was an error while processing a database query"

I get this error when I try to edit any user or when a new user tries to register.  The only changes I can think of was I added a group for users.  I did a search, but I couldn't find anything similar to this.  Any help is appreciated.

[Nibbler]

Any search would have told you to enable debug mode and post the mysql error message you receive,

[omaetoy]

This is what I get when I try to modify a user:

While executing query "UPDATE cpg133_users SET user_name           = 'AussiRayne', user_email          = 'AussiRayne@aol.com', user_active    = 'YES', user_group           = '2', user_location  = '', user_interests = '', user_website          = '', user_occupation= '', user_group_list      = '' WHERE user_id = '8'" on 0

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

File: /home/www/omaetoy/cpg133/include/functions.inc.php - Line: 105

I get the same error when a new user tries to register.  Is there more information I need to provide?  Please help in any way possible.  Thanks

[Joachim Müller]

has been posted many times, a search would have told you so:
http://forum.coppermine-gallery.net/index.php?topic=20128.0 and others.

[omaetoy]

I ran versioncheck.php and it found no outdated files, though there were dozens of notices about an undefined index in versioncheck.php.   Some of the file versions are higher versions than the cpg version.  Is it supposed to be that way?

[Joachim Müller]

post a link to your site

[omaetoy]

http://www.omaetoy.net/cpg133/index.php

[kegobeer]

If you switch to the classic theme, do you still have these errors?

[omaetoy]

yes I do

[kegobeer]

Have you made any modifications to Coppermine (mods/hacks, etc)?  Did you upgrade recently?

[omaetoy]

I haven't.  I don't think anyone else would have.  The only thing I did was add a group for users.

[kegobeer]

Use phpMyAdmin to examine the cpg133_users table.  Is there a field called user_location?

Can you remove the user group you added?

[omaetoy]

The fields for location, website, interests and occupation were all missing so I added them and the problem seems to have gone away.  Thank you for your help.

[asphyxiia]

My new users can't register either i get exactly the same error.

However my fields for website, interest etc are there and im still haveing the problem

[asphyxiia]

kegobeer where do we find myphpadmin?

please forgive my lack of knowledge but it is how i learn

[Nibbler]

Ask your host or install it yourself.

[asphyxiia]

OOOhh so its the domain hosts file/section? oook thanks