Database Error 1062 Phplist
is currently 1:57pm, Thu 06 Oct, 2016 Database error 1062 while doing query Duplicate entry '' for Questions & Problems about Installing or Upgrading Version 2 phpList Forum rules Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation. This is for Version 2 of phpList (the orange one). Post a reply 4 posts • Page 1 of 1 Database error 1062 while doing query Duplicate entry '' for by jpalmer » 2:32pm, Thu 24 May, 2007 Received this error when trying to add a new admin: Database error 1062 while doing query Duplicate entry '' for key 2 Was able to add one admin and then the second one I tried to add gave this error and every time I have tried to add a new one since has given this error. I even deleted the first one I added, but with no better result. This is a new installation and am just setting up the list managers (perhaps 25) and would really appreciate any assistance I can get on this. Thanks Jim jpalmer phpList newbie Posts: 1Joined: 2:24pm, Thu 24 May, 2007 Top Re: Database error 1062 while doing query Duplicate entry '' by janetkell » 6:04pm, Fri 13 Jul, 2007 you get this error because script can insert row with already exist value in db's primary index. You can simply delete problem's row and retry good luck janetkell phpList newbie Posts: 1Joined: 5:59pm, Fri 13 Jul, 2007 Top by H2B2 » 6:26pm, Fri 13 Jul, 2007 possibly related to this report: http://mantis.phplist.com/view.php?id=10468 phpList Documentation | FAQ | Troubleshooting | Backup | System Requirements H2B2 Moderator Posts: 7188Joined: 1:51am, Wed 15 Mar, 2006 Top by pappaj333 » 8:55am, Thu 08 Nov, 2007 I get this error whenever I try to edit an existing record. Particularly a record that I have just created, which seems to perpetually default to "0" for "confirmed" and "HTML" fields. I (as an admin) created these records to be pre-confirmed and HTML emails. But once created, they revert to "false" (literally "0" for those two options. I've deleted these records and tried again. I've repeated the steps with new email addresses (I had multiple that I needed to add). Each with the same error outcome. Help please! Thanks. pappaj333 phpList newbie Posts: 2Joined: 5:22am, Fri 30 Sep, 2005 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a rep
version roll out and QA » phpList, maintainer needed » UI lite phpList plugins » phpList API » rssmanager phpList.org My View | View Issues | Change Log | RoadmapView Issue Details[Jump to Notes] [Print] IDProjectCategoryView StatusDate SubmittedLast Update0010828phplistTemplate Managementpublic30-07-07 10:0518-02-08 14:08ReportersniffiPrioritynormalSeveritymajorReproducibilityalwaysStatusresolvedResolutionfixedPlatformOSOS VersionProduct Version2.10.4Target Version2.10.7Fixed in Version2.10.5Summary0010828: Possible https://forums.phplist.com/viewtopic.php?t=9995 faulty insert; Database error 1062 while doing query Duplicate entry 'Untitled Template' for key 2DescriptionWhen inserting a template with the name "Untitled Template" or when inserting a template fails for some reason you must manually delete the "untitled template" from the https://mantis.phplist.org/view.php?id=10828 template list. This is caused in admin/template.php: if (!$id) { Sql_Query("insert into {$tables["template"]} (title) values(\"Untitled Template\")"); $id = Sql_Insert_id(); } Sql_Query(sprintf('update %s set title = "%s",template = "%s" where id = %d', $tables["template"],$title,addslashes($content),$id)); Why not insert with the right title in the first place? i guess it's related to editing or something. maybe its easier to just not mark the title field as unique, and check uniqueness manuallyTagsNo tags attached.Attached Files Relationships related to0003721closedphplist 2.10.x Relationships Notes (0030815) user1822 21-08-07 20:26 When adding a template with an existing name this generates an 1062 error and the 'Untitled Template' tupel appears. Changed temporary name to the $title field, which solves this issue. Notes Copyright © 2000 - 2016 MantisBT Team
VersionTarget VersionFixed in VersionSummary0001112: Database https://mantis.phplist.org/print_bug_page.php?bug_id=1112 error 1062 Duplicate entry when saving messagesDescriptionPHPlist 2.8.3 When you save a draft after doing a database error test send, or vice versa, you get the error message 'Database Error 1062 Duplicate entry "messageid"-0' database error 1062 or similar. Not sure if it causes any problems other than the message. This happens on various different versions of PHP and MySQL (including the demo system on tincan).Steps To ReproduceAdditional InformationTagsNo tags attached.RelationshipsAttached Files Notes (0001149) michiel 02-04-04 23:15 resolved in CVS. bug won't affect anything.