Unclear Problem...? Unclear Problem...?
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Unclear Problem...?

Started by cboz, August 04, 2010, 10:34:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

cboz

I was having a problem with my gallery and was getting a critical error, unable to connect to database, can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).  After fighting with my host for a while I was finally able to get them to fix the problem and get the connection working again.  Everything looks like it's okay, but I'm getting the following debug information:


USER:
------------------
Array
(
    [ID] => 349396415335dbd8a0ffa023fc470365
    [am] => 1
    [lang] => english
)

==========================
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
        [upload_form_config] => 0
        [num_file_upload] => 5
        [num_URI_upload] => 3
        [custom_user_upload] => 0
        [disk_max] => 0
        [disk_min] => 0
        [ufc_max] => 0
        [ufc_min] => 0
        [has_admin_access] => 0
        [group_name] => Anonymous
        [can_see_all_albums] => 0
        [group_id] => 3
    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content, player FROM cpg_filetypes; (0.001s)
        [1] => select * from cpg_plugins order by priority asc; (0.001s)
        [2] => delete from `spiritline`.cpg_sessions where time<1280939659 and remember=0; (0s)
        [3] => delete from `spiritline`.cpg_sessions where time<1279733659; (0s)
        [4] => select user_id from `spiritline`.cpg_sessions where session_id=md5("3163541bd50b0251ef19d48d5d7431e1766e3dcd7c43dbd8594a2a8b5d6e5a13"); (0.001s)
        [5] => select user_id as id, user_password as password from `spiritline`.cpg_users where user_id=0 (0.001s)
        [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(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 (3) (0.001s)
        [7] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 3 (0.001s)
        [8] => update `spiritline`.cpg_sessions set time='1280943259' where session_id=md5('3163541bd50b0251ef19d48d5d7431e1766e3dcd7c43dbd8594a2a8b5d6e5a13'); (0s)
        [9] => DELETE FROM cpg_banned WHERE expiry < '2010-08-04 10:34:19' (0.001s)
        [10] => SELECT * FROM cpg_banned WHERE (ip_addr='68.230.100.73' OR ip_addr='68.230.100.73' OR user_id=0) AND brute_force=0 (0.001s)
        [11] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.001s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
        [referer] => index.php
    )

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

    ==========================
    Page generated in 0.052 seconds - 12 queries in 0.009 seconds - Album set : AND aid NOT IN (5) ; Meta set: ;



phill104

Then switch off the debug output from the config.

Please, always post a link to your site with each new support request.
It is a mistake to think you can solve any major problems just with potatoes.