Error with 0.9.3 in MantisBT v1.2.20

This plugin allows you to report an issue in MantisBT by sending an email to a particular mail account

Moderators: Developer, Contributor

Post Reply
franksanabria
Posts: 10
Joined: Jun 01, 2015 3:39 pm
Location: Bogota
Contact:

Error with 0.9.3 in MantisBT v1.2.20

Post by franksanabria »

Hí, I did use EmailReporting v0.9.3DEV with out any problem, but, when I use EmailReporting_v0.9.3 I have this error (attached)

php --version
PHP 5.4.16 (cli) (built: Nov 6 2016 00:29:02)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies

MariaDB:
mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1

SO Versión:
CentOS Linux release 7.3.1611 (Core)
Attachments
a.png
a.png (86.04 KiB) Viewed 4409 times

SL-Gundam
Posts: 605
Joined: Jul 06, 2011 9:17 am

Re: Error with 0.9.3 in MantisBT v1.2.20

Post by SL-Gundam »

Try the following:

This file and line
https://github.com/mantisbt-plugins/Ema ... .php#L1534

Change

Code: Select all

. '( SELECT 1 FROM ' . db_get_table( 'bug' ) . ' B WHERE B.id = issue_id )';
to

Code: Select all

. '( SELECT 1 FROM ' . db_get_table( 'mantis_bug_table' ) . ' B WHERE B.id = issue_id )';
Please let me know whether or not this fixes the issue

This problem does not exist for MantisBT 1.3.x or 2.0.x so you might also consider upgrading your MantisBT installation

franksanabria
Posts: 10
Joined: Jun 01, 2015 3:39 pm
Location: Bogota
Contact:

Re: Error with 0.9.3 in MantisBT v1.2.20

Post by franksanabria »

Yes is the solution, thank you for you answere


Post Reply