Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: "There was an error while processing a database query" involving users  (Read 12294 times)

0 Members and 1 Guest are viewing this topic.

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7

"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.
« Last Edit: August 15, 2005, 06:21:55 am by GauGau »
Logged

Nibbler

  • Guest
Re: "There was an error while processing a database query" involving users
« Reply #1 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,
Logged

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: "There was an error while processing a database query" involving users
« Reply #2 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: "There was an error while processing a database query" involving users
« Reply #3 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.
Logged

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: "There was an error while processing a database query" involving users
« Reply #4 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?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: "There was an error while processing a database query" involving users
« Reply #5 on: August 14, 2005, 11:30:08 pm »

post a link to your site
Logged

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: "There was an error while processing a database query" involving users
« Reply #7 on: August 14, 2005, 11:45:38 pm »

If you switch to the classic theme, do you still have these errors?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: "There was an error while processing a database query" involving users
« Reply #8 on: August 14, 2005, 11:48:51 pm »

yes I do
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: "There was an error while processing a database query" involving users
« Reply #9 on: August 14, 2005, 11:53:52 pm »

Have you made any modifications to Coppermine (mods/hacks, etc)?  Did you upgrade recently?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: "There was an error while processing a database query" involving users
« Reply #10 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.
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: "There was an error while processing a database query" involving users
« Reply #11 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?
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

omaetoy

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Re: "There was an error while processing a database query" involving users
« Reply #12 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.
Logged

asphyxiia

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 28
Re: "There was an error while processing a database query" involving users
« Reply #13 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
Logged

asphyxiia

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 28
Re: "There was an error while processing a database query" involving users
« Reply #14 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 :)
Logged

Nibbler

  • Guest
Re: "There was an error while processing a database query" involving users
« Reply #15 on: December 28, 2005, 05:48:47 pm »

Ask your host or install it yourself.
Logged

asphyxiia

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 28
Re: "There was an error while processing a database query" involving users
« Reply #16 on: December 29, 2005, 05:31:49 pm »

OOOhh so its the domain hosts file/section? oook ;) thanks
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.