Mantis Bug Tracker - Forums

Mantis Version = 0.19.3
PHP = 5.05
MySQL = 5.0.15
IIS = 6.0
--------------
Upon submitting a new issue or updating an issue I get the following error. It will still allow the issue to be created/updated however.

What could cause this?

APPLICATION ERROR #401

Database query failed. Error received from database was #1054: Unknown column 'p.field_id' in 'on clause' for the query: SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value
FROM mantis_custom_field_project_table AS p, mantis_custom_field_table AS f
LEFT JOIN mantis_custom_field_string_table AS s
ON p.field_id=s.field_id AND s.bug_id='10'
WHERE p.project_id = '1' AND p.field_id = f.id
ORDER BY p.sequence ASC, f.name ASC

I'm having the same exact problem.
I just migrated the DB to a new server. Now when you go to update any existing bugs you get this error. It seems to take the change though.

Any help is appreciated.

Hello,

I was just wondering if you've had any luck with this error. I just updated to mantis 1.1.1 and got a very similar error when trying to update a bug:

APPLICATION ERROR #401

Database query failed. Error received from database was #1054: Unknown column 'target version' in 'field list' for the query: UPDATE mantis_bug_table
SET project_id='3'
reporter_id='94'
handler_id='79'
duplicate_id='0'
priority='40'
etc...

Thanks for any input!