Email Reporting install error (APPLICATION ERROR #2503)

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

Moderators: Developer, Contributor

Post Reply
daisukepr
Posts: 12
Joined: Jan 14, 2015 3:45 pm

Email Reporting install error (APPLICATION ERROR #2503)

Post by daisukepr » Jan 14, 2015 4:17 pm

I'm running into an issue with this installation. I've just installed MantisBT Core 1.2.18 for the first time, then loaded the files for "Email Reporting 0.9.0-DEV" into the plugin folder, clicked install via the plugin Mantis page, and got the following error: APPLICATION ERROR #2503 Upgrading the plugin schema failed in block #0.

I've read this could be because the user doesn't have write table permissions, but I've validated that the user has full permissions and an admin check (...mantisbt/admin/check.php) shows everything running fine.

After the installation attempt, I go back to the plugins page and see it needs to be upgraded. Clicking upgrade yields the same error.

Can you help with this plugin installation issue?

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

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by SL-Gundam » Jan 15, 2015 2:15 pm

Just to be sure

The admin check does not check access rights on the database.
The admin install/upgrade allows for the filling in of admin username and password. Plugin installation will always happen using the current set user in the config_inc.php. So you need to make sure MantisBT is completely running under a user account with enough access rights to perform create and alter sql statements

Please verify this

daisukepr
Posts: 12
Joined: Jan 14, 2015 3:45 pm

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by daisukepr » Jan 15, 2015 2:28 pm

I can confirm that the config_inc.php file reflects a user with full db access. A table was even created in the db called "mantis_plugin_EmailReporting_msgids_table". I have no other issues with Mantis; just the plugin.

daisukepr
Posts: 12
Joined: Jan 14, 2015 3:45 pm

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by daisukepr » Jan 15, 2015 2:49 pm

Not sure if it helps at all, but I'm using GoDaddy hosting and am running MySQL. My goal was to have a form on the website (currently using a Wordpress theme) that could create a new ticket and assign to myself whenever it was filled out. I figured I'd do this by triggering an email from the form, that creates the ticket. I've triple checked that the DB user has "ALL PRIVILEGES" and all other data seems fine. I had no trouble installing/configuring MantisBT either.

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

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by SL-Gundam » Jan 15, 2015 5:59 pm

Thanks i know what went wrong.

This is an issue which should only affect new installations. Problem is that once it has occurred, it is very hard to correct without user intervention. Could you please remove said table and then perform the upgrade

https://github.com/mantisbt-plugins/Ema ... ebdbd34f54
Last edited by SL-Gundam on Sep 20, 2017 8:24 pm, edited 1 time in total.

daisukepr
Posts: 12
Joined: Jan 14, 2015 3:45 pm

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by daisukepr » Jan 15, 2015 6:05 pm

That worked perfectly! I appreciate your help, SL-Gundam!

Ancy
Posts: 46
Joined: Jun 30, 2017 6:10 am

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by Ancy » Sep 11, 2017 4:00 am

Dear Both,

I am also experiencing the same when i am trying to install the plugin n productive server.Could you please correct me if i am wrong here.

1. Delete the table mantis_plugin_EmailReporting_msgids_table
2.Comment out the line 'plugin_config_set( 'reset_schema', 1 );'
And upgrade ?

Thanks in advance!!
Ancy

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

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by SL-Gundam » Sep 11, 2017 11:45 am

Here are the steps
  1. Make sure you're using the latest version of EmailReporting (0.10.0 stable got released a couple days ago)
  2. Delete the table mantis_plugin_EmailReporting_msgids_table
  3. On the MantisBT configuration page delete the configuration option: plugin_EmailReporting_schema
  4. Try to install or upgrade the EmailReporting plugin

Ancy
Posts: 46
Joined: Jun 30, 2017 6:10 am

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by Ancy » Sep 15, 2017 3:05 am

Dear Soul,

I have done above steps ,but this time, page went blank. And emails are sent to queue. Could you please help me?

DanoGeorge
Posts: 1
Joined: Jul 01, 2019 1:45 am

Re: Email Reporting install error (APPLICATION ERROR #2503)

Post by DanoGeorge » Jul 01, 2019 1:58 am

Hi,

Is there any way to fix this? I've just installed the latest MantisBT version and faced this error: APPLICATION ERROR #2503
Upgrading the plugin schema failed in block #0.
I'm sure it's somehow connected with the latest Windows 10 updates.
Has anyone used DISM or System Update Readiness tool to fix the issues caused by Windows 10 updates?
Documentation is easy to understand via essay agency

Post Reply