Semi pro
Inscrit: 12/03/2006 17:12
De Besançon
|
La solution décrite par Mage fonctionne pour une installation chez Infomaniak. Avant installation il faut modifier mid par `mid`, dans le fichier htdocs ----> install ----> sql ----> mysql.structure.sql , comme décrit dans ( Table structure for table `modules` ) et dans ( Table structure for table `newblocks` ) ci - dessous.
Merci pour cette solution fournie par Mage il y a presque 1 an. # --------------------------------------------------------
# # Table structure for table `modules` #
CREATE TABLE modules ( `mid` smallint(5) unsigned NOT NULL auto_increment, name varchar(150) NOT NULL default '', version smallint(5) unsigned NOT NULL default '100', last_update int(10) unsigned NOT NULL default '0', weight smallint(3) unsigned NOT NULL default '0', isactive tinyint(1) unsigned NOT NULL default '0', dirname varchar(25) NOT NULL default '', hasmain tinyint(1) unsigned NOT NULL default '0', hasadmin tinyint(1) unsigned NOT NULL default '0', hassearch tinyint(1) unsigned NOT NULL default '0', hasconfig tinyint(1) unsigned NOT NULL default '0', hascomments tinyint(1) unsigned NOT NULL default '0', hasnotification tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (mid), KEY hasmain (hasmain), KEY hasadmin (hasadmin), KEY hassearch (hassearch), KEY hasnotification (hasnotification), KEY dirname (dirname), KEY name (name(15)), KEY isactive (isactive), KEY weight (weight), KEY hascomments (hascomments) ) ENGINE=MyISAM; # --------------------------------------------------------
# # Table structure for table `newblocks` #
CREATE TABLE newblocks ( bid mediumint(8) unsigned NOT NULL auto_increment, `mid` smallint(5) unsigned NOT NULL default '0', func_num tinyint(3) unsigned NOT NULL default '0', options varchar(255) NOT NULL default '', name varchar(150) NOT NULL default '', title varchar(255) NOT NULL default '', content text, side tinyint(1) unsigned NOT NULL default '0', weight smallint(5) unsigned NOT NULL default '0', visible tinyint(1) unsigned NOT NULL default '0', block_type char(1) NOT NULL default '', c_type char(1) NOT NULL default '', isactive tinyint(1) unsigned NOT NULL default '0', dirname varchar(50) NOT NULL default '', func_file varchar(50) NOT NULL default '', show_func varchar(50) NOT NULL default '', edit_func varchar(50) NOT NULL default '', template varchar(50) NOT NULL default '', bcachetime int(10) unsigned NOT NULL default '0', last_modified int(10) unsigned NOT NULL default '0', PRIMARY KEY (bid), KEY `mid` (`mid`), KEY visible (visible), KEY isactive_visible_mid (isactive,visible,`mid`), KEY mid_funcnum (`mid`,func_num) ) ENGINE=MyISAM; # --------------------------------------------------------
Posté le : 29/08/2020 18:12
|