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

[Migrated From Jforum.net]

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]

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]