Not letting me upload

[chicks]

I don't think it's the same problem, but I get There was an error while processing a database query when I try to upload a picture.  :cry:

[Joachim Müller]

switch on debug_mode in coppermine config and paste the debug info into your post from the page that has errors.

GauGau

[chicks]

YOu mean this stuff:

Code Select Expand

USER:
Array
(
    [ID] => e3a55983116f9c5a54296321b672f62d
    [am] => 1
    [search] => ###la8
    [liv] => Array
        (
            [0] => 2324
            [1] => 2326
            [2] => 4430
            [3] => 4370
            [4] => 4349
        )

    [sort] => dd
    [lap] => 1
)

 
 
USER DATA:
Array
(
    [0] => 1
    [user_id] => 1
    [1] => 1
    [user_group] => 1
    [2] => YES
    [user_active] => YES
    [3] => admin
    [user_name] => admin
    [4] => mercer
    [5] => 2003-12-31 14:41:04
    [user_lastvisit] => 2003-12-31 14:41:04
    [6] => 2003-12-31 14:41:04
    [user_regdate] => 2003-12-31 14:41:04
    [7] =>
    [user_lang] =>
    [8] =>
    [user_email] =>
    [9] =>
    [user_website] =>
    [10] =>
    [user_location] =>
    [11] =>
    [user_interests] =>
    [12] =>
    [user_occupation] =>
    [13] =>
    [user_actkey] =>
    [14] => 1
    [group_id] => 1
    [15] => Administrators
    [group_name] => Administrators
    [16] => 0
    [group_quota] => 0
    [17] => 1
    [has_admin_access] => 1
    [18] => 1
    [can_rate_pictures] => 1
    [19] => 1
    [can_send_ecards] => 1
    [20] => 1
    [can_post_comments] => 1
    [21] => 1
    [can_upload_pictures] => 1
    [22] => 1
    [can_create_albums] => 1
    [23] => 0
    [pub_upl_need_approval] => 0
    [24] => 0
    [priv_upl_need_approval] => 0
)

 
 
Queries:
Array
(
    [0] => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'db21ae7d732e6c559bb86aeb1b352289'
    [1] => DELETE FROM cpg11d_banned WHERE expiry < 1073063982
    [2] => SELECT * FROM cpg11d_banned WHERE ip_addr='24.167.122.157' OR ip_addr='24.167.122.157' OR user_id=1
    [3] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = ''  ORDER BY pos
    [4] => SELECT aid FROM cpg11d_albums WHERE category = 2
    [5] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 2
    [6] => SELECT count(*) FROM cpg11d_albums WHERE category = '2'
    [7] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '2' ORDER BY pos LIMIT 0,4
    [8] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1, 52, 2, 4) AND approved = 'YES' GROUP BY aid
    [9] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5039'
    [10] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4957'
    [11] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '2'  ORDER BY pos
    [12] => SELECT aid FROM cpg11d_albums WHERE category = 12
    [13] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 12
    [14] => SELECT aid FROM cpg11d_albums WHERE category = 3
    [15] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 3
    [16] => SELECT count(*) FROM cpg11d_albums WHERE category = '3'
    [17] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '3' ORDER BY pos LIMIT 0,2
    [18] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (3, 10) AND approved = 'YES' GROUP BY aid
    [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='3215'
    [20] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '3'  ORDER BY pos
    [21] => SELECT aid FROM cpg11d_albums WHERE category = 7
    [22] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 7
    [23] => SELECT count(*) FROM cpg11d_albums WHERE category = '7'
    [24] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '7' ORDER BY pos LIMIT 0,4
    [25] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (69, 25, 5, 72) AND approved = 'YES' GROUP BY aid
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4408'
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4230'
    [28] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '7'  ORDER BY pos
    [29] => SELECT aid FROM cpg11d_albums WHERE category = 8
    [30] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 8
    [31] => SELECT count(*) FROM cpg11d_albums WHERE category = '8'
    [32] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '8' ORDER BY pos LIMIT 0,4
    [33] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (73, 74, 75, 76) AND approved = 'YES' GROUP BY aid
    [34] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '8'  ORDER BY pos
    [35] => SELECT aid FROM cpg11d_albums WHERE category = 13
    [36] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 13
    [37] => SELECT count(*) FROM cpg11d_albums WHERE category = '13'
    [38] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '13' ORDER BY pos LIMIT 0,4
    [39] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (63, 65, 66, 28) AND approved = 'YES' GROUP BY aid
    [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4382'
    [41] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '13'  ORDER BY pos
    [42] => SELECT aid FROM cpg11d_albums WHERE category = 4
    [43] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 4
    [44] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '4'  ORDER BY pos
    [45] => SELECT aid FROM cpg11d_albums WHERE category = 6
    [46] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 6
    [47] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '6'  ORDER BY pos
    [48] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
    [49] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
    [50] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
    [51] => SELECT count(*) FROM cpg11d_albums WHERE 1
    [52] => SELECT count(*) FROM cpg11d_pictures WHERE 1
    [53] => SELECT count(*) FROM cpg11d_comments WHERE 1
    [54] => SELECT count(*) FROM cpg11d_categories WHERE 1
    [55] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
    [56] => SELECT count(*) FROM cpg11d_albums WHERE category = ''
    [57] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '' ORDER BY pos LIMIT 0,4
    [58] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (82, 84, 83, 85) AND approved = 'YES' GROUP BY aid
    [59] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
    [60] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
    [61] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid FROM cpg11d_pictures WHERE  randpos IN (7) AND approved = 'YES'  ORDER BY RAND() LIMIT 8
    [62] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
    [63] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
)

 
GET :
Array
(
)

 
POST :
Array
(
)

[jason]

not pertaining to you orginal question, but...do yourself a favor and change your passwords now that you posted them online.

[NorbertGutscher]

switch to
Create intermediate pictures = No
and try it again. If it works, you have a server time out problem (like me).