Bug #111
Installation error with newest revision
| 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
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