View Issue Details

IDProjectCategoryView StatusLast Update
0018008mantisbtdb mssqlpublic2015-01-26 12:02
Reporterjgreenhalgh Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Product Version1.2.18 
Summary0018008: Error 401 Without Log
Description

Hi
When i put a note a bug , i have a 401 error but i haven't any log on the scren
Best regards
JUlien

TagsNo tags attached.

Activities

atrol

atrol

2015-01-09 10:29

developer   ~0042126

jgreenhalgh,

I was not able to reproduce your problem with a fresh install of the latest stable version of MantisBT (1.2.18 at the moment).

Please provide detailed, step-by-step instructions to reproduce the issue. Additional information listed below may also be useful:

  • Exact version of MantisBT, PHP, Database, Web server and Operating System
  • Relevant customizations (e.g. changes in config_inc.php, etc)
  • Installed plugins or custom functions ?
  • Was the MantisBT source code modified in any way ?
jgreenhalgh

jgreenhalgh

2015-01-10 05:47

reporter   ~0042128

Hi
I have installed mantis on iis Windows 2012 SRV

  • sql server 2012

Mantis version 1.2.18 and 1.2.19dev master-1.2.x-559ba4e
Version du schéma 183

it's the same bug.

best regard julien

jgreenhalgh

jgreenhalgh

2015-01-10 05:47

reporter  

bugnote.png (49,565 bytes)   
bugnote.png (49,565 bytes)   
dregad

dregad

2015-01-10 18:12

developer   ~0042130

There are many known issues with SQL server support on Mantis 1.2.x. Would you be able to test if the problem also occurs with 1.3.0-beta.1 [1] ?

[1] Get it from https://mantisbt.org/download.php

jgreenhalgh

jgreenhalgh

2015-01-14 16:11

reporter   ~0042157

i want install a new version in beta but :

BAD
Database user does not have SELECT access to the database ( SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Nom d'objet 'mantis_config_table' non valide. )
checking ability to INSERT records BAD
Database user does not have INSERT access to the database ( SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Nom d'objet 'mantis_config_table' non valide. )
checking ability to UPDATE records BAD
Database user does not have UPDATE access to the database ( SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Nom d'objet 'mantis_config_table' non valide. )
checking ability to DELETE records BAD
Database user does not have DELETE access to the database ( SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Nom d'objet 'mantis_config_table' non valide. )

jgreenhalgh

jgreenhalgh

2015-01-14 16:17

reporter   ~0042158

Your database has not been created yet. Please create the database, then install the tables and data using the information above before proceeding.
The database is installed in sql server

other error : ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay INT DEFAULT 0 NOT NULL;

Msg 156, Niveau 15, État 1, Ligne 425
Syntaxe incorrecte vers le mot clé 'DEFAULT'.

when i want launch all requete in sql management studio

jgreenhalgh

jgreenhalgh

2015-01-14 16:18

reporter   ~0042159

BAD
ALTER TABLE mantis_user_pref_table ALTER COLUMN redirect_delay INT DEFAULT 0 NOT NULL
SQLState: 42000 Error Code: 156 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Syntaxe incorrecte vers le mot cl� 'DEFAULT'.

jgreenhalgh

jgreenhalgh

2015-01-14 16:19

reporter   ~0042160

syntaxe error on default

jgreenhalgh

jgreenhalgh

2015-01-26 12:02

reporter   ~0048695

Schema InsertData ( mantis_user_table ) BAD
INSERT INTO mantis_user_table(username, realname, email, password, date_created, last_visit, enabled, protected, access_level, login_count, lost_password_request_count, failed_login_count, cookie_string) VALUES ('administrator', '', 'root@localhost', '63a9f0ea7bb98050796b649e85481845', '2015-01-26 18:01:02', '2015-01-26 18:01:02', '1', '0', 90, 3, 0, 0, '9a3a148b652f45723f809334a413f383511550afd2981f5728492a9d52b4e4c4')
SQLState: 22007 Error Code: 242 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]La conversion d'un type de donn�es varchar en type de donn�es datetime a cr�� une valeur hors limites. SQLState: 01000 Error Code: 3621 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]L'instruction a �t� arr�t�e.

Issue History

Date Modified Username Field Change
2015-01-09 10:22 jgreenhalgh New Issue
2015-01-09 10:29 atrol Status new => feedback
2015-01-09 10:29 atrol Note Added: 0042126
2015-01-10 05:47 jgreenhalgh Note Added: 0042128
2015-01-10 05:47 jgreenhalgh Status feedback => new
2015-01-10 05:47 jgreenhalgh File Added: bugnote.png
2015-01-10 18:12 dregad Status new => feedback
2015-01-10 18:12 dregad Note Added: 0042130
2015-01-10 18:13 dregad Category reports => db mssql
2015-01-10 18:13 dregad Product Version => 1.2.18
2015-01-14 16:11 jgreenhalgh Note Added: 0042157
2015-01-14 16:11 jgreenhalgh Status feedback => new
2015-01-14 16:17 jgreenhalgh Note Added: 0042158
2015-01-14 16:18 jgreenhalgh Note Added: 0042159
2015-01-14 16:19 jgreenhalgh Note Added: 0042160
2015-01-26 12:02 jgreenhalgh Note Added: 0048695