Advanced search  

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

Pages: [1]   Go Down

Author Topic: database error  (Read 3741 times)

0 Members and 1 Guest are viewing this topic.

JacekF

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
database error
« on: December 28, 2006, 05:57:25 pm »

I don't now what to do? After clic on thumniball i have pages in html ... check: http://jacek.rajdy.info/galeria/
Quote
USER:
------------------
Array
(
    [ID] => 1084d9cbd16c41248820e1f75765b69b
    [am] => 1
    [lang] => polish
    [liv] => Array
        (
           
  • => 213
  • [1] => 214
                [2] => 14
                [3] => 5
                [4] => 22
            )

       
[search] => Array
        (
            [search] => 05przed01wianki
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [filename] => on
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                    [filename] => on
                )

        )

    [sort] => pa
)

==========================
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] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0.002s)
  • [1] => select * from cpg1410_plugins order by priority asc; (0.002s)
        [2] => delete from `rajdy`.cpg1410_sessions where time<1167321142 and remember=0; (0.001s)
        [3] => delete from `rajdy`.cpg1410_sessions where time<1166115142; (0s)
        [4] => select user_id from `rajdy`.cpg1410_sessions where session_id=md5("95c44fd3f3149028a32893fbec7bc9b21d16c628c186d87da5ddfb66c0ea5605"); (0s)
        [5] => select user_id as id, user_password as password from `rajdy`.cpg1410_users where user_id=0 (0.071s)
        [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 cpg1410_usergroups WHERE group_id in (3) (0.002s)
        [7] => SELECT group_name FROM  cpg1410_usergroups WHERE group_id= 3 (0.001s)
        [8] => update `rajdy`.cpg1410_sessions set time='1167324742' where session_id=md5('95c44fd3f3149028a32893fbec7bc9b21d16c628c186d87da5ddfb66c0ea5605'); (0.001s)
        [9] => DELETE FROM cpg1410_banned WHERE expiry < '2006-12-28 17:52:22' (0.004s)
        [10] => SELECT * FROM cpg1410_banned WHERE (ip_addr='83.7.213.26' OR ip_addr='83.7.213.26' OR user_id=0) AND brute_force=0 (0.001s)
        [11] => SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.001s)
        [12] => SELECT aid FROM cpg1410_albums (0.001s)
        [13] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = ''  ORDER BY pos (0.002s)
        [14] => SELECT aid FROM cpg1410_albums as a WHERE category>=10000 (0s)
        [15] => SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.002s)
        [16] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '1'  ORDER BY pos (0.001s)
        [17] => SELECT aid FROM cpg1410_albums as a WHERE category = '0' (0.001s)
        [18] => SELECT count(*) FROM cpg1410_albums as a WHERE 1 (0s)
        [19] => SELECT count(*) FROM cpg1410_pictures as p LEFT JOIN cpg1410_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.001s)
        [20] => SELECT count(*) FROM cpg1410_comments as c LEFT JOIN cpg1410_pictures as p ON c.pid=p.pid LEFT JOIN cpg1410_albums as a ON a.aid=p.aid WHERE 1 (0.002s)
        [21] => SELECT count(*) FROM cpg1410_categories WHERE 1 (0.001s)
        [22] => SELECT sum(hits) FROM cpg1410_pictures as p LEFT JOIN cpg1410_albums as a ON p.aid=a.aid WHERE 1 (0.002s)
        [23] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '0' (0s)
        [24] => SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,7 (0.001s)
        [25] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg1410_albums AS a  LEFT JOIN cpg1410_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (1, 2, 3, 4, 5, 6, 7)GROUP BY a.aid (0.003s)
        [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='71' (0s)
        [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='172' (0s)
        [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='228' (0.001s)
        [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='243' (0s)
        [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='250' (0.001s)
        [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='264' (0s)
        [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='286' (0s)
        [33] => SELECT COUNT(*) from cpg1410_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7)  (0.001s)
        [34] => SELECT * FROM cpg1410_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7)  ORDER BY RAND() LIMIT 8 (0.007s)
        [35] => SELECT count(*) from cpg1410_comments where pid=141 and msg_id!=0 (0s)
        [36] => SELECT count(*) from cpg1410_comments where pid=229 and msg_id!=0 (0s)
        [37] => SELECT count(*) from cpg1410_comments where pid=212 and msg_id!=0 (0s)
        [38] => SELECT count(*) from cpg1410_comments where pid=112 and msg_id!=0 (0s)
        [39] => SELECT count(*) from cpg1410_comments where pid=242 and msg_id!=0 (0s)
        [40] => SELECT count(*) from cpg1410_comments where pid=205 and msg_id!=0 (0s)
        [41] => SELECT count(*) from cpg1410_comments where pid=106 and msg_id!=0 (0s)
        [42] => SELECT count(*) from cpg1410_comments where pid=187 and msg_id!=0 (0s)
        [43] => SELECT COUNT(*) from cpg1410_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7)  (0.001s)
        [44] => SELECT * FROM cpg1410_pictures WHERE approved = 'YES' AND aid IN (1,2,3,4,5,6,7)  ORDER BY pid DESC  LIMIT 0 ,8 (0.001s)
        [45] => SELECT count(*) from cpg1410_comments where pid=286 and msg_id!=0 (0s)
        [46] => SELECT count(*) from cpg1410_comments where pid=285 and msg_id!=0 (0s)
        [47] => SELECT count(*) from cpg1410_comments where pid=284 and msg_id!=0 (0s)
        [48] => SELECT count(*) from cpg1410_comments where pid=283 and msg_id!=0 (0s)
        [49] => SELECT count(*) from cpg1410_comments where pid=282 and msg_id!=0 (0s)
        [50] => SELECT count(*) from cpg1410_comments where pid=281 and msg_id!=0 (0s)
        [51] => SELECT count(*) from cpg1410_comments where pid=280 and msg_id!=0 (0s)
        [52] => SELECT count(*) from cpg1410_comments where pid=279 and msg_id!=0 (0s)
    )

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

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

    ==========================
    Page generated in 0.373 seconds - 53 queries in 0.115 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,6,7) ;
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: database error
« Reply #1 on: December 28, 2006, 06:07:40 pm »

This is not database error
Disable SEf url plugin and you'll be fine , your server is not compatible with this plugin
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: database error
« Reply #2 on: December 28, 2006, 06:14:17 pm »

Leave notices_display off if it doesn't mean anything to you. Only post debug_output if a supporter explicitely requests it. Not related to initial install, moving accordingly.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.