ERROR: column "language" does not exist

[Zunair Fayaz]

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) 

[Zunair Fayaz]

ok looks like we found the table that is used to run the inline scripts... now to reset the table! table: public AO_..._LISTENERS

[Haithem SOUALA]

Hi Zunair,

Could you share some screenshots of the Groovy Listenners page.

[Zunair Fayaz]

Groovy Listener Page

[Haithem SOUALA]

Which version of Code runner is installed?

[Zunair Fayaz]

Version: 2.2

[Zunair Fayaz]

Groovy Rest Endpoint

[Haithem SOUALA]

Can you install v2.0, and see if that will help.

[Zunair Fayaz]

On it, will get back to you asap.

[Zunair Fayaz]

Sadly, same issue with 2.0... Posting the DB tables.. just incase - and as you can see there is data in listener table.

Thanks!

[Zunair Fayaz]

Version

[Haithem SOUALA]

OK, i think postgres column name is case-sensitive, i will change the code and re-build the plugin for some tests.

[Haithem SOUALA]

Fixing issue #19

→ <<cset 01ef2fc7c4a0>>

[Haithem SOUALA]

Could you please install the last version.

[Zunair Fayaz]

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.

[Zunair Fayaz]

2.2.1 did not fixed it...

[Zunair Fayaz]

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.

[Zunair Fayaz]

Not sure if you are getting notifications while issue is closed. So opening it.

Thanks

[Haithem SOUALA]

Yeah, i would like that, can we plan a teamviewer session @ 6pm - 7pm (Paris Time)

[Zunair Fayaz]

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!

[Haithem SOUALA]

OK.

[Zunair Fayaz]

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!

[Zunair Fayaz]

Quickly Fixed!

Thanks @souala_haithem

[Haithem SOUALA]

Cool :)