Database issues

[dreamdes]

I moved my gallery from another server last night and uploaded my database. I encountered this error.

Code Select Expand

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

Code Select Expand

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.

[François Keller]

Are your table create in your new database ?
if yes, is the table prefix cpg11d_ ?

[dreamdes]

Are your table create in your new database ?
if yes, is the table prefix cpg11d_ ?

The tables that I can see in PHPMYADMIN are

Code Select Expand

# Browse cpg11d_gailpicsalbums
# Browse cpg11d_gailpicsbanned
# Browse cpg11d_gailpicsbridge
# Browse cpg11d_gailpicsbuddy
# Browse cpg11d_gailpicsbuddy_req
# Browse cpg11d_gailpicscategories
# Browse cpg11d_gailpicscomments
# Browse cpg11d_gailpicsconfig
# Browse cpg11d_gailpicsdict
# Browse cpg11d_gailpicsecards
# Browse cpg11d_gailpicsexif
# Browse cpg11d_gailpicsfavpics
# Browse cpg11d_gailpicsfiletypes
# Browse cpg11d_gailpicshit_stats
# Browse cpg11d_gailpicsplugins
# Browse cpg11d_gailpicssessions
# Browse cpg11d_gailpicstemp_data
# Browse cpg11d_gailpicsusergroups
# Browse cpg11d_gailpicsusers
# Browse cpg11d_gailpicsvote_stats

[François Keller]

ok, your table prefix is cpg11d_gailpics.
also the table cpg11d_gailpicspictures doesn't exist, but it seems they are others tables who failed in your install.
Did you install correctly coppermine on your new server ?

[dreamdes]

I did a clean install of coppermine just to make sure before I linked the database and the error remains.

[François Keller]

can you give us a link ?