[Phpgroupware-tracker] [bug #6318] Problem updating a table with no data cols in class.so_sql.inc.php

[nobody]

=================== BUG #6318: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=6318&group_id=509

Submitted by: Caeies                  Project: phpGroupWare                 
Submitted on: Mon 11/03/03 at 13:02
Category:  eTemplates                 Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  Problem updating a table with no data cols in class.so_sql.inc.php

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__);

}

else

{

 /* 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.





No Followups Have Been Posted


CC list is empty


No files currently attached


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

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/