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: passwords  (Read 444 times)

0 Members and 1 Guest are viewing this topic.

nineninefive

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
passwords
« on: May 24, 2022, 11:32:37 pm »

Hi,

I have a gallery: kardashianworld.net/gallery

Every time I reset my password, it sends me the email etc, changes the password, but no matter what every time I put in new password, it says login failed.

I've tried changing the email addresses, I've tried changing on phpadmin but no luck. Any advice?
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #1 on: May 25, 2022, 09:51:44 pm »

I am the server admin for this persons gallery. I can occasionally get the passwords to work for the update.php script but they never seem to work to login to the actual gallery.

The database is just over 300 MB - The main gallery page loads horribly slow, http://kardashianworld.net/gallery/
while most other pages on the gallery load quickly. http://kardashianworld.net/gallery/index.php?cat=639

My theory is something related to the database is causing the slow loading issue along with the password issue. Hopefully Ron or someone else has ran into this sort of problem before. As I am out of ideas on how to fix.

Currently my only guess to fix it is a more powerful server or splitting the gallery into multiple galleries to avoid the large database size.
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #2 on: May 25, 2022, 10:38:21 pm »

We got the passwords working, but the slow loading is an on-going issue. Here is a copy of my debug. I see where it's extremely slow but I don't know what we can do to fix it. No other galleries on our server are having this issue.

ORDER BY NULL [index.php:362] (73013.31 ms)
LIMIT 0 ,7 [include/functions.inc.php:1971] (34741.23 ms)


FULL DEBUG

