Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

After upgrade 7.4 -> 7.10.1 JIRA fails with SQL error

zeramu June 26, 2018

Today we’ve upgraded from 7.4 to 7.10.1. We did everything as described in you upgrade manual.

When I enter the Kanban-board page (http://jira.goodcustomers.ru/secure/RapidBoard.jspa?projectKey=DEV&rapidView=2) I get an SQL error:

```

org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM customfieldvalue WHERE ISSUE=? ORDER BY UPDATED ASC, ID ASC (Unknown column 'UPDATED' in 'field list' Query is : SELECT ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM customfieldvalue WHERE ISSUE=10221 ORDER BY UPDATED ASC, ID ASC)

```

My setup is Linux + mysql (actually mariaDB 5.5.56).

2 answers

0 votes
zeramu June 26, 2018

Hi, @Yogesh Mude.

Thanks for you reply. Please do not get me wrong but I believe it is not a Mysql vs mariaDB compatibility issue.

Actually it looks like a column missing in a table.

0 votes
Yogesh Mude
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2018

Hi @zeramu

Have you checked Supported Platform before upgrading to Jira v7.10.1?

Yogesh Mude
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 26, 2018

Suggest an answer

Log in or Sign up to answer