You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 troubleshooting → Unable to fetch topic list
Since I updated to 1.2.14 on error appears when I try to use the news generator 
I enabled debug and gave me this msg:
An error was encountered
File: /usr/www/users/qwscen/forum/plugins/AP_News_Generator.php
Line: 96
PunBB reported: Unable to fetch topic list
Database reported: ERROR: function unix_timestamp("unknown") does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.You didn't have this error before?
Since the update didn't affect the database or the plugin, I'm curious why that would happen.
What database system are you using?
Database: PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC 2.96
Well, I don't know why it worked before: PostgreSQL doesn't support UNIX_TIMESTAMP.
This page may help you modify it to work:
http://www.raditha.com/postgres/timestamp.php
well, is someone able to rewrite a working PostgreSQL version of news generator? I´m not
On other thought came into my mind, is it possible to convert the complete PostgreSQL database into mysql ?
http://www.lightbox.ca/pg2mysql.php
I don't know how it is, you'll have to test it out
dont work Maybe the autor of the news generator should be ask for a postgre update?
OK, I realized something wrong.
The Error message apears but the output will be created.
So there should be a fix for that maybe?
Mmm?
PunBB Forums → PunBB 1.2 troubleshooting → Unable to fetch topic list
Powered by PunBB, supported by Informer Technologies, Inc.