06-16-2020, 02:38 PM
very strange. if you go to the line that is failing:
https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L606
you will see that it cannot find the column change_password in vtiger_users table, but this column is added right before the query:
https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L601:L604
in that block of code it looks if the column exists, if it doesn't it adds it, so the query below should never fail to find the column.
That is a symptom that there could be some other issue with the database, but I would ask you to copy the code and execute it manually in your database to see if you are getting some error with that SQL: https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L603
ALTER TABLE `vtiger_users` ADD `change_password` boolean NOT NULL DEFAULT 0
https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L606
you will see that it cannot find the column change_password in vtiger_users table, but this column is added right before the query:
https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L601:L604
in that block of code it looks if the column exists, if it doesn't it adds it, so the query below should never fail to find the column.
That is a symptom that there could be some other issue with the database, but I would ask you to copy the code and execute it manually in your database to see if you are getting some error with that SQL: https://github.com/tsolucio/corebos/blob/master/modules/Users/Users.php#L603
ALTER TABLE `vtiger_users` ADD `change_password` boolean NOT NULL DEFAULT 0
Joe
TSolucio
TSolucio