[moregroupware-tracker] [ moregroupware-Bugs-999234 ] Problem with Quoting module (PgSQL)

[SourceForge.net <no...@so...>]

Bugs item #999234, was opened at 2004-07-28 10:04
Message generated for change (Comment added) made by k-fish
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=999234&group_id=32034

Category: None
Group: 0.7.x
>Status: Pending
>Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Karsten Dambekalns (k-fish)
Summary: Problem with Quoting module (PgSQL)

Initial Comment:
System info:
mgw ver: 0.7.2 - Europe
os: linux (debian)
browser: Mozilla/5.0
database: PostgreSQL 7.4.2 on i386-pc-linux-gnu,
compiled by GCC i386-linux-gcc (GCC) 3.3.3 (Debian
20040401) (7.4.2)

Problem:
tried to create a new quote with a date in the future

Screen output:

Problem in Moregroupware found!
Version (config.inc.php):	0.7.2 - Europe
Version (version.inc.php):	0.7.2 - Europe
PHP version:	4.3.4
PHP OS:	Linux
register_globals:	0
magic_quotes_gpc:	0
safe_mode:	0
sql.safe_mode:	0
Server software:	Apache/1.3.29 (Debian GNU/Linux) PHP/4.3.4
User-Agent:	Mozilla/5.0 (Windows; U; Windows NT 5.0;
en-GB; rv:1.6) Gecko/20040113
session.use_trans_sid:	1
session.auto_start:	0
file_uploads:	1
upload_max_filesize:	2M
upload_tmp_dir:	
memory_limit:	8M
post_max_size:	8M
max_execution_time:	30
max_input_time:	-1
magic_quotes_runtime:	0
Database:	postgres7 / PostgreSQL 7.4.2 on
i386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC)
3.3.3 (Debian 20040401) (7.4.2)
Program:	/moregroupware/modules/quoting/index.php
File:
/home/moregroupware/modules/quoting/inc/quoting.class.php
Line:	570

Error (SQL):
UPDATE mgw_yb_quoting SET companyid = '0', custid =
'test1', lu_user = '6', notes = 'Data cleaning',
projectname = 'test1', targetdate = '20040730094600',
visible = '1', lastrevised = NOW() WHERE id='3'

Error (MSG):
ERROR: invalid input syntax for type timestamp:
"20040730094600"

Dump:
POST:

Array
(
)


GET:

Array
(
    [MGWSESSION] => 1be4779dbcdb5f28e5d85e9db390f585
    [mod] => quoting
    [id] => 3
    [action] => quote
    [mode] => save
    [quotenumber] => 3
    [loaded] => 1
    [custqnum] => test1
    [AddedYear] => 2004
    [AddedMonth] => 07
    [AddedDay] => 28
    [companyid] => 0
    [proname] => test1
    [TargetYear] => 2004
    [TargetMonth] => 07
    [TargetDay] => 30
    [TargetHour] => 09
    [TargetMinute] => 46
    [owneruserlist] => 6
    [quotedesc] => Data cleaning
    [quoteName] => 0
    [quoteHours] => 
    [approved] => 1
    [revised] => 
    [op] => Save Changes
)




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! 

----------------------------------------------------------------------

>Comment By: Karsten Dambekalns (k-fish)
Date: 2004-09-30 23:50

Message:
Logged In: YES 
user_id=105527

Should work now, please have a look (cannot test myself
right now).


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=999234&group_id=32034