Win a copy of React Cookbook: Recipes for Mastering the React Framework this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

First run on Firebird. Some good but then crashes. Help needed please.

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The first run crashed but at least some things look good.

The url was: http://localhost:8080/jforum/

First the good:

20:21:40,718 INFO [JForumBaseServlet ] Starting JForum. Debug mode is true
20:21:40,750 INFO [ConfigLoader ] Using cache engine: net.jforum.cache.DefaultCacheEngine
20:21:40,765 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BBCodeRepository
20:21:40,765 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RankingRepository
20:21:40,781 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SmiliesRepository
20:21:40,796 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.ForumRepository
20:21:40,812 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.TopicRepository
20:21:40,828 INFO [ConfigLoader ] Creating an instance of net.jforum.SessionFacade
20:21:40,828 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.PostRepository
20:21:40,828 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.Tpl
20:21:40,843 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RolesRepository
20:21:40,843 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SecurityRepository
20:21:40,859 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BanlistRepository
20:21:41,187 INFO [FileMonitor ] Watching C:\tomcat\webapps\jforum/WEB-INF/config/languages/en_US.properties
20:21:41,250 INFO [ConfigLoader ] Loading JDBC driver net.jforum.dao.firebird.FirebirdDataAccessDriver
20:21:41,515 INFO [FileMonitor ] Watching C:\tomcat\webapps\jforum/WEB-INF/config/database/generic/generic_queries.sql
20:21:41,515 INFO [FileMonitor ] Watching C:\tomcat\webapps\jforum/WEB-INF/config/database/firebird/firebird.sql
20:21:41,515 INFO [FileMonitor ] Watching C:\tomcat\webapps\jforum/WEB-INF/config/SystemGlobals.properties
20:21:42,140 INFO [MLog ] MLog clients using log4j logging.
20:21:42,312 INFO [C3P0Registry ] jdk1.5 management interfaces unavailable... JMX support disabled.

This is followed by:

java.lang.ClassNotFoundException: java.lang.management.ManagementFactory

Probably because of the jdk1.5 unavailable...

Then I get this:

20:21:42,312 INFO [C3P0Registry ] Initializing c3p0-0.9.1-pre9 [built 23-September-2006 01:47:24; debug? true; trace: 10]
20:21:42,500 INFO [AbstractPoolBackedDataSource] Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 120000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> fe0ce9, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.firebirdsql.jdbc.FBDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> fe0ce9, idleConnectionTestPeriod -> 3600, initialPoolSize -> 3, jdbcUrl -> jdbc:firebirdsql://127.0.0.1:3050/c:\Database\JFORUM.FDB?user=ADMIN&password=xyz26, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 180, usesTraditionalReflectiveProxies -> false ]
20:21:43,296 INFO [ConfigLoader ] Loading clickstream config from C:\tomcat\webapps\jforum/WEB-INF/config/clickstream-jforum.xml
20:21:43,671 ERROR [ExceptionWriter ] net.jforum.exceptions.DatabaseException: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)


So there is an SQL statement that is wrong. But I do not know which statement, it's NOT given.

Any ideas?

It must be one of the first SQL statements that is executed.



[originally posted on jforum.net by Infomedia]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think it is this SQL:

SELECT COUNT(pm.privmsgs_to_userid) AS private_messages,
u.*
FROM jforum_users u
LEFT JOIN jforum_privmsgs pm
ON pm.privmsgs_type = 1
AND pm.privmsgs_to_userid = u.user_id
WHERE u.user_id = 1
GROUP BY pm.privmsgs_to_userid
;


Will investigate.


[originally posted on jforum.net by Infomedia]
 
Our first order of business must be this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic