Page 1 of 1

Email Reporting install error (APPLICATION ERROR #2503)

Posted: 14 Jan 2015, 21:17
by daisukepr
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?

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

Posted: 15 Jan 2015, 19:15
by SL-Gundam
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

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

Posted: 15 Jan 2015, 19:28
by daisukepr
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.

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

Posted: 15 Jan 2015, 19:49
by daisukepr
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.

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

Posted: 15 Jan 2015, 22:59
by SL-Gundam
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

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

Posted: 15 Jan 2015, 23:05
by daisukepr
That worked perfectly! I appreciate your help, SL-Gundam!

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

Posted: 11 Sep 2017, 09:00
by Ancy
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

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

Posted: 11 Sep 2017, 16:45
by SL-Gundam
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

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

Posted: 15 Sep 2017, 08:05
by Ancy
Dear Soul,

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

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

Posted: 01 Jul 2019, 06:58
by DanoGeorge
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?