Hi David, No, I dropped the 4.0.12 empty database and imported a dump of 3.0.18
*3.0.18 source:* mysqldump -h localhost -u root -p -d reviewboard > /tmp/reviewboard.sql scp to destination *4.0.12 destination:* sudo mysql -h localhost -u root -p mysql> DROP DATABASE reviewboard; Query OK, 82 rows affected (0.26 sec) mysql> CREATE DATABASE reviewboard; Query OK, 1 row affected (0.00 sec) mysql> quit Bye sudo mysql -h localhost -u root -p reviewboard < /tmp/reviewboard.sql mysql> USE reviewboard; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SHOW TABLES; +------------------------------------------------------+ | Tables_in_reviewboard | +------------------------------------------------------+ | accounts_localsiteprofile | | accounts_profile | | accounts_profile_starred_groups | | accounts_profile_starred_review_requests | | accounts_reviewrequestvisit | | accounts_trophy | | attachments_fileattachment | | attachments_fileattachmenthistory | | auth_group | | auth_group_permissions | | auth_permission | | auth_user | | auth_user_groups | | auth_user_user_permissions | | changedescs_changedescription | | corsheaders_corsmodel | | diffviewer_diffset | | diffviewer_diffsethistory | | diffviewer_filediff | | diffviewer_filediffdata | | diffviewer_rawfilediffdata | | django_admin_log | | django_content_type | | django_evolution | | django_project_version | | django_session | | django_site | | djblets_privacy_storedconsentdata | | extensions_registeredextension | | hostingsvcs_hostingserviceaccount | | integrations_integrationconfig | | notifications_webhooktarget | | notifications_webhooktarget_repositories | | oauth2_provider_accesstoken | | oauth2_provider_application | | oauth2_provider_grant | | oauth2_provider_refreshtoken | | reviewboard_oauth_application | | reviews_comment | | reviews_defaultreviewer | | reviews_defaultreviewer_groups | | reviews_defaultreviewer_people | | reviews_defaultreviewer_repository | | reviews_fileattachmentcomment | | reviews_generalcomment | | reviews_group | | reviews_group_users | | reviews_review | | reviews_review_comments | | reviews_review_file_attachment_comments | | reviews_review_general_comments | | reviews_review_screenshot_comments | | reviews_reviewrequest | | reviews_reviewrequest_changedescs | | reviews_reviewrequest_depends_on | | reviews_reviewrequest_file_attachment_histories | | reviews_reviewrequest_file_attachments | | reviews_reviewrequest_inactive_file_attachments | | reviews_reviewrequest_inactive_screenshots | | reviews_reviewrequest_screenshots | | reviews_reviewrequest_target_groups | | reviews_reviewrequest_target_people | | reviews_reviewrequestdraft | | reviews_reviewrequestdraft_depends_on | | reviews_reviewrequestdraft_file_attachments | | reviews_reviewrequestdraft_inactive_file_attachments | | reviews_reviewrequestdraft_inactive_screenshots | | reviews_reviewrequestdraft_screenshots | | reviews_reviewrequestdraft_target_groups | | reviews_reviewrequestdraft_target_people | | reviews_screenshot | | reviews_screenshotcomment | | reviews_statusupdate | | scmtools_repository | | scmtools_repository_review_groups | | scmtools_repository_users | | scmtools_tool | | site_localsite | | site_localsite_admins | | site_localsite_users | | siteconfig_siteconfiguration | | webapi_webapitoken | +------------------------------------------------------+ 82 rows in set (0.00 sec) Regards, Adam On Mon, 3 Apr 2023 at 00:47, David Trowbridge <[email protected]> wrote: > It sounds like perhaps you imported the data from a 3.0.18 database into > the database schema of 4.0.2 > > You'll want to drop the database entirely, import the dump, then run the > rb-site upgrade command. > > On Sun, Apr 2, 2023 at 1:11 PM Adam Weremczuk <[email protected]> > wrote: > >> Hello, >> >> I have a production server happily running: >> >> Debian 9.13 >> MySQL 5.7.31 >> Python 2.7.13 >> ReviewBoard 3.0.18 >> >> I have set up a new machine: >> >> Debian 9.13 >> MySQL 5.7.34 >> Python 2.7.13 >> ReviewBoard 4.0.12 >> >> and repeated the initial set up steps. The new site is blank, i.e. has no >> users' data. >> >> Then I moved the db across as well as the entire /var/www/rb.example.com >> directory. >> >> Now when I try an upgrade I get: >> >> rb-site upgrade /var/www/rb.example.com >> >> Traceback (most recent call last): >> File "/usr/local/bin/rb-site", line 8, in <module> >> sys.exit(main()) >> File >> "/usr/local/lib/python2.7/dist-packages/reviewboard/cmdline/rbsite.py", >> line 2995, in main >> command.run(site, options) >> File >> "/usr/local/lib/python2.7/dist-packages/reviewboard/cmdline/rbsite.py", >> line 2503, in run >> siteconfig = SiteConfiguration.objects.get_current() >> File >> "/usr/local/lib/python2.7/dist-packages/djblets/siteconfig/managers.py", >> line 42, in get_current >> return self.get_for_site_id(Site.objects.get_current().pk) >> File >> "/usr/local/lib/python2.7/dist-packages/django/contrib/sites/models.py", >> line 63, in get_current >> return self._get_site_by_id(site_id) >> File >> "/usr/local/lib/python2.7/dist-packages/django/contrib/sites/models.py", >> line 35, in _get_site_by_id >> site = self.get(pk=site_id) >> File >> "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py", line >> 85, in manager_method >> return getattr(self.get_queryset(), name)(*args, **kwargs) >> File >> "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py", line >> 380, in get >> self.model._meta.object_name >> django.contrib.sites.models.DoesNotExist: Site matching query does not >> exist. >> >> Please advise. >> >> Regards, >> Adam >> >> -- >> 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/reviewboard/CALC-DAHCBhJttHmOHVE4abUbjg3x7i81a8JP9QQ%2B_3kr74FLOA%40mail.gmail.com >> <https://groups.google.com/d/msgid/reviewboard/CALC-DAHCBhJttHmOHVE4abUbjg3x7i81a8JP9QQ%2B_3kr74FLOA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/reviewboard/CAFS3VNUNrmPpBsenQAe%3DduUU%2B1vPtDAkwpcv_jiBsU1LAY5rCA%40mail.gmail.com > <https://groups.google.com/d/msgid/reviewboard/CAFS3VNUNrmPpBsenQAe%3DduUU%2B1vPtDAkwpcv_jiBsU1LAY5rCA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/reviewboard/CALC-DAEPTWg_sQsLAVvSKOceed%2BO%2BQM2Jt-F1v7cbg44JmS1EQ%40mail.gmail.com.
