forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: omaetoy on August 14, 2005, 09:40:07 pm

Title: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 09:40:07 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: Nibbler on August 14, 2005, 09:45:38 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 09:59:32 pm

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

Quote

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

Title: Re: "There was an error while processing a database query" involving users
Post by: Joachim Müller on August 14, 2005, 10:14:02 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 10:45:34 pm

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?

Title: Re: "There was an error while processing a database query" involving users
Post by: Joachim Müller on August 14, 2005, 11:30:08 pm

post a link to your site

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 11:36:50 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: kegobeer on August 14, 2005, 11:45:38 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 11:48:51 pm

yes I do

Title: Re: "There was an error while processing a database query" involving users
Post by: kegobeer on August 14, 2005, 11:53:52 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 14, 2005, 11:58:13 pm

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

Title: Re: "There was an error while processing a database query" involving users
Post by: kegobeer on August 15, 2005, 02:26:39 am

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

Can you remove the user group you added?

Title: Re: "There was an error while processing a database query" involving users
Post by: omaetoy on August 15, 2005, 03:13:38 am

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.

Title: Re: "There was an error while processing a database query" involving users
Post by: asphyxiia on December 12, 2005, 07:36:45 am

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

Title: Re: "There was an error while processing a database query" involving users
Post by: asphyxiia on December 28, 2005, 05:47:42 pm

kegobeer where do we find myphpadmin?

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

Title: Re: "There was an error while processing a database query" involving users
Post by: Nibbler on December 28, 2005, 05:48:47 pm

Ask your host or install it yourself.

Title: Re: "There was an error while processing a database query" involving users
Post by: asphyxiia on December 29, 2005, 05:31:49 pm

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