[moregroupware-tracker] [ moregroupware-Bugs-962779 ] Appointment Repetitions

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

Bugs item #962779, was opened at 2004-05-29 08:22
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=404018&aid=962779&group_id=32034

Category: Calendar
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Matthieu PAINEAU (leyeti)
Summary: Appointment Repetitions

Initial Comment:
Happens when an existing appointment is changed from 
being a single instance to (Appointment Repetitions - 
Works days)

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: 1 
safe_mode: 1 
sql.safe_mode: 0 
Server software: Apache 
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows 
NT 5.1; FunWebProducts; .NET CLR 1.1.4322) 
session.use_trans_sid: 0 
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: 60 
magic_quotes_runtime: 0 
Database: mysql / 4.0.18-log (4.0.18) 
Program: /moregroupware/modules/calendar/index.php 
File: /customers/cellbase.dk/cellbase.dk/httpd.www/more
groupware/modules/calendar/inc/calendar_func.inc.php 
Line: 742 

Error (SQL):
INSERT INTO mgw_calendar SELECT DISTINCT b.* FROM 
mgw_calendar_tmp a, mgw_calendar_tmp b WHERE a.id 
= AND a.userid = b.userid and ((a.id = b.id and 
a.dategroup_id = 0) OR (a.dategroup_id = 
b.dategroup_id and a.dategroup_id > 0))

Error (MSG):
You have an error in your SQL syntax. Check the manual 
that corresponds to your MySQL server version for the 
right syntax to use near 'AND a.userid = b.userid and 
((a.id = b.id and a.dategroup_id = 

Dump:
POST: 
Array
(
    [MGWSESSION] => 
0ee0d7fcc6b4cc1e00c443991a738fa1
    [date] => 1085983200
    [newtype] => 
    [start_day] => 31
    [start_month] => 05
    [start_year] => 2004
    [appointment_start] => 1085983200
    [appointment_end] => 1086012000
    [scheduling] => 0
    [id_appt_type] => 0
    [id_location_type] => 0
    [location] => 
    [availability] => 1
    [telephone] => 
    [subject_summ] => working
    [thema] => 
    [participants] => Array
        (
            [0] => 7
        )

    [external] => 
    [appointment_attribute] => 4
    [serial_end_day] => 31
    [serial_end_month] => 05
    [serial_end_year] => 2004
    [update] => Edit Appointment
    [id] => 25
)


GET: 
Array
(
)



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

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