Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: switch to new server, latest uplaod photo lost, newly upload not shown  (Read 6514 times)

0 Members and 1 Guest are viewing this topic.

happymm

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

someone please kindly help me with it.

USER:
------------------
Array
(
    [ID] => e74f3109514ef452f71c8b3c599f6244
    [am] => 1
    [liv] => Array
        (
           
  • => 4007

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 187
    [user_group] => 1
    [user_active] => YES
    [user_name] => 哈比摩圖庫分享
    [user_password] => ********
    [user_lastvisit] => 2005-08-25 19:25:42
    [user_regdate] => 2005-06-29 12:03:07
    [user_group_list] =>
    [user_email] => service@happymalls.com.tw
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [user_favpics] =>
    [disk_max] => 1024000
    [disk_min] => 1024000
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 1
    [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] => 管理者
    [upload_form_config] => 3
    [group_quota] => 1024000
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content FROM cpg_filetypes;
  • [1] => SELECT * FROM cpg_users WHERE user_id='187'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '096d3a817a272647f4ada2d6d733a8fb'
        [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 cpg_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg_banned WHERE expiry < '2005-08-25 19:58:53'
        [5] => SELECT * FROM cpg_banned WHERE ip_addr='61.224.101.50' OR ip_addr='61.224.101.50' OR user_id=187
        [6] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = ''  ORDER BY pos
        [7] => SELECT aid FROM cpg_albums as a WHERE category>=10000
        [8] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category >= 10000
        [9] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1'  ORDER BY pos
        [10] => SELECT aid FROM cpg_albums as a WHERE category = '0'
        [11] => SELECT count(*) FROM cpg_albums as a WHERE 1
        [12] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1
        [13] => SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1
        [14] => SELECT count(*) FROM cpg_categories WHERE 1
        [15] => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1
        [16] => SELECT count(*) FROM cpg_albums as a WHERE category = '0'
        [17] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES'
        [18] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,4
        [19] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES'
        [20] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 20
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.10-15 - OK
    ------------------
    mySQL version: 4.0.24_Debian-10-log
    ------------------
    Coppermine version: 1.3.3
    ==========================
    Module: gd
    ------------------
    GD Support enabled
    GD Version 2.0 or higher
    FreeType Support enabled
    FreeType Linkage with freetype
    T1Lib Support enabled
    GIF Read Support enabled
    GIF Create Support enabled
    JPG Support enabled
    PNG Support enabled
    WBMP Support enabled
    ==========================
    Module: mysql
    ------------------
    Active Persistent Links 0
    Active Links 1
    Client API version 4.0.24
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/run/mysqld/mysqld.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 | no value | no value
    file_uploads | On | On
    include_path | .:/usr/share/php:/usr/share/pear | .:/usr/share/php:/usr/share/pear
    open_basedir | no value | 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 | 30 | 30
    max_input_time | 60 | 60
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.108 seconds - 21 queries in 0.029 seconds - Album set :
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #1 on: August 26, 2005, 08:43:10 am »

only post debug output when a supporter requests it. Instead: post a link and non-admin test user account with upload privileges.
Logged

happymm

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #2 on: August 26, 2005, 11:46:34 am »

only post debug output when a supporter requests it. Instead: post a link and non-admin test user account with upload privileges.

try below:

http://happymalls.com.tw/photo

test1 / test1
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #3 on: August 26, 2005, 05:24:04 pm »

well, the pics don't exist on the server, you'll have to upload them to the new server:
http://happymalls.com.tw/photo/albums/userpics/10179/thumb_940822-4.jpg and http://happymalls.com.tw/photo/albums/userpics/10179/940822-4.jpg return
Quote
404 Not found
Logged

happymm

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #4 on: August 26, 2005, 05:28:59 pm »

well, the pics don't exist on the server, you'll have to upload them to the new server:
http://happymalls.com.tw/photo/albums/userpics/10179/thumb_940822-4.jpg and http://happymalls.com.tw/photo/albums/userpics/10179/940822-4.jpg return
Quote
404 Not found

Ok, then. But while I login as adim user, I cannot either delete the pics or uplaod new photo(image not shown). Whatr's going on?

You may try to upload a photo, and you'll know what I mean.

Thanx for your help.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #5 on: August 26, 2005, 05:30:26 pm »

well, the pics don't exist on the server, you'll have to upload them to the new server:
http://happymalls.com.tw/photo/albums/userpics/10179/thumb_940822-4.jpg and http://happymalls.com.tw/photo/albums/userpics/10179/940822-4.jpg return
Quote
404 Not found
I was refering to FTP-upload, not http upload.
Logged

happymm

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #6 on: August 26, 2005, 05:51:23 pm »

well, the pics don't exist on the server, you'll have to upload them to the new server:
http://happymalls.com.tw/photo/albums/userpics/10179/thumb_940822-4.jpg and http://happymalls.com.tw/photo/albums/userpics/10179/940822-4.jpg return
Quote
404 Not found
I was refering to FTP-upload, not http upload.

I know exactly what you mean. I'll try it later. But the problem of http upload still exsists as I mentioned above.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: switch to new server, latest uplaod photo lost, newly upload not shown
« Reply #7 on: August 27, 2005, 04:13:05 pm »

when you moved from your old server to the new one, you were suppossed to download all files from the old server (using ftp) and create a mysql dump. Then, on the new server, you were meant to upload all files you downloaded from the old server to the new one (again: using FTP). Then, you were meant to restore your mysql dump from the old server on the new server. Coppermine only "knows" the relative position of a file within the albums folder, if the pic is not there, it won't be able to display it. As I said before: the pic doesn't exist in the location the coppermine database "thinks" it should exist in, that's why you get a broken image. Restore the pic file, and the broken image will go away.

To solve any http upload issues you might have (which is a different issue and shouldn't have gone into the same thread, as we have a "one question per thread" policy you agreed to respect when signing up, do as suggested in http://coppermine-gallery.net/tutorial/uploads/troubleshooting.php

Joachim
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 19 queries.