SMF Support > Install and Upgrade Help

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

(1/2) > >>

hodhodshop.com:
please help me -=- an error in level "Database Changes"

text of error:


--- Quote ---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'
--- End quote ---

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:

--- Quote from: emanuele on May 28, 2012, 04:24:07 AM ---Hi hodhodshop.com.
What are you trying to do?
Upgrading?
From which version to which?

--- End quote ---

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

Navigation

[0] Message Index

[#] Next page