| Re: Pb connection avec login |
Titre du sujet : Re: Pb connection avec login
par Anonyme sur 20/04/2007 13:24:52
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.
|
|
