bugphpGroupWare - Bugs: bug #3738, Database error: Invalid SQL:...

 
 

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

bug #3738: Database error: Invalid SQL: INSERT INTO phpgw_categories

Submitted by:  None
Submitted on:  Fri 23 May 2003 02:54:30 PM UTC  
 
Item Group: 0.9.14.003 releaseCategory: calendar
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: NoneOpen/Closed: Closed
Component Version: BZIP2Operating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Thu 29 May 2003 12:30:05 AM UTC, comment #2:

This has been fixed in CVS and should be available in the next
release.

Dave Hall <skwashd>
Project Administrator
Fri 23 May 2003 03:11:09 PM UTC, comment #1:

I've got similar error when updating a category:

Database error: Invalid SQL: UPDATE phpgw_categories SET cat_name='teste', cat_description='testes', cat_data='N;', cat_parent='', cat_access='public', cat_main=1, cat_level=0 WHERE cat_appname='calendar' AND cat_id=1
PostgreSQL Error: 1 (ERROR: pg_atoi: zero-length string )

File: /var/www/html/phpgroupware/phpgwapi/inc/class.categories.inc.php
Line: 629
Session halted.

Anonymous
Fri 23 May 2003 02:54:30 PM UTC, original submission:

The following is the error message one gets when saving a new category:

Database error: Invalid SQL: INSERT INTO phpgw_categories ( cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data,cat_main,cat_level) VALUES ( '','5','public','calendar','teste','teste','N;','','')
PostgreSQL Error: 1 (ERROR: pg_atoi: zero-length string )

File: /var/www/html/phpgroupware/phpgwapi/inc/class.categories.inc.php
Line: 514
Session halted.

NOTE: We have PostgreSQL 7.3.2

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):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 29 May 2003 12:30:05 AM UTCskwashdStatusNone=>(Error - Not Found)
  Open/ClosedOpen=>(Error - Not Found)

Back to the top


Powered by Savane 3.1-cleanup1