[Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry

[nobody]

=================== BUG #3162: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3162&group_id=509

Changes by: Ralf Becker <address@hidden>
Date: Mon 04/14/2003 at 23:24 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This has been corrected in CVS.

To grab a complete update of all fixes:

1)  Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite 
distro.

2)  Then just type:
    'cd <your phpgroupware dir>; cvs update -dP'.

You can do step 2 as many times in a day as you wish, and 
will always get the most current bug fixes.

Thanks,




=================== BUG #3162: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Wed 04/09/2003 at 12:59
Category:  calendar                   Bug Group:  0.9.14.002 release        
Severity:  5 - Major                  Priority:  High                       
Resolution:  Fixed                    Assigned to:  ralfbecker              
Status:  Closed                       Component Version:  TGZ               
Platform Version:  None               Reproducibility:  Every Time          

Summary:  Impossible to create a calendar entry

Original Submission:  When creating a new entry the following message is 
returned:

Database error: Invalid SQL: UPDATE phpgw_cal SET owner=4, datetime=1049835600, 
mdatetime=1049881969, edatetime=1049835600, priority=2, category='', 
cal_type='E', is_public=1, title='test', description='', location='', 
reference=0 WHERE cal_id=
MySQL Error: 1064 (You have an error in your SQL syntax near '' at line 1)

File:[..]/htdocs/phpgroupware/calendar/inc/class.socalendar_sql.inc.php
Line: 491

Session halted.



Follow-up Comments
*******************

-------------------------------------------------------
Date: Mon 04/14/2003 at 23:24       By: ralfbecker
This has been corrected in CVS.

To grab a complete update of all fixes:

1)  Check to see if you have cvs installed: 'cvs --help'.
1a) If not, install a copy of cvs-cli from your favorite 
distro.

2)  Then just type:
    'cd <your phpgroupware dir>; cvs update -dP'.

You can do step 2 as many times in a day as you wish, and 
will always get the most current bug fixes.

Thanks,


-------------------------------------------------------
Date: Mon 04/14/2003 at 13:24       By: None
I took a short look at the code and found the reason:
In line 456 the calendar entry is created with a temporary title and in the 
following code this title is used to get the cal_id. In my configuration, this 
field was to short to hold the hole $temp_name so the cal_id could not be 
returned.

Solution:
I changed the field (phpggw_cal.title) from varchar(80) to varchar(128). This 
seems to work so far - do I have to consider anything else?

thanks for your toil
Andreas - http://www.swift-consult.de

-------------------------------------------------------
Date: Mon 04/14/2003 at 12:34       By: None
I start the calendar, klick (+) of any day, fill in a title and submit the 
page. 
The error is permanent and can always be reproduced.
The same occurs, if I first open a day and click on a time to add a new entry.

-------------------------------------------------------
Date: Fri 04/11/2003 at 11:59       By: ralfbecker
What are u doing to create the bug, which steps lead to it?
Can u reproduce it always or only under certain circumstances?

-------------------------------------------------------
Date: Thu 04/10/2003 at 09:38       By: None
register_globals is on
modified ReadHat Linux with 2.4.?? Kernel
Apache 1.3 (modified?) with latest patches
PHP 4.2.3  
mySQL 3.23.54

Since I don't have direct access to the server (it is controlled by our ISP) I 
unfortunately don't have more exactly Information about the Linux and Apache 
versions.
Hope that helps anyway. 
Thanks in advance.
Andreas

-------------------------------------------------------
Date: Thu 04/10/2003 at 00:35       By: ralfbecker
To be able to fix a bug I need to know what leeds to that bug, and how I can 
reproduce it and your php-version.
Btw. this bug looks like it could be caused by register globals set to off in 
your php.ini. 

-------------------------------------------------------
Date: Wed 04/09/2003 at 13:57       By: skwashd
do you have register_globals = on in your php.ini?  It must be on for some apps 
to function properly.  Try making the change, restart apache and let us know.  
Also letting us know the OS/disro and version of apache, php and mysql that run 
on this box will help us with diagnosing this problem.

Cheers


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3162&group_id=509