org.postgresql.util.PSQLException: ERROR: column "option_value" does not exist

Issue #9 resolved
Алексей Широких created an issue

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)

  1. Holger Schimanski repo owner

    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

  2. Алексей Широких 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

  3. Holger Schimanski 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

  4. Log in to comment