phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: nobody
Subject: [Phpgroupware-tracker] [Bug #897] Search for comic SQL error
Date: Wed, 24 Jul 2002 01:15:23 -0400

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

Submitted by: kbridger                  Project: phpGroupWare                   
Submitted on: 2002-Jul-24 05:15
Category:  comic                        Bug Group:  devel cvs                   
Severity:  5 - Major                    Priority:  Normal                       
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Platform Version:  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



No Followups Have Been Posted




No files currently attached


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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]