0 Replies Latest reply on Jul 3, 2015 12:12 AM by surabhimishra

    tables not created on plugin deployment

    surabhimishra

      HI,

       

      The idea plugin was not getting correctly deployed on my local setup so I deleted all the idea plugin tables from database.

      After deletion when I deploy the plugin again, the tables are not getting created according to schema.xml.

      After deployment when I click on content, it shows "An Unexpected error occurred" screen.

      Please help on how can I deploy the plugin.

       

      Error in the log:

      [http-bio-8080-exec-3] [1:admin:REGULAR] ERROR com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor - StatementCallback; bad SQL grammar [ SELECT stageID, stageName, stageBackgroundColor, stageForegroundColor, stageEnabled, stageDefault, votingEnabled, ideascount    FROM (SELECT jiveIdeaStage.stageid, jiveIdeaStage.stagename, jiveIdeaStage.stagebackgroundcolor, jiveIdeaStage.stageforegroundcolor, jiveIdeaStage.stageenabled, jiveIdeaStage.stagedefault, jiveIdeaStage.votingEnabled, COALESCE(jiveidea.ideascount, 0) AS ideascount FROM jiveIdeaStage LEFT JOIN ( SELECT jiveIdea.stageid, count(jiveIdea.stageid) AS ideascount FROM jiveIdea GROUP BY jiveIdea.stageid) jiveidea ON jiveIdeaStage.stageid = jiveidea.stageid) ideaStageView  WHERE stageEnabled = 1  ORDER BY stageName ASC]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "jiveideastage" does not exist

        Position: 400

       

      Thanks