org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
Issue #9
resolved
Just install that plugin. Got an error while viewing "Project Specific" tab in project. My test field is named in russian, maybe thats a problem?
2013-08-31 17:17:36,716 http-bio-127.0.0.1-8080-exec-25 ERROR shirokih 1037x2993x1 8ynyw3 xxxxx,127.0.0.1 /browse/TEST [webwork.util.ValueStack] query="/tabHtmlForJSON" {[id="null" type="5" values=""]} {[id="tabHtmlForJSON" type="8" values=""]}
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
...
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:8.4.16
- minor version:4
- major version:8
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.0 JDBC4 (build 801)
org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
Position: 108
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:153)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:81)
at sun.reflect.GeneratedMethodAccessor1202.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
...
at jira.plugin.projectspecificselectfield.ProjectSpecificSelectTab.getHtml(ProjectSpecificSelectTab.java:142)
at com.atlassian.jira.web.action.browser.BrowseProject.getTabHtml(BrowseProject.java:307)
at com.atlassian.jira.web.action.browser.BrowseProject.getTabHtmlForJSON(BrowseProject.java:276)
... 404 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist
Position: 108
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
...
Comments (8)
-
repo owner -
reporter "bug" is txt with stacktrace. jira 6.0.7 psql (8.4.16) addon Version: 1.2.2
i try to restrat jira after install. i got just blank screen while open tab
-
repo owner I guess, I run into a Postgresql-specific problem with order by in SQL statement of ActiveObject. Need to quote column name in order by. Will create a bugfix release next week. https://java.net/jira/browse/ACTIVEOBJECTS-73.
-
repo owner - changed milestone to 1.2.4
- edited description
-
repo owner - attached bug.txt
-
repo owner - changed milestone to 1.2.3
-
repo owner - changed status to resolved
New version 1.2.3 released incl. bugfix for this issue.
-
repo owner Another PostgreSQL error has been reported by another user as
#16.Please update to version 1.2.5 to get that bugfix.
Cheers, Holger
- Log in to comment
I am currently on travel with my iPad, therefore not able to open the attachment. Can you provide a little more about your environment? JIRA version, plugin version, stacktrace / sniplet from logfile etc.? Do you see a blank screen? Did you try to reboot?
Many thanks, Holger