[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bugs #897] Search for comic SQL error
From: |
Dave Hall |
Subject: |
[Phpgroupware-tracker] [bugs #897] Search for comic SQL error |
Date: |
Wed, 14 Jul 2004 20:02:00 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040602 Firefox/0.8 |
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/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [bugs #897] Search for comic SQL error,
Dave Hall <=