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: album is really long and out of size. how can i fix it?  (Read 2388 times)

0 Members and 1 Guest are viewing this topic.

paris online

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
album is really long and out of size. how can i fix it?
« on: August 01, 2005, 06:42:36 am »

USER:
------------------
Array
(
    [ID] => a0cea6e283f9d3750437f6dc79f39b91
    [am] => 1
    [lap] => 2
    [liv] => Array
        (
           
  • => 1724
  • [1] => 3296
            )

    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
       
[user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => *****
    [user_password] => ********
    [user_lastvisit] => 2005-07-05 20:55:06
    [user_regdate] => 2005-05-03 01:16:32
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [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] => 1
    [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 cpg_filetypes;
  • [1] => SELECT * FROM cpg_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '39c94dccfe8f20c6536f4747515862b4'
        [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 < 1122871114
        [5] => SELECT * FROM cpg_banned WHERE ip_addr='203.26.16.67' OR ip_addr='220.245.223.49' OR user_id=1
        [6] => SELECT name, parent FROM cpg_categories WHERE cid = '3'
        [7] => SELECT cid, name, parent FROM cpg_categories WHERE cid = '2'
        [8] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '3'  ORDER BY pos
        [9] => SELECT aid FROM cpg_albums as a WHERE category = '3'
        [10] => SELECT count(*) FROM cpg_albums as a WHERE category = '3'
        [11] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg_albums as a LEFT JOIN cpg_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.pos LIMIT 12,12
        [12] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (203, 204, 205, 190, 206, 192, 191, 207, 165, 208, 209, 166) AND approved = 'YES' GROUP BY aid
        [13] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3001'
        [14] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3012'
        [15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3024'
        [16] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2812'
        [17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3044'
        [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2877'
        [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2848'
        [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3059'
        [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2565'
        [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3076'
        [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3087'
        [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2570'
        [25] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,4,6,7,8,10,11,15,17,19,22,23,25,28,29,30,31,32,55,56,69,70,71,72,73,74,75,76,77,78,81,82,83,84,88,89,96,97,99,100,101,102,103,104,105,107,108,110,117,118,119,120,121,123,124,125,129,130,143,144,145,146,147,148,149,150,151,153,154,157,158,163,164,165,166,167,168,169,173,190,191,192,198,199,200,201,202,203,204,205,206,207,208,209,210,211,213,218,219,223,224,225,234)
        [26] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,4,6,7,8,10,11,15,17,19,22,23,25,28,29,30,31,32,55,56,69,70,71,72,73,74,75,76,77,78,81,82,83,84,88,89,96,97,99,100,101,102,103,104,105,107,108,110,117,118,119,120,121,123,124,125,129,130,143,144,145,146,147,148,149,150,151,153,154,157,158,163,164,165,166,167,168,169,173,190,191,192,198,199,200,201,202,203,204,205,206,207,208,209,210,211,213,218,219,223,224,225,234)  ORDER BY RAND() LIMIT 8
        [27] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,4,6,7,8,10,11,15,17,19,22,23,25,28,29,30,31,32,55,56,69,70,71,72,73,74,75,76,77,78,81,82,83,84,88,89,96,97,99,100,101,102,103,104,105,107,108,110,117,118,119,120,121,123,124,125,129,130,143,144,145,146,147,148,149,150,151,153,154,157,158,163,164,165,166,167,168,169,173,190,191,192,198,199,200,201,202,203,204,205,206,207,208,209,210,211,213,218,219,223,224,225,234)
        [28] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg_pictures WHERE approved = 'YES' AND aid IN (1,2,4,6,7,8,10,11,15,17,19,22,23,25,28,29,30,31,32,55,56,69,70,71,72,73,74,75,76,77,78,81,82,83,84,88,89,96,97,99,100,101,102,103,104,105,107,108,110,117,118,119,120,121,123,124,125,129,130,143,144,145,146,147,148,149,150,151,153,154,157,158,163,164,165,166,167,168,169,173,190,191,192,198,199,200,201,202,203,204,205,206,207,208,209,210,211,213,218,219,223,224,225,234)  ORDER BY pid DESC  LIMIT 0 ,8
    )

    ==========================
    GET :
    ------------------
    Array
    (
       
[cat] => 3
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 4.0.24-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
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.24
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.1.2
Linked Version 1.2.1.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/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/parih:/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 | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.163 seconds - 29 queries in 0.061 seconds - Album set : AND aid IN (1,2,4,6,7,8,10,11,15,17,19,22,23,25,28,29,30,31,32,55,56,69,70,71,72,73,74,75,76,77,78,81,82,83,84,88,89,96,97,99,100,101,102,103,104,105,107,108,110,117,118,119,120,121,123,124,125,129,130,143,144,145,146,147,148,149,150,151,153,154,157,158,163,164,165,166,167,168,169,173,190,191,192,198,199,200,201,202,203,204,205,206,207,208,209,210,211,213,218,219,223,224,225,234)



my gallery is at www.paris-online.org/gallery
the thing im having trouble at on it is here http://www.paris-online.org/gallery/index.php?cat=3
its only that cat that is really long and out of shape. ive looked through the forum, everywhere and can't find anything that can explain how to fix it. ive tryed playing around with the template and theme in the waterdrop theme which is what its set on but cant figure out where it's going wrong. any help/info appriciated. thank you! =)
Logged

kegobeer

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 4637
  • Beer - it does a body good!
    • The Kazebeer Family Website
Re: album is really long and out of size. how can i fix it?
« Reply #1 on: August 01, 2005, 03:23:30 pm »

I have no idea what the problem is.  Your gallery looks fine.  Post a screenshot of the issue, and don't post debug output unless it is requested.
Logged
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 20 queries.