I am not a PHP programmer, but I believe adding this at line 421 will resolve the issue:

if ($result.EOF) return $t_subquery_results;

Your fix helped me too, I was having a similar error.

I am also getting:

Database query failed. Error received from database was 0000209: Ambiguous column name 'id'. for the query: SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted FROM mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 1 ) ORDER BY id DESC, mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC.

(check the ORDER BY part)

This is when I click on "View Issues", did you get that as well?

I haven't received that error yet. This is a different problem altogether. A new issue should be opened for it.

It is clear that the ORDER BY clause needs to be fixed. It should say "mantis_bug_table.id DESC" rather than "id DESC"

My 2 cents: to really get the tags combo box fill in well:

while( $row = db_fetch_array( $result ) ) {
422

• $t_subquery_results[] = (int)$row;
  422
• $t_subquery_results[] = (int)$row['id'];
  423 423
  }

Can you retry with latest master-1.2.x from git ? I've applied a fix for bug 0013363 which should solve this problem as well.

I have tried with your patch too.
In fact, your patch correct an error when No tags are created.
If you create several tags,just the id=1 is displayed.
the $row gives an array, and not an integer, this array is converted into (1,1) ... the next query is false.

Got it, thanks. Can you resubmit the pull request on github or just attach a patch?

here is :
https://github.com/mantisbt/mantisbt/pull/18

i change the order for return the empty array in first

ps
(I have an account under mantisbt.org/bugs, with an hotmail.com email ... never received the activation URL (and email not put in junk folder)
jyperion is the same person as gcompagnon

Thanks! I started a discussion on the pull request.

I closed the 18

here is the correct (last) one:
https://github.com/mantisbt/mantisbt/pull/19

Cherry-picked to 1.2.x as well. Thanks!

Marking as 'acknowledged' not resolved/closed to track that change gets ported to master-2.0.x branch

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul