phpBB-fr.com

[jeremyto]

salut, j'ai aussi remarqué que tous les nouveaux inscrits depuis la période de la mise en place du domaine, leur nombres de messages sont à 0 !

Personne ne peux m'aider ? c'est urgent et je peux meme pas passer en phpbb3 sans perdre tous ces nouveaux messages

[jeremyto]

Bonsoir,

Quelques précisions quant à l'installation de notre "domaine". Auparavant, notre forum était hébergé chez free, puis il a été migré chez OVH. C'est à partir de cette migration que les problèmes ont commencé à apparaitre.

J'ai regardé dans la base de données pour isoler les topics à problèmes. J'ai pu constater que des topics ont le champ topic_views à NULL

De la même manière, j'ai trouvé des utilisateurs dans la table phpbb_users pour lesquels le champ user_posts est à null, idem pour les champs user_new_privmsg user_unread_privmsg et user_last_privmsg (entre autres)

J'ai l'impression que les contraintes SQL de type NOT NULL et DEFAULT ont été zappées lors du dump SQL pour le passage de free à OVH.
=> Est-ce que c'est effectivement le cas ?
=> Si oui, connaissez-vous un moyen de rétablir toutes les contraintes d'intégrité de la base ?
=> Le must : toujours en partant du principe que ces valeurs sont incorrectes pour phpBB, il est possible que l'import dans phpBB3 ne se fasse pas pour les mêmes raisons (si la base phpBB3 a des contraintes NOT NULL, je suppose que le script d'import "passe" les lignes erronnées). Connaissez-vous une page qui récapitule le script de création d'une base de données phpBB2 ? Si oui, je peux essayer de remettre des valeurs correctes à la place des NULLs et tenter un nouvel import vers phpBB3...

merci pour vos conseils

[jeremyto]

toujours pas de réponse et ça deviens urgent là s'il vous plait :s je n'ai pas envi de passer en phpbb3 et de perdre plein de posts

[jeremyto]

probleme résolu avec ça :

Code: Tout sélectionner

