[Top][All Lists]
[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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [Bug #897] Search for comic SQL error,
nobody <=