Upload doesn’t work

[Kazaf]

I have a problem, when I try to upload a single file it always says "0 uploads were successful."
I don't know why it happens, I changed CHMODs to 777. 
Batch upload works good, but when I try to change file info it says "Database Error".

http://www.xyberry.com/

I've read through FAQ sections but have not any ideas.


Upload error:

Notices
/upload.php
Notice line 1971: Undefined variable: escrow_array
Notice line 1972: Undefined variable: file_failure_array
Notice line 1973: Undefined variable: URI_failure_array
Notice line 1974: Undefined variable: zip_failure_array

When I try to update file info Debug mode shows:

While executing query "SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM pspg_albums, pspg_categories WHERE category < '10000' AND (category = 0 OR category = cid) ORDER BY cat_title" on 0

mySQL error: Can't create/write to file '/tmp/#sql_c3a_0.MYI' (Errcode: 30)

and

USER:
------------------
Array
(
    [ID] => 9fee2f298d8013e1f0c176ba49e85a71
    [am] => 1
    [lang] => russian
    [lap] => 1
    [search] => Array
        (
            [search] => resident evil
            [album] => search
            [title] => on
            [newer_than] =>
            [older_than] =>
            [keywords] => on
            [type] => OR
            [filename] => on
            [params] => Array
                (
                    [title] => on
                    [keywords] => on
                    [filename] => on
                )

        )

    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Kazaf
    [groups] => Array
        (
           

• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [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
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM pspg_filetypes; (0.001s)
      [1] => select * from pspg_plugins order by priority asc; (0s)
      [2] => delete from `xyberr_newpsp`.pspg_sessions where time<1192078223 and remember=0; (0.001s)
      [3] => delete from `xyberr_newpsp`.pspg_sessions where time<1190872223; (0s)
      [4] => select user_id from `xyberr_newpsp`.pspg_sessions where session_id=md5("465567780d21e08cc201d3a61b0cce971130efad04a32b5df8bba0173287c960"); (0.006s)
      [5] => select user_id as id, user_password as password from `xyberr_newpsp`.pspg_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `xyberr_newpsp`.pspg_users AS u INNER JOIN `xyberr_newpsp`.pspg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `xyberr_newpsp`.pspg_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => 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 pspg_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  pspg_usergroups WHERE group_id= 1 (0s)
      [10] => update `xyberr_newpsp`.pspg_sessions set time='1192081823' where session_id=md5('465567780d21e08cc201d3a61b0cce971130efad04a32b5df8bba0173287c960'); (0s)
      [11] => SELECT user_favpics FROM pspg_favpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM pspg_banned WHERE expiry < '2007-10-11 05:50:23' (0s)
      [13] => SELECT * FROM pspg_banned WHERE (ip_addr='85.173.98.130' OR ip_addr='0.0.0.0' OR user_id=1) AND brute_force=0 (0s)
      [14] => SELECT title, category FROM pspg_albums WHERE aid = '2' (0s)
      [15] => SELECT DISTINCT aid, title, IF(category = 0, CONCAT('> ', title), CONCAT(name,' < ',title)) AS cat_title FROM pspg_albums, pspg_categories WHERE category < '10000' AND (category = 0 OR category = cid) ORDER BY cat_title (0.001s)
      [16] => SELECT COUNT(*) FROM pspg_pictures WHERE approved = 'NO' (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [album] => 2
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.6 - OK
  ------------------
  mySQL version: 4.1.22-max
  ------------------
  Coppermine version: 1.4.13(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support:
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 4.1.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  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 | dl, system, exec, passthru, shell_exec | dl, system, exec, passthru, shell_exec
  file_uploads | On | On
  include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
  open_basedir | /home/xyberr:/usr/lib/php:/usr/local/lib/php:/tmp | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | no value | no value
  sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 600 | 600
  max_input_time | 60 | 60
  upload_max_filesize | 32M | 32M
  post_max_size | 32M | 32M
  ==========================
  Page generated in 0.09 seconds - 17 queries in 0.011 seconds - Album set : ; Meta set: ;

Please, I need some help.
Thanks

[Joachim Müller]

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upload_support

[Kazaf]

Arghh, I've read it twice. In the "Error messages" nothing useful for me.

Test admin account:
name: Test
pasw: test

[Joachim Müller]

Arghh, I've read it twice.

You haven't done as suggested in the upload troubleshooting section of the docs - read it once more. You're supposed to set the number of file upload fields to "1" and the number of URI upload fields to "0". The test user account you have posted still has 5 file upload fields and 3 URI upload fields (which is the default setting btw). Re-read the upload troubleshooting section extra, extra carefully and do exactly as suggested there.

[Kazaf]

K, I've made it. Now appears the following text:

If you have really selected a file to upload, check that the server allows file uploads...

File: /home/xyberr/public_html/xyberry/db_input.php - Line: 311

But server allows it, I've uploaded many files before. Hm, strange. I'm confused ;(

[Joachim Müller]

But server allows it, I've uploaded many files before.

Using what method? Don't confuse this with the fact that you can easily FTP-upload files. File-uploads must be allowed in PHP's setup. Look up phpinfo. Another thing to look into are permissions on the albums folder - read up the corresponding section of the docs and (re)apply permissions properly.

[Kazaf]

Whatever.....
I've re-uploded all files and re-install the CPG, hahaha :'(....it work properly.

thanks for help, GauGau.

[Joachim Müller]

OK, glad to hear that you were able to fix your issues. Marking thread accordingly.

For others with similar issues I want to point out that it is not a good idea at all to delete and re-install. This has been a panic reaction. Coppermine is not a desktop application that you uninstall and re-install if there are issues. The architecture is robust enough to get this working again without a re-install. Don't do as Kazaf did, kids .