Hi Reece,
Well saw the word "FREE" and thought I'd give it a shot. I understand that you do free installations. I actually have a lil issue with my site so wanted to start by asking your help. My site is
www.nivas.com/pics. I have been able to add numerous images in the past, however am getting an error when adding new images.
If you look at the bottom of the page, it shows debug info:
==========================================================
USER:
------------------
Array
(
[ID] => 117d3cfc13a3866789c4574c5d436e3a
[am] => 1
)
==========================
USER DATA:
------------------
Array
(
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 0
[ufc_max] => 0
[ufc_min] => 0
[custom_user_upload] => 0
[num_file_upload] => 10
[num_URI_upload] => 3
[can_post_comments] => 0
[can_upload_pictures] => 0
[can_create_albums] => 0
[has_admin_access] => 0
[pub_upl_need_approval] => 1
[priv_upl_need_approval] => 1
[group_name] => Anonymous
[upload_form_config] => 0
[group_quota] => 0
[can_see_all_albums] => 0
[group_id] => 3
[groups] => Array
(
[0] => 3
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content FROM cpg_filetypes;
[1] => SELECT * FROM cpg_users WHERE user_id='0'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*'
[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 (3)
[3] => SELECT group_name FROM cpg_usergroups WHERE group_id= 3
[4] => DELETE FROM cpg_banned WHERE expiry < 1169755246
[5] => SELECT * FROM cpg_banned WHERE ip_addr='75.19.38.71' OR ip_addr='75.19.38.71' OR user_id=0
[6] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)
[7] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '' ORDER BY pos
[8] => SELECT aid FROM cpg_albums WHERE category = 32 and aid NOT IN (96,113)
[9] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 32 and a.aid NOT IN (96,113)
[10] => SELECT aid FROM cpg_albums WHERE category = 37 and aid NOT IN (96,113)
[11] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 37 and a.aid NOT IN (96,113)
[12] => SELECT count(*) FROM cpg_albums as a WHERE category = '37' and a.aid NOT IN (96,113)
[13] => 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=37 and a.aid NOT IN (96,113) ORDER BY a.pos LIMIT 0,18
[14] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (11, 12, 13, 15, 16, 17, 19, 121, 83, 123, 89, 90, 95, 102, 103, 106, 107, 112) AND approved = 'YES' GROUP BY aid
[15] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2850'
[16] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1310'
[17] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1288'
[18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1320'
[19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2309'
[20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3293'
[21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2291'
[22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1764'
[23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2183'
[24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2798'
[25] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='3017'
[26] => SELECT aid FROM cpg_albums WHERE category = 26 and aid NOT IN (96,113)
[27] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 26 and a.aid NOT IN (96,113)
[28] => SELECT count(*) FROM cpg_albums as a WHERE category = '26' and a.aid NOT IN (96,113)
[29] => 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=26 and a.aid NOT IN (96,113) ORDER BY a.pos LIMIT 0,4
[30] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (53, 56, 57, 109) AND approved = 'YES' GROUP BY aid
[31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1520'
[32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1351'
[33] => SELECT aid FROM cpg_albums WHERE category = 24 and aid NOT IN (96,113)
[34] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 24 and a.aid NOT IN (96,113)
[35] => SELECT count(*) FROM cpg_albums as a WHERE category = '24' and a.aid NOT IN (96,113)
[36] => 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=24 and a.aid NOT IN (96,113) ORDER BY a.pos LIMIT 0,2
[37] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (58, 59) AND approved = 'YES' GROUP BY aid
[38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1716'
[39] => SELECT aid FROM cpg_albums WHERE category = 47 and aid NOT IN (96,113)
[40] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category = 47 and a.aid NOT IN (96,113)
[41] => SELECT count(*) FROM cpg_albums as a WHERE category = '47' and a.aid NOT IN (96,113)
[42] => 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=47 and a.aid NOT IN (96,113) ORDER BY a.pos LIMIT 0,3
[43] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (29, 111, 108) AND approved = 'YES' GROUP BY aid
[44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1378'
[45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='2801'
[46] => SELECT aid FROM cpg_albums as a WHERE category>=10000 and a.aid NOT IN (96,113)
[47] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category >= 10000 and a.aid NOT IN (96,113)
[48] => SELECT aid FROM cpg_albums as a WHERE category = '0' and a.aid NOT IN (96,113)
[49] => SELECT count(*) FROM cpg_albums as a WHERE 1 and a.aid NOT IN (96,113)
[50] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 and p.aid NOT IN (96,113)
[51] => SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 and p.aid NOT IN (96,113)
[52] => SELECT count(*) FROM cpg_categories WHERE 1
[53] => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1 and p.aid NOT IN (96,113)
[54] => SELECT count(*) FROM cpg_albums as a WHERE category = '0' and a.aid NOT IN (96,113)
[55] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid NOT IN (96,113)
[56] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg_pictures WHERE approved = 'YES' AND aid NOT IN (96,113) ORDER BY RAND() LIMIT 12
[57] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES' AND aid NOT IN (96,113)
[58] => 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 NOT IN (96,113) ORDER BY pid DESC LIMIT 0 ,12
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.229 seconds - 59 queries in 0.083 seconds - Album set : AND aid NOT IN (96,113)
==========================================================
Are you able to fix or help with this, or should I post this topic in another board.
Thank you for your consideration.
Regards,
Paul
Author
Topic: Free Coppermine Installation (Read 29116 times)