J'aimodifie dans la bdd, le post et le post_text, à savoir :
dans mon ancien site j'avais :
Structure de la table `xoops_bb_posts`
--
CREATE TABLE `xoops_bb_posts` (
`post_id` int(8) unsigned NOT NULL auto_increment,
`pid` int(8) NOT NULL default '0',
`topic_id` int(8) NOT NULL default '0',
`forum_id` int(4) NOT NULL default '0',
`post_time` int(10) NOT NULL default '0',
`uid` int(5) unsigned NOT NULL default '0',
`poster_name` varchar(255) default NULL,
`poster_ip` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`dohtml` tinyint(1) NOT NULL default '0',
`dosmiley` tinyint(1) NOT NULL default '1',
`doxcode` tinyint(1) NOT NULL default '1',
`dobr` tinyint(1) NOT NULL default '1',
`doimage` tinyint(1) NOT NULL default '1',
`icon` varchar(25) NOT NULL default '',
`attachsig` tinyint(1) NOT NULL default '0',
`approved` int(1) NOT NULL default '1',
`post_karma` int(10) NOT NULL default '0',
`attachment` text,
`require_reply` int(1) NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `uid` (`uid`),
KEY `pid` (`pid`),
KEY `subject` (`subject`(40)),
KEY `forumid_uid` (`forum_id`,`uid`),
KEY `topicid_uid` (`topic_id`,`uid`),
KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
FULLTEXT KEY `search` (`subject`)
) TYPE=MyISAM AUTO_INCREMENT=648 ;
que j'ai modifié en :
Structure de la table `prefix_bb_posts`
--
CREATE TABLE IF NOT EXISTS `prefix_bb_posts` (
`post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`topic_id` int(8) unsigned NOT NULL DEFAULT '0',
`forum_id` smallint(4) unsigned NOT NULL DEFAULT '0',
`post_time` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`poster_name` varchar(255) NOT NULL DEFAULT '',
`poster_ip` int(11) NOT NULL DEFAULT '0',
`subject` varchar(255) NOT NULL DEFAULT '',
`dohtml` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dosmiley` tinyint(1) unsigned NOT NULL DEFAULT '1',
`doxcode` tinyint(1) unsigned NOT NULL DEFAULT '1',
`dobr` tinyint(1) unsigned NOT NULL DEFAULT '1',
`doimage` tinyint(1) unsigned NOT NULL DEFAULT '1',
`icon` varchar(25) NOT NULL DEFAULT '',
`attachsig` tinyint(1) unsigned NOT NULL DEFAULT '0',
`approved` smallint(2) NOT NULL DEFAULT '1',
`post_karma` int(10) unsigned NOT NULL DEFAULT '0',
`attachment` text,
`require_reply` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`post_id`),
KEY `uid` (`uid`),
KEY `pid` (`pid`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `subject` (`subject`(40)),
KEY `forumid_uid` (`forum_id`,`uid`),
KEY `topicid_uid` (`topic_id`,`uid`),
KEY `post_time` (`post_time`),
KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
FULLTEXT KEY `search` (`subject`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8
et la table posts_text :
-- Structure de la table `xoops_bb_posts_text`
--
CREATE TABLE `xoops_bb_posts_text` (
`post_id` int(8) unsigned NOT NULL auto_increment,
`post_text` text,
`post_edit` text NOT NULL,
PRIMARY KEY (`post_id`),
FULLTEXT KEY `search` (`post_text`)
) TYPE=MyISAM AUTO_INCREMENT=648 ;
que j'ai modifié en :
-- Structure de la table `prefix_bb_posts_text`
--
CREATE TABLE IF NOT EXISTS `prefix_bb_posts_text` (
`post_id` int(10) unsigned NOT NULL DEFAULT '0',
`post_text` text,
`post_edit` text,
PRIMARY KEY (`post_id`),
FULLTEXT KEY `search` (`post_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
les importations sont ok
sauf le total à 0, sur la page index.php du forum.
merci de ton aide
celine
edit : montuy337513 : mise en forme du code et masquage des préfixes des nouvelles tables (questions de sécurité)