We are planning BioStar 2.5 hotfix release due to the 2 issues below during installation.
Issue 1
Error message "Error 206 : The filename or extension is too long." pops up with %temp% folder path during installation.
Workaround
1. Make a temp folder under C drive (ex : C\temp)
2. Go to Environment Variables
3. Change Value for Variables TEMP and TMP to the temp folder you made at step 1
Issue 2
BioStar is very slow based on MSSQL database users and sometimes configuration window pops up when clicking a button several times.
Reproduce
1. See if your database tables are created correctly in db-converter_DATE.log under C:\Program Files\BioStar 2(x64)\logs
2. If you see two tables are not created with below logs, you need to make two tables manually.
Error log
42000 [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
42S02 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "T_ZNDR" because it does not exist or you do not have permissions.
42000 [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
42S02 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "T_ZNCRD" because it does not exist or you do not have permissions.
Workaround
Run the query below and see if t_zndr and t_zncrd tables are created correctly.
CREATE TABLE T_ZNDR ( ZNUID INT NOT NULL, DRUID INT NOT NULL, PRIMARY KEY (ZNUID, DRUID) ) go ALTER TABLE T_ZNDR ADD CONSTRAINT R_DRIATZN FOREIGN KEY (DRUID) REFERENCES T_DR (DRUID) go ALTER TABLE T_ZNDR ADD CONSTRAINT R_ZNHASZNDR FOREIGN KEY (ZNUID) REFERENCES T_ZN (ZNUID) go CREATE TABLE T_ZNCRD ( ZNUID INT NOT NULL, CRDUID INT NOT NULL, PRIMARY KEY (ZNUID, CRDUID) ) go ALTER TABLE T_ZNCRD ADD CONSTRAINT R_CRDIATZN FOREIGN KEY (CRDUID) REFERENCES T_CRD (CRDUID) go ALTER TABLE T_ZNCRD ADD CONSTRAINT R_ZNHASZNCRD FOREIGN KEY (ZNUID) REFERENCES T_ZN (ZNUID) go
Our BioStar 2.5 hotfix which resolves those two installation issues is due for release by the end of January 2018.