Topic: please help me -=- an error in level "Database Changes"

[hodhodshop.com]

please help me -=- an error in level "Database Changes"

text of error:

Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Updating holidays and calendar..." (5 of 19 - of this script).

!!Error!
Duplicate entry '0001-01-01' for key 'PRIMARY'

[emanuele]

Hi hodhodshop.com.

What are you trying to do?
Upgrading?
From which version to which?

[emanuele]

The error seems due to a primary index on a start or end date column, but as far as I can see SMF doesn't introduce any primary index on these columns.
What you can do is check from phpMyAdmin if there is a primary index for one or both the columns eventDate and startDate in the tables smf_calendar and/or smf_calendar_holidays.

[hodhodshop.com]

Hi hodhodshop.com.
What are you trying to do?
Upgrading?
From which version to which?

Hello my friend

yes Upgrading

From version 1.1.16 to 2.0.2

[hodhodshop.com]

pic of smf_calendar



pic of smf_calendar_holidays

[emanuele]

In the second picture, under "Indexes" you see two rows, the first with ID_HOLIDAY under the columnc "Column" and the second with "eventDate", click the "drop" button corresponding to eventDate and the upgrade should work.