View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0026478mantisbtupgradepublic2019-12-18 05:002020-01-01 14:18
Reporterkeessonnema Assigned Toatrol  
PrioritynormalSeveritycrashReproducibilityhave not tried
Status closedResolutionno change required 
Product Version2.23.0 
Summary0026478: Upgraded to v2.23.0 on our acceptance installation, 0000401 application error
Description

I've installed the new v2.23.0 update on our acceptance installation.

  • I ran a composer install
  • I ran the installer (/admin/install.php)
  • I cleared the composer autoload cache

But when I want to visit a bug_view_page I get the following error:

APPLICATION ERROR #401

Database query failed. Error received from database was #1054: Unknown column 'bugnote_id' in 'field list' for the query: SELECT id, title, diskfile, filename, filesize, file_type, date_added, user_id, bugnote_id
FROM mantis_bug_file_table
WHERE bug_id=?
ORDER BY date_added.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

What could be the problem here?

EDIT [dregad] fix markdown

Additional Information

Updated from v2.22.0 to v2.23.0

TagsNo tags attached.

Activities

aban.zhou

aban.zhou

2019-12-18 05:44

reporter   ~0063303

I test here for demo anther guy work with you.
keessonnema

keessonnema

2019-12-18 05:53

reporter   ~0063304

@aban.zhou This website is not for testing. Could you please stop creating test issues here?
atrol

atrol

2019-12-18 05:56

developer   ~0063305

I assume you run the install script on the wrong database or there was a problem when running it.

E.g. see 0026468 0026465
keessonnema

keessonnema

2019-12-18 06:34

reporter   ~0063306

@atrol I am sure it's the correct database. It also shows 'GOOD' for each step. Could it perhaps be a strict-mode issue?
atrol

atrol

2019-12-18 07:54

developer   ~0063307

What's the result of the following query?

SELECT value FROM mantis_config_table WHERE config_id = 'database_version';

It should be 210
keessonnema

keessonnema

2019-12-18 08:58

reporter   ~0063308

Last edited: 2019-12-18 09:00

@atrol it returned 211
Edit: On my local installation it actually returned 210, so the acceptance installation is wrong. How do I fix this?
dregad

dregad

2019-12-18 11:18

developer   ~0063312

@keessonnema it is strange that your schema number would be higher than what we have defined in ours. Did you develop local changes / customizations ?

As for fixing the problem, not knowing what kind of schema changes were implemented locally, we can't really provide any help. You can try to compare a vanilla schema with the one in your acceptance system, to identify the changes made. Check also your local schema definition (admin/schema.php) for differences with the release file.
keessonnema

keessonnema

2019-12-19 03:18

reporter   ~0063319

@dregad Luckily our production installation is fine. I haven't done custom changes that affect the database schema, so it's a mystery for me aswell.
I will probably re-install the database for the acceptance as there's no data that we need.

I will run some tests to see what could have caused this.
atrol

atrol

2019-12-19 03:30

developer   ~0063321

Be aware that the database_version for your v2.22.0 system should be 209!
keessonnema

keessonnema

2019-12-19 03:32

reporter   ~0063322

@atrol Sure! Our production installation is on v2.22.0 and has db_schema version 209 :)