Print

[giulianofs]

Quando clicco sul nome di un utente mi esce questo "C'è stato un errore processando una query al database"
Come mai?

[twist]

Attiva la modalita' debug e guarda nella finestra dove sta il problema

[giulianofs]

Eccolo qui, io non ci ho capito niente.

Code: [Select]

USER:
------------------
Array
(
    [ID] => d1590d89cb7e57e464c6fd5bf9e0ae52
    [am] => 1
    [lang] => italian
    [liv] => Array
        (
        )

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

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => giuliano
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0.001s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `Sql151281_3`.cpg14x_sessions where time<1199964665 and remember=0; (0.001s)
    [3] => delete from `Sql151281_3`.cpg14x_sessions where time<1198758665; (0.001s)
    [4] => select user_id from `Sql151281_3`.cpg14x_sessions where session_id=md5("351cb82a3156220d2650ecfba50ffc55db1626f05a9d9eb46f920092056cee37"); (0s)
    [5] => select user_id as id, user_password as password from `Sql151281_3`.cpg14x_users where user_id=1 (0.001s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `Sql151281_3`.cpg14x_users AS u INNER JOIN `Sql151281_3`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
    [7] => SELECT user_group_list FROM `Sql151281_3`.cpg14x_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => 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 cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `Sql151281_3`.cpg14x_sessions set time='1199968265' where session_id=md5('351cb82a3156220d2650ecfba50ffc55db1626f05a9d9eb46f920092056cee37'); (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0.001s)
    [12] => SELECT count(*) FROM  cpg14x_pms WHERE owner=1 (0.001s)
    [13] => SELECT count(*) FROM  cpg14x_pms WHERE owner=1 AND showed='0' (0.001s)
    [14] => SELECT count(*) FROM  cpg14x_buddy WHERE user_id=1 (0.001s)
    [15] => SELECT count(*) FROM  cpg14x_buddy_req WHERE buddy_to=1 (0.001s)
    [16] => DELETE FROM cpg14x_banned WHERE expiry < '2008-01-10 12:31:05' (0.001s)
    [17] => SELECT * FROM cpg14x_banned WHERE (ip_addr='87.20.252.63' OR ip_addr='87.20.252.63' OR user_id=1) AND brute_force=0 (0s)
    [18] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY pos (0.003s)
    [19] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0.001s)
    [20] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
    [21] => SELECT aid FROM cpg14x_albums WHERE category = 3 (0.001s)
    [22] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0.001s)
    [23] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0.001s)
    [24] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0.203s)
    [25] => SELECT aid FROM cpg14x_albums WHERE category = 21 (0s)
    [26] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 21 (0s)
    [27] => SELECT aid FROM cpg14x_albums WHERE category = 27 (0s)
    [28] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 27 (0s)
    [29] => SELECT aid FROM cpg14x_albums WHERE category = 36 (0s)
    [30] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 36 (0s)
    [31] => SELECT aid FROM cpg14x_albums WHERE category = 45 (0s)
    [32] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 45 (0s)
    [33] => SELECT aid FROM cpg14x_albums WHERE category = 49 (0s)
    [34] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 49 (0s)
    [35] => SELECT aid FROM cpg14x_albums WHERE category = 56 (0s)
    [36] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 56 (0s)
    [37] => SELECT aid FROM cpg14x_albums WHERE category = 64 (0s)
    [38] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 64 (0s)
    [39] => SELECT aid FROM cpg14x_albums WHERE category = 80 (0s)
    [40] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 80 (0s)
    [41] => SELECT aid FROM cpg14x_albums WHERE category = 87 (0s)
    [42] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 87 (0s)
    [43] => SELECT aid FROM cpg14x_albums WHERE category = 88 (0s)
    [44] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 88 (0s)
    [45] => SELECT aid FROM cpg14x_albums WHERE category = 89 (0s)
    [46] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 89 (0s)
    [47] => SELECT aid FROM cpg14x_albums WHERE category = 93 (0s)
    [48] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 93 (0s)
    [49] => SELECT aid FROM cpg14x_albums WHERE category = 98 (0s)
    [50] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 98 (0s)
    [51] => SELECT aid FROM cpg14x_albums WHERE category = 99 (0s)
    [52] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 99 (0s)
    [53] => SELECT aid FROM cpg14x_albums WHERE category = 100 (0s)
    [54] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 100 (0s)
    [55] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
    [56] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
    [57] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
    [58] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [59] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [60] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [61] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0.001s)
    [62] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES'  (0.001s)
    [63] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,12 (0.002s)
    [64] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0.203s)
    [65] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES'  (0.001s)
    [66] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 12 (0.043s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 4.4.7 - OK
------------------
mySQL version: 5.0.45-community-log
------------------
Coppermine version: 1.4.14 modpack v1(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/php/lib/php/ | .:/php/lib/php/
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 120 | 120
max_input_time | -1 | -1
upload_max_filesize | 50M | 50M
post_max_size | 8M | 8M
==========================
Page generated in 0.783 seconds - 67 queries in 0.473 seconds - Album set : ; Meta set: ;

[Davide Renda]

Hai modificato qualche tabella da mySQL?  Così a prima vista, dal tipo d'errore, sembra che il tuo database sia in qualche maniera corrotto (tabelle users e usergroups direi). Cosa hai modificato recentemente?

[giulianofs]

Io il mysql non lo tocco mai, le ultime modifiche che ho fatto in fotogallery sono solo aggiunta di nuove categorie e album.
Il database mysql di phpbb e coppermine è in comune.
Chissà cos'è successo. Non c'è un modo per sistemare?

[giulianofs]

Ho risolto

[twist]

Se puoi spiegare quale era il problema e come hai risolto, credo sia più utile anche per il futuro

[giulianofs]

Un plugin che informava se gli utenti erano online o offline, era già disattivato ma ancora era presente la stringa nella visualizzazione album, l'ho tolta ed ora funziona tutto come prima.