Forum Home
Welcome to the new pyForum.org.
A message board system written in pure python using the web2py framework.
pyForum is sporting a new, completely re-designed interface and back-end
Download pyForum from https://bitbucket.org/speedbird/pyforum
Internal error At startup
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Thu, 29 May, 2014 - 09:01 AM

Hello I'm totally new to web2py.

I have a postgresql92-server running and accepting connection for web2py applications. The only application so far installed is PyForum. When opening the PyForum from "My Sites" I get an internal error.

Here's my Error log for PyForum

"OperationalError: no such table: auth_roles"
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Thu, 29 May, 2014 - 10:02 AM

Noted repeated errors in "/var/log/httpd-error.log" created by PyForum error.
__________________________________________________________
[Thu May 29 09:03:21 2014] [notice] Apache/2.2.27 (FreeBSD) mod_wsgi/3.4 Python/2.7.6 mod_ssl/2.2.27 OpenSSL/1.0.1e-freebsd DAV/2 configured --
[Thu May 29 09:03:53 2014] [notice] caught SIGTERM, shutting down
[Thu May 29 09:03:54 2014] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Thu May 29 09:03:54 2014] [notice] Digest: generating secret for digest authentication ...
[Thu May 29 09:03:54 2014] [notice] Digest: done
[Thu May 29 09:03:54 2014] [alert] (2)No such file or directory: mod_wsgi (pid=54291): Unable to change working directory to '/nonexistent'.
"
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Thu, 29 May, 2014 - 11:17 AM

From the Database servers syslog "/var/log/messages" I posted a snipet to show an Error.


May 29 10:57:33 db01 postgres[3009]: [4-40] order by
May 29 10:57:33 db01 postgres[3009]: [4-41] zfc.cat_sort,
May 29 10:57:33 db01 postgres[3009]: [4-42] zf.forum_sort
May 29 10:57:33 db01 postgres[3009]: [4-43]
May 29 10:57:38 db01 postgres[3024]: [4-1] ERROR: operator does not exist: boolean = integer at character 443
May 29 10:57:38 db01 postgres[3024]: [4-2] HINT: No operator matches the given name and argument type(s). You might need to add explicit type
May 29 10:57:38 db01 postgres[3024]: [4-3] STATEMENT:
May 29 10:57:38 db01 postgres[3024]: [4-4] select
May 29 10:57:38 db01 postgres[3024]: [4-5] zfc.id as cat_id,
May 29 10:57:38 db01 postgres[3024]: [4-6] zfc.cat_name,
May 29 10:57:38 db01 postgres[3024]: [4-7] zfc.cat_desc,
May 29 10:57:38 db01 postgres[3024]: [4-8] zfc.cat_visible_to,
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Thu, 29 May, 2014 - 11:19 AM

From the Database servers syslog "/var/log/messages" I posted a snipet to show an Error.


May 29 10:57:33 db01 postgres[3009]: [4-40] order by
May 29 10:57:33 db01 postgres[3009]: [4-41] zfc.cat_sort,
May 29 10:57:33 db01 postgres[3009]: [4-42] zf.forum_sort
May 29 10:57:33 db01 postgres[3009]: [4-43]
May 29 10:57:38 db01 postgres[3024]: [4-1] ERROR: operator does not exist: boolean = integer at character 443
May 29 10:57:38 db01 postgres[3024]: [4-2] HINT: No operator matches the given name and argument type(s). You might need to add explicit type
May 29 10:57:38 db01 postgres[3024]: [4-3] STATEMENT:
May 29 10:57:38 db01 postgres[3024]: [4-4] select
May 29 10:57:38 db01 postgres[3024]: [4-5] zfc.id as cat_id,
May 29 10:57:38 db01 postgres[3024]: [4-6] zfc.cat_name,
May 29 10:57:38 db01 postgres[3024]: [4-7] zfc.cat_desc,
May 29 10:57:38 db01 postgres[3024]: [4-8] zfc.cat_visible_to,
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Tue, 03 June, 2014 - 07:44 PM

Sorry for the double post. Hard problem eh!
By: user_266
Rank: Starfleet Ensign
Postings: 6
From: Unknown
Posted: Tue, 03 June, 2014 - 07:44 PM

Sorry for the double post. Hard problem eh!
Welcome
System Announcements
Latest Posts
Support pyForum