Impossible d'installer Edito | Titre du sujet : Impossible d'installer Edito par olico sur 07/09/2006 18:38:23
Bonjour, je viens d'installer Xoops 2.0.15 et je ne parviens pas à installer Edito 2.45 (bien qu'il soit affiché 2.44 dans le gestionnaire de modules de mon site). Il semble qu'il y ait une erreur avec MySQL, la version que j'ai installée correspond à celle de mon hébergeur. Merci de l'attention que vous porterez à ce problème.
Voici l'erreur affichée : Installing Edito Too big column length for column 'meta_title' (max = 255). Use BLOB instead Impossible d'installer edito. Erreur(s) :
et voici le code du mode debug : SELECT * FROM site_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data FROM site_session WHERE sess_id = '41bd482f560fde5854cd5dcfdf3c7995' SELECT * FROM site_users WHERE uid=1 SELECT * FROM site_modules WHERE dirname = 'system' SELECT COUNT(*) FROM site_modules WHERE dirname = 'edito' SELECT * FROM site_modules WHERE dirname = 'edito' SELECT id, pid, subject, groups FROM site_edito WHERE offline = 1 AND nomain = 1 ORDER BY Error number: 1064 Error message: 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 * FROM site_groups CREATE TABLE site_edito ( id int(11) NOT NULL auto_increment, pid int(11) unsigned default '0', uid int(6) unsigned default '1', datesub int(11) unsigned NOT NULL default '1033141070', subject varchar(255) default NULL, meta_title varchar(512) default NULL, meta_keywords varchar(512) default NULL, meta_description varchar(512) default NULL, informations text, nohtml tinyint(1) unsigned default '0', nosmiley tinyint(1) unsigned default '0', noxcode tinyint(1) unsigned default '0', notitle tinyint(1) unsigned default '0', nologo tinyint(1) unsigned default '0', nomain tinyint(1) unsigned default '0', noblock tinyint(1) unsigned default '0', counter int(8) unsigned default '0', offline int(11) unsigned default NULL, comments int(11) unsigned default '0', cancomment tinyint(1) unsigned default '1', artimage varchar(255) NOT NULL default 'blank.gif', groups varchar(255) NOT NULL default '', hidden tinyint(1) unsigned default '0', PRIMARY KEY (id) ) TYPE=MyISAM Error number: 1074 Error message: Too big column length for column 'meta_title' (max = 255). Use BLOB instead SELECT * FROM site_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC SELECT * FROM site_groups SELECT m.name,m.dirname FROM site_modules m LEFT JOIN site_tplfile t ON m.dirname=t.tpl_module WHERE m.isactive GROUP BY t.tpl_module ORDER BY m.weight,m.mid SELECT * FROM site_modules WHERE dirname = 'news' SELECT * FROM site_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
et voici les spécifications de mon installation : Url du site : http://localhost Version de Xoops : XOOPS 2.0.15 Thème Xoops : xhtml Jeu de templates : default Version PHP : 4.4.1 Version MySQL : 4.0.27-standard-log Logiciel serveur : Apache/1.3.33 (Darwin) PHP/4.4.1 Statut safe mode : OFF Register Globals : OFF Navigateur : Mozilla/5.0 (Macintosh; U; PPC Mac OS X; fr) AppleWebKit/418.8 (KHTML, like Gecko) Safari/419.3 Support librairie GD : Désactivé (vignettes non disponibles) Statut d'upload du serveur : ON Taille maximum d'upload autorisée : 2M
-- olivier
|
|