Bonjour,

Depuis 1 semaine, je n'arrive plus à me connecter sur mon site avec un login. Lorsque je valide le login et le mot de passe j'ai bien le texte de bienvenue mais ensuite il revient sur la page d'accueil, sans être connecté.
Ce n'est pas un probleme d'identifiant car je n'ai pas de message d'erreur.

J'ai bien vide xoops_session et xoops_online mais sans succes comme indique sur le forum mais sans succes.
J'ai essaye de remettre une vieille BDD de 09/06 mais j'ai le meme probleme.

Mon site a plus d'1 an et a toujours marche. Il y a environ 6 mois, je devais certaine fois faire F5 apres mettre logger pour avoir la page d'accueil des membres.
Avant-hier, j'ai reussi a me connecter avec un autre compte non admin que j'avais cree mais en deconnectant pour reessaye, ca ne marchait plus...

Si vous avex la moindre idee, je suis preneur.
Merci d'avance (help

Lis le forum et fais la recherche concernant le log admin... tu vas sur ta base de données etc...Mets toi en mode debug et donne les lignes d'erreurs...
Tu es certain d'avoir rien oublié ???
Mets ton site sur ta fiche qu'on puisse aller voir !
Quelle version ? Quel hébergeur ?

Faudrait en dire plus !

Bonjour,
J'ai essaye plusieurs recherche sur le site de xoops mais malheureusement sans succes. Par exemple, log admin, connection, connexion, admin.
C'est la que j'ai vu qu'il fallait vider xoops)session et xoops_online.

Mon site est chez free.
http://dinitz.free.fr
J'utilise phpmyadmin version 2.6.3-pl1
xoops2

Je n'ai pas de probleme pour creer des comptes.
J'ai cree un compte hier avec login: essai1 et password :footx
Un copain a essaye de chez lui (donc avec une autre IP adresse) mais il a la meme erreur que moi, c'est a dire qu'il se connecte, on lui dit bonjour mais sans arriver a la page d'accueil des membres. Comme si il ne s'etait pas identifie.

J'ai importe une vieille BDD de 10/06 (qui marchait...)et ca fait exactement pareil. Je pense donc que ce n'est pas un probleme dans la BDD.


Dans xoops_user j'ai 2 warning. je ne sais pas si je les avaient avant.
Mais je ne sais pas resoudre ce probleme.

PRIMARY PRIMARY 17 uid
uname INDEX aucune uname
email INDEX aucune email
uiduname INDEX aucune uid
uname
unamepass INDEX aucune uname
pass
pass INDEX aucune pass
pass_2 FULLTEXT aucune pass
La colonne `uid` ne devrait pas faire partie à la fois d'une clé primaire et d'une clé index
Plus d'un index de type INDEX existe pour la colonne `uname`

Sinon, je ne sais pas me mettre en mode debug. Est-ce que c'est sur la BDD ou sur le site? Si c'est sur le site, je n'ai pas acces au mode admin.

Juste pour info, j'ai lance xoops en local (que je n'avais plus touche depuis plus d'1 an) et j'arrive a me connecter en admin mais il revient sur la page d'accueil comme les gens non identifie. Il faut faire F5 pour pouvoir voir la page des gens identifie...

J'ai essaye de copier tout les fichiers recemment change sur le site (par rapport a la date donc une 10aine) avec ceux qui marchent en local et ca fait pareil.

Merci pour votre aide.

Dans PHP admin puis xoops_config --> debug_mode --> 1 au lieu de 0 pour passer en mode debug
La j'ai vu qu'il y avait un warning sur mainfile.php

J'ai change:
define('XOOPS_DB_PCONNECT', 0);
par
define('XOOPS_DB_PCONNECT', 1);

dans
// Use persistent connection? (Yes=1 No=0)
// Default is 'Yes'. Choose 'Yes' if you are unsure.
// define('XOOPS_DB_PCONNECT', 0);
define('XOOPS_DB_PCONNECT', 1);


Ca a marche.

J'ai remis dans PHP admin puis xoops_config --> debug_mode --> 0
J'ai transfere la base
J'ai remis define('XOOPS_DB_PCONNECT', 0); au lieu de 1
Et ca remarche.
champagne champagne champagne
Pour combien de temps!!!!

Bonjour,

j'ai le meme prob que toi, et j'ai fait les memes démarches mais c toujours pareil.

Mon site est chez OVH.
http://www.portaildubled.com
J'utilise phpmyadmin version 2.8.2.4
xoops2.16

Je n'ai pas de problème pour creer des comptes. j'ai essayé de me connecté d'un autre ordi( autre adresse ip), idem,il se connecte, on lui dit merci mais sans arriver a la page d'accueil des membres, juste apres j'ai unable to connect to DB.

j'ai pâsser en mode debug, puis relencé mon site et la g eu:

-------------
This page cannot be displayed due to an internal error.

You can provide the following information to the administrators of this site to help them solve the problem:

Error: Unable to connect to database

All errors (5) queries (90) blocks (22) extra (0) timers (4)
Errors
Notice: Only variables should be assigned by reference in file /modules/catads/class/ads.php line 320

Notice: Only variable references should be returned by reference in file /modules/myiframe/class/myiframe.php line 98

Warning: Smarty error: unable to read resource: "db:swb_block.html" in file /class/smarty/Smarty.class.php line 1095

