Duplicate column name 'slider_status'

Error
Duplicate column name 'slider_status'
ALTER TABLE `[prefix]_nextend2_smartslider3_sliders` CHANGE `status` `slider_status` VARCHAR(50) NOT NULL DEFAULT 'published'
Cause

This issue happens, when you install the latest version of Smart Slider -> then downgrade it to a lower version -> update Smart Slider again to the latest version. Maybe some wrongly configured server cache can create this issue as well, in case you haven't done this process.

In the latest Smart Slider within the [prefix]_nextend2_smartslider3_sliders database table we renamed the status column to slider_status. When you install an older Smart Slider version, that creates the status column, when it doesn't exists. Then the latest Smart Slider would try to rename status to slider_status again, just it can't, because slider_status already exists.

Solution

From your [prefix]_nextend2_smartslider3_sliders database table, delete the status column.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.