Thanks. I solved the above error using the following steps:
- Dumped the current rt4 db
mysqldump -u root -p"rootpassword" -R rt4 >rt4.sql - Created rt5 db:
mysqladmin -u root -p"rootpassword" create rt5 - Restored rt4 db to the new db
mysql -u root -p"rootpassword" rt5 < rt4.sql - Granted priviliges to rt_user on rt5 db
mysql -u root -p"rootpassword"
mysql>GRANT ALL PRIVILEGES ON rt5.* TO 'rt_user'@'localhost'; - Updated RT_Sight.pm config
Rerun the make upgrade-database, ran into a new error which solved in the thread;