[CDash] CDash 2.6.0 to 3.0.3 upgrade, database not migrated?

[Zack Galbreath]

Hmm, that's a new one. But yes, based on the error messages you shared, it
looks like CDash somehow skipped the 2.8 schema upgrade. Apologies for the
manual hackery, but the following steps should get you beyond this problem.

   - From a MySQL prompt, run the following command:
      - UPDATE version SET major=2, minor=7, patch=0;
      - From a web browser, log into your CDash instance as an administrator
   - Click on "My CDash"
   - Click on "Maintenance"
   - Click on the "Upgrade CDash" button. This might take a while. You can
   keep an eye on what it's doing by running "SHOW PROCESSLIST;" in a MySQL
   prompt.

Let me know if your CDash instance is too messed up to complete the second
step of these instructions. If so, we'll brainstorm some other ways to
complete this upgrade.


On Wed, Mar 3, 2021 at 1:23 PM Sean McBride <sean at rogue-research.com> wrote:

> Zack,
>
> I've managed to install cdash 3.0.3 on a test server.
>
> I exported my production (mysql) database and imported it to my test
> server.  But lots of the cdash UI doesn't seem to work, showing blank
> pages, 500 errors, and other weirdness.  In the logs, I see things like:
>
> [2021-03-03 06:16:12] development.ERROR: Unknown column 'b.testduration'
> in 'field list' {"function":"pdo_error"}
>
> [2021-03-03 06:16:12] development.ERROR: SQL error: Unknown column
> 'b.testduration' in 'field list' {"function":"Index.php"}
>
> [2021-03-03 10:54:19] development.ERROR: SQLSTATE[42S22]: Column not
> found: 1054 Unknown column 'remember_token' in 'field list' (SQL: update
> `user` set `remember_token` = ************* where `id` = 5)
> {"userId":5,"exception":"[object]
> (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column
> not found: 1054 Unknown column 'remember_token' in 'field list' (SQL:
> update `user` set `remember_token` = ************* where `id` = 5) at
> /usr/local/etc/apache24/
> cdash.example.com/CDash/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669,
> Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column
> not found: 1054 Unknown column 'remember_token' in 'field list' at
> /usr/local/etc/apache24/
> cdash.example.com/CDash/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63,
> PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown
> column 'remember_token' in 'field list' at /usr/local/etc/apache24/
> cdash.example.com/CDash/vendo
>  r/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61)
>
> [2021-03-03 11:29:43] development.ERROR: Unknown column 'recheck' in
> 'field list'
>
> Does this maybe mean a 2.6 -> 3 database migration didn't happen?
>
> Thanks,
>
> Sean
>
>
> _______________________________________________
> CDash mailing list
> CDash at public.kitware.com
> https://public.kitware.com/mailman/listinfo/cdash
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://public.kitware.com/pipermail/cdash/attachments/20210305/92872cf1/attachment-0003.htm>