bugphpGroupWare - Bugs: bug #6318, Problem updating a table with no...


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

bug #6318: Problem updating a table with no data cols in class.so_sql.inc.php

Submitted by:  Caeies <Caeies>
Submitted on:  Mon 03 Nov 2003 01:02:20 PM UTC  
Item Group: 0.9.16RC1Category: eTemplates
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: Caeies <Caeies>Open/Closed: Open
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Mon 03 Nov 2003 01:02:20 PM UTC, original submission:

Description :
When trying to update a record in a table that have no data cols (only key cols), the update failed.

Solution :
in the file etemplates/inc/class.so_sql.inc.php at line 332
just add a test against the $vals value:

if (!empty($vals))
$this->db->query($sql = "UPDATE $this->table_name SET $vals WHERE $keys",__LINE__,__FILE__);
/* No need to update :)*/

Seems working here, but I'm not sure that's there is no correlated bug.
Need to be tested against already made etemplate apps.

Caeies <Caeies>
Project AdministratorIn charge of this item.


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
Sun 06 Jun 2004 11:26:00 PM UTCskwashdAssigned toNone=>Caeies

Back to the top

Powered by Savane 3.1-cleanup1