Écrire une réponse

Veuillez écrire votre message et l'envoyer

Cliquez dans la zone sombre de l'image pour envoyer votre message.

Retour

Résumé de la discussion (messages les plus récents en premier)

Gotcha
2012-10-20 13:11:52

La solution était donnée dans le [wiki]

pixels78
2012-10-20 09:35:40

c'est fait!

ddtddt
2012-10-20 09:34:04

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 ;-)

pixels78
2012-10-20 09:16:37

merci beaucoup!
vous pouvez passer le sujet en résolu.

ddtddt
2012-10-20 09:01:26

Bonjour,

Éditer le fichier indiqué
et sur la ligne

$conf['db_password'] = 'aaaaaaaaaaa';

remplacer votre ancien mot de passe (ici aaaaaaaaaaa) par le nouveau

pixels78
2012-10-20 08:52:13

ok, pouvez vous me donnez la marche à suivre!

mistic100
2012-10-20 00:50:11

si vous avez changé le mot de passe de la base ile faut mettre à jour le fichier local/config/database.inc.php de Piwigo

pixels78
2012-10-19 20:34:51

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)

Gotcha
2012-10-19 12:49:43

C'est bon pour vous ? On peut passer le sujet comme étant [Résolu] ?

pixels78
2012-10-19 10:45:11

merci

Gotcha
2012-10-19 10:04:22

La première ligne présage de toutes les autres :

Code:

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 ^^

pixels78
2012-10-19 09:12:26

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

Pied de page des forums

Propulsé par FluxBB

github twitter newsletter Faire un don Piwigo.org © 2002-2024 · Contact