#2291 Error using postgresql 8.3.3 (3)
--End of report
--Hope this helps, thanks
Problem in Moregroupware found!
Version (config.inc.php): 0.7.4 - not2early
Version (version.inc.php): 0.7.4 - not2early
PHP version: 5.2.4-2ubuntu5.3
PHP OS: Linux
register_globals: 0
magic_quotes_gpc: 1
safe_mode: 0
sql.safe_mode: 0
Server software: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/0.3.154.9 Safari/525.19
session.use_trans_sid: 0
session.auto_start: 0
file_uploads: 1
upload_max_filesize: 2M
upload_tmp_dir:
memory_limit: 16M
post_max_size: 8M
max_execution_time: 30
max_input_time: 60
magic_quotes_runtime: 0
Database: postgres7 / PostgreSQL 8.3.3 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7) (8.3.3)
Program: /moregroupware/modules/todo/index.php
File: /var/www/moregroupware/modules/todo/inc/todo.class.php
Line: 385
Error (SQL):
SELECT a.*, c.title, b.lastname, b.firstname FROM mgw_todo a LEFT JOIN mgw_users b ON a.owner = b.id LEFT OUTER JOIN mgw_projects c ON c.project_id = a.projectid WHERE a.userid=1 AND a.status<>4 AND a.status<>6 ORDER BY enddate asc
Error (MSG):
ERROR: operator does not exist: character varying <> integer LINE 1: ...ect_id = a.projectid WHERE a.userid=1 AND a.status<>4 AND a.... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Dump:
POST:
Array
(
)
GET:
Array
(
)
Please report this error to our Bugtracker on sourceforge.net. Make sure to include the complete output on this screen into the bug report, along with a description of the steps that led to the error. Thanks for using moregroupware!