[Réglé] Erreur SQL restauration Base de données

[Jujufield]

(28-06-2011, 17:21)spyto a écrit :  Tu n'as pas changé de version de MyBB entre le backup et la tentative de restore ?

Non heureusement !

(28-06-2011, 17:21)spyto a écrit :  pourrais-tu poster les quelques lignes autour de cette ligne 267 (disons 10 avant et 10 après) si ça ne dévoile rien d'indiscret ?

Il n'y a pas de soucis.

La solution n'est peut-être pas très loin !

Je pense qu'il faut que j'explique "ma grosse erreur". En fait au lieu de faire un compte de test pour mes groupes forum j'ai fais un test sur mon compte (donc compte admin), c'est à dire que j'ai changé "Adminisitrateur" en "Groupe exemple" car je pensais vraiment que j'allais rester administrateur malgré ce paramètre. Enfin bref grosse erreur bête.

Donc j'ai supprimé sur la base de données importée sur mon PC la dernière ligne de l'admin log (je crois), en tout cas c'était du genre "Edit Profil Jujufield".

Donc peut-être que le bug n'est pas à cause d'un problème d'importation mais d'un manque de compte admin. Je viens d'y penser en lisant "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 'DROP TABLE IF EXISTS `mybb_adminoptions`' at line 267"


Je veux bien envoyer les lignes autour de 267 mais elles n'ont l'air de rien avoir de particulier et surtout elles font partie de adminlog et non adminoptions.

Citation :(1, '88.173.70.244', 1278088625, 'config/profile_fields', 'edit', 'a:2:{i:0;N;i:1;s:15:"Niveau d''étude";}'),
(1, '88.173.70.244', 1278090503, 'style/themes', 'edit', 'a:2:{i:0;s:1:"2";i:1;s:7:"Default";}'),
(1, '88.173.70.244', 1278091949, 'forum/management', 'add', 'a:2:{i:0;i:19;i:1;s:10:"Fragmovies";}'),
(1, '88.173.70.244', 1278092008, 'forum/management', 'add', 'a:2:{i:0;i:20;i:1;s:11:"Vie réelle";}'),
(1, '88.173.70.244', 1278092036, 'forum/management', 'add', 'a:2:{i:0;i:21;i:1;s:8:"Abstrait";}'),
(1, '88.173.70.244', 1278092267, 'config/settings', 'change', 'a:0:{}'),
(1, '88.173.70.244', 1278092310, 'forum/management', 'add', 'a:2:{i:0;i:22;i:1;s:14:"Total Abstrait";}'),
(1, '88.173.70.244', 1278092369, 'forum/management', 'add', 'a:2:{i:0;i:23;i:1;s:26:"Retouche Objet ou Elément";}'),
(1, '88.173.70.244', 1278092384, 'forum/management', '', 'a:3:{i:0;s:6:"orders";i:1;s:2:"13";i:2;s:10:"Créations";}'),
(1, '88.173.70.244', 1278092395, 'forum/management', 'add', 'a:2:{i:0;i:24;i:1;s:17:"Retouche Personne";}'),
(1, '88.173.70.244', 1278092407, 'forum/management', '', 'a:3:{i:0;s:6:"orders";i:1;s:2:"13";i:2;s:10:"Créations";}'),
(1, '88.173.70.244', 1278092408, 'forum/management', '', 'a:3:{i:0;s:6:"orders";i:1;s:2:"13";i:2;s:10:"Créations";}'),
(1, '88.173.70.244', 1278092428, 'forum/management', 'add', 'a:2:{i:0;i:25;i:1;s:5:"Autre";}'),
(1, '88.173.70.244', 1278092448, 'forum/management', 'add', 'a:2:{i:0;i:26;i:1;s:5:"Autre";}'),
(1, '88.173.70.244', 1278092483, 'forum/management', 'add', 'a:2:{i:0;i:27;i:1;s:17:"Techno ou Electro";}'),
(1, '88.173.70.244', 1278092506, 'forum/management', 'add', 'a:2:{i:0;i:28;i:1;s:26:"Intrumental Rap ou Hip-Hop";}'),
(1, '88.173.70.244', 1278092532, 'forum/management', 'add', 'a:2:{i:0;i:29;i:1;s:17:"Musique avec Voix";}'),
(1, '88.173.70.244', 1278092544, 'forum/management', 'add', 'a:2:{i:0;i:30;i:1;s:5:"Autre";}'),
(1, '88.173.70.244', 1278108416, 'forum/management', 'edit', 'a:2:{i:0;i:19;i:1;s:10:"Fragmovies";}'),
(1, '88.173.70.244', 1278108616, 'forum/management', 'edit', 'a:2:{i:0;i:19;i:1;s:10:"Fragmovies";}'),
(1, '88.173.70.244', 1278109424, 'user/groups', 'edit', 'a:2:{i:0;s:1:"2";i:1;s:6:"Membre";}'),

