coppermine-gallery.com/forum

when someone is trying to regiester on my site it says:
"There was an error while processing a database query."

code:

While executing query "INSERT INTO cpg130_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_location, user_interests, user_website, user_occupation) VALUES (NOW(), 'NO', '11f7cd1ca2cf6c38bd2ef776d00f567d', 'Milka', 'july', 'adas@yahoo.com', '', '', '', 'Student' )" on 0

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

And this is when I (admin) is trying to add a user:

There was an error while processing a database query

code:

While executing query "UPDATE cpg130_users SET user_name           = 'bla', user_email          = 'lars@linsson.com', user_active    = 'YES', user_group           = '2', user_location  = 'bla', user_interests = 'bla ', user_website          = 'bla', user_occupation= 'bla', user_group_list      = '', user_password = 'bla' WHERE user_id = '37'" on 0

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

and under that it says:

File: /home/virtual/linsson.com/public_html/2.lars/include/functions.inc.php - Line: 110

debug:

USER:
------------------
Array
(
    [ID] => 6d7014850b349f4bc5d00caf75f33183
    [am] => 1
    [liv] => Array
        (
           

• => 476
              [1] => 475
              [2] => 474
              [3] => 473
              [4] => 472
          )
  
      [search] => ###larstravel
      [lap] => 1
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_group] => 1
      [user_active] => YES
      [user_name] => LarsLindqvist
      [user_password] => ********
      [user_lastvisit] => 2005-07-28 10:21:44
      [user_regdate] => 2004-08-09 15:54:52
      [user_group_list] =>
      [user_email] =>
      [user_profile3] => www.linsson.com
      [user_profile1] => Nyköping, SWEDEN
      [user_profile2] =>
      [user_profile4] =>
      [user_actkey] =>
      [user_profile5] =>
      [user_profile6] =>
      [disk_max] => 10000000
      [disk_min] => 10000000
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 10
      [num_URI_upload] => 10
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 1
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 10000000
      [can_see_all_albums] => 1
      [group_id] => 1
      [groups] => Array
          (
              [1] => 1
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg130_filetypes;
      [1] => SELECT * FROM cpg130_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'd67c653953989875d7bc437dc07e94f3'
      [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg130_usergroups WHERE group_id in (1)
      [3] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1
      [4] => DELETE FROM cpg130_banned WHERE expiry < 1122538990
      [5] => SELECT * FROM cpg130_banned WHERE ip_addr='193.13.124.66' OR ip_addr='193.13.124.66' OR user_id=1
      [6] => SELECT user_id FROM cpg130_users WHERE user_name = 'bla' AND user_id != 37
      [7] => UPDATE cpg130_users SET user_name           = 'bla', user_email          = 'lars@linsson.com', user_active    = 'YES', user_group           = '2', user_location  = 'bla', user_interests = 'bla ', user_website          = 'bla', user_occupation= 'bla', user_group_list      = '', user_password = 'bla' WHERE user_id = '37'
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [op] => update
      [user_id] => 37
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
      [user_name] => bla
      [user_password] => bla
      [user_active] => YES
      [user_group] => 2
      [group_list] => Array
          (
             
• => 2
          )
  
      [user_email] => lars@linsson.com
      [user_location] => bla
      [user_interests] => bla
      [user_website] => bla
      [user_occupation] => bla
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.4 - OK
  ------------------
  mySQL version: 4.0.18-log
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.15 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  JPG Support enabled
  PNG Support enabled
  WBMP Support enabled
  XBM Support enabled
  ==========================
  Module: mysql
  ------------------
  Active Persistent Links 0
  Active Links 1
  Client API version 4.0.18
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/local/mysql/include/mysql
  MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | On | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | popen,chown,chgrp,chmod,touch | popen,chown,chgrp,chmod,touch
  file_uploads | On | On
  include_path | .:/usr/local/lib/php | .:/usr/local/lib/php
  open_basedir | /home/virtual/linsson.com:/home/virtual/_tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | webmaster@linsson.com | no value
  sendmail_path | /usr/sbin/sendmail -t -i -f webmaster@linsson.com | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 6M | 6M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.094 seconds - 8 queries in 0.008 seconds - Album set :
  

Use a tool like phpMyAdmin, browse coppermine's user table and check that a column "user_location" actually exists. If it doesn't, then you probably have deleted it accidentally. It has to be user_location varchar(255) NOT NULL default '', - re-insert the column.

thanks for the fast reply! I thought I would let dreamvieaver search trhu my whole website for " user_location varchar(255) NOT NULL default ''," and as u said It cant find it. then I tried to find that user table and the right user_location but I couldnt figure out where I should put it.... please help...
I will keep searching the forums and web,,,

cheers

lars

you don't do this in a file: it happens directly on your database. That's why I suggested using phpMyAdmin (http://www.phpmyadmin.net/) or similar. Ask your webhost for it (he may have a similar tool like cpanel available), or install it.
Sidenote: don't use Dreamweaver to edit your coppermine files unless you know your way around extremely well. Your OS is capable of searching for particular srtings in files as well. I also have the impression that you're using an outdated version of coppermine, so please post a link to your site as well.

www.linsson.com/2.lars
So you mean it might be solved if I update my database?
thanks alot for the help gaugau!

no, that's not what I was suggesting. You don't update anything, you fix things that are broken (either by accident by you, or by something your webhost did, or because your site got hacked, or because of a technical malfunction like a harddisk error). As you don't appear to be very experienced I recommend asking your webhost for support.

My webhost told me they cant help me with that so it looks like i have to try my self or ask some of my more experienced friends... Is it possible to get some tips how to work it out?

thanks

lars

take a look at the content of the sql folder that comes with coppermine. The file schema.sql contains the query that creates the tables. If a table that is required doesn't exist, build it using the query taken from that file. Remember to change your db prefix in the query. You run queries using phpMyAdmin. You better ask yourself first: why did the tables vanish in the first place? If your site got hacked, you'll have to close all existing vulnerabilities first. A good place to start is trivial passwords - change them asap.