User warning: Duplicate entry 'l, F j, Y - g:ia' when upgrading from 6.x-2.0-rc6 to 6.x-2.0

same here

Same here, with a j M Y date format in a Date field.
Suspect a relation with Views as that has become sort of buggy with version 2.3.

Strange thing is: I tested on a test site and all went fine.
The production site messed up.

I notice one difference: the option for the (desired) short format j M Y (no time) is present in the sandbox, but missing in the site producing the error messages.

Can confirm. I manually changed the mentioned rows via phpmyadmin to match the inserts of the queries.

Confirmed here as well.

Confirmed.

Does the same for me as well.

Confirmed - same error message.
Attached is a screenshot of the message

Could you expand what this means and how to do it — without risking wrecking my database!!

Thnx!

Got mine after upgrading calendar+date, seemed to go away and just now popped up after clearing cache.

Ok, here's a bunch of things I've found.

• This also affects the 6.x-2.x-dev release of 2009-Mar-04
• I fixed the errors on my installation by going to Administer › Site configuration › Date and time, "Formats" tab, "Custom Formats" sub-tab and finding the date format entries that matched my errors (I had two) and removing them. All clear now for me, though this is technically a work-around rather than a module update fix.
• This appears to be a duplicate of #369811: " Duplicate entry 'F j, Y - H:i' " warning for INSERT into date_format table

So I've marked this issue as fixed for 6.x-2.0 and but think the other bug #369811: " Duplicate entry 'F j, Y - H:i' " warning for INSERT into date_format table should be live because that is for -DEV and is to fix the problems in the module that cause this, rather than the symptoms.

I'll make a note over on that bug about this too.

I don't think I can delete the offending formats...
See attachments.

@arlinsandbulte - the Date Formats.jpg picture you post is from the wrong screen... you need to be in the "Custom Formats" tab which is a sub-tab of the "Formats" tab.

The adderss of the page is www.yoursite.blah/admin/settings/date-time/formats/custom

Ahhh... OK, thanks Jim. That did indeed take care of the errors.

That whole date format page is a little confusing (to me)...
What are the the date formats under 'Configure' ???
What are the 'Custom Formats' and how do they differ from the ones under 'Configure'?

Where did all these date formats come from? I never added them.
In noticed a clean install with CCK, Date, Calendar, & Views, I did not see as many of these date formats.

I fail to see how deleting a date format could solve an issue. I have this problem with the Short format, but that is the format I want to use...

Did delete the format for a custom date field a few days back, by the way, but that did not help.

Neither did reinstalling, update.php six times, disabling CCK and Views. So I can't see this as being fixed.

The workaround did not work for me and the message persists. So not fixed imho.

This is a duplicate of #369811: " Duplicate entry 'F j, Y - H:i' " warning for INSERT into date_format table.

subscribe