Geeting this massage after update the module

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'idx_last'; check that column/key exists: ALTER TABLE {ultimate_cron_

Comments

vipul tulse created an issue. See original summary.

arnested’s picture

Just to get a better understanding: What version did you upgrade from?

arnested’s picture

Assigned: Unassigned » arnested
Status: Active » Postponed (maintainer needs more info)

I took a deeper look into the code.

The error you ran into claims the index cannot be dropped because it doesn't exists.

The idx_last index has been present since the very first 6.x version of Ultimate Cron.

This could indicate your database is not in a correct state and some previous update errors have gone unnoticed or your database has otherwise been corrupted.

A suggestion could be to manually recreate the index before running the update again (and hope your database is not corrupted in other ways as well). But it's really hard to give advice from the limited information available.

Can you provide any more details/insights?

arnested’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

I'm closing this issue due to no feedback in the last 7 months.