MyBB Community Forums

Full Version: Error in database ... And now?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi!
I would like to help a ...
I tried to run a backup of my forum, however, the following message appears:

Erro
consulta SQL:

-- -- Extraindo dados da tabela `mybb_adminoptions` -- INSERT INTO `mybb_adminoptions` (`uid`, `cpstyle`, `codepress`, `notes`, `permissions`, `defaultviews`) VALUES (0, '', 1, '', 'a:5:{s:6:"config";a:16:{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: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:13:{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[...]

Mensagens do MySQL : 

#1062 - Duplicate entry '0' for key 'PRIMARY' 


I apologize for some things are in Portuguese (Brazil), however, this is due to the language of the forum!


Much obliged to help me, because otherwise the case will end up losing my forum ...
Do you have existing data in that table you are trying to restore?
I do not know ...
How can I check that?
Well, when you browse it, is there anything in it?? On the list of tables, what does it say the number of rows is??