I moved my gallery from another server last night and uploaded my database. I encountered this error.
While executing query "SELECT count(*) FROM cpg11d_gailpicspictures as p, cpg11d_gailpicsalbums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0
mySQL error: Table 'dreamdes_aff3.cpg11d_gailpicspictures' doesn't exist
and
USER:
------------------
Array
(
[ID] => 26a09eb5942e5bd2dae905216d8896d8
[am] => 1
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 0
[user_name] => Guest
[groups] => Array
(
[0] => 3
)
[group_quota] => 0
[can_rate_pictures] =>
[can_send_ecards] =>
[can_post_comments] =>
[can_upload_pictures] =>
[can_create_albums] => 0
[pub_upl_need_approval] =>
[priv_upl_need_approval] =>
[upload_form_config] =>
[num_file_upload] =>
[num_URI_upload] =>
[custom_user_upload] =>
[disk_max] =>
[disk_min] =>
[ufc_max] =>
[ufc_min] =>
[has_admin_access] => 0
[group_name] =>
[can_see_all_albums] => 0
[group_id] => 3
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content, player FROM cpg11d_gailpicsfiletypes; (0s)
[1] => select * from cpg11d_gailpicsplugins order by priority asc; (0s)
[2] => delete from `dreamdes_aff3`.cpg11d_gailpicssessions where time<1229504274 and remember=0; (0s)
[3] => delete from `dreamdes_aff3`.cpg11d_gailpicssessions where time<1228298274; (0s)
[4] => select user_id from `dreamdes_aff3`.cpg11d_gailpicssessions where session_id = 'c5b56e96ff3554a122e1d632268500f3' (0s)
[5] => select user_id as id, user_password as password from `dreamdes_aff3`.cpg11d_gailpicsusers 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 cpg11d_gailpicsusergroups WHERE group_id in (3) (0s)
[7] => SELECT group_name FROM cpg11d_gailpicsusergroups WHERE group_id= 3 (0s)
[8] => update `dreamdes_aff3`.cpg11d_gailpicssessions set time='1229507874' where session_id = 'c5b56e96ff3554a122e1d632268500f3' (0s)
[9] => DELETE FROM cpg11d_gailpicsbanned WHERE expiry < '2008-12-17 09:57:54' (0s)
[10] => SELECT * FROM cpg11d_gailpicsbanned WHERE (ip_addr='76.167.246.63' OR ip_addr='76.167.246.63' OR user_id=0) AND brute_force=0 (0s)
[11] => SELECT aid FROM cpg11d_gailpicsalbums (0s)
[12] => SELECT cid, name, description, thumb FROM cpg11d_gailpicscategories WHERE parent = '' ORDER BY pos (0s)
[13] => SELECT aid FROM cpg11d_gailpicsalbums as a WHERE category>=10000 (0s)
[14] => SELECT count(*) FROM cpg11d_gailpicspictures as p, cpg11d_gailpicsalbums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.044 seconds - 15 queries in 0.001 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,21,22,23,24,25,26,27,28,29,30,32,33,34,35,36,37,38,39,41,42,43,44,45,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,109,110,111,112,113,114,115,116,117,118,119,121,122,123,124,125,127,130,131,132,133,134,135,136,137,138,139,140,141,142,144,145,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,442,445,446,447,448,449,450,451,452) ;
I've tried 3 different back ups from the past few months...I've never had a hacking problem so I am not sure why I am getting this.
Author
Topic: Database issues (Read 2869 times)