forum.coppermine-gallery.net
Support => cpg1.3.x Support => Older/other versions => cpg1.3 Permissions & Access Rights => Topic started by: happymm on August 25, 2005, 02:07:21 pm
-
someone please kindly help me with it.
USER:
------------------
Array
(
[ID] => e74f3109514ef452f71c8b3c599f6244
[am] => 1
[liv] => Array
(
)
)
==========================
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 :
-
only post debug output when a supporter requests it. Instead: post a link and non-admin test user account with upload privileges.
-
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
-
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
-
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.
-
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.
-
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.
-
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