upload failed

[vorw]

hello everyone, good neews 
actually, bad neews 
i've got private gallery on coppermine script (http://coppermine.mazec.org). Yesterday, i changed something in my mysql database (not about coppermine datas), and now i tried to upload some picz, and it didnt work..  :-\\
you can try upload some picz to user galeries after registration. I think, that I deleted something in sql database, because that was all, what was I doing with coppermine last week..
everything seems okay, expect upload picz 
does anyone have any suggestion what could be wrong?

here's log..

adding a new pictures to emptz gallery through batch add..

btw, I can give the admin access to gallery and sql server to anyone, if he is willing to help me..

----------------------------------------

USER:
------------------
Array
(
    [ID] => 7c88f249b4d8f4a10352960ffd9425c7
    [am] => 1
    [liv] => Array
        (
           

• => 833
              [1] => 471
              [2] => 2469
              [3] => 2875
              [4] => 2880
          )
  
      [uid] => 2
      [sort] => na
      [search] =>
      [name] => ..
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_group] => 1
      [user_active] => YES
      [user_name] => vorw
      [user_password] => ********
      [user_lastvisit] => 2004-12-21 23:39:29
      [user_regdate] => 2004-11-27 17:14:18
      [user_group_list] =>
      [user_email] =>
      [user_website] =>
      [user_location] =>
      [user_interests] =>
      [user_occupation] =>
      [user_actkey] =>
      [user_favpics] =>
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 1
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [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] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
      [groups] => Array
          (
              [1] => 1
          )
  
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content FROM cpg132_filetypes;
      [1] => SELECT * FROM cpg132_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '266c8f7ef6ceb133c0a569b8cfe4f06a'
      [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 cpg132_usergroups WHERE group_id in (1)
      [3] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
      [4] => DELETE FROM cpg132_banned WHERE expiry < 1103668890
      [5] => SELECT * FROM cpg132_banned WHERE ip_addr='62.245.82.133' OR ip_addr='62.245.82.133' OR user_id=1
      [6] => SELECT filepath, filename FROM cpg132_pictures WHERE filepath LIKE 'vrwver%'
      [7] => SELECT aid, title FROM cpg132_albums WHERE category = 0 ORDER BY title
      [8] => SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg132_albums as a, cpg132_categories as c WHERE a.category = c.cid AND a.category < '10000' ORDER BY cname,title
      [9] => SELECT aid, CONCAT('(', user_name, ') ', title) AS title FROM cpg132_albums AS a INNER JOIN cpg132_users AS u ON category = (10000 + user_id) ORDER BY title
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [startdir] => vrwver
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.3.9 - OK
  ------------------
  mySQL version: 4.0.22-log
  ------------------
  Coppermine version: 1.3.2
  ==========================
  Module: gd
  ------------------
  GD Support enabled
  GD Version bundled (2.0.28 compatible)
  FreeType Support enabled
  FreeType Linkage with freetype
  GIF Read Support enabled
  GIF Create 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.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/run/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.2
  Linked Version 1.2.2
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | 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 | system,exec,passthru,proc_open,popen,shell_exec,readlink,symlink,link,pfsockopen,ini_alter,ini_set,dl,openlog,syslog,putenv,pcntl_exec,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,socket_accept,socket_bind,socket_create,socket_create_listen,socket_listen,socket_create_pair | system,exec,passthru,proc_open,popen,shell_exec,readlink,symlink,link,pfsockopen,ini_alter,ini_set,dl,openlog,syslog,putenv,pcntl_exec,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,socket_accept,socket_bind,socket_create,socket_create_listen,socket_listen,socket_create_pair
  file_uploads | On | On
  include_path | .:/usr/lib/php | .:/usr/lib/php
  open_basedir | /home/www/mazec.org/www/coppermine.mazec.org | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/bin/sendmail_hosting_wrapper.rb | /usr/bin/sendmail_hosting_wrapper.rb
  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 | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.116 seconds - 10 queries in 0.017 seconds - Album set :

[Joachim Müller]

• turn on debug mode in coppermine config
  
• turn "method for uploading" to "Single file uploads only" for registered users in "groups"
  
• Post a link and test user account (non-admin) with upload privileges
  

We do not register on galleries that request support, would mean we'd have to register on thousands of sites, with our email accounts being flooded with UBE even more. If you actually have deleted a db table that is being used by coppermine, you should use the back up. If you have non, you probably have a serious problem (depending on what table is missing or broken).

Joachim

[vorw]

hm, I have got only 2 months old backup  :-\\

here is a registred acount -> http://coppermine.mazec.org/login.php username: testing password: test

many thx for help GauGau!  :-\\

[Joachim Müller]

I get

There was an error while processing a database query.
While executing query "SELECT aid FROM cpg132_albums WHERE category =  and aid NOT IN (16) " on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and aid NOT IN (16)' at line 1

File: /home/www/mazec.org/www/coppermine.mazec.org/include/functions.inc.php - Line: 105

You messed the database up.
Use a tool like phpMyAdmin to check what tables are broken and re-create them from your backup. Nothing else I can advice - such things can happen if you're not extra carefull when fiddling with the database directly - that's why you already should backup first before performing database manipulations, sorry.

Joachim

[vorw]

i recovered my sql database, for 10$, and everything works fine.. :x
anyway, thx for help, and this cool gallery!

vorw