Bug #111

Installation error with newest revision

Added by Max Marze over 3 years ago. Updated almost 3 years ago.

Status:Closed Start date:12/22/2008
Priority:Normal Due date:
Assignee:Ryan Gordon % Done:

100%

Category:Installation Procedure
Target version:1.6.0 Beta
Reproducibility: Database Type:
Reported In MyBB Version:1.4.8 Database Version:
PHP Version: SQA assignments:
Browser:

Description

With a new installation with the newest revision you receive at the end of the installation process
SQL Error:
1062 - Duplicate entry '0' for key 1
Query:
INSERT INTO mybb_adminoptions (`uid`,`cpstyle`,`notes`,`permissions`,`defaultviews`) VALUES ('-4','','','a:5:{s:6:\"config\";a:16:{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:5:\"forum\";a:5:{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: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:13:{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: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\";}')

tested on both my dev server and localhost with the same result.

Associated revisions

Revision 4311
Added by Ryan Gordon over 3 years ago

Fixes Typo in ACP Mod Tools (fixes:153)
Fixes Installation error with newest revision (fixes:111)
Fixes SMTP Password text box (fixes:154)
WIP Feature Verifying files with checksums (fixes:23)
WIP Feature Bring back Reverse DNS Lookup (fixes:25)
Feature Link to add buddy/remove buddy in profile (fixes:32)

History

#1 Updated by Matt Rogowski over 3 years ago

This only seems to happen with MySQL (5.0.51b) - SQLite (2.8.17) installs ok.

#2 Updated by Imad Jomaa over 3 years ago

The Same happens to me.

#3 Updated by Tom Loveric over 3 years ago

Matt Rogowski wrote:

This only seems to happen with MySQL (5.0.51b) - SQLite (2.8.17) installs ok.

Seconded. I can't get it to happen on SQLite, though. I'll keep trying though.

#4 Updated by Ryan Gordon over 3 years ago

there's no need to keep trying to reproduce it on SQLite. There are schema differences between SQLite, MySQL, and PostgreSQL in which this error wouldn't show up.

#5 Updated by Ryan Gordon over 3 years ago

  • Status changed from New to Assigned
  • Assignee set to Ryan Gordon

#6 Updated by Ryan Gordon over 3 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Applied in changeset r4311.

#7 Updated by Michael Schlechtinger almost 3 years ago

  • Status changed from Resolved to Closed
  • Reported In MyBB Version set to 1.4.8

Also available in: Atom PDF