But now I have a problem with Updating from 0.19.2.
I had problems with the upgrade. I could fix them with one of the tips from the upgrading page:
But now I get this when I look upon a bug (below the bug-information itself, I think it regards user notes and some buttons):When upgrading from 0.19.2 to 1.0.0a1 I needed to change mantis_config_table columns config_id, project_id and user_id to be NOT NULL before the final SQL patch would apply (setting PRIMARY KEY).
Code: Select all
APPLICATION ERROR #401
Datenbankabfrage fehlgeschlagen. Die Reportmeldung lautet #1064: You have an error in your SQL syntax near '( mantis_project_table p LEFT JOIN mantis_project_user_list_table l ON p.id=l.pr' at line 3 für die Abfrage: SELECT DISTINCT u.id, u.username, u.realname, u.access_level as access_level, l.access_level as override
FROM mantis_user_table u LEFT JOIN
( mantis_project_table p LEFT JOIN mantis_project_user_list_table l ON p.id=l.project_id AND p.id = 1 )
ON l.user_id=u.id
WHERE ( ( p.view_state=50 AND u.access_level >= 90 )
OR ( l.access_level >= 55 AND l.user_id=u.id )
OR u.access_level>=90 )
AND u.enabled = 1
AND p.id = 1
Thanks in advance.