Piwigo.org

delmarty · 2012-06-22 16:08:05

je viens de basculer sur la version 2.4 mais je n'ai plus acces a mon administration. de plus voici la liste d'erreur qui apparait:.

pouvez vous me redonner mon mot de passe? et voir les problemes
merci d'avance

Warning: [mysql error 1146] Table 'ikonfo96_piwigo.users' doesn't exist

SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM users
WHERE id = '1' in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/ikonfo96/public_html/piwigo/include/functions_user.inc.php on line 354

Warning: Invalid argument supplied for foreach() in /home/ikonfo96/public_html/piwigo/include/functions_user.inc.php on line 356

Notice: Undefined index: id in /home/ikonfo96/public_html/piwigo/include/functions_user.inc.php on line 385

Notice: Undefined index: status in /home/ikonfo96/public_html/piwigo/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 piwigo_table1user_access
WHERE user_id =
; in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/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 piwigo_table1user_group AS ug INNER JOIN piwigo_table1group_access AS ga
ON ug.group_id = ga.group_id
WHERE ug.user_id =
; in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /home/ikonfo96/public_html/piwigo/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 piwigo_table1images INNER JOIN piwigo_table1image_category ON id=image_id
WHERE category_id NOT IN (0)
AND level> in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 200

Notice: Undefined index: level in /home/ikonfo96/public_html/piwigo/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 '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 piwigo_table1categories as c
LEFT JOIN piwigo_table1image_category AS ic ON ic.category_id = c.id
LEFT JOIN piwigo_table1images AS i
ON ic.image_id = i.id
AND i.level<=
GROUP BY c.id, c.global_rank in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Notice: Undefined index: status in /home/ikonfo96/public_html/piwigo/include/functions_user.inc.php on line 414

Notice: Undefined index: id in /home/ikonfo96/public_html/piwigo/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 piwigo_table1user_cache_categories
WHERE user_id = in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Notice: Undefined index: id in /home/ikonfo96/public_html/piwigo/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 piwigo_table1user_cache
WHERE user_id = in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Notice: Undefined index: id in /home/ikonfo96/public_html/piwigo/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',1340373900,'0',2385,'NOT IN','0')' at line 5

INSERT IGNORE INTO piwigo_table1user_cache
(user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
image_access_type, image_access_list)
VALUES
(,'false',1340373900,'0',2385,'NOT IN','0') in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Notice: Undefined index: language in /home/ikonfo96/public_html/piwigo/include/common.inc.php on line 151

Notice: Undefined index: language in /home/ikonfo96/public_html/piwigo/include/common.inc.php on line 155

Notice: Undefined index: language in /home/ikonfo96/public_html/piwigo/plugins/language_switch/language_switch.inc.php on line 30

Notice: Undefined index: language in /home/ikonfo96/public_html/piwigo/plugins/language_switch/language_switch.inc.php on line 66

Notice: Undefined index: nb_image_page in /home/ikonfo96/public_html/piwigo/include/section_init.inc.php on line 178

Warning: Cannot modify header information - headers already sent by (output started at /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php:769) in /home/ikonfo96/public_html/piwigo/include/functions_html.inc.php on line 510

Gotcha · 2012-06-22 16:19:12

Bonjour,

Avez-vous une sauvegarde de votre Base De Données ?

delmarty · 2012-06-22 16:21:10

je crois bien que non?!!! je crois que c'est grave...

Gotcha · 2012-06-22 16:25:53

Grave je ne saurais pas le dire pour le moment. Vous êtes semble t-il pas tout seul dans ce cas : [Forum, topic 22205] Migration en 2.4 et perte du prefix de la base

J'attends l'arrivé d'un expert pour dire comment procéder.

P.S :Vous pouvez suivre le fil du sujet cité ;-)

delmarty · 2012-06-22 16:56:52

la base est toujours la car j'ai acces via mon hebergeur ,elle fait toujours 38 mo et contient bien mes 2380 photos! mais je n'arrive pas a retrouver mon mot de passe

mistic100 · 2012-06-22 17:42:47

au cas ou vous n'auriez vu la réponse a été trouvée
http://fr.piwigo.org/forum/viewtopic.ph … 06#p187906

Dernière modification par mistic100 (2012-06-22 17:42:55)

delmarty · 2012-06-22 17:44:15

oui mais jen'aipas d'acces a mon administration,il ne reconnait plus mon mot de passe

