Moving Mantis from a Workstation to a Server

[tikeIII]

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

[bigstu]

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...?

[Mirandus]

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

[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