3155: After Postgres and MySQL migration - reviewboard color and text alignments are messed up.

munsa*****@yaho***** (Google Code) (Is this you? Claim this profile.)
Dec. 10, 2013 
What version are you running?
1.7.16


What's the URL of the page containing the problem?
The page appeared but the color is plain and simple unlike the regular reviewboard color page (with BLACK, Light BLUE, etc.)

What steps will reproduce the problem?
1. Migrated old reviewboard that uses Postgres and to MySQL using MySQL WorkBench
2. After migration, I renamed the database to allow the new reviewboard site retrieve info from MySQL database (migrated database).
3. Restarted mysqld and httpd service

What is the expected output? What do you see instead?
Please see the attachments...
1. Expected result
2. Current result after migration

What operating system are you using? What browser?
OS Centos 6.4 and Browser Firefox


Please provide any additional information below.
Database migration was success using MySQL WorkBench which was named "reviewboard". "rbtraders_db" database was part of when I installed the newly reviewboard site named rbtraders.

Since I wanted rbtraders site to use the migrated database, I dropped rbtraders_db. And created an empty "rbtraders_db". I used "mysqldump reviewboard | mysql rbtraders_db" to copy every content on that database onto rbtraders_db.

Then, I restarted the service of both mysqld and httpd to ensure everything is fine. But the result was in the attached. I can login using the username and password stored in this database.

I hope you can help me out with this.

I sincerely appreciate for any assistance.
chipx86
#1 chipx86 
Did you run a 'rb-site upgrade' on the site after moving things around? It will need to rebuild the media directory.
  • +NeedInfo
#2 munsa*****@yaho***** (Google Code) (Is this you? Claim this profile.) 
I forgot to mention that. I also run that prior to posting the problem "rb-site upgrade /var/www/rbtraders" and the result was no error, all got reindexed.
chipx86
#3 chipx86 
Okay, well this is unrelated to the database. It's either a caching problem or the result of not running rb-site upgrade.

Did you move the site directory? Perhaps Apache files weren't updated?
#4 munsa*****@yaho***** (Google Code) (Is this you? Claim this profile.) 
Apache not needed to be updated. I will state this problem has been fixed. I found solution. And here are the steps:

1. After migration, the sites config still looks after the old site config. Rather changing the values directly from MySQL, I created a backup using mysqldump.

2. Once backup is created, opened the file using any text editor. And locate the table "siteconfig_siteconfiguration".

3. In this table, there are text values that points to old site and change it to the name of the new site. In my case, I replaced all values named "reviewboard" to "rbtraders".

4. And wallah... color problem fixed.

I have not gotten thru all forms but certain pages within reviewboard and I saw no plain text problem.
david
#5 david
  • -NeedInfo
    +SetupIssue