- edited description
ERROR: column "language" does not exist
We added a Listener and looks like it added it, but it does not show under listeners. So we cant modify any inline listeners! - Really need to figure that out since we need to change a bit of code in there. Please advise where we can fix this quickly without updating sql for now.
Following error shows when Restpoint links are selected:
An error occurred whilst rendering this message. Please contact the administrators, and inform them of this bug.
Details: ------- org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getAllEntities'
in class fr.gfi.jira.plugins.runner.action.PHPRunnerCustomRest
threw exception com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database: - name:PostgreSQL - version:9.3.15 - minor version:3 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.4.1212 org.postgresql.util.PSQLException:
ERROR: column "language" does not exist Position: 142
at fr.gfi.jira.plugins.runner:phprunner.admin.webwork//templates/phprunner/admin/php-custom-rest-list.vm[line 25, column 45]
at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:284)
Comments (28)
-
reporter -
reporter - edited description
-
reporter ok looks like we found the table that is used to run the inline scripts... now to reset the table! table: public AO_..._LISTENERS
-
reporter - changed title to ERROR: column "language" does not exist
-
reporter - edited description
-
repo owner Hi Zunair,
Could you share some screenshots of the Groovy Listenners page.
-
reporter Groovy Listener Page
-
repo owner Which version of Code runner is installed?
-
reporter Version: 2.2
-
reporter Groovy Rest Endpoint
-
repo owner Can you install v2.0, and see if that will help.
-
reporter On it, will get back to you asap.
-
reporter Sadly, same issue with 2.0... Posting the DB tables.. just incase - and as you can see there is data in listener table.
Thanks!
-
reporter Version
-
repo owner OK, i think postgres column name is case-sensitive, i will change the code and re-build the plugin for some tests.
-
repo owner - changed status to resolved
Fixing issue
#19→ <<cset 01ef2fc7c4a0>>
-
repo owner Could you please install the last version.
-
reporter I thought about column name.. but seems like all columns comes up as ucase in RazorSQL ui... Check the table creation code, make sure case match there.
Let me know if you like to remote in for any debugging.
-
reporter 2.2.1 did not fixed it...
-
reporter Listeners list is still blank... Tried creating a new listener, same language error but i see another error now
2018-07-10 18:25:53,597 https-jsse-nio-443-exec-5 WARN userid 1105x1655x1 mjoc3k ip... /secure/admin/GroovyRunnerListeners.jspa [c.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'com.softwareplant.util.system.SystemUnavailableException - System has not been initialized yet, cannot execute entryPoint:JIRA-UserPermissionCondition.'.
you can ignore this error. happens when inline code is run under console with just "Test" in it.
-
reporter - changed status to open
Not sure if you are getting notifications while issue is closed. So opening it.
Thanks
-
repo owner Yeah, i would like that, can we plan a teamviewer session @ 6pm - 7pm (Paris Time)
-
reporter Sounds great, I'll post the Id here at 6pm CEST/ 12pm EST, please copy it and delete the comment.
Please confirm about this session.
Thanks!
-
repo owner OK.
-
reporter Looks like the update didn't went through yesterday! All looks good after 2nd update - I wonder if the installer was cached!
Thanks a lot for quickly fixing this!
-
reporter - changed status to resolved
Quickly Fixed!
Thanks @souala_haithem
-
repo owner Cool :)
-
repo owner - changed status to closed
- Log in to comment