USER:
------------------
Array
(
    [ID] => c40414937cd212dc10ab6f3a11b08d33
    [am] => 1
    [lang] => english
    [liv_a] => Array
        (
           
  • => 17863
  • [1] => 8082
            )

    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
       
[user_id] => 3
    [user_name] => ido
    [groups] => Array
        (
           
  • => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [access_level] => 3
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [can_create_public_albums] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT name, value FROM kyt_config [include/init.inc.php:177] (0.55 ms)
  • [1] => SELECT * FROM kyt_plugins ORDER BY priority
[include/plugin_api.inc.php:48] (0.2 ms)
    [2] => SELECT user_id, time FROM `u7297900_newgal`.kyt_sessions WHERE session_id = 'f27a1a0f0ec2ef3b486d2d5b8cb4fd5d' [bridge/coppermine.inc.php:241] (1.75 ms)
    [3] => SELECT user_id, user_password FROM `u7297900_newgal`.kyt_users WHERE user_id=3 [bridge/udb_base.inc.php:59] (0.52 ms)
    [4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `u7297900_newgal`.kyt_users AS u LEFT JOIN `u7297900_newgal`.kyt_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='3' [bridge/udb_base.inc.php:59] (0.21 ms)
    [5] => SELECT user_group_list FROM `u7297900_newgal`.kyt_users AS u WHERE user_id='3' AND user_group_list <> '' [bridge/udb_base.inc.php:59] (0.15 ms)
    [6] => 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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS    priv_upl_need_approval FROM kyt_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:357] (0.33 ms)
    [7] => SELECT group_name FROM kyt_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:362] (0.15 ms)
    [8] => SELECT COUNT(*) FROM kyt_categorymap WHERE group_id in (1) [bridge/udb_base.inc.php:375] (0.2 ms)
    [9] => SELECT lang_id FROM kyt_languages WHERE enabled='YES' [include/init.inc.php:334] (0.26 ms)
    [10] => SELECT user_favpics FROM kyt_favpics WHERE user_id = 3 [include/init.inc.php:392] (0.32 ms)
    [11] => DELETE FROM kyt_banned WHERE expiry < '2022-05-25 20:27:39' [include/init.inc.php:448] (0.2 ms)
    [12] => SELECT null FROM kyt_banned WHERE (user_id=3 OR '216.169.12.78' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:464] (0.18 ms)
    [13] => DELETE FROM kyt_temp_messages WHERE time < 1653506859 [include/functions.inc.php:5074] (0.96 ms)
    [14] => SELECT cid, lft, rgt, name, description, thumb, depth AS level, '0' AS alb_count, '0' AS subalb_count
        FROM kyt_categories
        WHERE depth BETWEEN 0 + 1 AND 0 + 1
       
        ORDER BY lft [index.php:299] (6.68 ms)
    [15] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
                FROM kyt_albums AS r
                INNER JOIN kyt_pictures AS p ON p.aid = r.aid
                WHERE r.category > 10000
                AND approved = 'YES'
                 [index.php:313] (0.5 ms)
    [16] => SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
        FROM kyt_categories AS c
        INNER JOIN kyt_albums AS r ON r.category = c.cid
        WHERE c.depth >= 0 + 1
       
       
        ORDER BY r.pos ASC, r.aid ASC [index.php:335] (198 ms)
    [17] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
        FROM kyt_categories AS c
        INNER JOIN kyt_albums AS r ON r.category = c.cid
        INNER JOIN kyt_pictures AS p ON p.aid = r.aid
        WHERE c.depth >= 0 + 1
        AND approved = 'YES'
       
       
        GROUP BY r.aid
        ORDER BY NULL [index.php:362] (73013.31 ms)
    [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163991  [index.php:409] (0.19 ms)
    [19] => SELECT extension, mime, content, player FROM kyt_filetypes [include/functions.inc.php:5952] (0.24 ms)
    [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163992  [index.php:409] (0.12 ms)
    [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163993  [index.php:409] (0.11 ms)
    [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163994  [index.php:409] (0.1 ms)
    [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163995  [index.php:409] (0.1 ms)
    [24] => SELECT COUNT(*) FROM kyt_pictures WHERE approved = 'NO' [include/functions.inc.php:2528] (558.57 ms)
    [25] => SELECT lang_id, abbr FROM kyt_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2291] (0.35 ms)
    [26] => SELECT COUNT(*)
                FROM kyt_pictures AS r
                INNER JOIN kyt_albums AS a ON a.aid = r.aid
                WHERE (1)
                AND approved = 'YES'
                GROUP BY r.aid [include/functions.inc.php:1959] (908.2 ms)
    [27] => SELECT r.aid, a.thumb, a.keyword, a.alb_hits, a.title, MAX(ctime) AS ctime
                FROM kyt_pictures AS r
                INNER JOIN kyt_albums AS a ON a.aid = r.aid
                WHERE (1)
                AND approved = 'YES'
                GROUP BY r.aid
                ORDER BY ctime DESC
                 LIMIT 0 ,7 [include/functions.inc.php:1971] (34741.23 ms)
    [28] => SELECT pid FROM kyt_pictures WHERE pid IN (1189707,1189675) [include/functions.inc.php:1986] (0.76 ms)
    [29] => SELECT pid FROM kyt_pictures WHERE ((aid = '17869' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (6.4 ms)
    [30] => SELECT pid FROM kyt_pictures WHERE ((aid = '17865' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.37 ms)
    [31] => SELECT pid FROM kyt_pictures WHERE ((aid = '17870' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (13.46 ms)
    [32] => SELECT pid FROM kyt_pictures WHERE ((aid = '17866' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (5 ms)
    [33] => SELECT pid FROM kyt_pictures WHERE ((aid = '17867' ) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.26 ms)
    [34] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
                    FROM kyt_pictures AS r
                    WHERE approved = 'YES'
                    AND r.pid IN (1189844,1189842,1189707,1189832,1189758,1189696,1189675) [include/functions.inc.php:2030] (2.69 ms)
    [35] => SELECT count(aid) FROM kyt_albums as a WHERE category = '0'  [index.php:663] (0.22 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [cpg15x_data] => YTo0OntzOjI6IklEIjtzOjMyOiJjNDA0MTQ5MzdjZDIxMmRjMTBhYjZmM2ExMWIwOGQzMyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjtzOjU6Imxpdl9hIjthOjI6e2k6MDtpOjE3ODYzO2k6MTtpOjgwODI7fX0=
    [f7d9a22c729013ede6c529cfd58f8b0e] => 7b1a1b57a52e1ea217b83ed54c92b31d
)

==========================
VERSION INFO :
------------------
PHP version        7.4.29          OK   
MySQL version      10.3.26-MariaDB OK   
Coppermine version 1.6.19          stable

==========================
Module: GD
------------------
Exact version                    2.1.0                     
GD Version                       bundled (2.1.0 compatible)
FreeType Support                 1                         
FreeType Linkage                 with freetype             
GIF Read Support                 1                         
GIF Create Support               1                         
JPEG Support                     1                         
PNG Support                      1                         
WBMP Support                     1                         
XPM Support                      1                         
XBM Support                      1                         
WebP Support                     1                         
BMP Support                      1                         
TGA Read Support                 1                         
JIS-mapped Japanese Font Support                           

==========================
Key config settings
------------------
site_url             http://kardashianworld.net/gallery/           
charset              utf-8                                         
allow_private_albums 1                                             
cookie_name          cpg15x                                       
cookie_path          /                                             
impath               /usr/bin/                                     
lang                 english                                       
main_page_layout     breadcrumb/lastalb/catlist/alblist/onlinestats
silly_safe_mode      0                                             
smtp_host                                                         
theme                water_drop                                   
thumb_method         gd2                                           

==========================
Plugins
------------------
Name           CoreH5A Upload                               
Enabled        1                                           
Actions        upload_form, plugin_install, plugin_uninstall
Filters        upload_options                               
--------------
Name           CoreSWF Upload                               
Enabled        1                                           
Actions        upload_form                                 
Filters        upload_options                               
--------------
Name           CoreSGL Upload                               
Enabled        1                                           
Actions        upload_form                                 
Filters        upload_options                               
--------------

==========================
Server restrictions
------------------
safe_mode                                                         
safe_mode_exec_dir                                                 
safe_mode_gid                                                     
safe_mode_include_dir                                             
sql.safe_mode                                                     
disable_functions                                                 
file_uploads             1                                         
include_path             .:/opt/cpanel/ea-php74/root/usr/share/pear
open_basedir                                                       
allow_url_fopen                                                   
max_execution_time       30                                       
max_input_time           60                                       
upload_max_filesize      500M                                     
post_max_size            500M                                     
memory_limit             500M                                     
suhosin.post.max_vars                                             
suhosin.request.max_vars                                           


==========================
Page (performance)
------------------
Parameter        Current      Peak       
Memory usage     638.78 KiB   8.14 MiB   
Page generation  109523.58 ms 109523.58 ms
Page query time  109462.85 ms 109462.85 ms
Page query count 36           36         


==========================
               
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1832
Re: passwords
« Reply #3 on: May 26, 2022, 12:50:45 am »

Are you using PHP 7 or later?
Is CPG using the mysqli API to access the database?
Is PHP allowed plenty of memory for processes (512M)?
Have you tried optimizing the tables?
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #4 on: May 26, 2022, 04:29:43 am »

PHP 7.4
$CONFIG['dbtype'] =      'mysqli';         // Your database type
PHP memory limit is 500 MB -- I am increasing to 900 MB for now to see if that helps.
Our database uses InnoDB, I used optimize in phpmyadmin after changing the this setting in the link you provided: innodb_optimize_fulltext_only=1

It may have improved slightly, but it's still taking 11 seconds to load the main page while other pages load much quicker. Why is it only the main album list page loading slowly?


USER:
------------------
Array
(
    [ID] => c40414937cd212dc10ab6f3a11b08d33
    [am] => 1
    [lang] => english
    [liv_a] => Array
        (
           
  • => 17863
  • [1] => 8082
                [2] => 17875
            )

       
[liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           
  • => 3

        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [access_level] => 3
    [disk_max] => 0
    [disk_min] => 0
    [has_admin_access] => 0
    [group_name] => Guests
    [can_create_public_albums] => 0
    [can_see_all_albums] => 0
    [group_id] => 3
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT name, value FROM kyt_config [include/init.inc.php:177] (0.49 ms)
  • [1] => SELECT * FROM kyt_plugins ORDER BY priority
[include/plugin_api.inc.php:48] (0.28 ms)
    [2] => SELECT user_id, time FROM `u7297900_newgal`.kyt_sessions WHERE session_id = '6b681e14982006dcc044aedf33a5270b' [bridge/coppermine.inc.php:241] (0.19 ms)
    [3] => 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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS    priv_upl_need_approval FROM kyt_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:357] (0.24 ms)
    [4] => SELECT group_name FROM kyt_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:362] (0.15 ms)
    [5] => SELECT COUNT(*) FROM kyt_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.16 ms)
    [6] => SELECT aid FROM kyt_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0.23 ms)
    [7] => SELECT lang_id FROM kyt_languages WHERE enabled='YES' [include/init.inc.php:334] (0.31 ms)
    [8] => DELETE FROM kyt_banned WHERE expiry < '2022-05-26 02:26:28' [include/init.inc.php:448] (0.28 ms)
    [9] => SELECT null FROM kyt_banned WHERE ('216.169.12.78' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:464] (0.19 ms)
    [10] => SELECT aid FROM kyt_albums WHERE (1  AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:1110] (0.3 ms)
    [11] => SELECT cid, lft, rgt, name, description, thumb, depth AS level, '0' AS alb_count, '0' AS subalb_count
        FROM kyt_categories
        WHERE depth BETWEEN 0 + 1 AND 0 + 1
       
        ORDER BY lft [index.php:299] (0.49 ms)
    [12] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
                FROM kyt_albums AS r
                INNER JOIN kyt_pictures AS p ON p.aid = r.aid
                WHERE r.category > 10000
                AND approved = 'YES'
                AND r.aid NOT IN (7346, 5077, 5078, 5079) [index.php:313] (5.16 ms)
    [13] => SELECT aid, title, r.description, keyword, alb_hits, category, visibility, r.thumb, r.owner, depth AS level, lft, '0' AS pic_count
        FROM kyt_categories AS c
        INNER JOIN kyt_albums AS r ON r.category = c.cid
        WHERE c.depth >= 0 + 1
        AND r.aid NOT IN (7346, 5077, 5078, 5079)
       
        ORDER BY r.pos ASC, r.aid ASC [index.php:335] (238.7 ms)
    [14] => SELECT c.cid, r.aid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
        FROM kyt_categories AS c
        INNER JOIN kyt_albums AS r ON r.category = c.cid
        INNER JOIN kyt_pictures AS p ON p.aid = r.aid
        WHERE c.depth >= 0 + 1
        AND approved = 'YES'
        AND r.aid NOT IN (7346, 5077, 5078, 5079)
       
        GROUP BY r.aid
        ORDER BY NULL [index.php:362] (5562.04 ms)
    [15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163991 AND p.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:409] (0.32 ms)
    [16] => SELECT extension, mime, content, player FROM kyt_filetypes [include/functions.inc.php:5952] (0.42 ms)
    [17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163992 AND p.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:409] (0.16 ms)
    [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163993 AND p.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:409] (0.13 ms)
    [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163994 AND p.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:409] (0.18 ms)
    [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM kyt_pictures AS p WHERE pid = 1163995 AND p.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:409] (0.18 ms)
    [21] => SELECT COUNT(*)
                FROM kyt_pictures AS r
                INNER JOIN kyt_albums AS a ON a.aid = r.aid
                WHERE (1) AND r.aid NOT IN (7346, 5077, 5078, 5079)
                AND approved = 'YES'
                GROUP BY r.aid [include/functions.inc.php:1959] (685.25 ms)
    [22] => SELECT r.aid, a.thumb, a.keyword, a.alb_hits, a.title, MAX(ctime) AS ctime
                FROM kyt_pictures AS r
                INNER JOIN kyt_albums AS a ON a.aid = r.aid
                WHERE (1) AND r.aid NOT IN (7346, 5077, 5078, 5079)
                AND approved = 'YES'
                GROUP BY r.aid
                ORDER BY ctime DESC
                 LIMIT 0 ,7 [include/functions.inc.php:1971] (4853.81 ms)
    [23] => SELECT pid FROM kyt_pictures WHERE ((aid = '17879'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.95 ms)
    [24] => SELECT pid FROM kyt_pictures WHERE ((aid = '17875'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.7 ms)
    [25] => SELECT pid FROM kyt_pictures WHERE ((aid = '17878'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.3 ms)
    [26] => SELECT pid FROM kyt_pictures WHERE ((aid = '17877'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.33 ms)
    [27] => SELECT pid FROM kyt_pictures WHERE ((aid = '17876'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.44 ms)
    [28] => SELECT pid FROM kyt_pictures WHERE ((aid = '17874'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.55 ms)
    [29] => SELECT pid FROM kyt_pictures WHERE ((aid = '17873'  AND aid NOT IN (7346, 5077, 5078, 5079)) ) AND approved='YES' ORDER BY ctime DESC LIMIT 0,1 [include/functions.inc.php:2015] (0.38 ms)
    [30] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
                    FROM kyt_pictures AS r
                    WHERE approved = 'YES'
                    AND r.pid IN (1190261,1190205,1190181,1190157,1190139,1190129,1189959) [include/functions.inc.php:2030] (0.3 ms)
    [31] => SELECT count(aid) FROM kyt_albums as a WHERE category = '0'  AND a.aid NOT IN (7346, 5077, 5078, 5079)  [index.php:663] (0.93 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [cpg15x_data] => YTo1OntzOjI6IklEIjtzOjMyOiJjNDA0MTQ5MzdjZDIxMmRjMTBhYjZmM2ExMWIwOGQzMyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjtzOjU6Imxpdl9hIjthOjM6e2k6MDtpOjE3ODYzO2k6MTtpOjgwODI7aToyO2k6MTc4NzU7fXM6MzoibGl2IjthOjA6e319
    [f7d9a22c729013ede6c529cfd58f8b0e] => 542837ab4dbc0cafef74833792228db5
    [PHPSESSID] => f00fc4fe31a8f4eb93e8e05245512f6f
)

==========================
SESSION :
------------------
Array
(
)

==========================
               

Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1832
Re: passwords
« Reply #5 on: May 26, 2022, 01:51:03 pm »

You haven't provided any history about the situation. Was it functioning more smoothly with so many categories and albums at one point and then suddenly got very slow? Are the other galleries that you mentioned as large as this one, yet have decent performance?

Suggestions:
You can remove 'lastalb' from what is displayed on the home page.
Or if it is mainly a public facing gallery with no login, you can use my theme caching plugin. (which I see you have used before)
« Last Edit: May 26, 2022, 01:58:58 pm by ron4mac »
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #6 on: May 27, 2022, 12:28:08 am »

It's been getting worst over the last year or two.  It didn't suddenly occur. The next largest account on our server has 550k photos and it doesn't have loading issues like this site. This gallery is over 1 million.

I've turned off everything on the front page except breadcrumb and album list and it still has the issues. Is it possible to turn off the photo count #'s and only display links to albums? It's got to be something causing the long SQL delays that is mostly related to the front page. That is the only thing the front page has that the subpages don't.

I highly doubt my client can afford a dedicated server, so what can we do to modify coppermine's main page? I've tried the cache plugin and it doesn't seem to help.
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1832
Re: passwords
« Reply #7 on: May 27, 2022, 04:31:20 am »

I have a hard time believing the theme cache plugin didn't help a great deal. Could you please install/enable it again so that I can see the results. Please tell me which theme(s) it is enabled for ... remember there must be a 'cache' folder in the theme directory. For only non-logged in use, after the home page is visited once, the next visit should be fast (within the cache expiration time).
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #8 on: May 27, 2022, 10:57:04 am »

I installed the 1.0 version of theme cache and it doesn't seem to be generating any files in the cache folder so I assume it is not working. I tested it on the default theme and the custom theme. The cache folder is chmod 755, I also tried it at 777 with no luck. Plugin enabled and set to 24 hours.
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #9 on: May 27, 2022, 11:13:44 am »

A file finally showed up in the cache folder, but I can't seem to get a cached page served to me as I am searching the source code for your CACHED hidden comment and cannot locate. I have logged out.
Logged

idosha

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 26
Re: passwords
« Reply #10 on: May 27, 2022, 11:17:32 am »

This is what is inside the temp file that did generate, it doesn't seem complete.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Pragma" content="no-cache" />
<title>Last additions - Kardashian World</title>

<link rel="stylesheet" href="css/coppermine.css" type="text/css" />
<link rel="stylesheet" href="themes/GD_KardashCPGv2/style.css" type="text/css" />
<link rel="shortcut icon" href="/wp-content/themes/GD_KardashWPv2/images/ico.png" />
<script type="text/javascript">
/* <![CDATA[ */
    var js_vars = {"site_url":"http:\/\/kardashianworld.net\/gallery","debug":false,"icon_dir":"images\/icons\/","lang_close":"Close","icon_close_path":"images\/icons\/close.png"};
/* ]]> */
</script>
<script type="text/javascript" src="js/jquery-1.12.4.js"></script>

<script type="text/javascript" src="js/jquery-migrate-1.4.1.js"></script>

<script type="text/javascript" src="js/scripts.js"></script>

<script type="text/javascript" src="js/jquery.greybox.js"></script>

<script type="text/javascript" src="js/jquery.elastic.js"></script>



<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">

<link href='https://fonts.googleapis.com/css?family=Playfair+Display:400,400italic,700,700italic|Source+Sans+Pro:400,300,300italic,400italic,700,700italic|Oswald:400,700,300|Lato:400,400italic,700,700italic' rel='stylesheet' type='text/css'>




<script>
$(document).ready(function() {
  $('body').addClass('js');
  var $menu = $('#menu'),
    $menulink = $('.menu-link');
 
$menulink.click(function() {
  $menulink.toggleClass('active');
  $menu.toggleClass('active');
  return false;
});});
</script>

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({
          google_ad_client: "ca-pub-2251721893274244",
          enable_page_level_ads: true
     });
</script>

</head>

<div class="wrapper">
<div id="navigation">
<div align="center">
<a href="#menu" class="menu-link"><i class="fa fa-bars"></i></a>
<nav id="menu" role="navigation"><ul>
   <li><a class="homepage" href="/">Home</a></li>
   <li><a href="/kuwtk">KUWTK</a></li>
   <li><a href="/about">About</a></li>
   <li><a href="/gallery">Photo Gallery</a></li>
   <li><a href="/interview-archive">Press Archive</a></li>
   <li><a href="http://twitter.com/KUWTKWorld/"><i class="fa fa-twitter"></i></a></li>
</ul></nav>
</div>
</div> </div>


  <div id="header">
</div>

<!-- start new FFH Google adcode -->

<br />



<!-- Google Auto-ads -->

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<script>

     (adsbygoogle = window.adsbygoogle || []).push({

          google_ad_client: "ca-pub-2251721893274244",

          enable_page_level_ads: true

     });

</script>

<!-- End Google Auto-ads -->

<center>



<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<!-- responsive-horizontal -->

<ins class="adsbygoogle"

     style="display:block"

     data-ad-client="ca-pub-2251721893274244"

     data-ad-slot="9360852998"

     data-ad-format="auto"

     data-full-width-responsive="true"></ins>

<script>

     (adsbygoogle = window.adsbygoogle || []).push({});

</script>



</center>

<br />



  <!-- FFH Ad Tracking code - shows stats for all sites combined-->

<script async src="https://www.googletagmanager.com/gtag/js?id=UA-36190990-2"></script>

<script>

  window.dataLayer = window.dataLayer || [];

  function gtag(){dataLayer.push(arguments);}

  gtag('js', new Date());



  gtag('config', 'UA-36190990-2');

</script>

<!-- FFH Network Tracking Code  - Shows what sites have ads-->

<script src="https://freefansitehosting.com/ads/track.js"></script>





<!-- end new FFH adcode -->

<body class=body><div id="container">


<div class="navigal" style="margin-bottom:5px;padding:5px;">
<center>                        <!-- BEGIN home -->
        <a href="index.php" title="Go to the home page" >Home</a> ::
  <!-- END home -->                    <!-- BEGIN login -->
        <a href="login.php?referer=thumbnails.php%3Falbum%3Dlastupby%26cat%3D0%26uid%3D1%26page%3D9732" title="Log me in" >Login</a>
  <!-- END login -->   
</center> </div>




<div style="height: 10px;"></div>

<center>


  <table width="950" border="0" cellpadding="5" cellspacing="5">
    <tr>
      <td valign="top">
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td valign="top">
             


<div style="height: 10px;"></div>
Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 1832
Re: passwords
« Reply #11 on: May 27, 2022, 02:25:16 pm »

I don't think there is any more help that I can provide without getting access to your server.
Logged
Pages: [1]   Go Up
 

Page created in 0.035 seconds with 21 queries.