La solution était donnée dans le [wiki]
c'est fait!
pixels78 a écrit:
vous pouvez passer le sujet en résolu.
Super si cela fonctionne :-)
Pour passer le sujet en résolu, tu as un lien dans ton premier message de la discussion ;-)
merci beaucoup!
vous pouvez passer le sujet en résolu.
Bonjour,
Éditer le fichier indiqué
et sur la ligne
$conf['db_password'] = 'aaaaaaaaaaa';
remplacer votre ancien mot de passe (ici aaaaaaaaaaa) par le nouveau
ok, pouvez vous me donnez la marche à suivre!
si vous avez changé le mot de passe de la base ile faut mettre à jour le fichier local/config/database.inc.php de Piwigo
non dsl, sur les conseil d'ovh j'ai changé le mp de la base, et depuis j'ai cette erreur!
je n'y connais rien! j'ai bien trouvé et édité include et index mais je modifie comment ces lignes?
merci de votre aide
Piwigo encountered a non recoverable error
[mysql error 1045] Access denied for user 'pixelssports'@'10.0.85.164' (using password: YES)
Can't connect to server
#1 my_error /homez.32/pixels/www/galeries/include/common.inc.php(140)
#2 include_once /homez.32/pixels/www/galeries/index.php(26)
C'est bon pour vous ? On peut passer le sujet comme étant [Résolu] ?
merci
La première ligne présage de toutes les autres :
Warning: [mysql error 1146] Table 'pixelsgaleri.users' doesn't exist
En gros votre Base De Données souffre d'un gros défaut.
Solution : faire une restauration que vous aurez bien sûre réalisée récemment ^^
bonjour,
je viens de faire la migration 2.3.5 vers 2.4.4 et depuis je n'ai plus accès à ma galerie!
voila la page qui s'affiche:
merci d'avance pour votre aide
Warning: [mysql error 1146] Table 'pixelsgaleri.users' doesn't exist
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM users
WHERE id = '1' in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 153
Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 354
Warning: Invalid argument supplied for foreach() in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 356
Notice: Undefined index: id in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 385
Notice: Undefined index: status in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 385
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
SELECT cat_id
FROM phpwebgallery_user_access
WHERE user_id =
; in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 200
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
SELECT cat_id
FROM phpwebgallery_user_group AS ug INNER JOIN phpwebgallery_group_access AS ga
ON ug.group_id = ga.group_id
WHERE ug.user_id =
; in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 200
Notice: Undefined index: level in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 393
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
SELECT DISTINCT(id)
FROM phpwebgallery_images INNER JOIN phpwebgallery_image_category ON id=image_id
WHERE category_id NOT IN (274,276)
AND level> in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 200
Notice: Undefined index: level in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 700
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE c.id NOT IN (274,276)
GROUP BY c.id, c.global_rank' at line 8
SELECT c.id AS cat_id, global_rank,
MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM phpwebgallery_categories as c
LEFT JOIN phpwebgallery_image_category AS ic ON ic.category_id = c.id
LEFT JOIN phpwebgallery_images AS i
ON ic.image_id = i.id
AND i.level<=
WHERE c.id NOT IN (274,276)
GROUP BY c.id, c.global_rank in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 153
Notice: Undefined index: status in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 414
Notice: Undefined index: id in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 441
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
DELETE FROM phpwebgallery_user_cache_categories
WHERE user_id = in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Notice: Undefined index: id in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 463
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
DELETE FROM phpwebgallery_user_cache
WHERE user_id = in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Notice: Undefined index: id in /homez.32/pixels/www/galerie/include/functions_user.inc.php on line 473
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''false',1350630025,'274,276',1403,'NOT IN','0')' at line 5
INSERT IGNORE INTO phpwebgallery_user_cache
(user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
image_access_type, image_access_list)
VALUES
(,'false',1350630025,'274,276',1403,'NOT IN','0') in /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php on line 770
Notice: Undefined index: language in /homez.32/pixels/www/galerie/include/common.inc.php on line 151
Notice: Undefined index: language in /homez.32/pixels/www/galerie/include/common.inc.php on line 155
Notice: Undefined index: nb_image_page in /homez.32/pixels/www/galerie/include/section_init.inc.php on line 178
Warning: Cannot modify header information - headers already sent by (output started at /homez.32/pixels/www/galerie/include/dblayer/functions_mysql.inc.php:769) in /homez.32/pixels/www/galerie/include/functions_html.inc.php on line 510
Vous n'êtes pas autorisé à accéder à la page demandée