upload failed upload failed
 

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 failed

Started by vorw, December 21, 2004, 11:46:11 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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  :-X
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
QuoteThere 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