Erreurs archivées
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Suite à un changement d'hébergeur, nous avons eu des erreurs fatales avec le module article et une autre erreur de connexion à la BDD.
Nous sommes passé d'un hébergeur à un autre hébergeur, et pour le moment nous avons du modifier les zones DNS de notre ancien registrar vers ceux de notre nouvel hébergeur pour le NDD.
Le transfert du site c'est bien passé, ainsi que l'utilisation du NDD avec notre nouvel hébergeur. Par contre nous avons eu des erreurs sur le module article que nous ne pouvons plus utilisé.
Voici l'erreur fatale :
Fatale : invalid query. (ERRNO 1104) The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okayquery: SELECT articles.*, member.*, com.number_comments, notes.average_notes, notes.number_notes, note.note
FROM phpboost_articles articles
LEFT JOIN phpboost_member member ON member.user_id = articles.author_user_id
LEFT JOIN phpboost_comments_topic com ON com.id_in_module = articles.id AND com.module_id = 'articles'
LEFT JOIN phpboost_average_notes notes ON notes.id_in_module = articles.id AND notes.module_name = 'articles'
LEFT JOIN phpboost_note note ON note.id_in_module = articles.id AND note.module_name = 'articles' AND note.user_id = 90
WHERE id_category = '0'
AND (published = 1 OR (published = 2 AND publishing_start_date < 1415222663 AND (publishing_end_date > 1415222663 OR publishing_end_date = 0)))
ORDER BY date_created DESC
LIMIT 10 OFFSET 0
[0] /kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php:48 - MySQLQuerier->execute(string, array)
[1] /kernel/framework/io/db/DBQuerier.class.php:50 - MySQLQuerier->select(string, array, int)
[2] /articles/controllers/ArticlesDisplayCategoryController.class.php:112 - DBQuerier->select(string, array)
[3] /articles/controllers/ArticlesDisplayCategoryController.class.php:62 - ArticlesDisplayCategoryController->build_articles_listing_view(Date, string, string)
[4] /articles/controllers/ArticlesDisplayCategoryController.class.php:42 - ArticlesDisplayCategoryController->build_view()
[5] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:87 - ArticlesDisplayCategoryController->execute(HTTPRequestCustom)
[6] /kernel/framework/mvc/dispatcher/UrlControllerMapper.class.php:59 - UrlControllerMapper->do_call()
[7] /kernel/framework/mvc/dispatcher/Dispatcher.class.php:67 - UrlControllerMapper->call()
[8] /kernel/framework/mvc/dispatcher/DispatchManager.class.php:43 - Dispatcher->dispatch()
[9] /articles/index.php:63 - DispatchManager::dispatch(array)
[URL] /HD/articles/
Voici l'erreur d'avertissement :
Inconnue : can't connect to database!. (ERRNO 1045) Access denied for user 'hdvisionhd'@'10.42.2.99' (using password: NO)
#0 /flex/domain/hdvision.org/site/www/HD/kernel/framework/io/db/factory/DBFactory.class.php(90): MySQLDBConnection->connect(Array)
#1 /flex/domain/hdvision.org/site/www/HD/kernel/framework/core/environment/context/PersistenceContext.class.php(124): DBFactory::get_db_connection()
#2 /flex/domain/hdvision.org/site/www/HD/kernel/framework/core/environment/context/PersistenceContext.class.php(86): PersistenceContext::get_sql_querier()
#3 /flex/domain/hdvision.org/site/www/HD/kernel/framework/phpboost/member/Session.class.php(286): PersistenceContext::get_querier()
#4 /flex/domain/hdvision.org/site/www/HD/kernel/framework/core/environment/Environment.class.php(241): Session->load()
#5 /flex/domain/hdvision.org/site/www/HD/kernel/framework/core/environment/Environment.class.php(87): Environment::init_session()
#6 /flex/domain/hdvision.org/site/www/HD/kernel/framework/core/environment/Environment.class.php(65): Environment::try_init()
#7 /flex/domain/hdvision.org/site/www/HD/kernel/init.php(37): Environment::init()
#8 /flex/domain/hdvision.org/site/www/HD/kernel/begin.php(28): require_once('/flex/domain/hd...')
#9 /flex/domain/hdvision.org/site/www/HD/shoutbox/xmlhttprequest.php(28): require_once('/flex/domain/hd...')
#10 {main}
/flex/domain/hdvision.org/site/www/HD/kernel/framework/io/db/driver/mysql/MySQLDBConnection.class.php
Nous n'arrivons pas malheureusement à résoudre le problème du module article. Lorsque nous allons directement sur un article cela fonctionne correctement. Par contre dès que nous essayons d'afficher la page http://www.site.com/articles/ cela nous renvoie ce message "Sorry, we encountered a problem and we cannot complete your request..."
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
pour cette erreur :
Citation :
Inconnue : can't connect to database!. (ERRNO 1045) Access denied for user 'hdvisionhd'@'10.42.2.99' (using password: NO)
c'est clairement écrit que vous n'avez pas spécifié de mot de passe donc l'accès est refusé, là c'est une erreur de correction des logins lors du transfert.
Pour l'autre erreur faudrait la remonter dans le bugtracker.
Cordialement, janus57
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Pour l'erreur fatale, je vais créer un rapport de bug, mais je pense que cela est du à notre transfert de site car cela ne le faisait pas avant.
Cordialement,
Edit : lien du bug déclaré dans bugtracker http://www.phpboost.com/bugtracker/detail/1195-erreur-fatale-module-articles
Édité par BigBud13 Le 06/11/2014 à 18h03
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
BigBud13 :Ok pour la première erreur de login.
Pour l'erreur fatale, je vais créer un rapport de bug, mais je pense que cela est du à notre transfert de site car cela ne le faisait pas avant.
Cordialement,
Edit : lien du bug déclaré dans bugtracker http://www.phpboost.com/bugtracker/detail/1195-erreur-fatale-module-articles
Bonjour,
vérifier que vous n'avez pas modifié quelque chose qu'il ne fallait pas dans le fichier de configuration qui pourrais gêner les requêtes PHPBoost.
De plus comment avait vous transférer la BDD, via backup au niveau du site ou de phpMyAdmin ?
Cordialement, janus57
Édité par janus57 Le 06/11/2014 à 18h12
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
je vais vérifier que la configuration des articles n'as pas été modifié, et je vais regarder les valeurs dans la BDD.
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Sur l'ancien hebergement qui était un site en phpboost v3 et qui a été transforme en v4.1 a la sortie de la nouvelle version de phpboost sans soucis particulier, j'ai donc :
La table phpboost_configs
Avec une entrée "articles"
Et sur le nouvel hebergement qui est un site phpboost v4.1 (install propre puis importation de la BDD par phpmyadmin) j'ai :
La table phpboost_configs
Avec une entrée "articles-configs"
Le contenu des entrées de la table phpboost_configs ne sont pas du tout identiques. Car lorsque j'ai importe la BDD de l'ancien hebergement sur le nouveau hebergement je n'ai pas importe la table phpboost_configs pour ne pas devoir reconfigurer certains paramètres kernel.
Je pense qu'il y a une différence entre les entrée de la table phpboost_configs lorsque l'on fait une mise a jour de phpboost v3 a v4 et une fresh install de phpboost v4.
Édité par BigBud13 Le 06/11/2014 à 22h05
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
V3 => V4.0 => V4.1 ?
Car V3 => V4.1 c'est pas possible ou alors vous étiez en 4.0 et non V4.1.
Dans tout les cas le mieux serait de tout réimporter et faire le changement d'url avec le script de migration.
Cordialement, janus57
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Lorsque j'ai dit v3 => v4.1 c'etait pour raccourcir, mais évidement il y a eu v3 => v4 => v4.1. Par contre la mise à jour de phpboost a été realise il y a un moment déjà sur l'ancien hebergeur.
Pourriez-vous me dire comment doit être constituer la table phpboost_configs ?
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
ce ne serait pas plus simple de restaurer entièrement la BDD comme elle était chez l'ancien hébergeur ?
Car là y peut être pas que le module articles de touché, donc autant faire une copie conforme entre l'ancien et le nouveau hébergeur.
Cordialement, janus57
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Lorsque j'essaye de faire un transfert du site de l'ancien hébergeur vers le nouveau hebergeur avec votre procédure de migration qui est dans la documentation, cela pose problème.
Voici les étapes réalisées :
- sauvegarde de la bdd de l'ancien site en passant par le module base de donnée de phpboost
- transferts des fichiers de l'ancien hébergement vers le nouvel hebergement
- envoie du fichier server_migration.php à la racine du nouveau site
- execution du script server_migration.php en changeant les bon paramètres
- aller dans le panneau d'administration du nouveau site pour restaurer la bdd (impossible d'y accéder car page blanche)
J'ai essayé de vider le cache du navigateur, j'ai modifier le fichier /kernel/db/config.php avec les valeurs de la nouvelle bdd cela donne rien.
Ais-je loupé un épisode ?
Édité par BigBud13 Le 08/11/2014 à 10h39
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
si vous avez sauvegardé la BDD via phpMyAdmin restauré là via phpMyAdmin et non phpboost.
vous transférer les fichiers, restaurer la BDD via phpMyAdmin et enfin vous utilisez le script de migrations, cela fonctionne car je l'ai déjà utilisé 3/4 fois.
Cordialement, janus57
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Après divers essai de restauration de la bd via phpmyadmin, le problème persiste.
J'ai donc restaurer table par table pour trouver le problème.
Le problème vient de la table phpboost_comments_topic. Dès que celle-ci est restauré, cela mets une erreur lorsque l'on accède à la page des articles : "Sorry, we encountered a problem and we cannot complete your request..."
Voici le contenu de la table :
Caché :
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Client : localhost
-- Généré le : Lun 10 Novembre 2014 à 08:21
-- Version du serveur : 5.5.34-MariaDB-cll-lve
-- Version de PHP : 5.4.23
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données : `.........`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_comments_topic`
--
CREATE TABLE IF NOT EXISTS `phpboost_comments_topic` (
`id_topic` int(11) NOT NULL AUTO_INCREMENT,
`module_id` varchar(255) NOT NULL DEFAULT '',
`topic_identifier` varchar(255) NOT NULL DEFAULT 'default',
`id_in_module` int(11) NOT NULL DEFAULT '0',
`is_locked` int(11) NOT NULL DEFAULT '0',
`number_comments` int(11) NOT NULL DEFAULT '0',
`path` varchar(255) NOT NULL,
PRIMARY KEY (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=253 ;
--
-- Contenu de la table `phpboost_comments_topic`
--
INSERT INTO `phpboost_comments_topic` (`id_topic`, `module_id`, `topic_identifier`, `id_in_module`, `is_locked`, `number_comments`, `path`) VALUES
(1, 'articles', 'default', 11, 0, 1, '/articles/articles.php?cat=0&id=11&com=0'),
(2, 'articles', 'default', 13, 0, 2, '/articles/articles.php?cat=0&id=13&com=0'),
(3, 'articles', 'default', 25, 0, 5, '/articles/articles.php?cat=0&id=25&com=0'),
(4, 'articles', 'default', 18, 0, 1, '/articles/articles.php?cat=0&id=18&com=0'),
(5, 'articles', 'default', 15, 0, 1, '/articles/articles.php?cat=0&id=15&com=0'),
(6, 'articles', 'default', 10, 0, 1, '/articles/articles.php?cat=0&id=10&com=0'),
(7, 'articles', 'default', 26, 0, 5, '/articles/articles.php?cat=0&id=26&com=0'),
(8, 'articles', 'default', 27, 0, 2, '/articles/articles.php?cat=0&id=27&com=0'),
(9, 'articles', 'default', 28, 0, 4, '/articles/articles.php?cat=0&id=28&com=0'),
(10, 'articles', 'default', 30, 0, 3, '/articles/articles.php?cat=0&id=30&com=0'),
(11, 'articles', 'default', 29, 0, 2, '/articles/articles.php?cat=0&id=29&com=0'),
(12, 'articles', 'default', 31, 0, 2, '/articles/articles.php?cat=0&id=31&com=0'),
(13, 'articles', 'default', 34, 0, 2, '/articles/articles.php?cat=0&id=34&com=0'),
(14, 'articles', 'default', 36, 0, 2, '/articles/articles.php?cat=0&id=36&com=0'),
(15, 'bugtracker', 'default', 1, 0, 1, '/bugtracker/?url=/detail/1-probleme-charset-module-discussion'),
(16, 'bugtracker', 'default', 3, 0, 1, '/bugtracker/?url=/detail/3-commentaires-developpes-par-defaut-sur-les-fiches-de-films'),
(17, 'bugtracker', 'default', 4, 0, 1, '/bugtracker/?url=/detail/4-validation-des-messages-shoutbox-avec-touche-enter'),
(18, 'bugtracker', 'default', 5, 0, 1, '/bugtracker/?url=/detail/5-smileys-dans-la-shoutbox'),
(19, 'articles', 'default', 38, 0, 9, '/articles/articles.php?cat=0&id=38&com=0'),
(20, 'bugtracker', 'default', 6, 0, 1, '/bugtracker/?url=/detail/6-affichage-smileys-shout'),
(21, 'bugtracker', 'default', 7, 0, 1, '/bugtracker/?url=/detail/7-clique-pseudo-shoutbox'),
(22, 'articles', 'default', 39, 0, 9, '/articles/articles.php?cat=0&id=39&com=0'),
(23, 'articles', 'default', 40, 0, 1, '/articles/articles.php?cat=0&id=40&com=0'),
(24, 'articles', 'default', 35, 0, 1, '/articles/articles.php?cat=0&id=35&com=0'),
(25, 'articles', 'default', 41, 0, 5, '/articles/articles.php?cat=0&id=41&com=0'),
(26, 'articles', 'default', 42, 0, 9, '/articles/articles.php?cat=0&id=42&com=0'),
(27, 'articles', 'default', 43, 0, 1, '/articles/articles.php?cat=0&id=43&com=0'),
(28, 'articles', 'default', 44, 0, 9, '/articles/articles.php?cat=0&id=44&com=0'),
(29, 'articles', 'default', 45, 0, 2, '/articles/articles.php?cat=0&id=45&com=0'),
(30, 'articles', 'default', 46, 0, 6, '/articles/articles.php?cat=0&id=46&com=0'),
(31, 'articles', 'default', 47, 0, 3, '/articles/articles.php?cat=0&id=47&com=0'),
(32, 'articles', 'default', 48, 0, 9, '/articles/articles.php?cat=0&id=48&com=0'),
(33, 'articles', 'default', 49, 0, 5, '/articles/articles.php?cat=0&id=49&com=0'),
(34, 'articles', 'default', 52, 0, 7, '/articles/articles.php?cat=0&id=52&com=0'),
(35, 'articles', 'default', 51, 0, 1, '/articles/articles.php?cat=0&id=51&com=0'),
(36, 'articles', 'default', 50, 0, 2, '/articles/articles.php?cat=0&id=50&com=0'),
(37, 'articles', 'default', 53, 0, 5, '/articles/articles.php?cat=0&id=53&com=0'),
(38, 'articles', 'default', 54, 0, 5, '/articles/articles.php?cat=0&id=54&com=0'),
(39, 'articles', 'default', 55, 0, 3, '/articles/articles.php?cat=0&id=55&com=0'),
(40, 'articles', 'default', 56, 0, 1, '/articles/articles.php?cat=0&id=56&com=0'),
(41, 'articles', 'default', 59, 0, 4, '/articles/articles.php?cat=0&id=59&com=0'),
(42, 'articles', 'default', 58, 0, 4, '/articles/articles.php?cat=0&id=58&com=0'),
(43, 'articles', 'default', 57, 0, 1, '/articles/articles.php?cat=0&id=57&com=0'),
(44, 'articles', 'default', 60, 0, 8, '/articles/articles.php?cat=0&id=60&com=0'),
(45, 'articles', 'default', 61, 0, 6, '/articles/articles.php?cat=0&id=61&com=0'),
(46, 'articles', 'default', 62, 0, 2, '/articles/articles.php?cat=0&id=62&com=0'),
(47, 'articles', 'default', 64, 0, 3, '/articles/articles.php?cat=0&id=64&com=0'),
(48, 'articles', 'default', 63, 0, 7, '/articles/articles.php?cat=0&id=63&com=0'),
(49, 'articles', 'default', 65, 0, 3, '/articles/articles.php?cat=0&id=65&com=0'),
(50, 'articles', 'default', 67, 0, 3, '/articles/articles.php?cat=0&id=67&com=0'),
(51, 'articles', 'default', 69, 0, 8, '/articles/articles.php?cat=0&id=69&com=0'),
(52, 'articles', 'default', 68, 0, 1, '/articles/articles.php?cat=0&id=68&com=0'),
(53, 'articles', 'default', 70, 0, 3, '/articles/articles.php?cat=0&id=70&com=0'),
(54, 'articles', 'default', 71, 0, 20, '/articles/articles.php?cat=0&id=71&com=0'),
(172, 'articles', 'default', 206, 0, 3, '/articles/articles.php?cat=0&id=206&com=0'),
(56, 'articles', 'default', 74, 0, 5, '/articles/articles.php?cat=0&id=74&com=0'),
(57, 'articles', 'default', 75, 0, 2, '/articles/articles.php?cat=0&id=75&com=0'),
(58, 'articles', 'default', 66, 0, 2, '/articles/articles.php?cat=0&id=66&com=0'),
(59, 'articles', 'default', 76, 0, 10, '/articles/articles.php?cat=0&id=76&com=0'),
(60, 'articles', 'default', 77, 0, 2, '/articles/articles.php?cat=0&id=77&com=0'),
(61, 'articles', 'default', 78, 0, 4, '/articles/articles.php?cat=0&id=78&com=0'),
(62, 'articles', 'default', 79, 0, 18, '/articles/articles.php?cat=0&id=79&com=0'),
(63, 'articles', 'default', 80, 0, 4, '/articles/articles.php?cat=0&id=80&com=0'),
(64, 'articles', 'default', 81, 0, 2, '/articles/articles.php?cat=0&id=81&com=0'),
(65, 'articles', 'default', 82, 0, 1, '/articles/articles.php?cat=0&id=82&com=0'),
(66, 'articles', 'default', 83, 0, 11, '/articles/articles.php?cat=0&id=83&com=0'),
(67, 'articles', 'default', 86, 0, 1, '/articles/articles.php?cat=0&id=86&com=0'),
(68, 'articles', 'default', 87, 0, 4, '/articles/articles.php?cat=0&id=87&com=0'),
(69, 'articles', 'default', 84, 0, 1, '/articles/articles.php?cat=0&id=84&com=0'),
(70, 'articles', 'default', 88, 0, 2, '/articles/articles.php?cat=0&id=88&com=0'),
(71, 'articles', 'default', 73, 0, 3, '/articles/articles.php?cat=0&id=73&com=0'),
(72, 'articles', 'default', 90, 0, 3, '/articles/articles.php?cat=0&id=90&com=0'),
(73, 'articles', 'default', 93, 0, 7, '/articles/articles.php?cat=0&id=93&com=0'),
(74, 'articles', 'default', 96, 0, 6, '/articles/articles.php?cat=0&id=96&com=0'),
(75, 'articles', 'default', 94, 0, 2, '/articles/articles.php?cat=0&id=94&com=0'),
(76, 'articles', 'default', 91, 0, 2, '/articles/articles.php?cat=0&id=91&com=0'),
(77, 'articles', 'default', 97, 0, 6, '/articles/articles.php?cat=0&id=97&com=0'),
(78, 'articles', 'default', 98, 0, 4, '/articles/articles.php?cat=0&id=98&com=0'),
(79, 'articles', 'default', 100, 0, 3, '/articles/articles.php?cat=0&id=100&com=0'),
(80, 'articles', 'default', 101, 0, 5, '/articles/articles.php?cat=0&id=101&com=0'),
(81, 'articles', 'default', 102, 0, 7, '/articles/articles.php?cat=0&id=102&com=0'),
(82, 'articles', 'default', 103, 0, 3, '/articles/articles.php?cat=0&id=103&com=0'),
(83, 'articles', 'default', 104, 0, 4, '/articles/articles.php?cat=0&id=104&com=0'),
(84, 'articles', 'default', 105, 0, 5, '/articles/articles.php?cat=0&id=105&com=0'),
(85, 'articles', 'default', 107, 0, 1, '/articles/articles.php?cat=0&id=107&com=0'),
(86, 'articles', 'default', 108, 0, 11, '/articles/articles.php?cat=0&id=108&com=0'),
(87, 'articles', 'default', 109, 0, 8, '/articles/articles.php?cat=0&id=109&com=0'),
(88, 'articles', 'default', 110, 0, 1, '/articles/articles.php?cat=0&id=110&com=0'),
(89, 'articles', 'default', 111, 0, 1, '/articles/articles.php?cat=0&id=111&com=0'),
(90, 'articles', 'default', 113, 0, 7, '/articles/articles.php?cat=0&id=113&com=0'),
(91, 'articles', 'default', 112, 0, 2, '/articles/articles.php?cat=0&id=112&com=0'),
(92, 'articles', 'default', 115, 0, 3, '/articles/articles.php?cat=0&id=115&com=0'),
(93, 'articles', 'default', 114, 0, 3, '/articles/articles.php?cat=0&id=114&com=0'),
(94, 'articles', 'default', 117, 0, 1, '/articles/articles.php?cat=0&id=117&com=0'),
(95, 'articles', 'default', 121, 0, 3, '/articles/articles.php?cat=0&id=121&com=0'),
(96, 'articles', 'default', 119, 0, 2, '/articles/articles.php?cat=0&id=119&com=0'),
(97, 'articles', 'default', 116, 0, 1, '/articles/articles.php?cat=0&id=116&com=0'),
(98, 'articles', 'default', 122, 0, 6, '/articles/articles.php?cat=0&id=122&com=0'),
(99, 'articles', 'default', 123, 0, 9, '/articles/articles.php?cat=0&id=123&com=0'),
(100, 'articles', 'default', 124, 0, 2, '/articles/articles.php?cat=0&id=124&com=0'),
(101, 'articles', 'default', 125, 0, 1, '/articles/articles.php?cat=0&id=125&com=0'),
(102, 'articles', 'default', 127, 0, 2, '/articles/articles.php?cat=0&id=127&com=0'),
(103, 'articles', 'default', 126, 0, 4, '/articles/articles.php?cat=0&id=126&com=0'),
(104, 'articles', 'default', 129, 0, 10, '/articles/articles.php?cat=0&id=129&com=0'),
(105, 'articles', 'default', 130, 0, 3, '/articles/articles.php?cat=0&id=130&com=0'),
(106, 'articles', 'default', 131, 0, 7, '/articles/articles.php?cat=0&id=131&com=0'),
(107, 'articles', 'default', 128, 0, 7, '/articles/articles.php?cat=0&id=128&com=0'),
(108, 'articles', 'default', 135, 0, 5, '/articles/articles.php?cat=0&id=135&com=0'),
(109, 'articles', 'default', 136, 0, 7, '/articles/articles.php?cat=0&id=136&com=0'),
(110, 'articles', 'default', 132, 0, 3, '/articles/articles.php?cat=0&id=132&com=0'),
(111, 'articles', 'default', 134, 0, 3, '/articles/articles.php?cat=0&id=134&com=0'),
(112, 'articles', 'default', 133, 0, 1, '/articles/articles.php?cat=0&id=133&com=0'),
(113, 'articles', 'default', 138, 0, 4, '/articles/articles.php?cat=0&id=138&com=0'),
(114, 'articles', 'default', 140, 0, 2, '/articles/articles.php?cat=0&id=140&com=0'),
(115, 'articles', 'default', 142, 0, 1, '/articles/articles.php?cat=0&id=142&com=0'),
(116, 'articles', 'default', 139, 0, 3, '/articles/articles.php?cat=0&id=139&com=0'),
(117, 'articles', 'default', 145, 0, 5, '/articles/articles.php?cat=0&id=145&com=0'),
(118, 'articles', 'default', 144, 0, 5, '/articles/articles.php?cat=0&id=144&com=0'),
(119, 'articles', 'default', 147, 0, 5, '/articles/articles.php?cat=0&id=147&com=0'),
(120, 'articles', 'default', 146, 0, 3, '/articles/articles.php?cat=0&id=146&com=0'),
(121, 'articles', 'default', 148, 0, 4, '/articles/articles.php?cat=0&id=148&com=0'),
(122, 'articles', 'default', 153, 0, 7, '/articles/articles.php?cat=0&id=153&com=0'),
(123, 'articles', 'default', 137, 0, 4, '/articles/articles.php?cat=0&id=137&com=0'),
(124, 'articles', 'default', 154, 0, 3, '/articles/articles.php?cat=0&id=154&com=0'),
(125, 'articles', 'default', 155, 0, 4, '/articles/articles.php?cat=0&id=155&com=0'),
(126, 'articles', 'default', 156, 0, 2, '/articles/articles.php?cat=0&id=156&com=0'),
(127, 'articles', 'default', 158, 0, 4, '/articles/articles.php?cat=0&id=158&com=0'),
(128, 'articles', 'default', 159, 0, 7, '/articles/articles.php?cat=0&id=159&com=0'),
(129, 'articles', 'default', 160, 0, 6, '/articles/articles.php?cat=0&id=160&com=0'),
(130, 'articles', 'default', 161, 0, 4, '/articles/articles.php?cat=0&id=161&com=0'),
(131, 'articles', 'default', 162, 0, 4, '/articles/articles.php?cat=0&id=162&com=0'),
(132, 'articles', 'default', 163, 0, 2, '/articles/articles.php?cat=0&id=163&com=0'),
(133, 'articles', 'default', 164, 0, 5, '/articles/articles.php?cat=0&id=164&com=0'),
(134, 'articles', 'default', 166, 0, 3, '/articles/articles.php?cat=0&id=166&com=0'),
(135, 'articles', 'default', 167, 0, 16, '/articles/articles.php?cat=0&id=167&com=0'),
(136, 'articles', 'default', 169, 0, 3, '/articles/articles.php?cat=0&id=169&com=0'),
(137, 'articles', 'default', 170, 0, 3, '/articles/articles.php?cat=0&id=170&com=0'),
(138, 'articles', 'default', 168, 0, 4, '/articles/articles.php?cat=0&id=168&com=0'),
(139, 'articles', 'default', 171, 0, 3, '/articles/articles.php?cat=0&id=171&com=0'),
(140, 'articles', 'default', 172, 0, 2, '/articles/articles.php?cat=0&id=172&com=0'),
(141, 'articles', 'default', 174, 0, 2, '/articles/articles.php?cat=0&id=174&com=0'),
(142, 'articles', 'default', 175, 0, 1, '/articles/articles.php?cat=0&id=175&com=0'),
(143, 'articles', 'default', 176, 0, 1, '/articles/articles.php?cat=0&id=176&com=0'),
(144, 'articles', 'default', 177, 0, 1, '/articles/articles.php?cat=0&id=177&com=0'),
(145, 'articles', 'default', 173, 0, 3, '/articles/articles.php?cat=0&id=173&com=0'),
(146, 'articles', 'default', 178, 0, 10, '/articles/articles.php?cat=0&id=178&com=0'),
(147, 'articles', 'default', 179, 0, 3, '/articles/articles.php?cat=0&id=179&com=0'),
(148, 'articles', 'default', 181, 0, 2, '/articles/articles.php?cat=0&id=181&com=0'),
(149, 'articles', 'default', 182, 0, 4, '/articles/articles.php?cat=0&id=182&com=0'),
(150, 'articles', 'default', 183, 0, 1, '/articles/articles.php?cat=0&id=183&com=0'),
(151, 'articles', 'default', 184, 0, 2, '/articles/articles.php?cat=0&id=184&com=0'),
(152, 'articles', 'default', 185, 0, 2, '/articles/articles.php?cat=0&id=185&com=0'),
(153, 'articles', 'default', 186, 0, 4, '/articles/articles.php?cat=0&id=186&com=0'),
(154, 'articles', 'default', 187, 0, 4, '/articles/articles.php?cat=0&id=187&com=0'),
(155, 'articles', 'default', 188, 0, 8, '/articles/articles.php?cat=0&id=188&com=0'),
(156, 'articles', 'default', 189, 0, 5, '/articles/articles.php?cat=0&id=189&com=0'),
(157, 'articles', 'default', 191, 0, 7, '/articles/articles.php?cat=0&id=191&com=0'),
(158, 'articles', 'default', 190, 0, 4, '/articles/articles.php?cat=0&id=190&com=0'),
(159, 'articles', 'default', 180, 0, 1, '/articles/articles.php?cat=0&id=180&com=0'),
(160, 'articles', 'default', 192, 0, 4, '/articles/articles.php?cat=0&id=192&com=0'),
(161, 'articles', 'default', 193, 0, 4, '/articles/articles.php?cat=0&id=193&com=0'),
(162, 'articles', 'default', 194, 0, 4, '/articles/articles.php?cat=0&id=194&com=0'),
(163, 'articles', 'default', 195, 0, 1, '/articles/articles.php?cat=0&id=195&com=0'),
(164, 'articles', 'default', 196, 0, 3, '/articles/articles.php?cat=0&id=196&com=0'),
(165, 'articles', 'default', 197, 0, 5, '/articles/articles.php?cat=0&id=197&com=0'),
(166, 'articles', 'default', 198, 0, 5, '/articles/articles.php?cat=0&id=198&com=0'),
(167, 'articles', 'default', 201, 0, 7, '/articles/articles.php?cat=0&id=201&com=0'),
(168, 'articles', 'default', 200, 0, 1, '/articles/articles.php?cat=0&id=200&com=0'),
(169, 'articles', 'default', 202, 0, 6, '/articles/articles.php?cat=0&id=202&com=0'),
(170, 'articles', 'default', 199, 0, 1, '/articles/articles.php?cat=0&id=199&com=0'),
(171, 'articles', 'default', 203, 0, 2, '/articles/articles.php?cat=0&id=203&com=0'),
(173, 'articles', 'default', 205, 0, 1, '/articles/articles.php?cat=0&id=205&com=0'),
(174, 'articles', 'default', 204, 0, 1, '/articles/articles.php?cat=0&id=204&com=0'),
(175, 'articles', 'default', 207, 0, 6, '/articles/articles.php?cat=0&id=207&com=0'),
(176, 'articles', 'default', 208, 0, 7, '/articles/articles.php?cat=0&id=208&com=0'),
(177, 'articles', 'default', 209, 0, 6, '/articles/articles.php?cat=0&id=209&com=0'),
(178, 'articles', 'default', 210, 0, 1, '/articles/articles.php?cat=0&id=210&com=0'),
(179, 'articles', 'default', 212, 0, 2, '/articles/articles.php?cat=0&id=212&com=0'),
(180, 'articles', 'default', 214, 0, 3, '/articles/articles.php?cat=0&id=214&com=0'),
(181, 'articles', 'default', 215, 0, 1, '/articles/articles.php?cat=0&id=215&com=0'),
(182, 'articles', 'default', 216, 0, 5, '/articles/articles.php?cat=0&id=216&com=0'),
(183, 'articles', 'default', 217, 0, 3, '/articles/articles.php?cat=0&id=217&com=0'),
(184, 'articles', 'default', 218, 0, 8, '/articles/articles.php?cat=0&id=218&com=0'),
(185, 'articles', 'default', 219, 0, 3, '/articles/articles.php?cat=0&id=219&com=0'),
(186, 'articles', 'default', 221, 0, 3, '/articles/articles.php?cat=0&id=221&com=0'),
(187, 'articles', 'default', 222, 0, 8, '/articles/articles.php?cat=0&id=222&com=0'),
(188, 'articles', 'default', 223, 0, 2, '/articles/articles.php?cat=0&id=223&com=0'),
(189, 'articles', 'default', 220, 0, 1, '/articles/articles.php?cat=0&id=220&com=0'),
(190, 'articles', 'default', 224, 0, 1, '/articles/articles.php?cat=0&id=224&com=0'),
(191, 'articles', 'default', 225, 0, 3, '/articles/articles.php?cat=0&id=225&com=0'),
(192, 'articles', 'default', 226, 0, 4, '/articles/articles.php?cat=0&id=226&com=0'),
(193, 'articles', 'default', 227, 0, 1, '/articles/articles.php?cat=0&id=227&com=0'),
(194, 'articles', 'default', 228, 0, 3, '/articles/articles.php?cat=0&id=228&com=0'),
(195, 'articles', 'default', 229, 0, 6, '/articles/articles.php?cat=0&id=229&com=0'),
(196, 'articles', 'default', 232, 0, 7, '/articles/articles.php?cat=0&id=232&com=0'),
(197, 'articles', 'default', 230, 0, 1, '/articles/articles.php?cat=0&id=230&com=0'),
(198, 'articles', 'default', 234, 0, 2, '/articles/articles.php?cat=0&id=234&com=0'),
(199, 'articles', 'default', 233, 0, 1, '/articles/articles.php?cat=0&id=233&com=0'),
(200, 'articles', 'default', 235, 0, 8, '/articles/articles.php?cat=0&id=235&com=0'),
(201, 'articles', 'default', 236, 0, 4, '/articles/articles.php?cat=0&id=236&com=0'),
(202, 'articles', 'default', 238, 0, 4, '/articles/articles.php?cat=0&id=238&com=0'),
(203, 'articles', 'default', 237, 0, 4, '/articles/articles.php?cat=0&id=237&com=0'),
(204, 'articles', 'default', 239, 0, 7, '/articles/articles.php?cat=0&id=239&com=0'),
(205, 'articles', 'default', 241, 0, 3, '/articles/articles.php?cat=0&id=241&com=0'),
(206, 'articles', 'default', 240, 0, 1, '/articles/articles.php?cat=0&id=240&com=0'),
(207, 'articles', 'default', 242, 0, 4, '/articles/articles.php?cat=0&id=242&com=0'),
(208, 'articles', 'default', 244, 0, 3, '/articles/articles.php?cat=0&id=244&com=0'),
(209, 'articles', 'default', 246, 0, 2, '/articles/articles.php?cat=0&id=246&com=0'),
(210, 'articles', 'default', 247, 0, 3, '/articles/articles.php?cat=0&id=247&com=0'),
(211, 'articles', 'default', 249, 0, 3, '/articles/articles.php?cat=0&id=249&com=0'),
(212, 'articles', 'default', 250, 0, 1, '/articles/articles.php?cat=0&id=250&com=0'),
(213, 'articles', 'default', 243, 0, 1, '/articles/articles.php?cat=0&id=243&com=0'),
(214, 'articles', 'default', 248, 0, 1, '/articles/articles.php?cat=0&id=248&com=0'),
(215, 'articles', 'default', 251, 0, 3, '/articles/articles.php?cat=0&id=251&com=0'),
(216, 'articles', 'default', 245, 0, 4, '/articles/articles.php?cat=0&id=245&com=0'),
(217, 'articles', 'default', 253, 0, 3, '/articles/articles.php?cat=0&id=253&com=0'),
(218, 'articles', 'default', 254, 0, 1, '/articles/articles.php?cat=0&id=254&com=0'),
(219, 'articles', 'default', 255, 0, 3, '/articles/articles.php?cat=0&id=255&com=0'),
(220, 'articles', 'default', 257, 0, 1, '/articles/articles.php?cat=0&id=257&com=0'),
(221, 'articles', 'default', 256, 0, 2, '/articles/articles.php?cat=0&id=256&com=0'),
(225, 'articles', 'default', 261, 0, 8, '/articles/?url=/0-root/261-edge-of-tomorrow-2014/'),
(223, 'articles', 'default', 260, 0, 3, '/articles/articles.php?cat=0&id=260&com=0'),
(224, 'articles', 'default', 264, 0, 5, '/articles/?url=/0-root/264-noah-2014/'),
(226, 'articles', 'default', 263, 0, 3, '/articles/?url=/0-root/263-rain-man-remastered-1988/'),
(227, 'articles', 'default', 265, 0, 2, '/articles/?url=/0-root/265-une-rencontre-2014/'),
(228, 'articles', 'default', 266, 0, 8, '/articles/?url=/0-root/266-star-trek-into-darkness-imax-2013/'),
(229, 'articles', 'default', 267, 0, 4, '/articles/?url=/0-root/267-a-million-ways-to-die-in-the-west-2014/'),
(230, 'articles', 'default', 268, 0, 3, '/articles/?url=/0-root/268-x-men-days-of-future-past-2014/'),
(231, 'articles', 'default', 269, 0, 3, '/articles/?url=/0-root/269-gangs-of-new-york-2002/'),
(232, 'articles', 'default', 270, 0, 3, '/articles/?url=/0-root/270-boogie-nights-1997/'),
(233, 'articles', 'default', 271, 0, 2, '/articles/?url=/0-root/271-fear-and-desire-1953/'),
(234, 'articles', 'default', 272, 0, 2, '/articles/?url=/0-root/272-the-homesman-2014/'),
(235, 'articles', 'default', 273, 0, 3, '/articles/?url=/0-root/273-boardwalk-empire-saison-4/'),
(236, 'articles', 'default', 274, 0, 4, '/articles/?url=/0-root/274-kingdom-of-heaven-dc-2005/'),
(237, 'articles', 'default', 275, 0, 3, '/articles/?url=/0-root/275-spirired-away-2001/'),
(238, 'articles', 'default', 277, 0, 3, '/articles/?url=/0-root/277-once-upon-a-time-in-america-extended-dc-1984/'),
(239, 'articles', 'default', 278, 0, 2, '/articles/?url=/0-root/278-x-men-2000/'),
(240, 'articles', 'default', 279, 0, 1, '/articles/?url=/0-root/279-x-men-2-2003/'),
(241, 'articles', 'default', 276, 0, 2, '/articles/?url=/0-root/276-don-jon-2013/'),
(242, 'articles', 'default', 282, 0, 1, '/articles/?url=/0-root/282-x-men-first-class-2011/'),
(243, 'articles', 'default', 284, 0, 1, '/articles/?url=/0-root/284-deux-jours-une-nuit-2014/'),
(244, 'articles', 'default', 287, 0, 3, '/articles/?url=/0-root/287-die-nibelungen-1924/'),
(245, 'articles', 'default', 288, 0, 1, '/articles/?url=/0-root/288-spider-man-2-2004-4k-remastered/'),
(246, 'articles', 'default', 289, 0, 1, '/articles/?url=/0-root/289-the-holy-mountain-1973/'),
(247, 'articles', 'default', 291, 0, 8, '/articles/?url=/0-root/291-how-to-train-your-dragon-2-2014/'),
(248, 'articles', 'default', 292, 0, 1, '/articles/?url=/0-root/292-the-fury-1978/'),
(249, 'articles', 'default', 293, 0, 2, '/articles/?url=/0-root/293-twin-peaks-saison-1/'),
(250, 'articles', 'default', 252, 0, 1, '/articles/?url=/0-root/252-august-osage-county-2013/'),
(251, 'articles', 'default', 295, 0, 3, '/articles/?url=/0-root/295-bad-lieutenant-1992/'),
(252, 'articles', 'default', 296, 0, 1, '/articles/?url=/0-root/296-godzilla-2014/');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Client : localhost
-- Généré le : Lun 10 Novembre 2014 à 08:21
-- Version du serveur : 5.5.34-MariaDB-cll-lve
-- Version de PHP : 5.4.23
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données : `.........`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_comments_topic`
--
CREATE TABLE IF NOT EXISTS `phpboost_comments_topic` (
`id_topic` int(11) NOT NULL AUTO_INCREMENT,
`module_id` varchar(255) NOT NULL DEFAULT '',
`topic_identifier` varchar(255) NOT NULL DEFAULT 'default',
`id_in_module` int(11) NOT NULL DEFAULT '0',
`is_locked` int(11) NOT NULL DEFAULT '0',
`number_comments` int(11) NOT NULL DEFAULT '0',
`path` varchar(255) NOT NULL,
PRIMARY KEY (`id_topic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=253 ;
--
-- Contenu de la table `phpboost_comments_topic`
--
INSERT INTO `phpboost_comments_topic` (`id_topic`, `module_id`, `topic_identifier`, `id_in_module`, `is_locked`, `number_comments`, `path`) VALUES
(1, 'articles', 'default', 11, 0, 1, '/articles/articles.php?cat=0&id=11&com=0'),
(2, 'articles', 'default', 13, 0, 2, '/articles/articles.php?cat=0&id=13&com=0'),
(3, 'articles', 'default', 25, 0, 5, '/articles/articles.php?cat=0&id=25&com=0'),
(4, 'articles', 'default', 18, 0, 1, '/articles/articles.php?cat=0&id=18&com=0'),
(5, 'articles', 'default', 15, 0, 1, '/articles/articles.php?cat=0&id=15&com=0'),
(6, 'articles', 'default', 10, 0, 1, '/articles/articles.php?cat=0&id=10&com=0'),
(7, 'articles', 'default', 26, 0, 5, '/articles/articles.php?cat=0&id=26&com=0'),
(8, 'articles', 'default', 27, 0, 2, '/articles/articles.php?cat=0&id=27&com=0'),
(9, 'articles', 'default', 28, 0, 4, '/articles/articles.php?cat=0&id=28&com=0'),
(10, 'articles', 'default', 30, 0, 3, '/articles/articles.php?cat=0&id=30&com=0'),
(11, 'articles', 'default', 29, 0, 2, '/articles/articles.php?cat=0&id=29&com=0'),
(12, 'articles', 'default', 31, 0, 2, '/articles/articles.php?cat=0&id=31&com=0'),
(13, 'articles', 'default', 34, 0, 2, '/articles/articles.php?cat=0&id=34&com=0'),
(14, 'articles', 'default', 36, 0, 2, '/articles/articles.php?cat=0&id=36&com=0'),
(15, 'bugtracker', 'default', 1, 0, 1, '/bugtracker/?url=/detail/1-probleme-charset-module-discussion'),
(16, 'bugtracker', 'default', 3, 0, 1, '/bugtracker/?url=/detail/3-commentaires-developpes-par-defaut-sur-les-fiches-de-films'),
(17, 'bugtracker', 'default', 4, 0, 1, '/bugtracker/?url=/detail/4-validation-des-messages-shoutbox-avec-touche-enter'),
(18, 'bugtracker', 'default', 5, 0, 1, '/bugtracker/?url=/detail/5-smileys-dans-la-shoutbox'),
(19, 'articles', 'default', 38, 0, 9, '/articles/articles.php?cat=0&id=38&com=0'),
(20, 'bugtracker', 'default', 6, 0, 1, '/bugtracker/?url=/detail/6-affichage-smileys-shout'),
(21, 'bugtracker', 'default', 7, 0, 1, '/bugtracker/?url=/detail/7-clique-pseudo-shoutbox'),
(22, 'articles', 'default', 39, 0, 9, '/articles/articles.php?cat=0&id=39&com=0'),
(23, 'articles', 'default', 40, 0, 1, '/articles/articles.php?cat=0&id=40&com=0'),
(24, 'articles', 'default', 35, 0, 1, '/articles/articles.php?cat=0&id=35&com=0'),
(25, 'articles', 'default', 41, 0, 5, '/articles/articles.php?cat=0&id=41&com=0'),
(26, 'articles', 'default', 42, 0, 9, '/articles/articles.php?cat=0&id=42&com=0'),
(27, 'articles', 'default', 43, 0, 1, '/articles/articles.php?cat=0&id=43&com=0'),
(28, 'articles', 'default', 44, 0, 9, '/articles/articles.php?cat=0&id=44&com=0'),
(29, 'articles', 'default', 45, 0, 2, '/articles/articles.php?cat=0&id=45&com=0'),
(30, 'articles', 'default', 46, 0, 6, '/articles/articles.php?cat=0&id=46&com=0'),
(31, 'articles', 'default', 47, 0, 3, '/articles/articles.php?cat=0&id=47&com=0'),
(32, 'articles', 'default', 48, 0, 9, '/articles/articles.php?cat=0&id=48&com=0'),
(33, 'articles', 'default', 49, 0, 5, '/articles/articles.php?cat=0&id=49&com=0'),
(34, 'articles', 'default', 52, 0, 7, '/articles/articles.php?cat=0&id=52&com=0'),
(35, 'articles', 'default', 51, 0, 1, '/articles/articles.php?cat=0&id=51&com=0'),
(36, 'articles', 'default', 50, 0, 2, '/articles/articles.php?cat=0&id=50&com=0'),
(37, 'articles', 'default', 53, 0, 5, '/articles/articles.php?cat=0&id=53&com=0'),
(38, 'articles', 'default', 54, 0, 5, '/articles/articles.php?cat=0&id=54&com=0'),
(39, 'articles', 'default', 55, 0, 3, '/articles/articles.php?cat=0&id=55&com=0'),
(40, 'articles', 'default', 56, 0, 1, '/articles/articles.php?cat=0&id=56&com=0'),
(41, 'articles', 'default', 59, 0, 4, '/articles/articles.php?cat=0&id=59&com=0'),
(42, 'articles', 'default', 58, 0, 4, '/articles/articles.php?cat=0&id=58&com=0'),
(43, 'articles', 'default', 57, 0, 1, '/articles/articles.php?cat=0&id=57&com=0'),
(44, 'articles', 'default', 60, 0, 8, '/articles/articles.php?cat=0&id=60&com=0'),
(45, 'articles', 'default', 61, 0, 6, '/articles/articles.php?cat=0&id=61&com=0'),
(46, 'articles', 'default', 62, 0, 2, '/articles/articles.php?cat=0&id=62&com=0'),
(47, 'articles', 'default', 64, 0, 3, '/articles/articles.php?cat=0&id=64&com=0'),
(48, 'articles', 'default', 63, 0, 7, '/articles/articles.php?cat=0&id=63&com=0'),
(49, 'articles', 'default', 65, 0, 3, '/articles/articles.php?cat=0&id=65&com=0'),
(50, 'articles', 'default', 67, 0, 3, '/articles/articles.php?cat=0&id=67&com=0'),
(51, 'articles', 'default', 69, 0, 8, '/articles/articles.php?cat=0&id=69&com=0'),
(52, 'articles', 'default', 68, 0, 1, '/articles/articles.php?cat=0&id=68&com=0'),
(53, 'articles', 'default', 70, 0, 3, '/articles/articles.php?cat=0&id=70&com=0'),
(54, 'articles', 'default', 71, 0, 20, '/articles/articles.php?cat=0&id=71&com=0'),
(172, 'articles', 'default', 206, 0, 3, '/articles/articles.php?cat=0&id=206&com=0'),
(56, 'articles', 'default', 74, 0, 5, '/articles/articles.php?cat=0&id=74&com=0'),
(57, 'articles', 'default', 75, 0, 2, '/articles/articles.php?cat=0&id=75&com=0'),
(58, 'articles', 'default', 66, 0, 2, '/articles/articles.php?cat=0&id=66&com=0'),
(59, 'articles', 'default', 76, 0, 10, '/articles/articles.php?cat=0&id=76&com=0'),
(60, 'articles', 'default', 77, 0, 2, '/articles/articles.php?cat=0&id=77&com=0'),
(61, 'articles', 'default', 78, 0, 4, '/articles/articles.php?cat=0&id=78&com=0'),
(62, 'articles', 'default', 79, 0, 18, '/articles/articles.php?cat=0&id=79&com=0'),
(63, 'articles', 'default', 80, 0, 4, '/articles/articles.php?cat=0&id=80&com=0'),
(64, 'articles', 'default', 81, 0, 2, '/articles/articles.php?cat=0&id=81&com=0'),
(65, 'articles', 'default', 82, 0, 1, '/articles/articles.php?cat=0&id=82&com=0'),
(66, 'articles', 'default', 83, 0, 11, '/articles/articles.php?cat=0&id=83&com=0'),
(67, 'articles', 'default', 86, 0, 1, '/articles/articles.php?cat=0&id=86&com=0'),
(68, 'articles', 'default', 87, 0, 4, '/articles/articles.php?cat=0&id=87&com=0'),
(69, 'articles', 'default', 84, 0, 1, '/articles/articles.php?cat=0&id=84&com=0'),
(70, 'articles', 'default', 88, 0, 2, '/articles/articles.php?cat=0&id=88&com=0'),
(71, 'articles', 'default', 73, 0, 3, '/articles/articles.php?cat=0&id=73&com=0'),
(72, 'articles', 'default', 90, 0, 3, '/articles/articles.php?cat=0&id=90&com=0'),
(73, 'articles', 'default', 93, 0, 7, '/articles/articles.php?cat=0&id=93&com=0'),
(74, 'articles', 'default', 96, 0, 6, '/articles/articles.php?cat=0&id=96&com=0'),
(75, 'articles', 'default', 94, 0, 2, '/articles/articles.php?cat=0&id=94&com=0'),
(76, 'articles', 'default', 91, 0, 2, '/articles/articles.php?cat=0&id=91&com=0'),
(77, 'articles', 'default', 97, 0, 6, '/articles/articles.php?cat=0&id=97&com=0'),
(78, 'articles', 'default', 98, 0, 4, '/articles/articles.php?cat=0&id=98&com=0'),
(79, 'articles', 'default', 100, 0, 3, '/articles/articles.php?cat=0&id=100&com=0'),
(80, 'articles', 'default', 101, 0, 5, '/articles/articles.php?cat=0&id=101&com=0'),
(81, 'articles', 'default', 102, 0, 7, '/articles/articles.php?cat=0&id=102&com=0'),
(82, 'articles', 'default', 103, 0, 3, '/articles/articles.php?cat=0&id=103&com=0'),
(83, 'articles', 'default', 104, 0, 4, '/articles/articles.php?cat=0&id=104&com=0'),
(84, 'articles', 'default', 105, 0, 5, '/articles/articles.php?cat=0&id=105&com=0'),
(85, 'articles', 'default', 107, 0, 1, '/articles/articles.php?cat=0&id=107&com=0'),
(86, 'articles', 'default', 108, 0, 11, '/articles/articles.php?cat=0&id=108&com=0'),
(87, 'articles', 'default', 109, 0, 8, '/articles/articles.php?cat=0&id=109&com=0'),
(88, 'articles', 'default', 110, 0, 1, '/articles/articles.php?cat=0&id=110&com=0'),
(89, 'articles', 'default', 111, 0, 1, '/articles/articles.php?cat=0&id=111&com=0'),
(90, 'articles', 'default', 113, 0, 7, '/articles/articles.php?cat=0&id=113&com=0'),
(91, 'articles', 'default', 112, 0, 2, '/articles/articles.php?cat=0&id=112&com=0'),
(92, 'articles', 'default', 115, 0, 3, '/articles/articles.php?cat=0&id=115&com=0'),
(93, 'articles', 'default', 114, 0, 3, '/articles/articles.php?cat=0&id=114&com=0'),
(94, 'articles', 'default', 117, 0, 1, '/articles/articles.php?cat=0&id=117&com=0'),
(95, 'articles', 'default', 121, 0, 3, '/articles/articles.php?cat=0&id=121&com=0'),
(96, 'articles', 'default', 119, 0, 2, '/articles/articles.php?cat=0&id=119&com=0'),
(97, 'articles', 'default', 116, 0, 1, '/articles/articles.php?cat=0&id=116&com=0'),
(98, 'articles', 'default', 122, 0, 6, '/articles/articles.php?cat=0&id=122&com=0'),
(99, 'articles', 'default', 123, 0, 9, '/articles/articles.php?cat=0&id=123&com=0'),
(100, 'articles', 'default', 124, 0, 2, '/articles/articles.php?cat=0&id=124&com=0'),
(101, 'articles', 'default', 125, 0, 1, '/articles/articles.php?cat=0&id=125&com=0'),
(102, 'articles', 'default', 127, 0, 2, '/articles/articles.php?cat=0&id=127&com=0'),
(103, 'articles', 'default', 126, 0, 4, '/articles/articles.php?cat=0&id=126&com=0'),
(104, 'articles', 'default', 129, 0, 10, '/articles/articles.php?cat=0&id=129&com=0'),
(105, 'articles', 'default', 130, 0, 3, '/articles/articles.php?cat=0&id=130&com=0'),
(106, 'articles', 'default', 131, 0, 7, '/articles/articles.php?cat=0&id=131&com=0'),
(107, 'articles', 'default', 128, 0, 7, '/articles/articles.php?cat=0&id=128&com=0'),
(108, 'articles', 'default', 135, 0, 5, '/articles/articles.php?cat=0&id=135&com=0'),
(109, 'articles', 'default', 136, 0, 7, '/articles/articles.php?cat=0&id=136&com=0'),
(110, 'articles', 'default', 132, 0, 3, '/articles/articles.php?cat=0&id=132&com=0'),
(111, 'articles', 'default', 134, 0, 3, '/articles/articles.php?cat=0&id=134&com=0'),
(112, 'articles', 'default', 133, 0, 1, '/articles/articles.php?cat=0&id=133&com=0'),
(113, 'articles', 'default', 138, 0, 4, '/articles/articles.php?cat=0&id=138&com=0'),
(114, 'articles', 'default', 140, 0, 2, '/articles/articles.php?cat=0&id=140&com=0'),
(115, 'articles', 'default', 142, 0, 1, '/articles/articles.php?cat=0&id=142&com=0'),
(116, 'articles', 'default', 139, 0, 3, '/articles/articles.php?cat=0&id=139&com=0'),
(117, 'articles', 'default', 145, 0, 5, '/articles/articles.php?cat=0&id=145&com=0'),
(118, 'articles', 'default', 144, 0, 5, '/articles/articles.php?cat=0&id=144&com=0'),
(119, 'articles', 'default', 147, 0, 5, '/articles/articles.php?cat=0&id=147&com=0'),
(120, 'articles', 'default', 146, 0, 3, '/articles/articles.php?cat=0&id=146&com=0'),
(121, 'articles', 'default', 148, 0, 4, '/articles/articles.php?cat=0&id=148&com=0'),
(122, 'articles', 'default', 153, 0, 7, '/articles/articles.php?cat=0&id=153&com=0'),
(123, 'articles', 'default', 137, 0, 4, '/articles/articles.php?cat=0&id=137&com=0'),
(124, 'articles', 'default', 154, 0, 3, '/articles/articles.php?cat=0&id=154&com=0'),
(125, 'articles', 'default', 155, 0, 4, '/articles/articles.php?cat=0&id=155&com=0'),
(126, 'articles', 'default', 156, 0, 2, '/articles/articles.php?cat=0&id=156&com=0'),
(127, 'articles', 'default', 158, 0, 4, '/articles/articles.php?cat=0&id=158&com=0'),
(128, 'articles', 'default', 159, 0, 7, '/articles/articles.php?cat=0&id=159&com=0'),
(129, 'articles', 'default', 160, 0, 6, '/articles/articles.php?cat=0&id=160&com=0'),
(130, 'articles', 'default', 161, 0, 4, '/articles/articles.php?cat=0&id=161&com=0'),
(131, 'articles', 'default', 162, 0, 4, '/articles/articles.php?cat=0&id=162&com=0'),
(132, 'articles', 'default', 163, 0, 2, '/articles/articles.php?cat=0&id=163&com=0'),
(133, 'articles', 'default', 164, 0, 5, '/articles/articles.php?cat=0&id=164&com=0'),
(134, 'articles', 'default', 166, 0, 3, '/articles/articles.php?cat=0&id=166&com=0'),
(135, 'articles', 'default', 167, 0, 16, '/articles/articles.php?cat=0&id=167&com=0'),
(136, 'articles', 'default', 169, 0, 3, '/articles/articles.php?cat=0&id=169&com=0'),
(137, 'articles', 'default', 170, 0, 3, '/articles/articles.php?cat=0&id=170&com=0'),
(138, 'articles', 'default', 168, 0, 4, '/articles/articles.php?cat=0&id=168&com=0'),
(139, 'articles', 'default', 171, 0, 3, '/articles/articles.php?cat=0&id=171&com=0'),
(140, 'articles', 'default', 172, 0, 2, '/articles/articles.php?cat=0&id=172&com=0'),
(141, 'articles', 'default', 174, 0, 2, '/articles/articles.php?cat=0&id=174&com=0'),
(142, 'articles', 'default', 175, 0, 1, '/articles/articles.php?cat=0&id=175&com=0'),
(143, 'articles', 'default', 176, 0, 1, '/articles/articles.php?cat=0&id=176&com=0'),
(144, 'articles', 'default', 177, 0, 1, '/articles/articles.php?cat=0&id=177&com=0'),
(145, 'articles', 'default', 173, 0, 3, '/articles/articles.php?cat=0&id=173&com=0'),
(146, 'articles', 'default', 178, 0, 10, '/articles/articles.php?cat=0&id=178&com=0'),
(147, 'articles', 'default', 179, 0, 3, '/articles/articles.php?cat=0&id=179&com=0'),
(148, 'articles', 'default', 181, 0, 2, '/articles/articles.php?cat=0&id=181&com=0'),
(149, 'articles', 'default', 182, 0, 4, '/articles/articles.php?cat=0&id=182&com=0'),
(150, 'articles', 'default', 183, 0, 1, '/articles/articles.php?cat=0&id=183&com=0'),
(151, 'articles', 'default', 184, 0, 2, '/articles/articles.php?cat=0&id=184&com=0'),
(152, 'articles', 'default', 185, 0, 2, '/articles/articles.php?cat=0&id=185&com=0'),
(153, 'articles', 'default', 186, 0, 4, '/articles/articles.php?cat=0&id=186&com=0'),
(154, 'articles', 'default', 187, 0, 4, '/articles/articles.php?cat=0&id=187&com=0'),
(155, 'articles', 'default', 188, 0, 8, '/articles/articles.php?cat=0&id=188&com=0'),
(156, 'articles', 'default', 189, 0, 5, '/articles/articles.php?cat=0&id=189&com=0'),
(157, 'articles', 'default', 191, 0, 7, '/articles/articles.php?cat=0&id=191&com=0'),
(158, 'articles', 'default', 190, 0, 4, '/articles/articles.php?cat=0&id=190&com=0'),
(159, 'articles', 'default', 180, 0, 1, '/articles/articles.php?cat=0&id=180&com=0'),
(160, 'articles', 'default', 192, 0, 4, '/articles/articles.php?cat=0&id=192&com=0'),
(161, 'articles', 'default', 193, 0, 4, '/articles/articles.php?cat=0&id=193&com=0'),
(162, 'articles', 'default', 194, 0, 4, '/articles/articles.php?cat=0&id=194&com=0'),
(163, 'articles', 'default', 195, 0, 1, '/articles/articles.php?cat=0&id=195&com=0'),
(164, 'articles', 'default', 196, 0, 3, '/articles/articles.php?cat=0&id=196&com=0'),
(165, 'articles', 'default', 197, 0, 5, '/articles/articles.php?cat=0&id=197&com=0'),
(166, 'articles', 'default', 198, 0, 5, '/articles/articles.php?cat=0&id=198&com=0'),
(167, 'articles', 'default', 201, 0, 7, '/articles/articles.php?cat=0&id=201&com=0'),
(168, 'articles', 'default', 200, 0, 1, '/articles/articles.php?cat=0&id=200&com=0'),
(169, 'articles', 'default', 202, 0, 6, '/articles/articles.php?cat=0&id=202&com=0'),
(170, 'articles', 'default', 199, 0, 1, '/articles/articles.php?cat=0&id=199&com=0'),
(171, 'articles', 'default', 203, 0, 2, '/articles/articles.php?cat=0&id=203&com=0'),
(173, 'articles', 'default', 205, 0, 1, '/articles/articles.php?cat=0&id=205&com=0'),
(174, 'articles', 'default', 204, 0, 1, '/articles/articles.php?cat=0&id=204&com=0'),
(175, 'articles', 'default', 207, 0, 6, '/articles/articles.php?cat=0&id=207&com=0'),
(176, 'articles', 'default', 208, 0, 7, '/articles/articles.php?cat=0&id=208&com=0'),
(177, 'articles', 'default', 209, 0, 6, '/articles/articles.php?cat=0&id=209&com=0'),
(178, 'articles', 'default', 210, 0, 1, '/articles/articles.php?cat=0&id=210&com=0'),
(179, 'articles', 'default', 212, 0, 2, '/articles/articles.php?cat=0&id=212&com=0'),
(180, 'articles', 'default', 214, 0, 3, '/articles/articles.php?cat=0&id=214&com=0'),
(181, 'articles', 'default', 215, 0, 1, '/articles/articles.php?cat=0&id=215&com=0'),
(182, 'articles', 'default', 216, 0, 5, '/articles/articles.php?cat=0&id=216&com=0'),
(183, 'articles', 'default', 217, 0, 3, '/articles/articles.php?cat=0&id=217&com=0'),
(184, 'articles', 'default', 218, 0, 8, '/articles/articles.php?cat=0&id=218&com=0'),
(185, 'articles', 'default', 219, 0, 3, '/articles/articles.php?cat=0&id=219&com=0'),
(186, 'articles', 'default', 221, 0, 3, '/articles/articles.php?cat=0&id=221&com=0'),
(187, 'articles', 'default', 222, 0, 8, '/articles/articles.php?cat=0&id=222&com=0'),
(188, 'articles', 'default', 223, 0, 2, '/articles/articles.php?cat=0&id=223&com=0'),
(189, 'articles', 'default', 220, 0, 1, '/articles/articles.php?cat=0&id=220&com=0'),
(190, 'articles', 'default', 224, 0, 1, '/articles/articles.php?cat=0&id=224&com=0'),
(191, 'articles', 'default', 225, 0, 3, '/articles/articles.php?cat=0&id=225&com=0'),
(192, 'articles', 'default', 226, 0, 4, '/articles/articles.php?cat=0&id=226&com=0'),
(193, 'articles', 'default', 227, 0, 1, '/articles/articles.php?cat=0&id=227&com=0'),
(194, 'articles', 'default', 228, 0, 3, '/articles/articles.php?cat=0&id=228&com=0'),
(195, 'articles', 'default', 229, 0, 6, '/articles/articles.php?cat=0&id=229&com=0'),
(196, 'articles', 'default', 232, 0, 7, '/articles/articles.php?cat=0&id=232&com=0'),
(197, 'articles', 'default', 230, 0, 1, '/articles/articles.php?cat=0&id=230&com=0'),
(198, 'articles', 'default', 234, 0, 2, '/articles/articles.php?cat=0&id=234&com=0'),
(199, 'articles', 'default', 233, 0, 1, '/articles/articles.php?cat=0&id=233&com=0'),
(200, 'articles', 'default', 235, 0, 8, '/articles/articles.php?cat=0&id=235&com=0'),
(201, 'articles', 'default', 236, 0, 4, '/articles/articles.php?cat=0&id=236&com=0'),
(202, 'articles', 'default', 238, 0, 4, '/articles/articles.php?cat=0&id=238&com=0'),
(203, 'articles', 'default', 237, 0, 4, '/articles/articles.php?cat=0&id=237&com=0'),
(204, 'articles', 'default', 239, 0, 7, '/articles/articles.php?cat=0&id=239&com=0'),
(205, 'articles', 'default', 241, 0, 3, '/articles/articles.php?cat=0&id=241&com=0'),
(206, 'articles', 'default', 240, 0, 1, '/articles/articles.php?cat=0&id=240&com=0'),
(207, 'articles', 'default', 242, 0, 4, '/articles/articles.php?cat=0&id=242&com=0'),
(208, 'articles', 'default', 244, 0, 3, '/articles/articles.php?cat=0&id=244&com=0'),
(209, 'articles', 'default', 246, 0, 2, '/articles/articles.php?cat=0&id=246&com=0'),
(210, 'articles', 'default', 247, 0, 3, '/articles/articles.php?cat=0&id=247&com=0'),
(211, 'articles', 'default', 249, 0, 3, '/articles/articles.php?cat=0&id=249&com=0'),
(212, 'articles', 'default', 250, 0, 1, '/articles/articles.php?cat=0&id=250&com=0'),
(213, 'articles', 'default', 243, 0, 1, '/articles/articles.php?cat=0&id=243&com=0'),
(214, 'articles', 'default', 248, 0, 1, '/articles/articles.php?cat=0&id=248&com=0'),
(215, 'articles', 'default', 251, 0, 3, '/articles/articles.php?cat=0&id=251&com=0'),
(216, 'articles', 'default', 245, 0, 4, '/articles/articles.php?cat=0&id=245&com=0'),
(217, 'articles', 'default', 253, 0, 3, '/articles/articles.php?cat=0&id=253&com=0'),
(218, 'articles', 'default', 254, 0, 1, '/articles/articles.php?cat=0&id=254&com=0'),
(219, 'articles', 'default', 255, 0, 3, '/articles/articles.php?cat=0&id=255&com=0'),
(220, 'articles', 'default', 257, 0, 1, '/articles/articles.php?cat=0&id=257&com=0'),
(221, 'articles', 'default', 256, 0, 2, '/articles/articles.php?cat=0&id=256&com=0'),
(225, 'articles', 'default', 261, 0, 8, '/articles/?url=/0-root/261-edge-of-tomorrow-2014/'),
(223, 'articles', 'default', 260, 0, 3, '/articles/articles.php?cat=0&id=260&com=0'),
(224, 'articles', 'default', 264, 0, 5, '/articles/?url=/0-root/264-noah-2014/'),
(226, 'articles', 'default', 263, 0, 3, '/articles/?url=/0-root/263-rain-man-remastered-1988/'),
(227, 'articles', 'default', 265, 0, 2, '/articles/?url=/0-root/265-une-rencontre-2014/'),
(228, 'articles', 'default', 266, 0, 8, '/articles/?url=/0-root/266-star-trek-into-darkness-imax-2013/'),
(229, 'articles', 'default', 267, 0, 4, '/articles/?url=/0-root/267-a-million-ways-to-die-in-the-west-2014/'),
(230, 'articles', 'default', 268, 0, 3, '/articles/?url=/0-root/268-x-men-days-of-future-past-2014/'),
(231, 'articles', 'default', 269, 0, 3, '/articles/?url=/0-root/269-gangs-of-new-york-2002/'),
(232, 'articles', 'default', 270, 0, 3, '/articles/?url=/0-root/270-boogie-nights-1997/'),
(233, 'articles', 'default', 271, 0, 2, '/articles/?url=/0-root/271-fear-and-desire-1953/'),
(234, 'articles', 'default', 272, 0, 2, '/articles/?url=/0-root/272-the-homesman-2014/'),
(235, 'articles', 'default', 273, 0, 3, '/articles/?url=/0-root/273-boardwalk-empire-saison-4/'),
(236, 'articles', 'default', 274, 0, 4, '/articles/?url=/0-root/274-kingdom-of-heaven-dc-2005/'),
(237, 'articles', 'default', 275, 0, 3, '/articles/?url=/0-root/275-spirired-away-2001/'),
(238, 'articles', 'default', 277, 0, 3, '/articles/?url=/0-root/277-once-upon-a-time-in-america-extended-dc-1984/'),
(239, 'articles', 'default', 278, 0, 2, '/articles/?url=/0-root/278-x-men-2000/'),
(240, 'articles', 'default', 279, 0, 1, '/articles/?url=/0-root/279-x-men-2-2003/'),
(241, 'articles', 'default', 276, 0, 2, '/articles/?url=/0-root/276-don-jon-2013/'),
(242, 'articles', 'default', 282, 0, 1, '/articles/?url=/0-root/282-x-men-first-class-2011/'),
(243, 'articles', 'default', 284, 0, 1, '/articles/?url=/0-root/284-deux-jours-une-nuit-2014/'),
(244, 'articles', 'default', 287, 0, 3, '/articles/?url=/0-root/287-die-nibelungen-1924/'),
(245, 'articles', 'default', 288, 0, 1, '/articles/?url=/0-root/288-spider-man-2-2004-4k-remastered/'),
(246, 'articles', 'default', 289, 0, 1, '/articles/?url=/0-root/289-the-holy-mountain-1973/'),
(247, 'articles', 'default', 291, 0, 8, '/articles/?url=/0-root/291-how-to-train-your-dragon-2-2014/'),
(248, 'articles', 'default', 292, 0, 1, '/articles/?url=/0-root/292-the-fury-1978/'),
(249, 'articles', 'default', 293, 0, 2, '/articles/?url=/0-root/293-twin-peaks-saison-1/'),
(250, 'articles', 'default', 252, 0, 1, '/articles/?url=/0-root/252-august-osage-county-2013/'),
(251, 'articles', 'default', 295, 0, 3, '/articles/?url=/0-root/295-bad-lieutenant-1992/'),
(252, 'articles', 'default', 296, 0, 1, '/articles/?url=/0-root/296-godzilla-2014/');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Édité par BigBud13 Le 10/11/2014 à 14h26
janus57 Membre non connecté
- Booster Fusée
- Voir le profil du membre janus57
- Inscrit le : 07/12/2007
- Groupes :
- Equipe Assistance
sans trop dire de connerie, cette table ne semble pas avoir été migré en V4.1 en totalité car les liens des commentaires sont encore sous la forme V4.0. pour les 3/4 des commentaires des articles.
Cordialement, janus57
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Ce qui pose soucis, c'est que sans cette table, plus aucun commentaire n'est affiché, car elle se réfère à la table phpboost_comments.
Pour le moment je l'ai pas restauré sur le nouvel hébergement de notre site, en attendant que la solution soit trouvé.
BigBud13 Membre non connecté
Booster Fuzil
- Booster Fuzil
- Voir le profil du membre BigBud13
- Inscrit le : 28/08/2009
- Groupes :
Je reviens sur le problème.
Après plusieurs jours de recherche, je viens de remarquer que le bug se produit lorsque il y a plus de 170 articles environs par catégorie. Si je limite le nombre d'articles à 170 par catégorie je n'ai plus de souci.
Cordialement,
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie