[Phpgroupware-tracker] [bugs #897] Search for comic SQL error

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #897] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Wed 07/14/2004 at 23:58 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Item Group | devel cvs                 | 0.9.16.000 release
          Resolution | None                      | Fixed
         Assigned to | None                      | skwashd
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This has been fixed in CVS and should be available in the next
release.






/**************************************************************************/
[bugs #897] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=897>
Project: phpGroupWare
Submitted by: Kirk Bridger
On: Wed 07/24/2002 at 05:15

Category:  comic
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  Fixed
Assigned to:  skwashd
Status:  Closed
Component Version:  None
Platform Version:  GNU/Linux - Debian
Reproducibility:  Every Time


Summary:  Search for comic SQL error

Original Submission:  Searching the comic database via administration:

Daily Comics -> Global Comics -> type word in search field at top.

Returns an SQL error, like so:

Database error: Invalid SQL: select * from phpgw_comic_data WHERE like 
'%dilbert%' order by data_title asc LIMIT 15

File: inc/comic_data.inc.php
Line: 126
Session halted. 

The problem is the SQL query does not specify a table to search through.  If I 
manually log into the database and query like so, it works:

select * from phpgw_comic_data WHERE data_title like '%dilbert%' order by 
data_title asc LIMIT 15

Follow-up Comments
------------------


-------------------------------------------------------
Date: Wed 07/14/2004 at 23:58       By: skwashd
This has been fixed in CVS and should be available in the next
release.

-------------------------------------------------------
Date: Wed 08/14/2002 at 08:09       By: chewy
Yup. It's something to do with $qfield not being passed properly. I've just 
downloaded the phpgroupware system, and noticed that myself. Trying to fix it.

Also, there was a problem with adding a new comic...
It said 'Error with SQL(Insert into phpgw_comic_data (comic_name) VALUES 
('whatever'))
This was easy to fix - the field name should be data_name rather than 
comic_name.
This is for rc4, rather than devel, but thought it might be useful.












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=897>

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