Upload doesn’t work Upload doesn’t work
 

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

Main Menu

Upload doesn’t work

Started by Kazaf, October 11, 2007, 07:54:03 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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:

QuoteNotices
/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:

QuoteWhile 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

QuoteUSER:
------------------
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


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

Quote from: Kazaf on October 11, 2007, 08:07:54 AM
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:

QuoteIf 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

Quote from: Kazaf on October 11, 2007, 08:52:22 AM
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 ;).