Mantis Bug Tracker - Forums

Hello:

I have a Mantis system that is working fairly well. It was initially installed on a workstation, and now that it works so well, we want to move it to a production server. A DBA recreated the bugtracker DB on the new server. The plan is to move the DB now, and move the application later. When I try and point to the new DB in the config file, I receive this error:
Database query failed. Error received from database was #515: The statement has been terminated. for the query:
INSERT INTO mantis_tokens_table
( type, value, timestamp, expiry, owner )
VALUES ( '4', '1', '2009-06-16 16:01:11', '2009-06-16 16:06:11', '1' ).
I looked for information on the tokens table, and did not find much. It would be good to have a Data Dictionary with basic information on tables.In this case, I would like to know, What is the purpose of the tokens table (and of course, how to fix the insert problem)?

Thanks,

Tim

I'm having exactly the same problem moving to a server deployment:

Mantis 1.1.8
MSSQL 2005
PHP 5.2.10
IIS 6

Any suggestions...?

Same Problem here:

Database query failed. Error received from database was #515: Die Anweisung wurde beendet. for the query: INSERT INTO mantis_tokens_table
( type, value, timestamp, expiry, owner )
VALUES ( '4', '1', '2009-11-27 07:41:43', '2009-11-27 07:46:43', '3' )

Its a String/Datetime converting error.

If i change the Datatime to

INSERT INTO mantis_tokens_table ( type, value, timestamp, expiry, owner ) VALUES ( '4', '1', '2009-27-11 07:41:43', '2009-27-11 07:46:43', '3' )

everything is fine.

Any ideas?

Cheerz Mirandus

Same error here:

Database query failed. Error received from database was #515: Die Anweisung wurde beendet. for the query:
INSERT INTO mantis_tokens_table ( type, value, timestamp, expiry, owner ) VALUES ( '4', '1', '2009-11-27 07:41:43', '2009-11-27 07:46:43', '3' )

Its a String/Datetime converting error. If i change the datetime to

INSERT INTO mantis_tokens_table ( type, value, timestamp, expiry, owner ) VALUES ( '4', '1', '2009-27-11 07:41:43', '2009-27-11 07:46:43', '3' )

everthing works fine!

Cheerz Mirandus