Hi,
I am trying to take backup my reviewboard server but after restore command
reviewboard giving database error.
backup from one machine: Reviewboard version 2.0.18
mysqldump -u [user] -p [database_name] > [filename].sql
Restore to another machine; Reviewboard version 3.0
mysql -u [new_user] -p [database_name] < [file_name].sql
[root@localhost Rajoria]# systemctl status httpd.service
â httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled)
Drop-In: /usr/lib/systemd/system/httpd.service.d
ââreviewboard-sites.conf
Active: failed (Result: exit-code) since Thu 2018-05-31 18:43:20 IST;
3min 14s ago
Process: 5021 ExecStartPre=/usr/bin/rb-site upgrade --all-sites
(code=exited, status=1/FAILURE)
Main PID: 1939 (code=exited, status=0/SUCCESS)
May 31 18:43:20 localhost.localdomain rb-site[5021]: Installed 0 object(s)
from 0 fixture(s)
May 31 18:43:20 localhost.localdomain rb-site[5021]: This may take a while.
Please be patient, and do not cancel the upgrade!
May 31 18:43:20 localhost.localdomain rb-site[5021]: Applying database
evolutions for accounts...
May 31 18:43:20 localhost.localdomain rb-site[5021]: Database evolutions
for accounts failed!
May 31 18:43:20 localhost.localdomain rb-site[5021]: The SQL statement was:
ALTER TABLE `accounts_profile` ADD COLUMN `settings` longtext NULL;
May 31 18:43:20 localhost.localdomain rb-site[5021]: The database error
was: (1060, "Duplicate column name 'settings'")
May 31 18:43:20 localhost.localdomain systemd[1]: httpd.service: control
process exited, code=exited status=1
May 31 18:43:20 localhost.localdomain systemd[1]: Failed to start The
Apache HTTP Server.
May 31 18:43:20 localhost.localdomain systemd[1]: Unit httpd.service
entered failed state.
May 31 18:43:20 localhost.localdomain systemd[1]: httpd.service failed.
Please guide us. what table we need to update.
Thanks & Regrads,
Lokesh
--
Supercharge your Review Board with Power Pack:
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons:
https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
"Review Board Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