Warning: Smarty error: unable to read resource: "db:swb_block.html" in file /class/smarty/Smarty.class.php line 1095

Error: notrace:Unable to connect to database in file /class/database/databasefactory.php line 34

Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '49ecf9c123faa5d9b5107afbb806a642'
SELECT * FROM xoops_users WHERE uid=1
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 2, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 3
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (7,6,38,5,4,3,2,1,60,53,59,56,57,39,31,12,8,9,10,11,13,14,15,16,17,18,19,20,28,40,27,25,23,22,21,24,26,55,58,33,52,29,51,50,30,32,49,48,47,46,45,44,34,35,36,37,43,42,41) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_modules WHERE dirname = 'news'
SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_catads_ads WHERE uid = '1'
SELECT * FROM xoops_bb_forums ORDER BY forum_order
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT news, auto, image, auto_image FROM xoops_spotlight LIMIT 0, 1
SELECT storyid, uid, title, hometext, comments, topicid FROM xoops_stories WHERE storyid=180 LIMIT 0, 1
SELECT uname, uid FROM xoops_users WHERE uid=1 LIMIT 0, 1
SELECT storyid, title, published, expired, counter FROM xoops_stories WHERE published < 1177066667 AND published > 0 AND (expired = 0 OR expired > 1177066667) AND storyid != 180 ORDER BY published DESC LIMIT 0, 10
SELECT topic_id, topic_title FROM xoops_topics order by topic_title ASC
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'news_block_spotlight.html') ORDER BY tpl_refid
SELECT * FROM xoops_myiframe WHERE frame_frameid=0
SELECT * FROM xoops_topics WHERE (topic_pid=0) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=2) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=3) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=4) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=5) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=6) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=7) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=8) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=9) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=12) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=10) ORDER BY topic_title
SELECT * FROM xoops_topics WHERE (topic_pid=11) ORDER BY topic_title
SELECT * FROM xoops_smiles
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'news_block_topicnav.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (6) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (12) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest2.html') ORDER BY tpl_refid
SELECT storyid FROM xoops_stories WHERE (published > 0 AND published <= 1177066667) AND (expired = 0 OR expired > 1177066667) ORDER BY published DESC
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=203) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=136) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=128) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=126) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=120) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=114) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=92) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=89) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=59) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM xoops_stories s, xoops_topics t WHERE (storyid=39) AND (s.topicid=t.topic_id)
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'news_block_randomnews.html') ORDER BY tpl_refid
SELECT cat_id, title FROM xoops_catads_cat WHERE pid=0 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=1 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=2 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=4 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=3 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=5 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=6 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=7 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=8 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=9 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=10 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=15 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=12 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=13 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=14 ORDER BY title
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'catads_block_add.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (7) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest3.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (5) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest4.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (10) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest5.html') ORDER BY tpl_refid
SELECT storyid, title, published, counter FROM xoops_stories WHERE published<1177066667 AND published>0 AND topicid in (11) ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'b_lykos_blocks_latest6.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'googlesearch_block.html') ORDER BY tpl_refid
SELECT * FROM xoops_sweatherbloc_config WHERE swbid=1
SELECT * FROM xoops_sweatherbloc_datacache WHERE citycode="MOXX0007"
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'swb_block.html') ORDER BY tpl_refid
Error number: 2006
Error message: MySQL server has gone away
SELECT distinct(FROM_UNIXTIME(published,'%Y-%m')) as published FROM xoops_stories WHERE published>=1175378400 AND published<=1177066684 ORDER BY published ASC
Error number: 2006
Error message: MySQL server has gone away
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
Error number: 2006
Error message: MySQL server has gone away
INSERT INTO xoops_online (online_uid, online_uname, online_updated, online_ip, online_module) VALUES (1, 'admin', 1177066684, '81.192.36.111', 0)
Error number: 2006
Error message: MySQL server has gone away
SELECT * FROM xoops_online
Error number: 2006
Error message: MySQL server has gone away

Error number: 2006
Error message: MySQL server has gone away
Total: 90 queries
Blocks
Menu utilisateur: No Cache
Connexion: No Cache
Recherche: No Cache
Menu principal: No Cache
Spotlight - Articles: No Cache
Affiche une iframe: No Cache
Navigation dans les sujets: No Cache
Recent articles in category: No Cache
Recent articles in category: No Cache
Articles Aléatoires: No Cache
Proposer une annonce: No Cache
Recent articles in category: No Cache
Recent articles in category: No Cache
Recent articles in category: No Cache
Recent articles in category: No Cache
Bloc personnalisé (HTML): No Cache
Recherche Google: No Cache
Simple Weather Bloc: No Cache
Bloc personnalisé (HTML): No Cache
Archives: No Cache
Qui est en ligne: No Cache
Sondages: No Cache
Total: 22 blocks
Extra
Timers
XOOPS took 16.992 seconds to load.
XOOPS Boot took 0.042 seconds to load.
Module init took 0.005 seconds to load.
XOOPS output init took 16.946 seconds to load.

---------------
dans xoops_users :

Keyname Type Cardinality Action Field
PRIMARY PRIMARY 2 Edit Drop uid
uname INDEX None Edit Drop uname
email INDEX None Edit Drop email
uiduname INDEX None Edit Drop uid
uname
unamepass INDEX None Edit Drop uname
pass

------------------


j'attends votre aide et merci.