View Issue Details

IDProjectCategoryView StatusLast Update
0019777mantisbtsignuppublic2015-06-07 12:30
Reportersinaei Assigned Toatrol  
PriorityhighSeveritycrashReproducibilityunable to reproduce
Status closedResolutionno change required 
Summary0019777: APPLICATION ERROR 0000401 for sign up new user
Description

Hi

I have installed new MantisBT on my pc, then I have import the databases that we had in other machine,

I faced with a lot of problem, but now my problem is about craeting new user
when I click on the sign up for a new user, and fill it, I see this message!

Database query failed. Error received from database was #1292: Incorrect datetime value: '1432735173' for column 'date_created' at row 1 for the query: INSERT INTO mantis_user_table
( username, email, password, date_created, last_visit,
enabled, access_level, login_count, cookie_string, realname )
VALUES
( ?, ?, ?, ?, ?,
?,?,?,?, ?).

What should I have to do?

TagsNo tags attached.

Activities

atrol

atrol

2015-05-27 11:59

developer   ~0050833

The version that you have installed and the version from where you imported the database must be the same.

If not, you have to upgrade the old database to the newer version, see [1] for it.

Does this fix your issue?

[1] https://www.mantisbt.org/docs/master-1.2.x/en/administration_guide.html#ADMIN.INSTALL.UPGRADE

sinaei

sinaei

2015-05-27 12:05

reporter   ~0050834

Thanks alot!
yes as I know they are not in the same version.
I will follow Upgrading part in the documentation.

So probably also this error is because of different version.
APPLICATION ERROR 0000401
Database query failed. Error received from database was #1054: Unknown column 'p.inherit_global' in 'field list' for the query: SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent
FROM mantis_project_table p
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = ?
ORDER BY p.name.

Regards,

atrol

atrol

2015-05-27 12:47

developer   ~0050835

So probably also this error is because of different version.
Yes