aspose file tools*
The moose likes JForum and the fly likes First run on Firebird. Some good but then crashes. Help needed please. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "First run on Firebird. Some good but then crashes. Help needed please." Watch "First run on Firebird. Some good but then crashes. Help needed please." New topic
Author

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

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: First run on Firebird. Some good but then crashes. Help needed please.