zikula-modules / DizkusModule

Official repository for Dizkus, a fully integrated forum solution for Zikula 1.4+
21 stars 7 forks source link

DizkusModulInstaller Upgrade 3.1 - 4.0 - dizkus_users - wrong column name #298

Closed lasker closed 7 years ago

lasker commented 7 years ago

Hello!

During the upgrade there is a column rename from user_rank to rank. But this rename is after the following two updates.

$sql = "UPDATE dizkus_users SET rank=NULL WHERE rank=0"; $stmt = $connection->prepare($sql); $stmt->execute(); // set rank to NULL where rank no longer available $sql = "UPDATE dizkus_users set rank=NULL WHERE rank NOT IN (SELECT DISTINCT rank_id from dizkus_ranks)"; $stmt = $connection->prepare($sql); $stmt->execute();

Kaik commented 7 years ago

This should be fixed in current master, I'm closing this issue now. Please create new issue if problem still exists.