bugphpGroupWare - Bugs: bug #3162, Impossible to create a calendar...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #3162: Impossible to create a calendar entry

Submitted by:  None
Submitted on:  Wed 09 Apr 2003 10:59:23 AM UTC  
 
Item Group: 0.9.14.002 releaseCategory: calendar
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Invalid User ID <Invalid User ID>Open/Closed: Closed
Component Version: TGZOperating System: None
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Mon 14 Apr 2003 11:24:05 AM UTC, comment #4:

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

Anonymous
Mon 14 Apr 2003 10:34:07 AM UTC, comment #3:

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.

Anonymous
Thu 10 Apr 2003 07:38:49 AM UTC, comment #2:

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

Anonymous
Wed 09 Apr 2003 11:57:10 AM UTC, comment #1:

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

Dave Hall <skwashd>
Project Administrator
Wed 09 Apr 2003 10:59:23 AM UTC, 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.

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Wed 09 Apr 2003 11:57:10 AM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1