ALTER TABLE `phpbb_auth_access` CHANGE `group_id` `group_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `forum_id` `forum_id` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_view` `auth_view` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_read` `auth_read` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_post` `auth_post` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_reply` `auth_reply` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_edit` `auth_edit` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_delete` `auth_delete` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_sticky` `auth_sticky` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_announce` `auth_announce` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_vote` `auth_vote` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_pollcreate` `auth_pollcreate` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_attachments` `auth_attachments` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_mod` `auth_mod` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_ban` `auth_ban` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_greencard` `auth_greencard` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_auth_access` CHANGE `auth_bluecard` `auth_bluecard` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_banlist` CHANGE `ban_userid` `ban_userid` mediumint(8) NOT NULL;
ALTER TABLE `phpbb_banlist` CHANGE `ban_ip` `ban_ip` char(8) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_categories` CHANGE `cat_order` `cat_order` mediumint(8) unsigned NOT NULL;
ALTER TABLE `phpbb_config` CHANGE `config_name` `config_name` varchar(255) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_config` CHANGE `config_value` `config_value` varchar(255) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_confirm` CHANGE `confirm_id` `confirm_id` char(32) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_confirm` CHANGE `session_id` `session_id` char(32) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_confirm` CHANGE `code` `code` char(6) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_disallow` CHANGE `disallow_username` `disallow_username` varchar(25) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_forums` CHANGE `forum_id` `forum_id` smallint(5) unsigned NOT NULL;
ALTER TABLE `phpbb_forums` CHANGE `cat_id` `cat_id` mediumint(8) unsigned NOT NULL;
ALTER TABLE `phpbb_forums` CHANGE `forum_status` `forum_status` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `forum_order` `forum_order` mediumint(8) unsigned NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_forums` CHANGE `forum_posts` `forum_posts` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `forum_topics` `forum_topics` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `forum_last_post_id` `forum_last_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `prune_enable` `prune_enable` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_view` `auth_view` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_read` `auth_read` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_post` `auth_post` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_reply` `auth_reply` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_edit` `auth_edit` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_delete` `auth_delete` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_sticky` `auth_sticky` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_announce` `auth_announce` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_vote` `auth_vote` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_pollcreate` `auth_pollcreate` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_attachments` `auth_attachments` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` CHANGE `auth_ban` `auth_ban` tinyint(2) NOT NULL DEFAULT '3';
ALTER TABLE `phpbb_forums` CHANGE `auth_greencard` `auth_greencard` tinyint(2) NOT NULL DEFAULT '5';
ALTER TABLE `phpbb_forums` CHANGE `auth_bluecard` `auth_bluecard` tinyint(2) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_forum_prune` CHANGE `forum_id` `forum_id` smallint(5) unsigned NOT NULL;
ALTER TABLE `phpbb_forum_prune` CHANGE `prune_days` `prune_days` smallint(5) unsigned NOT NULL;
ALTER TABLE `phpbb_forum_prune` CHANGE `prune_freq` `prune_freq` smallint(5) unsigned NOT NULL;
ALTER TABLE `phpbb_groups` CHANGE `group_type` `group_type` tinyint(4) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_groups` CHANGE `group_name` `group_name` varchar(40) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_groups` CHANGE `group_description` `group_description` varchar(255) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_groups` CHANGE `group_moderator` `group_moderator` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_groups` CHANGE `group_single_user` `group_single_user` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_posts` CHANGE `topic_id` `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` CHANGE `forum_id` `forum_id` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` CHANGE `poster_id` `poster_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` CHANGE `post_time` `post_time` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` CHANGE `poster_ip` `poster_ip` char(8) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_posts` CHANGE `enable_bbcode` `enable_bbcode` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_posts` CHANGE `enable_html` `enable_html` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts` CHANGE `enable_smilies` `enable_smilies` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_posts` CHANGE `enable_sig` `enable_sig` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_posts` CHANGE `post_edit_count` `post_edit_count` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts_text` CHANGE `post_id` `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_posts_text` CHANGE `bbcode_uid` `bbcode_uid` char(10) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_type` `privmsgs_type` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_subject` `privmsgs_subject` varchar(255) collate latin1_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_from_userid` `privmsgs_from_userid` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_to_userid` `privmsgs_to_userid` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_date` `privmsgs_date` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_ip` `privmsgs_ip` char(8) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_enable_bbcode` `privmsgs_enable_bbcode` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_enable_html` `privmsgs_enable_html` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_enable_smilies` `privmsgs_enable_smilies` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_privmsgs` CHANGE `privmsgs_attach_sig` `privmsgs_attach_sig` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_privmsgs_text` CHANGE `privmsgs_text_id` `privmsgs_text_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_privmsgs_text` CHANGE `privmsgs_bbcode_uid` `privmsgs_bbcode_uid` char(10) collate latin1_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_ranks` CHANGE `rank_title` `rank_title` varchar(50) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_ranks` CHANGE `rank_min` `rank_min` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_results` CHANGE `search_id` `search_id` int(11) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_results` CHANGE `session_id` `session_id` char(32) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_search_results` CHANGE `search_time` `search_time` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_results` CHANGE `search_array` `search_array` text collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_search_wordlist` CHANGE `word_text` `word_text` varchar(50) character set latin1 collate latin1_bin NOT NULL DEFAULT '';
ALTER TABLE `phpbb_search_wordlist` CHANGE `word_common` `word_common` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_wordmatch` CHANGE `post_id` `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_wordmatch` CHANGE `word_id` `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_search_wordmatch` CHANGE `title_match` `title_match` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_id` `session_id` char(32) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_sessions` CHANGE `session_user_id` `session_user_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_start` `session_start` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_time` `session_time` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_ip` `session_ip` char(8) collate latin1_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_page` `session_page` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_logged_in` `session_logged_in` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions` CHANGE `session_admin` `session_admin` tinyint(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions_keys` CHANGE `key_id` `key_id` varchar(32) collate latin1_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions_keys` CHANGE `user_id` `user_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions_keys` CHANGE `last_ip` `last_ip` varchar(8) collate latin1_general_ci NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_sessions_keys` CHANGE `last_login` `last_login` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_themes` CHANGE `template_name` `template_name` varchar(30) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_themes` CHANGE `style_name` `style_name` varchar(30) collate latin1_general_ci NOT NULL DEFAULT '';
ALTER TABLE `phpbb_themes_name` CHANGE `themes_id` `themes_id` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `forum_id` `forum_id` smallint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_title` `topic_title` char(60) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_topics` CHANGE `topic_poster` `topic_poster` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_time` `topic_time` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_views` `topic_views` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_replies` `topic_replies` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_status` `topic_status` tinyint(3) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_vote` `topic_vote` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_type` `topic_type` tinyint(3) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_first_post_id` `topic_first_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_last_post_id` `topic_last_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics` CHANGE `topic_moved_id` `topic_moved_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics_watch` CHANGE `topic_id` `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics_watch` CHANGE `user_id` `user_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_topics_watch` CHANGE `notify_status` `notify_status` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_id` `user_id` mediumint(8) NOT NULL;
ALTER TABLE `phpbb_users` CHANGE `username` `username` varchar(25) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_users` CHANGE `user_password` `user_password` varchar(32) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_users` CHANGE `user_session_time` `user_session_time` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_session_page` `user_session_page` smallint(5) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_lastvisit` `user_lastvisit` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_regdate` `user_regdate` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_posts` `user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_timezone` `user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00';
ALTER TABLE `phpbb_users` CHANGE `user_dateformat` `user_dateformat` varchar(14) collate latin1_general_ci NOT NULL DEFAULT 'd M Y H:i';
ALTER TABLE `phpbb_users` CHANGE `user_new_privmsg` `user_new_privmsg` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_unread_privmsg` `user_unread_privmsg` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_last_privmsg` `user_last_privmsg` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_login_tries` `user_login_tries` smallint(5) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_last_login_try` `user_last_login_try` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_allowavatar` `user_allowavatar` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_users` CHANGE `user_allow_pm` `user_allow_pm` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_users` CHANGE `user_allow_viewonline` `user_allow_viewonline` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_users` CHANGE `user_notify` `user_notify` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `phpbb_users` CHANGE `user_notify_pm` `user_notify_pm` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_popup_pm` `user_popup_pm` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_avatar_type` `user_avatar_type` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_trombine` `user_trombine` varchar(255) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_users` CHANGE `user_allow_view_trombine` `user_allow_view_trombine` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_users` CHANGE `user_inactive_emls` `user_inactive_emls` tinyint(1) NOT NULL;
ALTER TABLE `phpbb_users` CHANGE `user_inactive_last_eml` `user_inactive_last_eml` int(11) NOT NULL;
ALTER TABLE `phpbb_user_group` CHANGE `group_id` `group_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_user_group` CHANGE `user_id` `user_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_desc` CHANGE `topic_id` `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_desc` CHANGE `vote_text` `vote_text` text collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_vote_desc` CHANGE `vote_start` `vote_start` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_desc` CHANGE `vote_length` `vote_length` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_results` CHANGE `vote_id` `vote_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_results` CHANGE `vote_option_id` `vote_option_id` tinyint(4) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_results` CHANGE `vote_option_text` `vote_option_text` varchar(255) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_vote_results` CHANGE `vote_result` `vote_result` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_voters` CHANGE `vote_id` `vote_id` mediumint(8) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_voters` CHANGE `vote_user_id` `vote_user_id` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_vote_voters` CHANGE `vote_user_ip` `vote_user_ip` char(8) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_words` CHANGE `word` `word` char(100) collate latin1_general_ci NOT NULL;
ALTER TABLE `phpbb_words` CHANGE `replacement` `replacement` char(100) collate latin1_general_ci NOT NULL;


[mathieu23]

Bonjour jeremyto,

C'est désormais la coche que tu dois ajouter en éditant ton premier message pour signaler que le sujet est réglé et non plus mettre la mention [Réglé] ou [Résolu] dans le titre.

Je l'ai fait pour toi.

Bonne journée et à bientôt