[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry |
Date: |
Mon, 14 Apr 2003 17:24:55 -0400 |
=================== 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
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/09
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/09
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/09
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/10
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/11
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/14
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry, nobody, 2003/04/14
- [Phpgroupware-tracker] [Bug #3162] Impossible to create a calendar entry,
nobody <=