Search found 282 matches: mssql

Searched query: +mssql

by Phroobar
18 May 2023, 18:14
Forum: General Discussion
Topic: Connecting with odbc18 and multisubnetfailover
Replies: 5
Views: 21102

Connecting with odbc18 and multisubnetfailover

At my office we use Mantis to track business related issues. We have moved the database to MSSQL 2019. We are currently getting [microsoft][odbc driver 13]Login timeout expired. I need Mantis to use ODBC18 with multisubnetfailover=YES. What do I need to do to make this happen. I am not a PHP developer.
by Kölschtiroler
14 Mar 2023, 13:49
Forum: Help
Topic: time_tracking_with_billing does not show extra field
Replies: 3
Views: 2696

time_tracking_with_billing does not show extra field

Hi,
we are just trying to start with mantis (actuel version on MSSQL).
We enabled timetracking in configuration reports - database config:
time_tracking_enabled
time_tracking_stopwatch
time_tracking_with_billing

First 2 entries work fine but time_tracking_with_billing does not show any extra field ...
by Phroobar
15 Dec 2022, 14:54
Forum: Help
Topic: windows AD user login
Replies: 5
Views: 9434

Re: windows AD user login

MSSQL.
by cas
14 Dec 2022, 12:49
Forum: Help
Topic: windows AD user login
Replies: 5
Views: 9434

Re: windows AD user login

Whatever the Database is that you are using. Are you using Postgres. MySql/Mariadb or MSSQL?
by kenny.yc.chen
19 Oct 2021, 03:25
Forum: General Discussion
Topic: I can not download my attachments when I moved them from basedata to disk by system_utils.php
Replies: 0
Views: 23392

I can not download my attachments when I moved them from basedata to disk by system_utils.php

Hi all

I have a question..

When I Update Mantis from 2.10.0 to 2.25.2, and my DB is MSSQL

I tried use system_utils.php to move my attachments.

But when I finished the move, I could not load the old attachments...(but when I upload a new attachment will be worked...)

I already setting the config ...
by TerranceM
20 Apr 2020, 19:49
Forum: General Discussion
Topic: Migration Mysql to MSSQL
Replies: 2
Views: 7198

Re: Migration Mysql to MSSQL

Download and install the MySQL ODBC Connector.
Open your ODBC Data Source Administrator from the Control Panel -> Administrative Tools. On the System, DSN tab click 'Add', browse the 'MySQL ODBC driver' and click 'Finish'.
In the next dialog enter your MySQL server connection details, test it and ...
by TerranceM
24 Mar 2020, 19:25
Forum: General Discussion
Topic: Migration Mysql to MSSQL
Replies: 2
Views: 7198

Re: Migration Mysql to MSSQL

Follow the steps for the Mysql to MSSQL migration.

https://www.sqlshack.com/migrate-mysql- ... ssma-ssis/
by vmungar
26 Feb 2020, 06:39
Forum: Customizations
Topic: Migration Mysql to MSSQL
Replies: 1
Views: 5414

Migration Mysql to MSSQL

PFB more details of the encoding issue that we faced during the migration.

• The old mantis database was on Mysql and the new migrated database is SQL
server. This was done for better integration of mantis with timesheet.
o All data has been migrated as per the migration report generated
o However ...
by vmungar
19 Feb 2020, 06:00
Forum: General Discussion
Topic: Migration Mysql to MSSQL
Replies: 2
Views: 7198

Migration Mysql to MSSQL

PFB more details of the encoding issue that we faced during the migration.

• The old mantis database was on Mysql and the new migrated database is SQL
server. This was done for better integration of mantis with timesheet.
o All data has been migrated as per the migration report generated
o However ...
by Benji89
02 Sep 2019, 14:31
Forum: Help
Topic: Black icons at status
Replies: 3
Views: 6169

Black icons at status

... C9D8FF', # indigo
'closed' => '#e8e8e8'); # light gray

But still remains black,

If anyone has a suggestion on how to fix this issue without having to do a complete reinstall of MantisBT would be appricated.

Info on installation
Windows Server with IIS
PHP 7.3.7
MSSQL 2017

Kind regards,
Ben
by Dormelchen
29 Jul 2019, 08:04
Forum: Help
Topic: Mantis 1.0.8 Upgrade to 1.18 problem
Replies: 2
Views: 2286

Re: Mantis 1.0.8 Upgrade to 1.18 problem

... compatible with Mantis versions 1.1.8 to 1.2.16."

But when i want to upgrade i got the error:

Could not find stored procedure 'DESCRIBE'. für die Abfrage: DESCRIBE mantis_project_table

It is an Windows Server with Mantis and MSSQL Server

Any other Chance to upgrade Mantis to another Version ?
by atrol
11 Jul 2019, 18:57
Forum: Help
Topic: Mantis 1.0.8 Upgrade to 1.18 problem
Replies: 2
Views: 2286

Re: Mantis 1.0.8 Upgrade to 1.18 problem

... Atlassian user listening in this forum.
I recommend to post in a Atlassian forum.

Upgrade 1.0.8 to 1.18 can become a pain, especially when using MSSQL
I don't expect there is a user listening who could help, but who knows ...

I am pretty sure that migrating from 1.18 to Atlassian is also a lot ...
by Dormelchen
11 Jul 2019, 09:47
Forum: Help
Topic: Mantis 1.0.8 Upgrade to 1.18 problem
Replies: 2
Views: 2286

Mantis 1.0.8 Upgrade to 1.18 problem

... So i read the guide
http://www.mantisbt.org/docs/master/en-US/Admin_Guide/html-desktop/#admin.install.upgrade

But when i want to upgrade i got the error:

Could not find stored procedure 'DESCRIBE'. für die Abfrage: DESCRIBE mantis_project_table

It is an Windows Server with Mantis and MSSQL Server
by cas
15 May 2019, 12:54
Forum: Help
Topic: install problem with mantis 2.20.0
Replies: 6
Views: 6727

Re: install problem with mantis 2.20.0

Install it locally using XAMPP which will eable you to demonstrate the functionality. Perhaps once convinced you can get MySQL loaded or MSSQL upgraded. :mrgreen: