Win a copy of Testing JavaScript Applications 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

An error has occurred in Admin Control Panel

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys,

i�ve the following issue.

it�s jforum 2.1.8 with postgres 8.3 running

but i get a error-message in the Admin Control Panel:

---
An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

java.sql.SQLException: FEHLER: Operator existiert nicht: timestamp without time zone integer
---

so i can�t see the the "Version Information", "Forum Statistics" and "Who is online"

apart from that jforum is running very well, if i install it with a mysql-database

do somebody know to solve this problem?

i would be delighted to get a answer


[originally posted on jforum.net by sechmolly]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
First, you need to look at your application server logs to see more detailed information. However, since it says it's a SQL Exception and mentions a Timestamp error, I'll make a few guesses here.

Make sure your using the correct JDBC library for your version of PostGres. jForum uses prepared statements to access the DB. It's the JDBC driver's responsibility to convert a Java Date object to the correct SQL format for your DB server. Date handling is one place that many servers are making syntax changes to become more SQL standards compliant. Old JDBC drivers may not match the new server standards (and vice versa).

It could also be that there is a version specific problem with the table creation scripts (column type defined wrong and the like). Sometimes this can be related to Database/Table default settings that need to be overridden at a column level. (e.g., defining that a timestamp field should use the server Timezone.)

It might also be that one or more SQL queries are not correct for your DB version. The log file should give more indication about where the error is occuring. This can be used to track it down to the query defined in the postgres.sql or generic.sql config files.
[originally posted on jforum.net by monroe]
 
    Bookmark Topic Watch Topic
  • New Topic