switch to new server, latest uplaod photo lost, newly upload not shown

[happymm]

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 :

[Joachim Müller]

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

[happymm]

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

[Joachim Müller]

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

404 Not found

[happymm]

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

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.

[Joachim Müller]

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

404 Not found

I was refering to FTP-upload, not http upload.

[happymm]

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

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.

[Joachim Müller]

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