Hi Abhi, The problem looks like it's an InnoDB vs MyISAM table compatibility issue. Your older database was likely created using MyISAM, and is now trying to upgrade using InnoDB.
You'll need to either convert your existing tables to InnoDB, or set MySQL to use MyISAM by default. InnoDB is better for Review Board, though, so that's the recommendation. You'll also want to repeat the upgrade again from a backup. (Did you take a backup before upgrading?) Christian -- Christian Hammond President/CEO of Beanbag <https://www.beanbaginc.com/> Makers of Review Board <https://www.reviewboard.org/> On Mon, Jul 25, 2016 at 5:10 AM, Abhishek Choudhary <xabh...@gmail.com> wrote: > Hi, > > > I am trying to upgrade my ReviewBoard setup from v1.5.1 to v2.5.6.1 and > saw below error when I tried to install site using rb-site but connected to > my old database. > > > Do i have start afresh with database as well? Is there an easy workaround? > > > >rb-site install --debug ~/reviewboard/site > > ... > > Creating table attachments_fileattachmenthistory > > Creating table attachments_fileattachment > > > > [!] There was an error synchronizing the database. Make sure the > > database is created and has the appropriate permissions, and then > > continue. > > [!] Details: (1005, "Can't create table 'reviewboard.#sql-280a_6' > > (errno: 150)") > > > > Press Enter to continue > > Creating tables ... > > Creating table diffviewer_filediffdata > > Creating table diffviewer_rawfilediffdata > > Creating table hostingsvcs_hostingserviceaccount > > Creating table notifications_webhooktarget_repositories > > > > [!] There was an error synchronizing the database. Make sure the > > database is created and has the appropriate permissions, and then > > continue. > > [!] Details: (1005, "Can't create table 'reviewboard.#sql-280a_6' > > (errno: 150)") > > > > Press Enter to continue > > Creating tables ... > > Creating table notifications_webhooktarget > > Creating table reviews_fileattachmentcomment > > Creating table site_localsite_users > > > > [!] There was an error synchronizing the database. Make sure the > > database is created and has the appropriate permissions, and then > > continue. > > [!] Details: (1005, "Can't create table 'reviewboard.#sql-280a_6' > > (errno: 150)") > > > > Press Enter to continue > > Creating tables ... > > Creating table site_localsite_admins > > > > [!] There was an error synchronizing the database. Make sure the > > database is created and has the appropriate permissions, and then > > continue. > > [!] Details: (1005, "Can't create table 'reviewboard.#sql-280a_6' > > (errno: 150)") > > > > Press Enter to continue > > Creating tables ... > > Creating table site_localsite > > Creating table webapi_webapitoken > > > > [!] There was an error synchronizing the database. Make sure the > > database is created and has the appropriate permissions, and then > > continue. > > [!] Details: (1005, "Can't create table 'reviewboard.#sql-280a_6' > > (errno: 150)") > > > > Press Enter to continue > > Creating tables ... > > Upgrading Review Board from 1.5.1 to 2.5.6.1 > > There are unapplied evolutions for auth. > > There are unapplied evolutions for contenttypes. > > There are unapplied evolutions for accounts. > > There are unapplied evolutions for attachments. > > There are unapplied evolutions for changedescs. > > There are unapplied evolutions for diffviewer. > > There are unapplied evolutions for hostingsvcs. > > There are unapplied evolutions for notifications. > > There are unapplied evolutions for reviews. > > There are unapplied evolutions for scmtools. > > There are unapplied evolutions for site. > > There are unapplied evolutions for webapi. > > Adding baseline version for new models > > Evolutions in attachments baseline: file_attachment_orig_filename, > file_attachment_file_max_length_512, file_attachment_repo_info, > file_attachment_repo_path_no_index, > file_attachment_repo_revision_max_length_64, file_attachment_revision > > Evolutions in hostingsvcs baseline: account_hosting_url, > account_hosting_url_max_length_255, account_unique_together_baseline > > Evolutions in site baseline: localsite_public > > Evolutions in webapi baseline: webapitoken_jsonfield_null > > Evolutions in notifications baseline: webhooktarget_extra_state, > webhooktarget_extra_data_null > > Project signature has changed - an evolution is required > > Installing custom SQL ... > > Installing indexes ... > > Installed 0 object(s) from 0 fixture(s) > > Registering new SCM Tool Plastic SCM > (reviewboard.scmtools.plastic.PlasticTool) in database > > OK > > ERROR:root:Unexpected error: u'FileDiffData' > > > > Thanks, > > Abhi > > > -- > 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 > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to reviewboard+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
