OpenCATS icon indicating copy to clipboard operation
OpenCATS copied to clipboard

Published 20 hours ago • verified publisher icon opencats

upgrade to 0.9.6 doesn't create new database

Open RussH opened this issue 4 years ago • 4 comments

see https://forums.opencats.org/viewtopic.php?f=4&t=1724

RussH avatar May 14 '21 08:05 RussH

see here https://github.com/opencats/OpenCATS/commits/c68de3a312bebc9b3c230d8107eb671a3157f93d/modules/install/Schema.php

RussH avatar May 14 '21 08:05 RussH

should already be present https://github.com/opencats/OpenCATS/blob/2764566bcb37ebde9e87f9106e9defed3d7d7c0c/db/upgrade-0.9.4-0.9.5.sql

RussH avatar May 14 '21 12:05 RussH

Version 0.9.6 still has issue with empty candidate lists even after "upgrade" with "installation wizard"

Manual upgrade:

  1. Just in case backup your current database ("cats_dev" is a database name) sudo mysqldump -u root cats_dev > cats_dev__backup.sql
  2. Upgrade your current database using a file mentioned above sudo mysql -u root cats_dev < /var/www/html/opencats/db/upgrade-0.9.4-0.9.5.sql

xalt7x avatar Oct 05 '21 17:10 xalt7x

try selecting traditional instead of sql from the drop-down menu when your dumping a sql data.

sshheerr avatar Nov 03 '21 20:11 sshheerr