Problème placement des fichiers (2)

[AnnC]

Après la mise à jour de mon site réalisée hier (cf post en dessous...), je rencontre le même soucis (donc je me permet de squatter le post) :
- upload "réussi"
- mais après, pas moyen de placer le fichier : "Il y eu une erreur lors de l'exécution de la requête" (j'ai essayé dans mon album et dans un album pour tous utulisateurs)
- config : coppermine 1.4.8, sur free (http://ecusduweb.free.fr/galerie)

J'ai tenté de modifier les CHMOD mais étant sur free je me suis rendue compte (comme en témoignent de nombreux messages) que ce n'est pas possible. Par contre ce qui ressort dans ces messages c'est que normalement c'est pas nécessaire... Qq'un pourrait il me dire ce qui cloche sinon, ce qu'il faudrait aller voir ? Merci beaucoup 

AnnC

[AnnC]

Up plize ?
Qq'un a une idée pour mon soucis ?

[François Keller]

Il semble qu'il y ait un autre problème sur la galerie, il est impossible d'accedre à la galerie des utilisateurs.

Pour y voir plus clair, il faudrait un  login et mot de passe avec des droits d'upload

[AnnC]

Je t'envoie ça tout de suite.

Ci joint les infos de debug :

Code Select Expand

While executing query "SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg132_albums AS a INNER JOIN `ecusduweb`.cpg132_users as u on u.user_id = a.category - 10000 INNER JOIN cpg132_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 15 " on 0

mySQL error: Unknown column 'galleryicon' in 'field list'


Code Select Expand

USER:
------------------
Array
(
    [ID] => a97649183c2839d962af7a1a3e5e05e9
    [am] => 1
)

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

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 1
    [ufc_min] => 1
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 1
    [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] => 1
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg132_filetypes; (0.001s)
    [1] => select * from cpg132_plugins order by priority asc; (0s)
    [2] => delete from `ecusduweb`.cpg132_sessions where time<1152081489 and remember=0; (0.349s)
    [3] => delete from `ecusduweb`.cpg132_sessions where time<1150875489; (0.001s)
    [4] => select user_id from `ecusduweb`.cpg132_sessions where session_id=md5("bcd2fb5100e30977caa9fb11aa528fb89eb1ba507fd0676baa3bc8d95c4fa199"); (0.002s)
    [5] => select user_id as id, user_password as password from `ecusduweb`.cpg132_users where user_id=1 (0.009s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `ecusduweb`.cpg132_users AS u INNER JOIN `ecusduweb`.cpg132_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `ecusduweb`.cpg132_users AS u WHERE user_id='1' and user_group_list <> ''; (0.003s)
    [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 cpg132_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1 (0.001s)
    [10] => update `ecusduweb`.cpg132_sessions set time='1152085089' where session_id=md5('bcd2fb5100e30977caa9fb11aa528fb89eb1ba507fd0676baa3bc8d95c4fa199'); (0.001s)
    [11] => SELECT user_favpics FROM cpg132_favpics WHERE user_id = 1 (0.006s)
    [12] => DELETE FROM cpg132_banned WHERE expiry < '2006-07-05 07:38:09' (0.009s)
    [13] => SELECT * FROM cpg132_banned WHERE (ip_addr='193.55.119.252' OR ip_addr='193.55.119.252' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT aid FROM cpg132_albums as a WHERE category>=10000 (0s)
    [15] => SELECT cid FROM cpg132_categories WHERE parent = '1' (0s)
    [16] => SELECT name, parent FROM cpg132_categories WHERE cid = '1' (0s)
    [17] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos (0s)
    [18] => SELECT aid FROM cpg132_albums as a WHERE category >= 10000 (0.006s)
    [19] => SELECT COUNT(*) FROM cpg132_pictures WHERE approved = 'NO' (0.001s)
    [20] => select null from cpg132_albums as p  INNER JOIN cpg132_pictures AS pics ON pics.aid = p.aid where ( category>10000 ) group by category; (0.001s)
    [21] => SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg132_albums AS a INNER JOIN `ecusduweb`.cpg132_users as u on u.user_id = a.category - 10000 INNER JOIN cpg132_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 15  (0.001s)
)

==========================
GET :
------------------
Array
(
    [cat] => 1
)

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 5.0.23-nightly-20060619
------------------
Coppermine version: 1.4.8(stable)
==========================
Module: GD
------------------
GD Version: 2.0 or higher
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:
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Links 1
Client API version 5.0.21-nightly-20060409
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/mysql/include/mysql
MYSQL_LIBS -L/usr/mysql/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 | On | On
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 | On | On
disable_functions | no value | no value
file_uploads | On | On
include_path | /var/www/sdc/4/7/ecusduweb/include:. | .
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 2M | 2M
==========================
Page generated in 0.632 seconds - 22 queries in 0.392 seconds - Album set : AND aid IN (6,5,7,8,19,15,14,54,20,21,23,26,27,53,29,31,33,34,35,50,45,46,48,41,55,56,60,47,77,51,58,59,62,63,65,66,67,68,70,71,72,73,74,75,76,78,80,81,82,83,84) ; Meta set: AND aid IN (6,5,7,8,19,15,14,54,20,21,23,26,27,53,29,31,33,34,35,50,45,46,48,41,55,56,60,47,77,51,58,59,62,63,65,66,67,68,70,71,72,73,74,75,76,78,80,81,82,83,84) ;

[Titooy]

J'ai séparé les problèmes qui n'ont rien à voir l'un avec l'autre à part l'intitulé...

[François Keller]

J'ai séparé les problèmes qui n'ont rien à voir l'un avec l'autre à part l'intitulé...

ok, le problème est d'ailleur reglé. J'ai refait un update.php et tout semble rentré dans l'ordre