Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-702

Statistics is not computed when a table is missing

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.21.0
    • None
    • None
    • None
    • 4.9.0 M7
    • Oui

      I have got this error :

      2025-02-13 05:00:33,247 ERROR [org.ametys.plugins.forms.content.table.FormTableManager] (AmetysRuntimeScheduler_Worker-6 Error while getting entries for table Forms_form3
      java.sql.SQLSyntaxErrorException: Table 'Ametys_CMS.Forms_form3' doesn't exist
          at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
          at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
          at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
          at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)
          at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
          at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
          at org.ametys.plugins.forms.content.table.FormTableManager.getTotalSubmissions(FormTableManager.java:726)
          at org.ametys.plugins.forms.statistics.ContentFormsStatisticsProvider.lambda$_getFormsSubmissions$0(ContentFormsStatisticsProvider.java:142)
          at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
          at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
          at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
          at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
          at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:575)
          at java.base/java.util.stream.AbstractPipeline.evaluateToArrayNode(AbstractPipeline.java:260)
          at java.base/java.util.stream.ReferencePipeline.toArray(ReferencePipeline.java:616)
          at java.base/java.util.stream.ReferencePipeline.toArray(ReferencePipeline.java:622)
          at java.base/java.util.stream.ReferencePipeline.toList(ReferencePipeline.java:627)
          at org.ametys.plugins.forms.statistics.ContentFormsStatisticsProvider._getFormsSubmissions(ContentFormsStatisticsProvider.java:151)
          at org.ametys.plugins.forms.statistics.ContentFormsStatisticsProvider.getStatistics(ContentFormsStatisticsProvider.java:64)
          at org.ametys.runtime.plugins.admin.statistics.StatisticsProviderExtensionPoint.computeStatistics(StatisticsProviderExtensionPoint.java:74)
          at org.ametys.runtime.plugins.admin.statistics.StatisticsSchedulable.execute(StatisticsSchedulable.java:63)
          at org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:151)
          at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
          at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

            raphael Raphaël Franchet
            ogehin Olivier Gehin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: