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, 14 Aug 2002 04:09:10 -0400

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

Changes by: Chewy <address@hidden>
Date: 2002-Aug-14 08:09 (GMT)

------------------ Additional Follow-up Comments ----------------------------
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.



=================== BUG #897: FULL BUG SNAPSHOT ===================


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

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

-------------------------------------------------------
Date: 2002-Aug-14 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.




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]