Voici donc aussi la partie adminoptions de la BDD :

Code :

-- --------------------------------------------------------

--
-- Structure de la table `mybb_adminoptions`
--

DROP TABLE IF EXISTS `mybb_adminoptions`;
CREATE TABLE IF NOT EXISTS `mybb_adminoptions` (
  `uid` int(10) NOT NULL DEFAULT '0',
  `cpstyle` varchar(50) NOT NULL DEFAULT '',
  `codepress` int(1) NOT NULL DEFAULT '1',
  `notes` text NOT NULL,
  `permissions` text NOT NULL,
  `defaultviews` text NOT NULL,
  `loginattempts` int(10) unsigned NOT NULL DEFAULT '0',
  `loginlockoutexpiry` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Contenu de la table `mybb_adminoptions`
--

INSERT INTO `mybb_adminoptions` (`uid`, `cpstyle`, `codepress`, `notes`, `permissions`, `defaultviews`, `loginattempts`, `loginlockoutexpiry`) VALUES
(0, '', 1, '', 'a:5:{s:6:"config";a:18:{s:3:"tab";s:1:"0";s:8:"settings";s:1:"0";s:7:"banning";s:1:"0";s:14:"profile_fields";s:1:"0";s:7:"smilies";s:1:"0";s:8:"badwords";s:1:"0";s:6:"mycode";s:1:"0";s:9:"languages";s:1:"0";s:10:"post_icons";s:1:"0";s:14:"help_documents";s:1:"0";s:7:"plugins";s:1:"0";s:16:"attachment_types";s:1:"0";s:9:"mod_tools";s:1:"0";s:7:"spiders";s:1:"0";s:9:"calendars";s:1:"0";s:7:"warning";s:1:"0";s:15:"thread_prefixes";i:0;s:9:"mysupport";i:0;}s:5:"forum";a:6:{s:3:"tab";s:1:"0";s:10:"management";s:1:"0";s:13:"announcements";s:1:"0";s:16:"moderation_queue";s:1:"0";s:11:"attachments";s:1:"0";s:7:"akismet";i:0;}s:5:"style";a:3:{s:3:"tab";s:1:"0";s:6:"themes";s:1:"0";s:9:"templates";s:1:"0";}s:5:"tools";a:15:{s:3:"tab";s:1:"0";s:13:"system_health";s:1:"0";s:5:"cache";s:1:"0";s:5:"tasks";s:1:"0";s:8:"backupdb";s:1:"0";s:10:"optimizedb";s:1:"0";s:8:"adminlog";s:1:"0";s:6:"modlog";s:1:"0";s:15:"recount_rebuild";s:1:"0";s:8:"php_info";s:1:"1";s:8:"maillogs";s:1:"0";s:10:"mailerrors";s:1:"0";s:10:"warninglog";s:1:"0";s:17:"file_verification";i:0;s:10:"statistics";i:0;}s:4:"user";a:8:{s:3:"tab";s:1:"0";s:5:"users";s:1:"0";s:6:"groups";s:1:"0";s:6:"titles";s:1:"0";s:7:"banning";s:1:"0";s:17:"admin_permissions";s:1:"0";s:9:"mass_mail";s:1:"0";s:16:"group_promotions";s:1:"0";}}', 'a:1:{s:4:"user";s:1:"1";}', 0, 0),
(-4, '', 1, '', 'a:5:{s:6:"config";a:18:{s:3:"tab";s:1:"1";s:8:"settings";s:1:"1";s:7:"banning";s:1:"1";s:14:"profile_fields";s:1:"1";s:7:"smilies";s:1:"1";s:8:"badwords";s:1:"1";s:6:"mycode";s:1:"1";s:9:"languages";s:1:"1";s:10:"post_icons";s:1:"1";s:14:"help_documents";s:1:"1";s:7:"plugins";s:1:"1";s:16:"attachment_types";s:1:"1";s:9:"mod_tools";s:1:"1";s:7:"spiders";s:1:"1";s:9:"calendars";s:1:"1";s:7:"warning";s:1:"1";s:15:"thread_prefixes";i:1;s:9:"mysupport";i:1;}s:5:"forum";a:6:{s:3:"tab";s:1:"1";s:10:"management";s:1:"1";s:13:"announcements";s:1:"1";s:16:"moderation_queue";s:1:"1";s:11:"attachments";s:1:"1";s:7:"akismet";i:1;}s:5:"style";a:3:{s:3:"tab";s:1:"1";s:6:"themes";s:1:"1";s:9:"templates";s:1:"1";}s:5:"tools";a:15:{s:3:"tab";s:1:"1";s:13:"system_health";s:1:"1";s:5:"cache";s:1:"1";s:5:"tasks";s:1:"1";s:8:"backupdb";s:1:"1";s:10:"optimizedb";s:1:"1";s:8:"adminlog";s:1:"1";s:6:"modlog";s:1:"1";s:15:"recount_rebuild";s:1:"1";s:8:"php_info";s:1:"1";s:8:"maillogs";s:1:"1";s:10:"mailerrors";s:1:"1";s:10:"warninglog";s:1:"1";s:17:"file_verification";i:1;s:10:"statistics";i:1;}s:4:"user";a:8:{s:3:"tab";s:1:"1";s:5:"users";s:1:"1";s:6:"groups";s:1:"1";s:6:"titles";s:1:"1";s:7:"banning";s:1:"1";s:17:"admin_permissions";s:1:"1";s:9:"mass_mail";s:1:"1";s:16:"group_promotions";s:1:"1";}}', 'a:1:{s:4:"user";s:1:"1";}', 0, 0),
(1, 'default', 1, '', 'a:5:{s:6:"config";a:18:{s:3:"tab";s:1:"1";s:8:"settings";s:1:"1";s:7:"banning";s:1:"1";s:14:"profile_fields";s:1:"1";s:7:"smilies";s:1:"1";s:8:"badwords";s:1:"1";s:6:"mycode";s:1:"1";s:9:"languages";s:1:"1";s:10:"post_icons";s:1:"1";s:14:"help_documents";s:1:"1";s:7:"plugins";s:1:"1";s:16:"attachment_types";s:1:"1";s:9:"mod_tools";s:1:"1";s:7:"spiders";s:1:"1";s:9:"calendars";s:1:"1";s:7:"warning";s:1:"1";s:15:"thread_prefixes";i:1;s:9:"mysupport";i:1;}s:5:"forum";a:6:{s:3:"tab";s:1:"1";s:10:"management";s:1:"1";s:13:"announcements";s:1:"1";s:16:"moderation_queue";s:1:"1";s:11:"attachments";s:1:"1";s:7:"akismet";i:1;}s:5:"style";a:3:{s:3:"tab";s:1:"1";s:6:"themes";s:1:"1";s:9:"templates";s:1:"1";}s:5:"tools";a:15:{s:3:"tab";s:1:"1";s:13:"system_health";s:1:"1";s:5:"cache";s:1:"1";s:5:"tasks";s:1:"1";s:8:"backupdb";s:1:"1";s:10:"optimizedb";s:1:"1";s:15:"recount_rebuild";s:1:"1";s:8:"php_info";s:1:"1";s:8:"adminlog";s:1:"1";s:6:"modlog";s:1:"1";s:8:"maillogs";s:1:"1";s:10:"mailerrors";s:1:"1";s:10:"warninglog";s:1:"1";s:17:"file_verification";i:1;s:10:"statistics";i:1;}s:4:"user";a:8:{s:3:"tab";s:1:"1";s:5:"users";s:1:"1";s:6:"groups";s:1:"1";s:6:"titles";s:1:"1";s:7:"banning";s:1:"1";s:17:"admin_permissions";s:1:"1";s:9:"mass_mail";s:1:"1";s:16:"group_promotions";s:1:"1";}}', 'a:1:{s:4:"user";N;}', 0, 0);

-- --------------------------------------------------------