mistic100 · 2012-06-22 18:01:23

alors il faut mettre les mains dans le cambouis et accéder au fichier avec un client FTP

Gotcha · 2012-06-22 18:11:02

mistic100 a écrit:
avec un client FTP

Ou via le panneau d'administration de votre hébergeur ;-)

delmarty · 2012-06-22 20:08:01

j'ai modifier mon mot de pass via mon hebergeur,mais lorsque je retourne sur mon site il ne le reconnait pas?

http://www.ikonfoto.com/piwigo/

user:
jeanjon

mot de passe:

***************************************************

Dernière modification par ddtddt (2012-06-22 20:25:55)

mistic100 · 2012-06-22 20:23:34

tres mauvaise idée de donner vos identifiants au public

et il faut savoir que les identifiants Piwigo n'ont aucun rapport avec les identifiants de l'administration de l'hebergement ni meme de la base SQL

ce que voulais dire Gotcha c'est que si votre hebergeur propose un client FTP in-browser vous pouvez l'utiliser, sinon il faut que vous utilisiez le votre pour corriger le fichier config.inc.php

Dernière modification par mistic100 (2012-06-22 20:24:18)

delmarty · 2012-06-22 20:24:20

j'ai resolu un probleme,cependant il en reste un majeur,il ne reconnait pas mon mot de passe!
donc pas acces a l'admin de piwigo.

je suis aller via mon hebergeur changer mon mot de passe dans la table piwigo_table1users mais ca marche pas!

ddtddt · 2012-06-22 20:26:37

delmarty a écrit:
je suis aller via mon hebergeur changer mon mot de passe dans la table piwigo_table1users mais ca marche pas!

As tu choisie encodage MD5 ?

delmarty · 2012-06-22 20:34:10

je crois que le plus simple pour que je puisse avancer et remettre de l'ordre sur mon site,qu'une ame charitable modifie mon mot de passe et me l'envoi par email car je crois que je suis perdu totalement.

jean.delmarty@gmail.com

merci au dieu de l'informatique de bien vouloir sauver le soldat delmarty.!

delmarty · 2012-06-22 20:42:03

Warning: [mysql error 1054] Unknown column 'tn_ext' in 'field list'
il reste plus que ces erreurs la!:

SELECT id,path,tn_ext,file,filesize,level,name
FROM piwigo_table1images
WHERE id IN (2647,2648)
ORDER BY date_available DESC, file ASC, id ASC
LIMIT 20 OFFSET 0
; in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 770

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php on line 153

Warning: Cannot modify header information - headers already sent by (output started at /home/ikonfo96/public_html/piwigo/include/dblayer/functions_mysql.inc.php:769) in /home/ikonfo96/public_html/piwigo/include/page_header.php on line 105

Warning: filemtime() [function.filemtime]: stat failed for ./themes/default/js/plugins/colorbox/style2/colorbox.css in /home/ikonfo96/public_html/piwigo/include/template.class.php on line 1307

Warning: file_get_contents(./themes/default/js/plugins/colorbox/style2/colorbox.css) [function.file-get-contents]: failed to open stream: No such file or directory in /home/ikonfo96/public_html/piwigo/include

Piwigo.org

Annonce

#1 2012-06-22 16:08:05

plus d'acces a mon administration

#2 2012-06-22 16:19:12

Re: plus d'acces a mon administration

#3 2012-06-22 16:21:10

Re: plus d'acces a mon administration

#4 2012-06-22 16:25:53

Re: plus d'acces a mon administration

#5 2012-06-22 16:56:52

Re: plus d'acces a mon administration

#6 2012-06-22 17:42:47

Re: plus d'acces a mon administration

#7 2012-06-22 17:44:15

Re: plus d'acces a mon administration

#8 2012-06-22 18:01:23

Re: plus d'acces a mon administration

#9 2012-06-22 18:11:02

Re: plus d'acces a mon administration

mistic100 a écrit:

#10 2012-06-22 20:08:01

Re: plus d'acces a mon administration

#11 2012-06-22 20:23:34

Re: plus d'acces a mon administration

#12 2012-06-22 20:24:20

Re: plus d'acces a mon administration

#13 2012-06-22 20:26:37

Re: plus d'acces a mon administration

delmarty a écrit:

#14 2012-06-22 20:34:10

Re: plus d'acces a mon administration

#15 2012-06-22 20:42:03

Re: plus d'acces a mon administration

Pied de page des forums