Régulier  
Inscrit: 07/10/2004 07:35
|
Bonjour,
J'ai un problème avec la mise à jour et l'installation de nouveaux modules. Les modules apparaissent bien dans la liste mais lorque je demande installation ou mise à jour, la liste des modules réapparait sans affichage des informations de mises à jour. Je ne peux pas non plus désinstaller de module.
Il m'est aussi impossible de modifier les préférences du site (module système/préférence), lorsque je valide les modifications, j'ai une page blanche qui apparait !
J'ai donc mis en debug directement dans la table xoops_config et je n'ai apparemment aucune anomalie php. En sql, j'obtiens ceci:
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 = 'ddf37d418fce2fc6833dc6f0ab7f8f14'
SELECT * FROM xoops_users WHERE uid=5
SELECT * FROM xoops_modules WHERE dirname = 'system'
DELETE FROM xoops_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM xoops_protector_access WHERE ip='83.205.136.125' AND request_uri='/modules/system/admin.php'
SELECT COUNT(*) FROM xoops_protector_access WHERE ip='83.205.136.125'
INSERT INTO xoops_protector_access SET ip='83.205.136.125',request_uri='/modules/system/admin.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5' OR gperm_groupid = '10'))
SELECT * FROM xoops_modules
SELECT * FROM xoops_modules WHERE dirname = 'edito'
SELECT * FROM xoops_config WHERE (conf_modid = '9') ORDER BY conf_order ASC
SELECT Id_content, subject, groups FROM xoops_edito WHERE offline = 1 AND contents_nomain = 1 ORDER BY subject ASC
SELECT * FROM xoops_wfs_config
SELECT * FROM xoops_modules WHERE dirname = 'wfsection'
SELECT * FROM xoops_config WHERE (conf_modid = '11') ORDER BY conf_order ASC
SELECT * FROM xoops_wfs_templates
SELECT * FROM xoops_wfs_mainmenu
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=2
SELECT * FROM xoops_wfs_category WHERE id=2
SELECT id FROM xoops_wfs_category WHERE pid= 2
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=10
SELECT * FROM xoops_wfs_category WHERE id=10
SELECT id FROM xoops_wfs_category WHERE pid= 10
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=1
SELECT * FROM xoops_wfs_category WHERE id=1
SELECT id FROM xoops_wfs_category WHERE pid= 1
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=9
SELECT * FROM xoops_wfs_category WHERE id=9
SELECT id FROM xoops_wfs_category WHERE pid= 9
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=3
SELECT * FROM xoops_wfs_category WHERE id=3
SELECT id FROM xoops_wfs_category WHERE pid= 3
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=6
SELECT * FROM xoops_wfs_category WHERE id=6
SELECT id FROM xoops_wfs_category WHERE pid= 6
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=8
SELECT * FROM xoops_wfs_category WHERE id=8
SELECT id FROM xoops_wfs_category WHERE pid= 8
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=7
SELECT * FROM xoops_wfs_category WHERE id=7
SELECT id FROM xoops_wfs_category WHERE pid= 7
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=5
SELECT * FROM xoops_wfs_category WHERE id=5
SELECT id FROM xoops_wfs_category WHERE pid= 5
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=11
SELECT * FROM xoops_wfs_category WHERE id=11
SELECT id FROM xoops_wfs_category WHERE pid= 11
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=12
SELECT * FROM xoops_wfs_category WHERE id=12
SELECT id FROM xoops_wfs_category WHERE pid= 12
SELECT * FROM xoops_wfs_article where (published > 0 AND published <= 1125761516) AND (expired = 0 OR expired > 1125761516) AND noshowart = 0 AND offline = '0' and spotlight = 0 and categoryid=13
SELECT * FROM xoops_wfs_category WHERE id=13
SELECT id FROM xoops_wfs_category WHERE pid= 13
SELECT * FROM xoops_groups
SELECT * FROM xoops_modules WHERE dirname = 'news'
SELECT * FROM xoops_modules WHERE dirname = 'wfdownloads'
SELECT COUNT(*) FROM xoops_catads_ads WHERE uid = '5'
SELECT * FROM xoops_groups
SELECT gperm_itemid FROM xoops_group_permission WHERE gperm_modid='' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2,4,5,10))
SELECT gperm_itemid FROM xoops_group_permission WHERE gperm_modid='' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2,4,5,10))
SELECT categoryID, name FROM xoops_wbcategories
SELECT * FROM xoops_modules WHERE dirname = 'wordbook'
SELECT * FROM xoops_config WHERE (conf_modid = '48') ORDER BY conf_order ASC
SELECT * FROM xoops_modules WHERE dirname = 'wflinks'
SELECT * FROM xoops_modules WHERE dirname = 'wfchannel'
SELECT CID, pagetitle, defaultpage FROM xoops_wfschannel WHERE defaultpage = '0' AND submenu = 1 AND (publishdate > 0 AND publishdate <= 1125761517) AND (expiredate = 0 OR expiredate > 1125761517) ORDER BY weight
Error number: 1146
Error message: Table 'cucrugby.xoops_wfschannel' doesn't exist
SELECT * FROM xoops_groups
Il y a une erreur sql concernant une table qui n'existe pas (elle doit appartenir au module WF channel et je n'ai pas ce module installé sur le site !).
Cette erreur sql peut-elle être la cause de tout le reste ?
Merci pour votre aide
Posté le : 03/09/2005 17:27
Edité par lachouette sur 03/09/2005 17:35:47
Edité par lachouette sur 03/09/2005 17:36:56
Edité par lachouette sur 03/09/2005 17:38:12
|
